SAP ABAP View V_VIRADOCCFCN_DS (View of RE Document with Contract and Cash Flow Data)
Hierarchy
☛
EA-FIN (Software Component) EA-FIN
⤷ RE-FX-RA (Application Component) Rental Accounting
⤷ RE_DS_RA (Package) RE: Dev. Support - Rental Accounting
⤷ RE-FX-RA (Application Component) Rental Accounting
⤷ RE_DS_RA (Package) RE: Dev. Support - Rental Accounting
Basic Data
View Type | D | Database View |
Database View | V_VIRADOCCFCN_DS | |
Short Description | View of RE Document with Contract and Cash Flow Data | |
Root table | VIRADOC | RE Document Header |
Table
# | Table Name | Foreign Table | Foreign Field | Foreign DIR |
---|---|---|---|---|
1 | VIRADOC | VIRADOC | ||
2 | VIRADOCITEM | |||
3 | VICDCFPAY | |||
4 | VICNCN |
Join Conditions
# | Table Name | Field Name | Negation | Operator | Constants | Cont. line | AND/OR | Offset | F Length | Mco Field |
---|---|---|---|---|---|---|---|---|---|---|
1 | VIRADOC | MANDT | JL | EQ | 0 | 0 | ||||
2 | VIRADOCITEM | MANDT | JR | EQ | AND | 0 | 0 | |||
3 | VIRADOC | DOCGUID | JL | EQ | 0 | 0 | ||||
4 | VIRADOCITEM | DOCGUID | JR | EQ | AND | 0 | 0 | |||
5 | VIRADOCITEM | MANDT | JL | EQ | 0 | 0 | ||||
6 | VICDCFPAY | MANDT | JR | EQ | AND | 0 | 0 | |||
7 | VIRADOCITEM | REFGUID | JL | EQ | 0 | 0 | ||||
8 | VICDCFPAY | CFPAYGUID | JR | EQ | AND | 0 | 0 | |||
9 | VIRADOCITEM | MANDT | JL | EQ | 0 | 0 | ||||
10 | VICNCN | MANDT | JR | EQ | AND | 0 | 0 | |||
11 | VIRADOCITEM | OBJNR | JL | EQ | 0 | 0 | ||||
12 | VICNCN | OBJNR | JR | EQ | 0 | 0 | ||||
View Fields
# | View field | Table | Field | Maintenance Flag | Key | Data element | Mod | Short Description |
---|---|---|---|---|---|---|---|---|
1 | MANDT | VIRADOC | MANDT | MANDT | Client | |||
2 | CFSTATUS | VICDCFPAY | CFSTATUS | RECDCFSTATUS | Indicates Status of Flow | |||
3 | RECNTYPE | VICNCN | RECNTYPE | RECNCONTRACTTYPE | Contract Type | |||
4 | BUKRS | VIRADOCITEM | BUKRS | BUKRS | Company Code | |||
5 | RECNNR | VICNCN | RECNNR | RECNNUMBER | Contract Number | |||
6 | PSTNGPROCEDURE | VIRADOC | PSTNGPROCEDURE | RERAPROCEDURE | Posting Procedure | |||
7 | PROCESS | VIRADOC | PROCESS | RECAPROCESS | Process | |||
8 | FISC_YEAR | VIRADOC | FISC_YEAR | GJAHR | Fiscal Year | |||
9 | PSTNGPERIOD | VIRADOC | PSTNGPERIOD | RERAPSTNGPERIOD | Posting Period | |||
10 | PSTNGDATE | VIRADOC | PSTNGDATE | RERAPSTNGDATE | Posting Date | |||
11 | DOCDATE | VIRADOC | DOCDATE | RERADOCDATE | Document Date | |||
12 | STATUS | VIRADOC | STATUS | RERASTATUS | RE Document Status | |||
13 | RERF | VIRADOC | RERF | RERF | Entered by | |||
14 | DERF | VIRADOC | DERF | DERF | First Entered on | |||
15 | TERF | VIRADOC | TERF | TERF | Time of Initial Entry | |||
16 | REHER | VIRADOC | REHER | REHER | Source of initial entry | |||
17 | RBEAR | VIRADOC | RBEAR | RBEAR | Employee ID | |||
18 | DBEAR | VIRADOC | DBEAR | DBEAR | Last Edited on | |||
19 | TBEAR | VIRADOC | TBEAR | TBEAR | Last Edited at | |||
20 | RBHER | VIRADOC | RBHER | RBHER | Editing Source | |||
21 | ITEMNO | VIRADOCITEM | ITEMNO | POSNR_ACC | Accounting Document Line Item Number | |||
22 | REFITEMNO | VIRADOCITEM | REFITEMNO | RERAREFITEMNO | Reference to Other Item Number of Document | |||
23 | REFDATE | VIRADOCITEM | REFDATE | DABRBEZ | Reference date for settlement | |||
24 | OBJNR | VIRADOCITEM | OBJNR | RERAOBJNR | Account Assignment: Object Number | |||
25 | PFROM | VIRADOCITEM | PFROM | DBERVON | Start of Calculation Period | |||
26 | PTO | VIRADOCITEM | PTO | DBERBIS | End of Calculation Period | |||
27 | CONDTYPE | VIRADOCITEM | CONDTYPE | RECDCONDTYPE | Condition Type | |||
28 | ISADVANCEPAYMENT | VIRADOCITEM | ISADVANCEPAYMENT | RECDADVANCEPAYMENT | Condition Is Advance Payment Condition | |||
29 | FLOWTYPE | VIRADOCITEM | FLOWTYPE | RECDFLOWTYPE | Flow Type | |||
30 | AMOUNT | VIRADOCITEM | AMOUNT | RERAAMOUNT | Amount in Transaction Currency | |||
31 | GROSSAMOUNT | VIRADOCITEM | GROSSAMOUNT | RERAGROSSAMOUNT | Gross Amount in Transaction Currency | |||
32 | NETAMOUNT | VIRADOCITEM | NETAMOUNT | RERANETAMOUNT | Net Amount in Transaction Currency | |||
33 | TAXAMOUNT | VIRADOCITEM | TAXAMOUNT | RERATAXAMOUNT | Tax Amount in Transaction Currency | |||
34 | INTRENO | VICDCFPAY | INTRENO | RECAINTRENO | Internal Key of Real Estate Object | |||
35 | DBERVON | VICDCFPAY | DBERVON | DBERVON | Start of Calculation Period | |||
36 | DBERBIS | VICDCFPAY | DBERBIS | DBERBIS | End of Calculation Period | |||
37 | TERMNOPY | VICDCFPAY | TERMNOPY | RECDTERMNOPY | Number of Posting Term | |||
38 | TERMNORH | VICDCFPAY | TERMNORH | RECDTERMNORH | Number of Frequency Term | |||
39 | TERMNOAJ | VICDCFPAY | TERMNOAJ | RECDTERMNOAJ | Number of Adjustment Term | |||
40 | TERMNOOA | VICDCFPAY | TERMNOOA | RECDTERMNOOA | Number of Organizational Assignment Term | |||
41 | TERMNOSR | VICDCFPAY | TERMNOSR | RECDTERMNOSR | Number of Sales Term | |||
42 | TERMNOMR | VICDCFPAY | TERMNOMR | RECDTERMNOMR | Number of Peak Sales Term | |||
43 | SEAPSTATUS | VICDCFPAY | SEAPSTATUS | RERASEAPSTATUS | Status of Advance Payment Relevant to SCS | |||
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 |