I_RECashFlowC

Real Estate Cash Flow - Cube | view: IRECSHFLWC | TRAN | Extraction: Not supported | Component: Real Estate Contract
Tables used: VICDCFOBJ, VICDCFPAY, T001, TKA02, VICNCN, TIV26, TIVCDFLOWTYPE, VICAINTRENO, TIVCNCCTADD, FINSC_FISC_DATE
Column Name Description
RECashFlowRecordUUID Real Estate Cashflow Object Number
Column Name Description
💲 Local Currency of Cash Flow Item (RECashFlowLoclCurrency):
RECashFlowLoclNetAmount null
RECashFlowLoclGrossAmount null
RECashFlowLoclTaxAmount null
💲 Condition Currency of Cash Flow Item (RECashFlowConditionCurrency):
RECashFlowConditionNetAmount null
RECashFlowConditionGrossAmount null
RECashFlowConditionTaxAmount null
FinTransFlowNomAmt Net Cash Flow in Condition Currency
💲 Display Currency (DisplayCurrency):
NetAmountInDisplayCurrency Net Cash Flow in Display Currency
Column Name Description
Column Name Description
REContractActivateDate Active From
CalculationPeriodStartDate Start of Calculation Period
CalculationPeriodEndDate End of Calculation Period
CalculationDate Calculation Date
PaymentDueDate Due date
REBeginOfPeriodDate Period start
REEndOfPeriodDate Period End
PostingDate Posting Date
DocumentDate Document Date
REContractCashFlowDate Cash Flow Generated Starting On
ContractStartDate Contract Start Date
ContractEndDate Contract End Date
ValidityStartDate Date from when condition is valid
Column Name Description
DebitCreditCode Debit/Credit Indicator Show values
CashFlowPostingStatus Indicates Status of Flow Show values
RECashFlowOrigin Origin of the Cash Flow Show values
REContractIsActive Contract Active Show values
REContractUserSupplier Offerer (Customer), User (Vendor) Show values
REIsSalesRelevant Indicator: Relevant to Sales Show values
Column Name Description Domain name
REConditionUUID GUID (RAW16) for Conditions RECAGUID
InternalRealEstateNumber Internal Key of Real Estate Object RECAINTRENO
REStatusObject Real estate object: Object no. J_OBJNR
RealEstateObjectType Object Type J_OBART
RealEstateContract Real Estate Contract RECNVDMCNNR
BusinessPartner Business Partner Number BU_PARTNER
REPartnerStatusObject Partner Object J_OBJNR
ControllingArea Controlling Area CACCD
CostCenter Cost Center KOSTL
InternalOrder Order Number AUFNR
REDocumentReferenceUUID GUID (RAW16) for Document References in Cash Flow RECAGUID
REContractName Contract Name XTEXT80
REContractNumberOld Number of Old Contract VVOSMIVE
REIndustrySector Industry BU_INDSECTOR
REBusinessEntity RE Business Entity REBDVDMBENO
REIdentificationKey ID Part Key, for example "1000/123" CHAR45
REAuthorizationGroup Authorization Group RECAAUTHGRP
FiscalYearPeriod Fiscal Year + Fiscal Period FINS_FYEARPERIOD
FiscalYear Fiscal Year GJAHR
FiscalQuarter Fiscal Quarter FINS_FSCALQUARTER
FiscalPeriod Fiscal Period POPER
Master Data Relations Join Conditions
Company Code
  • Client
  • Company Code
  • Real Estate Contract Company Code
  • I_RECASHFLOWC.MANDT == T001.MANDT
  • I_RECASHFLOWC.COMPANYCODE == T001.BUKRS
  • I_RECASHFLOWC.RECONTRACTCOMPANYCODE == T001.BUKRS
Fiscal Year Variant
  • Client
  • Fiscal Year Variant
  • I_RECASHFLOWC.MANDT == T009.MANDT
  • I_RECASHFLOWC.FISCALYEARVARIANT == T009.PERIV
Booked Flow Type
  • Client
  • Booked Flow Type
Real Estate Contract Company Code
  • Client
  • Company Code
  • Real Estate Contract Company Code
  • I_RECASHFLOWC.MANDT == T001.MANDT
  • I_RECASHFLOWC.COMPANYCODE == T001.BUKRS
  • I_RECASHFLOWC.RECONTRACTCOMPANYCODE == T001.BUKRS
Currency for Contract
  • Client
  • Currency for Contract
  • I_RECASHFLOWC.MANDT == TCURC.MANDT
  • I_RECASHFLOWC.RECONTRACTCURRENCY == TCURC.WAERS
Reason for Notice
  • Client
  • Reason for Notice
  • I_RECASHFLOWC.MANDT == TIVCNNTRE.MANDT
  • I_RECASHFLOWC.RECONTRACTNOTICEREASON == TIVCNNTRE.NTREASON
Contract Type
  • Client
  • Contract Type
  • I_RECASHFLOWC.MANDT == TIV26.MANDT
  • I_RECASHFLOWC.RECONTRACTTYPE == TIV26.SMVART
Flow Type
  • Client
  • Flow Type