1. Home
  2. Resources
  3. SAP Tables
  4. REIS_CASHFLOW_PAY_L - ALV Reporting: Cash Flow

SAP Table REIS_CASHFLOW_PAY_L

ALV Reporting: Cash Flow

REIS_CASHFLOW_PAY_L (ALV Reporting: Cash Flow) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link REIS_CASHFLOW_PAY_L to other SAP tables.

REIS_CASHFLOW_PAY_L table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT CLNT 3 0
INTRENO Internal Key of Real Estate Object RECAINTRENO CHAR 13 0
BUKRS Company Code BUKRS T001 CHAR 4 0
RECNNR Contract Number RECNNUMBER CHAR 13 0
OBJNR Object Number RECAOBJNR CHAR 22 0
IMKEY Internal Key of Real Estate Object (FI) RECAIMKEY CHAR 8 0
CREATIONTYPE How the Object Was Created RECACREATIONTYPE CHAR 1 0
NULL Object created in Classic RE
1 Object created in Classic RE or migrated from other system
2 Object created in Flexible Real Estate Management
RERF Entered by RERF CHAR 12 0
DERF First Entered on DERF DATS 8 0
TERF Time of Initial Entry TERF TIMS 6 0
REHER Source of initial entry REHER CHAR 10 0
RBEAR Employee ID RBEAR CHAR 12 0
DBEAR Last Edited on DBEAR DATS 8 0
TBEAR Last Edited at TBEAR TIMS 6 0
RBHER Editing Source RBHER CHAR 10 0
RESPONSIBLE Person Responsible RECARESPONSIBLE USR02 CHAR 12 0
USEREXCLUSIVE User with Exclusive Change Authorization RECAUSEREXCLUSIVE USR02 CHAR 12 0
AUTHGRP Authorization Group RECAAUTHGRP CHAR 40 0
RECNTYPE Contract Type RECNCONTRACTTYPE TIV26 CHAR 4 0
RECNBEG Date of contract start RECNCNBEG DATS 8 0
RECNENDABS Term End Date RECNCNENDABS DATS 8 0
RECNTXT Contract name RECNTXT CHAR 80 0
RECNDACTIV Contract activation DAKTV DATS 8 0
RECNTLAW Tenancy law SMIETR TIV03 CHAR 5 0
RECNTXTOLD Number of old contract VVOSMIVE CHAR 20 0
RECNBUKRSCOLLECT Company code of main contract RECNBUKRSCOLLECT T001 CHAR 4 0
RECNNRCOLLECT Number of Real Estate Main Contract RECNNUMBERCOLLECT CHAR 13 0
RECNCNCURR Currency for Contract RECNWAERS_CN CUKY 5 0
INDUSTRY Industry BU_IND_SECTOR CHAR 10 0
SRRELEVANT Relevant to Sales RECNSALESRENTRELEVANT CHAR 1 0
X Yes
NULL No
DPTARGETTYPE Security Deposit Type RECNDPTYPE TIVCNDPTYPE CHAR 4 0
RECNDAT Date of Contract Conclusion RECNDAT DATS 8 0
RECN2DAT Date of Second Signature RECN2DAT DATS 8 0
RECNDPO Cash Flow Generated Starting On RECDCFSTARTFROM DATS 8 0
RECNEND1ST Date of First Contract End RECNCNEND1ST DATS 8 0
RECNNOTPER Contract Notice Per RECNNTPER DATS 8 0
RECNNOTRECEIPT Date of receipt of notice RECNNTRECEIPT DATS 8 0
RECNNOTREASON Reason for Notice RECNNTREASON TIVCNNTRE NUMC 2 0
RECNDAKTKU Notice: Date of Activation RECNNTACTIVATEDON DATS 8 0
CFARCHIVEDTO Date Up to Which the Cash Flow Is Archived RECDCFARCHIVEDTO DATS 8 0
CFLOCKEDTO Date Until Which the Cash Flow Is Locked RECDCFLOCKEDTO DATS 8 0
CFPOSTINGFROM First Posting From RECDCFPOSTINGFROM DATS 8 0
BENOCN Site That Belongs to Contract RECNBENOCN CHAR 8 0
TRANSPOSSFROM Transfer of Possession: Start Date RECNTRANSPOSSFROM DATS 8 0
TRANSPOSSTO Transfer of Possession: End Date RECNTRANSPOSSTO DATS 8 0
HASMULTIASSIGN Multiple Assignment of Object to Group Allowed REBDHASMULTIASSIGN CHAR 1 0
X Yes
NULL No
POSSDATEFROM Date From Which the Object Is Made Available for Use REBDPOSSDATEFROM DATS 8 0
POSSDATETO Date Up to Which the Object Is Used REBDPOSSDATETO DATS 8 0
SECDEPRELEVANT Relevant to Security Deposit REXCESCDREL CHAR 1 0
X Yes
NULL No
NOTADJSDCN No Data Update in Security Deposit Contract REXCESCDNOTADJ CHAR 1 0
X Yes
NULL No
REYCMAJORCN CAM Major Contract REYCMAJORCN CHAR 13 0
REYCDEDUCTMEAS Deduct Major Tenant Space in Den. when Calc. Subtenant Share REYCDEDUCTMEAS CHAR 1 0
X Yes
NULL No
REYCMAJORTNT Major Tenant Contribution Indicator REYCMAJORTNT CHAR 1 0
X Yes
NULL No
REYCISSUECREDIT Issue Credit REYCISSUECREDIT CHAR 1 0
N No cedit
F Issue credit at final settlement
A Issue credit at all settlement
REYCPOSDATEREL Possession Date Relevant REYCPOSDATEREL CHAR 1 0
X Yes
NULL No
XRECNNRCOL Contract name RECNTXT CHAR 80 0
XBUKRS Name of Company Code or Company BUTXT CHAR 25 0
XRECNTYPE Description of type of RE contract type XMVARTM CHAR 30 0
GSBER Business Area GSBER CHAR 4 0
PRCTR Profit Center PRCTR CHAR 10 0
KOSTL Cost Center KOSTL CHAR 10 0
AUFNR Order Number AUFNR CHAR 12 0
XTENANCYLAW Tenancy law long text XMIETR CHAR 50 0
XCOLLECT Contract name RECNTXT CHAR 80 0
XAUTHGRP Description of Authorization Group RECAXAUTHGRP CHAR 60 0
XINDUSTRY Industry Name RECNINDUSTRY CHAR 20 0
XTRANSPOSSPERIOD Productive Holdings: Time Period RECNXTRANSPOSSPERIOD CHAR 30 0
CFPAYGUID GUID (RAW16) for Payment-Related Cash Flow RECDCFPAYGUID RAW 16 0
CONDGUID GUID (RAW16) for Conditions RECDCONDGUID RAW 16 0
CONDVALIDFROM Date from when condition is valid RECDVALIDFROM DATS 8 0
REFGUID GUID (RAW16) for Document References in Cash Flow RECDREFGUID RAW 16 0
BBWHR Amount which changes position TFM_BBWHR CURR 23 2
BNWHR Nominal amount TFM_BNWHR CURR 23 2
DBERVON Start of Calculation Period DBERVON DATS 8 0
SEXCLVON Exclusive Indicator for the Start of a Calculation Period VVSEXCLVON NUMC 1 0
0 Inclusive
1 Exclusive
SULTVON Month-End Indicator for Start of a Calculation Period VVSULTVON CHAR 1 0
NULL
X Month-end date
DBERBIS End of Calculation Period DBERBIS DATS 8 0
SINCLBIS Inclusive Indicator for the End of a Calculation Period VVSINCLBIS NUMC 1 0
0 Exclusive
1 Inclusive
SULTBIS Month-End Indicator for the End of a Calculation Period VVSULTBIS CHAR 1 0
NULL
X Month-end date
DVALUT Calculation Date DVALUT DATS 8 0
SINCL Inclusive indicator for beginning and end of a period VVSINCL NUMC 1 0
0 Start date inclusive/end date exclusive
1 Start date exclusive/end date inclusive
SVINCL Inclusive indicator for value date VVSVINCL NUMC 1 0
0 Start date inclusive/end date exclusive
1 Start date exclusive/end date inclusive
SVULT Month-End Indicator for Value Date VVSVULT CHAR 1 0
NULL
X Month-end date
DFAELL Due date DFAELL DATS 8 0
SFINCL Inclusive Indicator for Due Date VVSFINCL NUMC 1 0
0 Start date inclusive/end date exclusive
1 Start date exclusive/end date inclusive
SFULT Month-End Indicator for Due Date SFULT CHAR 1 0
NULL
X Month-end date
DDISPO Payment Date DDISPO DATS 8 0
SINCLVERR Inclusive Indicator for Clearing Date VVSINCLVER NUMC 1 0
0 Exclusive
1 Inclusive
SULTVERR Month-End Indicator for Clearing Date VVSULTVERR CHAR 1 0
NULL
X Month-end date
ATAGE Number of Days TFMATAGE INT4 10 0
ABASTAGE Amount in floating point format for recursive determination BITER FLTP 16 16
APERTAGE No. of days of a (calculation) period in cash flow VVAPERTAGE NUMC 6 0
STGMETH Daily Method VVSTGMETH NUMC 1 0
1 360E
2 Act
3 365
4 360
5 ActW
6 360 ISDA
7 m+act
8 m+30
9 360 German
STGBASIS Base Days Method VVSTGBASIS NUMC 1 0
1 0
2 360
3 365
4 366
5 ActP
6 ActY
7 252
8 364
9 ActE
SZBMETH Interest Calculation Method SZBMETH CHAR 1 0
1 360E/360
B 360E/365
F 360/360 (ISDA)
H 360/365 (ISDA)
7 360/360
2 Act/360
E Act/364
3 Act/365
4 Act/366
5 Act/ActP (ICMA)
6 Act/ActY (ISDA)
G Act/ActE (AFB)
A ActW/252
D 365/360
C 365/365
I 360E/ActY
8 *365/360
9 *365.25/360
P 1/1
J m+act/360
K m+30/360
0 Not Specified
DBPERIOD Period start VVDBPERIOD DATS 8 0
SPAEXCL Exclusive Indicator for Start Date of a Period TFMSPAEXCL NUMC 1 0
0 inclusive
1 exclusive
SPAULT Month-End Indicator for Start Date of a Period TFMSPAULT CHAR 1 0
NULL
X Month-end date
DEPERIOD Period End VVDEPERIOD DATS 8 0
SPEINCL Inclusive Indicator for End Date of a Period TFMSPEINCL NUMC 1 0
0 exclusive
1 inclusive
SPEULT Month-End Indicator for End of a Period TFMSPEULT CHAR 1 0
NULL
X Month-end date
SWHRKOND Currency of Condition Item TFMWHRKOND CUKY 5 0
BKOND Condition item currency amount TFM_BKOND CURR 17 2
SSTAFF Type of Scaled Calculation TFMSSTAFF NUMC 1 0
0 No incremental/interval calculation
1 Incremental calculation
2 Interval calculation
SBASIS Calculation Base Reference TFM_SBASIS CHAR 4 0
JSOFVERR Indicator for Immediate Settlement (Financial Mathematics) TFMSOFVERR CHAR 1 0
NULL Settlement According to Condition
X Immediate Settlement
Y Settlement on Due Date
Z Settlement on Calculation Date
P Settlement at End of Period
E Clearing on Calculation Date (Interest Calc. Capital Only)
AMMRHY Frequency in months AMMRHY NUMC 3 0
ATTRHY Frequency in Days ATTRHY NUMC 3 0
SSORTZIT Sort indicator for financial mathematic calculations TFM_SORT NUMC 2 0
SZEITANT Indicator for Pro Rata Temporis Calculations VVSZEITANT NUMC 1 0
0 Pro rate calculation in shortened/extended periods
1 No consideration taken in shortened/extended periods
2 Full consideration taken in shortened/extended periods
3 Start period: pro rate; End period: no consideration taken
4 Start period: pro rate; End period: full consideration taken
5 Start period: No consideration; End period: Pro rata
6 Start period: Full consideration; End period: Pro rata
7 Start period: No consideration; End period: full considerat.
8 Start period: Full consideration; End period: no considerat.
SSALBAS Indicator for debit position/incoming pmnt (internal FiMa) TFMSSALBAS CHAR 1 0
NULL Planned flow
1 (Posted) debit position
2 (Posted) incoming payment
SKONDGRP Condition group in cash flow calculator SKONDGRP NUMC 4 0
LCNETAMOUNT Net Amount of Cash Flow Item in Local Currency RECDCFLCVALUENET CURR 15 2
LCGROSSAMOUNT Gross Amount of Cash Flow Item in Local Currency RECDCFLCVALUEGROSS CURR 15 2
LCTAXAMOUNT Sales/Purch. Tax Amount of Cash Flow Item in Local Currency RECDCFLCTAXVALUE CURR 15 2
LOCALCURR Local Currency of Cash Flow Item RECDCFLCCURR CUKY 5 0
CCNETAMOUNT Net Amount of Cash Flow Item in Condition Currency RECDCFVALUENET CURR 15 2
CCGROSSAMOUNT Gross Amount of Cash Flow Item in Condition Currency RECDCFVALUEGROSS CURR 15 2
CCTAXAMOUNT Tax on Sales/Purch. of Cash Flow Item in Condition Currency RECDCFTAXVALUE CURR 15 2
CONDCURR Condition Currency of Cash Flow Item RECDCFCURR CUKY 5 0
TAXTYPE Tax Type RERATAXTYPE TIVRATAXTYPE CHAR 4 0
TAXGROUP Tax Group RERATAXGROUP TIVRATAXGROUP CHAR 20 0
TXJCD Tax Jurisdiction TXJCD CHAR 15 0
ISGROSS Condition Amount Is Gross Amount RECDISGROSS CHAR 1 0
X Yes
NULL No
WHEREFROM Flow Origin RECDWHEREFROM CHAR 1 0
G Entered by TR - Generating Program (Financial Mathematics)
F Entered by RE - Generating Program (Follow-Up Postings)
O Entered by TR - Generating Program (One-Time Conditions)
P Entered by Process - One-Time Postings
A Entered by Process - Accruals/Deferrals
R Entered by RE - Generator (Differences)
S Entered by RE - Generator (Split)
E Entered by Process - Reservation/Continuous Occupancy
U Entered by Process - Sales-Based Settlement
FLOWTYPE Flow Type RECDFLOWTYPE TIVCDFLOWTYPE CHAR 4 0
ORIGFLOWTYPE Original Flow Type RECDORIGFLOWTYPE TIVCDFLOWTYPE CHAR 4 0
REFFLOWREL Type of Relationship Between Flow Type and Refer.Flow Type RECDREFFLOWREL TIVCDREFFLOWREL CHAR 3 0
CFSTATUS Indicates Status of Flow RECDCFSTATUS CHAR 1 0
P Planned Record
I Actual Record
V Partially Canceled
FDLEV Planning level FDLEV CHAR 2 0
FDUPD Flag as to whether record enters cash management + forecast FDUPD CHAR 1 0
X Selection character
NULL Blank
FDELETE Deletion Indicator for Archiving RECAARDELETEIND CHAR 1 0
X Yes
NULL No
ORIGDUEDATE Original Due Date RECDORIGDUEDATE DATS 8 0
PARTNER Business Partner of Cash Flow REISCFPARTNER CHAR 10 0
PARTNEROBJNR Object Number RECAOBJNR CHAR 22 0
CONDTYPE Condition Type RECDCONDTYPE TIVCDCONDTYPE CHAR 4 0
TERMNOPY Number of Posting Term RECDTERMNOPY CHAR 4 0
TERMNORH Number of Frequency Term RECDTERMNORH CHAR 4 0
TERMNOAJ Number of Adjustment Term RECDTERMNOAJ CHAR 4 0
TERMNOOA Number of Organizational Assignment Term RECDTERMNOOA CHAR 4 0
TERMNOSR Number of Sales Term RECDTERMNOSR CHAR 4 0
TERMNOMR Number of Peak Sales Term RECDTERMNOMR CHAR 4 0
TERMNOWT Number of Withholding Tax Term RECDTERMNOWT CHAR 4 0
ORIGEXDUEDATE Original Due Date RECDORIGDUEDATE DATS 8 0
SEAPSTATUS Status of Advance Payment Relevant to SCS RERASEAPSTATUS CHAR 1 0
NULL Not Yet Considered
+ Simulation Mode
X Was Updated
POSTINGDATE Posting Date RECDPOSTINGDATE DATS 8 0
DOCUMENTDATE Document Date RECDDOCUMENTDATE DATS 8 0
VALUATIONDATE Date for Translation of Contract Currency to Local Currency RECDVALUATIONDATE DATS 8 0
REVERSAL_FOR GUID (RAW16) for 'Reversal for' References RECDREVERSALFORGUID RAW 16 0
REVERSAL_BY GUID (RAW16) for 'Reversed by' References RECDREVERSALBYGUID RAW 16 0
FOLLOWUP_FOR GUID (RAW16) for 'Follow-Up Posting for' References RECDFOLLOWUPFORGUID RAW 16 0
BOOK_FLOWTYPE Flow Type RECDFLOWTYPE TIVCDFLOWTYPE CHAR 4 0
BOOK_REFFLOWREL Type of Relationship Between Flow Type and Refer.Flow Type RECDREFFLOWREL TIVCDREFFLOWREL CHAR 3 0
TAXDATE Date of Calculation of Sales/Purchase Tax RECDTAXDATE DATS 8 0
MODDUEDATE Modified Due Date RECDMODDUEDATE DATS 8 0
CALCDUEDATE Calculated Due Date RECDCALCDUEDATE DATS 8 0
CTRULE Currency Translation Rule RECACTRULE CHAR 20 0
CTLCNETAMOUNT Net Amount in Local Currency RECACTLCNETAMOUNT CURR 15 2
CTLCGROSSAMOUNT Gross Amount in Local Currency RECACTLCGROSSAMOUNT CURR 15 2
CTLCTAXAMOUNT Tax Amount in Local Currency RECACTLCTAXAMOUNT CURR 15 2
CTRATE Exchange Rate RECACTRATE DEC 9 5
CTRATEORIG Exchange Rate RECACTRATE DEC 9 5
CTPOSTCDCURR Post in Condition Currency RECACTPOSTCDCURR CHAR 1 0
X Yes
NULL No
CTDATEREQ Planned Translation Date RECACTDATEREQ DATS 8 0
CTDATEACT Actual Translation Date RECACTDATEACT DATS 8 0
CTDATEACTORIG Actual Translation Date RECACTDATEACT DATS 8 0
SPLANIST Plan/actual record/record to be released indicator SPLANIST CHAR 1 0
P Planned Record
I Actual Record
F Record to be Released
S Simulated Record
SWOHER Source of flow record TFM_SWOHER CHAR 1 0
NULL Non-condition FiMa flow record
K FiMa condition flow record
C Imputed FiMa flow record
SBEWEGRP Flow record group in cash flow calculator SBEWEGRP NUMC 4 0
SBERFIMA Calculation category for cash flow calculator SBEWFIMA CHAR 4 0
SAEND Change Indicator for FiMa Flow Records TFM_SAEND NUMC 1 0
0 Can be Changed
1 Cannot be Changed
2 Due Date and Payment Date Cannot be Changed
3 Application Part of Flow Record Cannot be Changed
9 To Be Deleted
BBWHR2 Amount TFMBBWHR2 DEC 26 5
BBASISUR Original calculation basis (e.g. for interval calculation) TFMBBASISU CURR 23 2
BBASIS Calculation Base Amount TFM_BBASIS CURR 23 2
TBERVON Time of Start of Calculation Period TFM_TBERVON TIMS 6 0
TBERBIS Time of End of Calculation Period TFM_TBERBIS TIMS 6 0
TVALUT Time of Calculation Date TFM_TVALUT TIMS 6 0
SRUNDVORF Rounding of interim results for prepayments VVSRUNDVF NUMC 1 0
0 Redemption is rounded up/down
1 Interest rounded up/down if >= 5
2 Interest rounded up/down if > 5
DVERRECH Settlement date VVDVERRECH DATS 8 0
ASEKUNDEN Number of Seconds TFMASEKUNDEN DEC 5 0
JEXPOZINS Exponential Interest Calculation TB_JZINSRE CHAR 1 0
X Yes
NULL No
PKOND Percentage rate for condition items PKOND DEC 10 7
DPKOND Determination date for percentage rate of condition items VVDPKOND DATS 8 0
DZFEST Interest rate fixing date TB_DZFEST DATS 8 0
KBKOND Currency-independent FiMa condition amount TFM_KBKOND DEC 15 6
BUGRENZ Lower Limit for Amount TFMBUGRENZ CURR 23 2
BOGRENZ Upper Limit for Amt TFMBOGRENZ CURR 23 2
BTIKALK Imputed annuity repayment amount (internal FiMa) TFM_TIKALK CURR 23 2
BKARZINS Interest amount on diff. betw. clearing/pmnt date (int.FIMA) TFMKARZINS CURR 23 2
ASTUECK No. of units for unit-quoted securities (fin. mathematics) TFMASTUECK DEC 15 5
SSTCKKZ Accrued interest method SSTCKKZ CHAR 1 0
P Plus accrued interest
M Minus accrued interest
O No accrued interest, next coupon only partial right
NULL Accrued int. determined automat. acc. to coupon cutting day
F Traded flat, accrued interest included in price
SSTCKTG Accrued interest: Daily method SSTCKTG CHAR 1 0
1 360E/360
B 360E/365
F 360/360 (ISDA)
H 360/365 (ISDA)
7 360/360
2 Act/360
E Act/364
3 Act/365
4 Act/366
5 Act/ActP (ICMA)
6 Act/ActY (ISDA)
G Act/ActE (AFB)
A ActW/252
D 365/360
C 365/365
I 360E/ActY
8 *365/360
9 *365.25/360
P 1/1
J m+act/360
K m+30/360
0 Not Specified
SSTCKNOT Internal FiMa indicator for unit-quoted securities TFMSTCKNOT NUMC 1 0
0 Not unit-quoted
1 Unit-quoted
SFLAT Indicator 'Traded flat',i.e.no accrued interest calculation VVSFLAT CHAR 1 0
X Yes
NULL No
JGESUCHT Int. indicator for alternative calculations VVJGESUCHT CHAR 1 0
SBERECH Grace Period Interest Method SBERECH CHAR 1 0
X Yes
NULL No
SBASFIX Indicator for fixing calculation base TFMSBASFIX NUMC 1 0
0 For each entry
1 At start of period
2 At end of period
3 At start of calculation
4 At end of calculation
SFANT Indicator for due date-related FiMa calculations VVSFANT NUMC 1 0
0 Do not use due date in calculation
1 Calculate using due date
RURKONDIND Reference index for an investment mathematical item VVRKONDIND INT4 10 0
RURBEWEIND Reference index for a FiMa flow record VVRBEWEIND INT4 10 0
SKALIDWT Interest Calendar TFMSKALIDWT CHAR 2 0
SROUND Rounding Category TFM_SROUND CHAR 1 0
NULL Round to the Nearest
- Round Down
+ Round Up
BROUNDUNIT Rounding Unit TFMPRUNIT DEC 13 7
BBASISUNIT Base Unit for Rounding TFM_BBASISUNIT CURR 17 2
PPAYMENT Payment Rate TFM_PPAYMENT DEC 11 7
SDISCOUNT Discounting Category TFM_SDISCOUNT NUMC 1 0
0 No Discounting
1 Discounting with Compounding Factor
2 Discounting with Discounting Factor
PDISCOUNT Percentage Discount Rate TFM_PDISCOUNT DEC 10 7
AMMRHYZV Interest Settlement Frequency for Exponential Interest Calc. TFM_AMMRHYZV NUMC 2 0
00 Annual Interest Settlement
06 Interest Settlement Every Six Months
03 Quarterly Interest Settlement
01 Monthly Interest Settlement
52 Weekly Interest Settlement
97 Daily Interest Settlement (360)
98 Daily Interest Settlement (365)
99 Continuous Interest Settlement
ARHYREL Relative Frequency TFM_ARHYREL NUMC 3 0
JRATENFIX Keep Installment TFM_JRATENFIX CHAR 1 0
X Yes
NULL No
JANNVERR Settle Annuity Installment TFM_JANNVERR CHAR 1 0
NULL Settle Repayment Share
X Settle Annuity Installment
JSOFTILG Begin with Repayment Immediately TFM_JSOFTILG CHAR 1 0
NULL Begin With Repayment When Balance > Zero
X Begin with Repayment Immediately
SVKEYDAY Key Date for Update of Calculation Date TFM_SVKEYDAY NUMC 2 0
SFKEYDAY Key Date for Update of Due Date TFM_SFKEYDAY NUMC 2 0
JINTRADAY Intraday Interest Calculation TFM_JINTRADAY CHAR 1 0
X Yes
NULL No
JEFFZREL Relevant for Effective Interest Rate TFM_JEFFZREL CHAR 1 0
XCONDITION Condition Type Name RECDXCONDITION CHAR 30 0
XCONDCURR Condition Currency Name RECDXCONDCURR CHAR 40 0
XTAXTYPE Name of Tax Type RERAXMTAXTYPE CHAR 30 0
XTAXGROUP Name of Tax Group RERAXMTAXGROUP CHAR 30 0
XLOCALCURR Local Currency Name RECDXLOCALCURR CHAR 40 0
XFLOWTYPE Name of Flow Type RECDXFLOWTYPE CHAR 30 0
ICON_CFSTATUS Cash Flow Status RECDICONCFSTATUS CHAR 132 0
ICON_REFFLOWREL Relationship of Flow Type to Reference Flow Type RECDICONREFFLOWREL CHAR 132 0
BOOK_XFLOWTYPE Name of Flow Type RECDXFLOWTYPE CHAR 30 0
ICON_BOOK_REFFLOWREL Relationship of Flow Type to Posting Flow Type RECDICONBREFFLOWREL CHAR 132 0
PROCESSID Process Identification -> Accounting Reference Number RECAPROCESSID CHAR 16 0
XWHEREFROM Flow Origin RECDXWHEREFROM CHAR 60 0
OBJIDENTCALC Complete Object Identification, for Example BE 1000/123 RECAIDENT CHAR 50 0
CONDDELETE Deletion Indicator for Condition RECDCONDDELETE CHAR 1 0
X Yes
NULL No
SWENR Site Number REBDBENO CHAR 8 0
SGENR Number of Building REBDBUNO CHAR 8 0
SGRNR Number of Land REBDPRNO CHAR 8 0
NORUPS Number of Pooled Space or Rental Unit REBDNORUPS CHAR 8 0
FUND Fund RERAFUND CHAR 24 0
FUNDSCENTER Funds Center RERAFUNDSCENTER CHAR 24 0
COMMITMENTITEM Commitment Item RERACOMMITMENTITEM CHAR 24 0
FUNCTIONALAREA Functional Area RERAFUNCTIONALAREA CHAR 24 0
GRANTNUMBER Grant RERAGRANTNUMBER CHAR 24 0
MEASURE Program in Funds Management RERAMEASURE CHAR 24 0
BUDGETPERIOD FM: Budget Period RERABUDGETPERIOD CHAR 24 0
NORS Number of Rental Space REBDNORS CHAR 8 0
OBJECTID Object ID REISOBJECTID CHAR 40 0
OBJECTTEXT Short Description of Object REISOBJECTTEXT CHAR 60 0
OBJECTICON Icon: Object Type REISOBJECTICON CHAR 137 0
OBJECT_VALIDFROM Date: Object Valid From REISOBJVALIDFROM DATS 8 0
OBJECT_VALIDTO Date: Object Valid To REISOBJVALIDTO DATS 8 0
ROLE_BP1 First Main Contractual Partner: Role REBPROLE1 CHAR 6 0
XROLE_BP1 1st Main Contractual Partner: Name of Role Category REBPXROLE1 CHAR 30 0
PARTNER_BP1 First Main Contractual Partner REBPPARTNER1 CHAR 10 0
XPARTNER_BP1 Name/Address of 1st Business Partner REBPXPARTNER1 CHAR 80 0
TEL_NUMBER_LONG_BP1 Complete number: dialling code+number+extension AD_TELNRLG CHAR 30 0
FAX_NUMBER_LONG_BP1 Complete number: dialling code+number+extension AD_FXNRLNG CHAR 30 0
SMTP_ADDR_BP1 E-Mail Address AD_SMTPADR CHAR 241 0
XNAME_BP1 Short Description of 1st Business Partner REBPXNAME1 CHAR 50 0
STREET_BP1 Street AD_STREET CHAR 60 0
HOUSE_NUM1_BP1 House Number AD_HSNM1 CHAR 10 0
POST_CODE1_BP1 City postal code AD_PSTCD1 CHAR 10 0
CITY1_BP1 City AD_CITY1 CHAR 40 0
CITY2_BP1 District AD_CITY2 CHAR 40 0
REGION_BP1 Region (State, Province, County) REGIO CHAR 3 0
PO_BOX_BP1 PO Box AD_POBX CHAR 10 0
POST_CODE2_BP1 PO Box Postal Code AD_PSTCD2 CHAR 10 0
ROLE_BP2 Second Main Contractual Partner: Role REBPROLE2 CHAR 6 0
XROLE_BP2 2nd Main Contractual Partner: Name of Role Category REBPXROLE2 CHAR 30 0
PARTNER_BP2 Second Main Contractual Partner REBPPARTNER2 CHAR 10 0
XPARTNER_BP2 Name/Address of 2nd Business Partner REBPXPARTNER2 CHAR 80 0
TEL_NUMBER_LONG_BP2 Complete number: dialling code+number+extension AD_TELNRLG CHAR 30 0
FAX_NUMBER_LONG_BP2 Complete number: dialling code+number+extension AD_FXNRLNG CHAR 30 0
SMTP_ADDR_BP2 E-Mail Address AD_SMTPADR CHAR 241 0
XNAME_BP2 Short Description of 2nd Business Partner REBPXNAME2 CHAR 50 0
STREET_BP2 Street AD_STREET CHAR 60 0
HOUSE_NUM1_BP2 House Number AD_HSNM1 CHAR 10 0
POST_CODE1_BP2 City postal code AD_PSTCD1 CHAR 10 0
CITY1_BP2 City AD_CITY1 CHAR 40 0
CITY2_BP2 District AD_CITY2 CHAR 40 0
REGION_BP2 Region (State, Province, County) REGIO CHAR 3 0
PO_BOX_BP2 PO Box AD_POBX CHAR 10 0
POST_CODE2_BP2 PO Box Postal Code AD_PSTCD2 CHAR 10 0
GEN_OBJTYPE Object Type RECAOBJTYPE CHAR 2 0
GEN_OBJNR Object Number RECAOBJNR CHAR 22 0
GEN_CONTRACT Object Number RECAOBJNR CHAR 22 0
GEN_PARTNER1 Business Partner Number BU_PARTNER CHAR 10 0
GEN_PARTNER2 Business Partner Number BU_PARTNER CHAR 10 0
ALVROWS Number of Rows REISALVROWS INT2 5 0
INFOCOND Statistical or Informational Condition RECDINFOCOND CHAR 1 0
X Yes
NULL No
RECISVALIDFROM Displayed Row Is Valid From REISRECVALIDFROM DATS 8 0
RECISVALIDTO Displayed Row Is Valid Until REISRECVALIDTO DATS 8 0
OBJECT_BUKRS Object Company Code REISOBJECTBUKRS CHAR 4 0
XPARTNER Description of a Business Partner BU_DESCRIP_LONG CHAR 80 0
OIACCOUNTTYPE Account Type RERAOIACCOUNTTYPE CHAR 1 0
1 Customer
2 Vendor
3 Contract A/R + A/P
OIACCOUNT Open Item Account RERAOIACCOUNT CHAR 20 0
PO_SUB_NO ISR Subscriber Number ESRNR CHAR 11 0
PO_REF_NO ISR Reference Number ESRRE CHAR 27 0
PO_TEXT Text of Vendor Invoice REXCRAESRREFTEXT CHAR 60 0
ESRREFDELFITXT Delete FI Posting Text (Yes or No) REXCRAESRREFDELFITXT CHAR 1 0
X Yes
NULL No
DOCGUID GUID: Unique Internal Key for RE Document RERADOCGUID RAW 16 0
ITEMNO Accounting Document Line Item Number POSNR_ACC NUMC 10 0

REIS_CASHFLOW_PAY_L foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
REIS_CASHFLOW_PAY_L BOOK_FLOWTYPE SYST MANDT TIVCDFLOWTYPE Flow Type MANDT
REIS_CASHFLOW_PAY_L BOOK_FLOWTYPE REIS_CASHFLOW_PAY_L BOOK_FLOWTYPE TIVCDFLOWTYPE Flow Type FLOWTYPE
REIS_CASHFLOW_PAY_L BOOK_REFFLOWREL REIS_CASHFLOW_PAY_L BOOK_REFFLOWREL TIVCDREFFLOWREL Type of Relationships Between Flow Types REFFLOWREL
REIS_CASHFLOW_PAY_L BUKRS SYST MANDT T001 Company Codes MANDT
REIS_CASHFLOW_PAY_L BUKRS REIS_CASHFLOW_PAY_L BUKRS T001 Company Codes BUKRS
REIS_CASHFLOW_PAY_L CONDTYPE SYST MANDT TIVCDCONDTYPE Condition Type MANDT
REIS_CASHFLOW_PAY_L CONDTYPE REIS_CASHFLOW_PAY_L CONDTYPE TIVCDCONDTYPE Condition Type CONDTYPE
REIS_CASHFLOW_PAY_L DPTARGETTYPE SYST MANDT TIVCNDPTYPE Security Deposit Type MANDT
REIS_CASHFLOW_PAY_L DPTARGETTYPE REIS_CASHFLOW_PAY_L DPTARGETTYPE TIVCNDPTYPE Security Deposit Type DPTYPE
REIS_CASHFLOW_PAY_L FLOWTYPE SYST MANDT TIVCDFLOWTYPE Flow Type MANDT
REIS_CASHFLOW_PAY_L FLOWTYPE REIS_CASHFLOW_PAY_L FLOWTYPE TIVCDFLOWTYPE Flow Type FLOWTYPE
REIS_CASHFLOW_PAY_L ORIGFLOWTYPE SYST MANDT TIVCDFLOWTYPE Flow Type MANDT
REIS_CASHFLOW_PAY_L ORIGFLOWTYPE REIS_CASHFLOW_PAY_L ORIGFLOWTYPE TIVCDFLOWTYPE Flow Type FLOWTYPE
REIS_CASHFLOW_PAY_L RECNBUKRSCOLLECT SYST MANDT T001 Company Codes MANDT
REIS_CASHFLOW_PAY_L RECNBUKRSCOLLECT REIS_CASHFLOW_PAY_L RECNBUKRSCOLLECT T001 Company Codes BUKRS
REIS_CASHFLOW_PAY_L RECNNOTREASON SYST MANDT TIVCNNTRE Reason for Notice MANDT
REIS_CASHFLOW_PAY_L RECNNOTREASON REIS_CASHFLOW_PAY_L RECNNOTREASON TIVCNNTRE Reason for Notice NTREASON
REIS_CASHFLOW_PAY_L RECNTLAW SYST MANDT TIV03 Country-specific tenancy law MANDT
REIS_CASHFLOW_PAY_L RECNTLAW REIS_CASHFLOW_PAY_L RECNTLAW TIV03 Country-specific tenancy law SMIETR
REIS_CASHFLOW_PAY_L RECNTYPE REIS_CASHFLOW_PAY_L RECNTYPE TIV26 Real Estate Contract Type (Entities) SMVART
REIS_CASHFLOW_PAY_L RECNTYPE SYST MANDT TIV26 Real Estate Contract Type (Entities) MANDT
REIS_CASHFLOW_PAY_L REFFLOWREL REIS_CASHFLOW_PAY_L REFFLOWREL TIVCDREFFLOWREL Type of Relationships Between Flow Types REFFLOWREL
REIS_CASHFLOW_PAY_L RESPONSIBLE REIS_CASHFLOW_PAY_L RESPONSIBLE USR02 Logon Data (Kernel-Side Use) BNAME
REIS_CASHFLOW_PAY_L RESPONSIBLE SYST MANDT USR02 Logon Data (Kernel-Side Use) MANDT
REIS_CASHFLOW_PAY_L TAXGROUP REIS_CASHFLOW_PAY_L TAXGROUP TIVRATAXGROUP Tax Group TAXGROUP
REIS_CASHFLOW_PAY_L TAXGROUP SYST MANDT TIVRATAXGROUP Tax Group MANDT
REIS_CASHFLOW_PAY_L TAXTYPE SYST MANDT TIVRATAXTYPE Tax Types MANDT
REIS_CASHFLOW_PAY_L TAXTYPE * TIVRATAXTYPE Tax Types COUNTRY
REIS_CASHFLOW_PAY_L TAXTYPE REIS_CASHFLOW_PAY_L TAXTYPE TIVRATAXTYPE Tax Types TAXTYPE
REIS_CASHFLOW_PAY_L USEREXCLUSIVE SYST MANDT USR02 Logon Data (Kernel-Side Use) MANDT
REIS_CASHFLOW_PAY_L USEREXCLUSIVE REIS_CASHFLOW_PAY_L USEREXCLUSIVE USR02 Logon Data (Kernel-Side Use) BNAME