SAP ABAP View V_VISCSMEAS_DS (Measurements Used per Settlement (Breakdown of MEASOBJGUID))
Hierarchy
☛
EA-FIN (Software Component) EA-FIN
⤷ RE-FX-SC (Application Component) Service Charge Settlement
⤷ RE_DS_SC (Package) RE: Dev. Support - Service Charge Settlement
⤷ RE-FX-SC (Application Component) Service Charge Settlement
⤷ RE_DS_SC (Package) RE: Dev. Support - Service Charge Settlement
Basic Data
View Type | D | Database View |
Database View | V_VISCSMEAS_DS | |
Short Description | Measurements Used per Settlement (Breakdown of MEASOBJGUID) | |
Root table | VISCSMEAS | Measurement Amount Used |
Table
# | Table Name | Foreign Table | Foreign Field | Foreign DIR |
---|---|---|---|---|
1 | VISCSMEAS | VISCSMEAS | ||
2 | VISCS_RENT | |||
3 | VISCS_SU_RO | |||
4 | VISCS_SU_SUM | |||
5 | VISCSETTL | |||
6 | VICAPROCESSID |
Join Conditions
# | Table Name | Field Name | Negation | Operator | Constants | Cont. line | AND/OR | Offset | F Length | Mco Field |
---|---|---|---|---|---|---|---|---|---|---|
1 | VISCS_RENT | MANDT | JL | EQ | 0 | 0 | ||||
2 | VISCSMEAS | MANDT | JR | EQ | AND | 0 | 0 | |||
3 | VISCS_RENT | SCS_PERIOD_GUID | JL | EQ | 0 | 0 | ||||
4 | VISCSMEAS | SCS_PERIOD_GUID | JR | EQ | AND | 0 | 0 | |||
5 | VISCS_SU_RO | MANDT | JL | EQ | 0 | 0 | ||||
6 | VISCSMEAS | MANDT | JR | EQ | AND | 0 | 0 | |||
7 | VISCS_SU_RO | SCS_RO_GUID | JL | EQ | 0 | 0 | ||||
8 | VISCSMEAS | SCS_RO_GUID | JR | EQ | AND | 0 | 0 | |||
9 | VISCS_SU_SUM | MANDT | JL | EQ | 0 | 0 | ||||
10 | VISCSMEAS | MANDT | JR | EQ | AND | 0 | 0 | |||
11 | VISCS_SU_SUM | SCS_SU_GUID | JL | EQ | 0 | 0 | ||||
12 | VISCSMEAS | SCS_SU_GUID | JR | EQ | AND | 0 | 0 | |||
13 | VISCSETTL | MANDT | JL | EQ | 0 | 0 | ||||
14 | VISCSMEAS | MANDT | JR | EQ | AND | 0 | 0 | |||
15 | VISCSETTL | SETTL_GUID | JL | EQ | 0 | 0 | ||||
16 | VISCSMEAS | SETTL_GUID | JR | EQ | AND | 0 | 0 | |||
17 | VICAPROCESSID | MANDT | JL | EQ | 0 | 0 | ||||
18 | VISCSETTL | MANDT | JR | EQ | AND | 0 | 0 | |||
19 | VICAPROCESSID | PROCESSGUID | JL | EQ | 0 | 0 | ||||
20 | VISCSETTL | SETTL_GUID | JR | EQ | 0 | 0 | ||||
View Fields
# | View field | Table | Field | Maintenance Flag | Key | Data element | Mod | Short Description |
---|---|---|---|---|---|---|---|---|
1 | MANDT | VISCSMEAS | MANDT | MANDT | Client | |||
2 | MEASOBJGUID | VISCSMEAS | MEASOBJGUID | RESCMEASOBJGUID | Object for Measurement Amount (Unique Internal Key) | |||
3 | VALIDFROM | VISCSMEAS | VALIDFROM | REBDMEASVALIDFROM | Date: Measurement Valid From | |||
4 | VALIDTO | VISCSMEAS | VALIDTO | REBDMEASVALIDTO | Date: Measurement Valid To | |||
5 | PLENGTH | VISCSMEAS | PLENGTH | VVATAGE | Number of days | |||
6 | MEASUNIT | VISCSMEAS | MEASUNIT | REBDMEASUNIT | Measurement Unit | |||
7 | MEASVALUE | VISCSMEAS | MEASVALUE | RESCROMEASVALUE | Measurement Amount | |||
8 | MEASVALUEARR | VISCSMEAS | MEASVALUEARR | RESCMEASVALUEARRANGE | Agreed Measurement Amount | |||
9 | IS_CALCULATED | VISCSMEAS | IS_CALCULATED | RESCMSISCALCULATED | Value was calculated | |||
10 | APPORTVALUE | VISCSMEAS | APPORTVALUE | RESCAPPORTVALUE | Reference Factor | |||
11 | APPORTVALUEOPT | VISCSMEAS | APPORTVALUEOPT | RESCAPPORTVALUEOPTING | Part of the Reference Factor that Opts | |||
12 | APPORTVALUEARR | VISCSMEAS | APPORTVALUEARR | RESCAPPORTVALUEARRANGE | Agreed Reference Factor | |||
13 | PROCESSGUID | VICAPROCESSID | PROCESSGUID | RECAPROCESSGUID | Generic Key of Process | |||
14 | VERSION | VICAPROCESSID | VERSION | RECAPROCESSVER | Version of Process | |||
15 | PROCESSID | VICAPROCESSID | PROCESSID | RECAPROCESSID | Process Identification -> Accounting Reference Number | |||
16 | SCS_PERIOD_GUID | VISCS_RENT | SCS_PERIOD_GUID | RESCPERIODGUID | Rental Periods | |||
17 | CN_OBJNR | VISCS_RENT | CN_OBJNR | RESCCNOBJNR | Object Number of Real Estate Contract (REC) | |||
18 | RO_OBJNR | VISCS_RENT | RO_OBJNR | RESCROOBJNR | Object Number of Rental Object | |||
19 | SCS_RO_GUID | VISCS_SU_RO | SCS_RO_GUID | RESCROGUID | Rental Object for an SU, Period and Measurement Type | |||
20 | OBJNR | VISCS_SU_RO | OBJNR | RESCROOBJNR | Object Number of Rental Object | |||
21 | SCS_SU_GUID | VISCS_SU_SUM | SCS_SU_GUID | RESCSUGUID | SU within SCS, for a Period and Measurement Type | |||
22 | SU_OBJNR | VISCS_SU_SUM | OBJNR | RECAOBJNR | Object Number | |||
Maintenance Status
read only |
read and change |
Time-dependent views: like U, validity data like ' ' |
read, change, delete and insert |
Delivery Class | ||
Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
History
Last changed by/on | SAP | 20110901 |
SAP Release Created in | 500 |