SAP ABAP View V_VICDCFPAYCN_DS (Partner-Related Cash Flow for Contracts)
Hierarchy
EA-FIN (Software Component) EA-FIN
   RE-FX-CN (Application Component) Real Estate Contract
     RE_DS_CD (Package) RE: Dev. Support - Conditions and Cash Flow
Basic Data
View Type D Database View 
Database View V_VICDCFPAYCN_DS  
Short Description Partner-Related Cash Flow for Contracts    
Root table VICDCFPAY   Payment-Related Cash Flow 
Table
# Table Name Foreign Table Foreign Field Foreign DIR
1 VICDCFPAY VICDCFPAY
2 VICDCOND  
3 VICNCN  
Join Conditions
# Table Name Field Name Negation Operator Constants Cont. line AND/OR Offset F Length Mco Field
1 VICDCFPAY MANDT JL EQ 0 0
2 VICDCOND MANDT JR EQ AND 0 0
3 VICDCFPAY MANDT JL EQ 0 0
4 VICNCN MANDT JR EQ AND 0 0
5 VICDCFPAY INTRENO JL EQ 0 0
6 VICDCOND INTRENO JR EQ AND 0 0
7 VICDCFPAY INTRENO JL EQ 0 0
8 VICNCN INTRENO JR EQ AND 0 0
9 VICDCFPAY CONDGUID JL EQ 0 0
10 VICDCOND CONDGUID JR EQ 0 0
                     
View Fields
# View field Table Field Maintenance Flag Key Data element Mod Short Description
1 MANDT VICNCN MANDT   MANDT Client
2 BUKRS VICNCN BUKRS   BUKRS Company Code
3 RECNNR VICNCN RECNNR   RECNNUMBER Contract Number
4 RECNTYPE VICNCN RECNTYPE   RECNCONTRACTTYPE Contract Type
5 CONDTYPE VICDCOND CONDTYPE   RECDCONDTYPE Condition Type
6 CONDVALIDFROM VICDCOND CONDVALIDFROM   RECDVALIDFROM Date from when condition is valid
7 CONDVALIDTO VICDCOND CONDVALIDTO   RECDVALIDTO Date up to when condition is valid
8 OBJNR VICDCOND OBJNR   RECDOBJNRCALC Object Number for Calculation
9 OBJNRDIST VICDCOND OBJNRDIST   RECDOBJNRDIST Object Number for Distribution
10 CONDDELETE VICDCOND CONDDELETE   RECDCONDDELETE Deletion Indicator for Condition
11 BBWHR VICDCFPAY BBWHR   TFM_BBWHR Amount which changes position
12 BNWHR VICDCFPAY BNWHR   TFM_BNWHR Nominal amount
13 DBERVON VICDCFPAY DBERVON   DBERVON Start of Calculation Period
14 DBERBIS VICDCFPAY DBERBIS   DBERBIS End of Calculation Period
15 SEXCLVON VICDCFPAY SEXCLVON   VVSEXCLVON Exclusive Indicator for the Start of a Calculation Period
16 SULTVON VICDCFPAY SULTVON   VVSULTVON Month-End Indicator for Start of a Calculation Period
17 SINCLBIS VICDCFPAY SINCLBIS   VVSINCLBIS Inclusive Indicator for the End of a Calculation Period
18 SULTBIS VICDCFPAY SULTBIS   VVSULTBIS Month-End Indicator for the End of a Calculation Period
19 DVALUT VICDCFPAY DVALUT   DVALUT Calculation Date
20 SINCL VICDCFPAY SINCL   VVSINCL Inclusive indicator for beginning and end of a period
21 SVINCL VICDCFPAY SVINCL   VVSVINCL Inclusive indicator for value date
22 SVULT VICDCFPAY SVULT   VVSVULT Month-End Indicator for Value Date
23 DFAELL VICDCFPAY DFAELL   DFAELL Due date
24 SFINCL VICDCFPAY SFINCL   VVSFINCL Inclusive Indicator for Due Date
25 SFULT VICDCFPAY SFULT   SFULT Month-End Indicator for Due Date
26 DDISPO VICDCFPAY DDISPO   DDISPO Payment Date
27 SINCLVERR VICDCFPAY SINCLVERR   VVSINCLVER Inclusive Indicator for Clearing Date
28 SULTVERR VICDCFPAY SULTVERR   VVSULTVERR Month-End Indicator for Clearing Date
29 ATAGE VICDCFPAY ATAGE   TFMATAGE Number of Days
30 APERTAGE VICDCFPAY APERTAGE   VVAPERTAGE No. of days of a (calculation) period in cash flow
31 STGMETH VICDCFPAY STGMETH   VVSTGMETH Daily Method
32 STGBASIS VICDCFPAY STGBASIS   VVSTGBASIS Base Days Method
33 SZBMETH VICDCFPAY SZBMETH   SZBMETH Interest Calculation Method
34 DBPERIOD VICDCFPAY DBPERIOD   VVDBPERIOD Period start
35 SPAEXCL VICDCFPAY SPAEXCL   TFMSPAEXCL Exclusive Indicator for Start Date of a Period
36 SPAULT VICDCFPAY SPAULT   TFMSPAULT Month-End Indicator for Start Date of a Period
37 DEPERIOD VICDCFPAY DEPERIOD   VVDEPERIOD Period End
38 SPEINCL VICDCFPAY SPEINCL   TFMSPEINCL Inclusive Indicator for End Date of a Period
39 SPEULT VICDCFPAY SPEULT   TFMSPEULT Month-End Indicator for End of a Period
40 SWHRKOND VICDCFPAY SWHRKOND   TFMWHRKOND Currency of Condition Item
41 BKOND VICDCFPAY BKOND   TFM_BKOND Condition item currency amount
42 SSTAFF VICDCFPAY SSTAFF   TFMSSTAFF Type of Scaled Calculation
43 SBASIS VICDCFPAY SBASIS   TFM_SBASIS Calculation Base Reference
44 JSOFVERR VICDCFPAY JSOFVERR   TFMSOFVERR Indicator for Immediate Settlement (Financial Mathematics)
45 AMMRHY VICDCFPAY AMMRHY   AMMRHY Frequency in months
46 ATTRHY VICDCFPAY ATTRHY   ATTRHY Frequency in Days
47 SSORTZIT VICDCFPAY SSORTZIT   TFM_SORT Sort indicator for financial mathematic calculations
48 SZEITANT VICDCFPAY SZEITANT   VVSZEITANT Indicator for Pro Rata Temporis Calculations
49 SSALBAS VICDCFPAY SSALBAS   TFMSSALBAS Indicator for debit position/incoming pmnt (internal FiMa)
50 SKONDGRP VICDCFPAY SKONDGRP   SKONDGRP Condition group in cash flow calculator
51 LCNETAMOUNT VICDCFPAY LCNETAMOUNT   RECDCFLCVALUENET Net Amount of Cash Flow Item in Local Currency
52 LCGROSSAMOUNT VICDCFPAY LCGROSSAMOUNT   RECDCFLCVALUEGROSS Gross Amount of Cash Flow Item in Local Currency
53 LCTAXAMOUNT VICDCFPAY LCTAXAMOUNT   RECDCFLCTAXVALUE Sales/Purch. Tax Amount of Cash Flow Item in Local Currency
54 LOCALCURR VICDCFPAY LOCALCURR   RECDCFLCCURR Local Currency of Cash Flow Item
55 CCNETAMOUNT VICDCFPAY CCNETAMOUNT   RECDCFVALUENET Net Amount of Cash Flow Item in Condition Currency
56 CCGROSSAMOUNT VICDCFPAY CCGROSSAMOUNT   RECDCFVALUEGROSS Gross Amount of Cash Flow Item in Condition Currency
57 CCTAXAMOUNT VICDCFPAY CCTAXAMOUNT   RECDCFTAXVALUE Tax on Sales/Purch. of Cash Flow Item in Condition Currency
58 CONDCURR VICDCFPAY CONDCURR   RECDCFCURR Condition Currency of Cash Flow Item
59 TAXTYPE VICDCFPAY TAXTYPE   RERATAXTYPE Tax Type
60 TAXGROUP VICDCFPAY TAXGROUP   RERATAXGROUP Tax Group
61 TXJCD VICDCFPAY TXJCD   TXJCD Tax Jurisdiction
62 ISGROSS VICDCFPAY ISGROSS   RECDISGROSS Condition Amount Is Gross Amount
63 WHEREFROM VICDCFPAY WHEREFROM   RECDWHEREFROM Flow Origin
64 FLOWTYPE VICDCFPAY FLOWTYPE   RECDFLOWTYPE Flow Type
65 ORIGFLOWTYPE VICDCFPAY ORIGFLOWTYPE   RECDORIGFLOWTYPE Original Flow Type
66 REFFLOWREL VICDCFPAY REFFLOWREL   RECDREFFLOWREL Type of Relationship Between Flow Type and Refer.Flow Type
67 CFSTATUS VICDCFPAY CFSTATUS   RECDCFSTATUS Indicates Status of Flow
68 FDLEV VICDCFPAY FDLEV   FDLEV Planning Level
69 FDUPD VICDCFPAY FDUPD   FDUPD Flag as to whether record enters cash management + forecast
70 FDELETE VICDCFPAY FDELETE   RECAARDELETEIND Deletion Indicator for Archiving
71 ORIGDUEDATE VICDCFPAY ORIGDUEDATE   RECDORIGDUEDATE Original Due Date
72 PARTNER VICDCFPAY PARTNER   BU_PARTNER Business Partner Number
73 PARTNEROBJNR VICDCFPAY PARTNEROBJNR   RECAOBJNR Object Number
74 TERMNOPY VICDCFPAY TERMNOPY   RECDTERMNOPY Number of Posting Term
75 TERMNORH VICDCFPAY TERMNORH   RECDTERMNORH Number of Frequency Term
76 TERMNOAJ VICDCFPAY TERMNOAJ   RECDTERMNOAJ Number of Adjustment Term
77 TERMNOOA VICDCFPAY TERMNOOA   RECDTERMNOOA Number of Organizational Assignment Term
78 TERMNOSR VICDCFPAY TERMNOSR   RECDTERMNOSR Number of Sales Term
79 TERMNOMR VICDCFPAY TERMNOMR   RECDTERMNOMR Number of Peak Sales Term
80 ORIGEXDUEDATE VICDCFPAY ORIGEXDUEDATE   RECDORIGDUEDATE Original Due Date
81 SEAPSTATUS VICDCFPAY SEAPSTATUS   RERASEAPSTATUS Status of Advance Payment Relevant to SCS
82 POSTINGDATE VICDCFPAY POSTINGDATE   RECDPOSTINGDATE Posting Date
83 DOCUMENTDATE VICDCFPAY DOCUMENTDATE   RECDDOCUMENTDATE Document Date
84 VALUATIONDATE VICDCFPAY VALUATIONDATE   RECDVALUATIONDATE Date for Translation of Contract Currency to Local Currency
85 REVERSAL_FOR VICDCFPAY REVERSAL_FOR   RECDREVERSALFORGUID GUID (RAW16) for 'Reversal for' References
86 REVERSAL_BY VICDCFPAY REVERSAL_BY   RECDREVERSALBYGUID GUID (RAW16) for 'Reversed by' References
87 FOLLOWUP_FOR VICDCFPAY FOLLOWUP_FOR   RECDFOLLOWUPFORGUID GUID (RAW16) for 'Follow-Up Posting for' References
88 BOOK_FLOWTYPE VICDCFPAY BOOK_FLOWTYPE   RECDFLOWTYPE Flow Type
89 BOOK_REFFLOWREL VICDCFPAY BOOK_REFFLOWREL   RECDREFFLOWREL Type of Relationship Between Flow Type and Refer.Flow Type
90 TAXDATE VICDCFPAY TAXDATE   RECDTAXDATE Date of Calculation of Sales/Purchase Tax
91 MODDUEDATE VICDCFPAY MODDUEDATE   RECDMODDUEDATE Modified Due Date
92 CALCDUEDATE VICDCFPAY CALCDUEDATE   RECDCALCDUEDATE Calculated Due Date
93 CFPAYGUID VICDCFPAY CFPAYGUID   RECDCFPAYGUID GUID (RAW16) for Payment-Related Cash Flow
94 CONDTYPE_CF VICDCFPAY CONDTYPE   RECDCONDTYPE Condition Type
95 CONDGUID_CF VICDCFPAY CONDGUID   RECDCONDGUID GUID (RAW16) for Conditions
96 CONDVALIDFROM_CF VICDCFPAY CONDVALIDFROM   RECDVALIDFROM Date from when condition is valid
97 REFGUID VICDCFPAY REFGUID   RECDREFGUID GUID (RAW16) for Document References in Cash Flow
98 RERF VICDCFPAY RERF   RERF Entered by
99 DERF VICDCFPAY DERF   DERF First Entered on
100 TERF VICDCFPAY TERF   TERF Time of Initial Entry
101 REHER VICDCFPAY REHER   REHER Source of initial entry
102 RBEAR VICDCFPAY RBEAR   RBEAR Employee ID
103 DBEAR VICDCFPAY DBEAR   DBEAR Last Edited on
104 TBEAR VICDCFPAY TBEAR   TBEAR Last Edited at
105 RBHER VICDCFPAY RBHER   RBHER Editing Source
106 CONDGUID VICDCOND CONDGUID   RECDCONDGUID GUID (RAW16) for Conditions
                 
Maintenance Status
Access
  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