SAP ABAP View V_VISCS_RO_DS (Rental Objects of Settlement)
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_RO_DS | |
Short Description | Rental Objects of Settlement | |
Root table | VISCS_SU_RO | Sum of All Costs and Measurement Amounts for a Rental Object |
Table
# | Table Name | Foreign Table | Foreign Field | Foreign DIR |
---|---|---|---|---|
1 | VISCS_SU_RO | VISCS_SU_RO | ||
2 | VIBDRO | |||
3 | TIVBDMEAS | |||
4 | VISCS_SU_SUM | |||
5 | VISCSU | |||
6 | TIVBDMEAST | |||
7 | VISCSETTL | |||
8 | 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 | VIBDRO | MANDT | JR | EQ | AND | 0 | 0 | |||
3 | VISCS_SU_RO | OBJNR | JL | EQ | 0 | 0 | ||||
4 | VIBDRO | OBJNR | JR | EQ | AND | 0 | 0 | |||
5 | TIVBDMEAS | MANDT | JL | EQ | 0 | 0 | ||||
6 | VISCS_SU_RO | MANDT | JR | EQ | AND | 0 | 0 | |||
7 | TIVBDMEAS | MEAS | JL | EQ | 0 | 0 | ||||
8 | VISCS_SU_RO | MEAS | 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 | TIVBDMEAS | MANDT | JL | EQ | 0 | 0 | ||||
18 | TIVBDMEAST | MANDT | JR | EQ | AND | 0 | 0 | |||
19 | TIVBDMEAS | MEAS | JL | EQ | 0 | 0 | ||||
20 | TIVBDMEAST | MEAS | JR | EQ | AND | 0 | 0 | |||
21 | VISCSETTL | MANDT | JL | EQ | 0 | 0 | ||||
22 | VISCS_SU_RO | MANDT | JR | EQ | AND | 0 | 0 | |||
23 | VISCSETTL | SETTL_GUID | JL | EQ | 0 | 0 | ||||
24 | VISCS_SU_RO | SETTL_GUID | JR | EQ | AND | 0 | 0 | |||
25 | VICAPROCESSID | MANDT | JL | EQ | 0 | 0 | ||||
26 | VISCSETTL | MANDT | JR | EQ | AND | 0 | 0 | |||
27 | VICAPROCESSID | PROCESSGUID | JL | EQ | 0 | 0 | ||||
28 | VISCSETTL | SETTL_GUID | JR | EQ | 0 | 0 | ||||
View Fields
# | View field | Table | Field | Maintenance Flag | Key | Data element | Mod | Short Description |
---|---|---|---|---|---|---|---|---|
1 | MANDT | VISCS_SU_RO | MANDT | MANDT | Client | |||
2 | SETTL_GUID | VISCS_SU_SUM | SETTL_GUID | RECASETTLGUID | Unique Key of Settlement | |||
3 | SCS_RO_GUID | VISCS_SU_RO | SCS_RO_GUID | RESCROGUID | Rental Object for an SU, Period and Measurement Type | |||
4 | BUKRS | VIBDRO | BUKRS | BUKRS | Company Code | |||
5 | SWENR | VIBDRO | SWENR | REBDBENO | Business Entity Number | |||
6 | SMENR | VIBDRO | SMENR | REBDRONO | Number of Rental Object | |||
7 | XMETXT | VIBDRO | XMETXT | REBDXRO | Rental Object Name | |||
8 | SCS_SU_GUID | VISCS_SU_RO | SCS_SU_GUID | RESCSUGUID | SU within SCS, for a Period and Measurement Type | |||
9 | SU_BUKRS | VISCSU | BUKRS | BUKRS | Company Code | |||
10 | SU_SWENR | VISCSU | SWENR | RESCSUBE | Valid Business Entity | |||
11 | SU_SNKSL | VISCSU | SNKSL | RESCSCKEY | Service Charge Key | |||
12 | SU_SEMPSL | VISCSU | SEMPSL | RESCSUID | Settlement Unit | |||
13 | SU_OBJNR | VISCSU | OBJNR | RECAOBJNR | Object Number | |||
14 | SU_XTEXTAE | VISCSU | XSU | RESCXSU | Name of settlement unit | |||
15 | OBJTYPE | VISCS_SU_RO | OBJTYPE | RECAOBJTYPE | Object Type | |||
16 | OBJNR | VISCS_SU_RO | OBJNR | RESCROOBJNR | Object Number of Rental Object | |||
17 | PFROM | VISCS_SU_RO | PFROM | RECAPERIODFROM | Period Start Date | |||
18 | PTO | VISCS_SU_RO | PTO | RECAPERIODTO | Period End Date | |||
19 | SU_PFROM | VISCS_SU_SUM | PFROM | RECAPERIODFROM | Period Start Date | |||
20 | SU_PTO | VISCS_SU_SUM | PTO | RECAPERIODTO | Period End Date | |||
21 | PURPOSE | VISCS_SU_RO | PURPOSE | RESCFORPURPOSE | Purpose of Apportionment | |||
22 | MEAS | VISCS_SU_RO | MEAS | REBDMEAS | Measurement Type | |||
23 | XMMEAS | TIVBDMEAST | XMMEAS | REBDXMMEAS | Name of Measurement Type - Medium-Length | |||
24 | PLENGTH | VISCS_SU_RO | PLENGTH | VVATAGE | Number of days | |||
25 | APPORTVALUE | VISCS_SU_RO | APPORTVALUE | RESCAPPORTVALUE | Reference Factor | |||
26 | APPORTVALUEOPT | VISCS_SU_RO | APPORTVALUEOPT | RESCAPPORTVALUEOPTING | Part of the Reference Factor that Opts | |||
27 | APPORTVALUESU | VISCS_SU_RO | APPORTVALUESU | RESCAPPORTVALUESUM | Sum of Reference Factors of Lower-Level Objects | |||
28 | CURRENCY | VISCS_SU_RO | CURRENCY | WAERS | Currency Key | |||
29 | NETAMOUNT | VISCS_SU_RO | NETAMOUNT | RESCNETAMOUNT | Net Amount | |||
30 | NONDEDTAXAMT | VISCS_SU_RO | NONDEDTAXAMT | RESCNONDEDTAXAMT | Non-Deductible Tax Amount | |||
31 | HAS_COSTS | VISCS_SU_RO | HAS_COSTS | RESCHASCOSTS | Costs Were Posted on the Object | |||
32 | INTERNAL_OBJID | VISCS_SU_RO | INTERNAL_OBJID | ABNNR | Identification of lease-out at settlement company | |||
33 | EXTERNAL_OBJID | VISCS_SU_RO | EXTERNAL_OBJID | STECHEM | Heating expenses settlement company evaluation group | |||
34 | PROCESSGUID | VICAPROCESSID | PROCESSGUID | RECAPROCESSGUID | Generic Key of Process | |||
35 | PROCESSID | VICAPROCESSID | PROCESSID | RECAPROCESSID | Process Identification -> Accounting Reference Number | |||
36 | RERF | VICAPROCESSID | RERF | RERF | Entered by | |||
37 | DERF | VICAPROCESSID | DERF | DERF | First Entered on | |||
38 | SU_INTRENO | VISCSU | INTRENO | RECAINTRENO | Internal Key of Real Estate Object | |||
39 | RO_INTRENO | VIBDRO | INTRENO | RECAINTRENO | Internal Key of Real Estate Object | |||
40 | VERSION | VICAPROCESSID | VERSION | RECAPROCESSVER | Version of Process | |||
41 | SPRAS | TIVBDMEAST | SPRAS | SPRAS | Language Key | |||
42 | 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 |