SAP ABAP View V_VISCS_ROCN_DS (Costs and Measurement Amounts for REC + RO (Lease-Out View))
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_VISCS_ROCN_DS | |
Short Description | Costs and Measurement Amounts for REC + RO (Lease-Out View) | |
Root table | VISCS_RO_CN | Costs and Measurement Amounts for REC + RO (Lease-Out View) |
Table
# | Table Name | Foreign Table | Foreign Field | Foreign DIR |
---|---|---|---|---|
1 | VISCS_RO_CN | VISCS_RO_CN | ||
2 | VISCS_SU_RO | |||
3 | VISCS_SU_SUM | |||
4 | VIBDRO | |||
5 | VISCSU | |||
6 | VISCSETTL | |||
7 | VICAPROCESSID |
Join Conditions
# | Table Name | Field Name | Negation | Operator | Constants | Cont. line | AND/OR | Offset | F Length | Mco Field |
---|---|---|---|---|---|---|---|---|---|---|
1 | VISCS_SU_RO | MANDT | JL | EQ | 0 | 0 | ||||
2 | VISCS_RO_CN | MANDT | JR | EQ | AND | 0 | 0 | |||
3 | VISCS_SU_RO | SCS_RO_GUID | JL | EQ | 0 | 0 | ||||
4 | VISCS_RO_CN | SCS_RO_GUID | JR | EQ | AND | 0 | 0 | |||
5 | VISCS_SU_RO | MANDT | JL | EQ | 0 | 0 | ||||
6 | VIBDRO | MANDT | JR | EQ | AND | 0 | 0 | |||
7 | VISCS_SU_RO | OBJNR | JL | EQ | 0 | 0 | ||||
8 | VIBDRO | OBJNR | JR | EQ | AND | 0 | 0 | |||
9 | VISCS_SU_SUM | MANDT | JL | EQ | 0 | 0 | ||||
10 | VISCS_SU_RO | MANDT | JR | EQ | AND | 0 | 0 | |||
11 | VISCS_SU_SUM | SCS_SU_GUID | JL | EQ | 0 | 0 | ||||
12 | VISCS_SU_RO | SCS_SU_GUID | JR | EQ | AND | 0 | 0 | |||
13 | VISCS_SU_SUM | MANDT | JL | EQ | 0 | 0 | ||||
14 | VISCSU | MANDT | JR | EQ | AND | 0 | 0 | |||
15 | VISCS_SU_SUM | OBJNR | JL | EQ | 0 | 0 | ||||
16 | VISCSU | OBJNR | JR | EQ | AND | 0 | 0 | |||
17 | VISCSETTL | MANDT | JL | EQ | 0 | 0 | ||||
18 | VISCS_SU_SUM | MANDT | JR | EQ | AND | 0 | 0 | |||
19 | VISCSETTL | SETTL_GUID | JL | EQ | 0 | 0 | ||||
20 | VISCS_SU_SUM | SETTL_GUID | JR | EQ | AND | 0 | 0 | |||
21 | VICAPROCESSID | MANDT | JL | EQ | 0 | 0 | ||||
22 | VISCSETTL | MANDT | JR | EQ | AND | 0 | 0 | |||
23 | VICAPROCESSID | PROCESSGUID | JL | EQ | 0 | 0 | ||||
24 | VISCSETTL | SETTL_GUID | JR | EQ | 0 | 0 | ||||
View Fields
# | View field | Table | Field | Maintenance Flag | Key | Data element | Mod | Short Description |
---|---|---|---|---|---|---|---|---|
1 | MANDT | VISCS_RO_CN | MANDT | MANDT | Client | |||
2 | SETTL_GUID | VISCS_SU_SUM | SETTL_GUID | RECASETTLGUID | Unique Key of Settlement | |||
3 | SCS_ROCN_GUID | VISCS_RO_CN | SCS_ROCN_GUID | RESCROCNGUID | Rental Object or Contract, Depending on Rental | |||
4 | SCS_RO_GUID | VISCS_RO_CN | SCS_RO_GUID | RESCROGUID | Rental Object for an SU, Period and Measurement Type | |||
5 | RO_INTRENO | VIBDRO | INTRENO | RECAINTRENO | Internal Key of Real Estate Object | |||
6 | RO_BUKRS | VIBDRO | BUKRS | BUKRS | Company Code | |||
7 | RO_SWENR | VIBDRO | SWENR | REBDBENO | Business Entity Number | |||
8 | RO_SMENR | VIBDRO | SMENR | REBDRONO | Number of Rental Object | |||
9 | RO_OBJNR | VIBDRO | OBJNR | RECAOBJNR | Object Number | |||
10 | RO_XMETXT | VIBDRO | XMETXT | REBDXRO | Rental Object Name | |||
11 | SCS_SU_GUID | VISCS_SU_RO | SCS_SU_GUID | RESCSUGUID | SU within SCS, for a Period and Measurement Type | |||
12 | SU_INTRENO | VISCSU | INTRENO | RECAINTRENO | Internal Key of Real Estate Object | |||
13 | SU_BUKRS | VISCSU | BUKRS | BUKRS | Company Code | |||
14 | SU_SWENR | VISCSU | SWENR | RESCSUBE | Valid Business Entity | |||
15 | SU_SNKSL | VISCSU | SNKSL | RESCSCKEY | Service Charge Key | |||
16 | SU_SEMPSL | VISCSU | SEMPSL | RESCSUID | Settlement Unit | |||
17 | SU_OBJNR | VISCSU | OBJNR | RECAOBJNR | Object Number | |||
18 | SU_XSU | VISCSU | XSU | RESCXSU | Name of settlement unit | |||
19 | OBJTYPE | VISCS_RO_CN | OBJTYPE | RECAOBJTYPE | Object Type | |||
20 | OBJNR | VISCS_RO_CN | OBJNR | RECAOBJNR | Object Number | |||
21 | PFROM | VISCS_RO_CN | PFROM | RECAPERIODFROM | Period Start Date | |||
22 | PTO | VISCS_RO_CN | PTO | RECAPERIODTO | Period End Date | |||
23 | PURPOSE | VISCS_RO_CN | PURPOSE | RESCFORPURPOSE | Purpose of Apportionment | |||
24 | MEAS | VISCS_RO_CN | MEAS | REBDMEAS | Measurement Type | |||
25 | CNTRIGGER_GUID | VISCS_RO_CN | CNTRIGGER_GUID | RESCTRIGGERGUID | Which Object (Usually RO) is Trigger for This Entry | |||
26 | PLENGTH | VISCS_RO_CN | PLENGTH | VVATAGE | Number of days | |||
27 | CONDTYPE | VISCS_RO_CN | CONDTYPE | RECDCONDTYPE | Condition Type | |||
28 | FLOWTYPE | VISCS_RO_CN | FLOWTYPE | RECDFLOWTYPE | Flow Type | |||
29 | SCS_PERIOD_GUID | VISCS_RO_CN | SCS_PERIOD_GUID | RESCPERIODGUID | Rental Periods | |||
30 | APPORTVALUE | VISCS_RO_CN | APPORTVALUE | RESCAPPORTVALUE | Reference Factor | |||
31 | APPORTVALUEOPT | VISCS_RO_CN | APPORTVALUEOPT | RESCAPPORTVALUEOPTING | Part of the Reference Factor that Opts | |||
32 | APPORTVALUERO | VISCS_RO_CN | APPORTVALUERO | RESCAPPORTVALUESUM | Sum of Reference Factors of Lower-Level Objects | |||
33 | CURRENCY | VISCS_RO_CN | CURRENCY | WAERS | Currency Key | |||
34 | NETAMOUNT | VISCS_RO_CN | NETAMOUNT | RESCNETAMOUNT | Net Amount | |||
35 | NONDEDTAXAMT | VISCS_RO_CN | NONDEDTAXAMT | RESCNONDEDTAXAMT | Non-Deductible Tax Amount | |||
36 | HAS_COSTS | VISCS_RO_CN | HAS_COSTS | RESCHASCOSTS | Costs Were Posted on the Object | |||
37 | PARTTYPE | VISCS_RO_CN | PARTTYPE | RESCPARTTYPE | Type of Service Charge Settlement Participation | |||
38 | TENANT_SHARE | VISCS_RO_CN | TENANT_SHARE | RESCPTENANT | Tenant Share per SU as Percentage | |||
39 | OWNER_SHARE | VISCS_RO_CN | OWNER_SHARE | RESCPOWNER | Share of Owner, per Service Charge Key, as Percent | |||
40 | HAS_LIMITATION | VISCS_RO_CN | HAS_LIMITATION | RESCHASLIMITATION | Limitation of Settlement Participation | |||
41 | NET_AMOUNT_REAL | VISCS_RO_CN | NET_AMOUNT_REAL | RESCNETAMOUNTREAL | Net Amount | |||
42 | DEDUCT_TAX_REAL | VISCS_RO_CN | DEDUCT_TAX_REAL | RESCNONITAXREAL | Non-Deductible Tax Amount | |||
43 | MAXCOSTSU | VISCS_RO_CN | MAXCOSTSU | RESCSMAXCOSTSU | Maximum Costs Value per Settlement Unit for SCS | |||
44 | BASE | VISCS_RO_CN | BASE | RESCSBASE | Basis for Calculation of All-Inclusive Rent | |||
45 | BASEAMOUNT | VISCS_RO_CN | BASEAMOUNT | RESCSBASEAMOUNT | Basis Amount for Part-Inclusive Rent | |||
46 | BASEDATE | VISCS_RO_CN | BASEDATE | RESCSBASEDATE | Date of Base Year Settlement | |||
47 | IS_TAX | VISCS_RO_CN | IS_TAX | JMWST | Value added tax indicator | |||
48 | PROCESSGUID | VICAPROCESSID | PROCESSGUID | RECAPROCESSGUID | Generic Key of Process | |||
49 | VERSION | VICAPROCESSID | VERSION | RECAPROCESSVER | Version of Process | |||
50 | PROCESSID | VICAPROCESSID | PROCESSID | RECAPROCESSID | Process Identification -> Accounting Reference Number | |||
51 | RERF | VICAPROCESSID | RERF | RERF | Entered by | |||
52 | DERF | VICAPROCESSID | DERF | DERF | First Entered on | |||
53 | SUTYPE | VISCSU | SUTYPE | RESCSUTYPE | Type of Settlement Unit | |||
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 | 20130529 |
SAP Release Created in | 500 |