C_RECashFlowQ

Real Estate Cash Flow Query | view: CRECSHFLWQ | Extraction: Not supported | Component: Real Estate Contract

Tables used: VICDCFOBJ, VICDCFPAY, T001, TKA02, VICNCN, TIV26, TIVCDFLOWTYPE, VICAINTRENO, TIVCNCCTADD, FINSC_FISC_DATE

🔑 Keys (1)
💰 Amounts (2)
∑ Quantities
📅 Dates (13)
☰ Categorical (5)
Other (18)
🔗 Relations (7)

Column Name	Description
RECashFlowRecordUUID	Real Estate Cashflow Object Number

Column Name	Description
💲 Condition Currency of Cash Flow Item (RECashFlowConditionCurrency):
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

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
REIdentificationKey	ID Part Key, for example "1000/123"	CHAR45
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
FiscalYear	Fiscal Year	GJAHR
FiscalYearPeriod	Fiscal Year + Fiscal Period	FINS_FYEARPERIOD
FiscalQuarter	Fiscal Quarter	FINS_FSCALQUARTER
FiscalPeriod	Fiscal Period	POPER

Master Data Relations	Join Conditions
Company Code Company Code Real Estate Contract Company Code Client	`C_RECASHFLOWQ.COMPANYCODE == T001.BUKRS` `C_RECASHFLOWQ.RECONTRACTCOMPANYCODE == T001.BUKRS` `C_RECASHFLOWQ.MANDT == T001.MANDT`
Fiscal Year Variant Client Fiscal Year Variant	`C_RECASHFLOWQ.MANDT == T009.MANDT` `C_RECASHFLOWQ.FISCALYEARVARIANT == T009.PERIV`
Booked Flow Type Booked Flow Type Client	`C_RECASHFLOWQ.REBOOKEDFLOWTYPE == TIVCDFLOWTYPE.FLOWTYPE` `C_RECASHFLOWQ.MANDT == TIVCDFLOWTYPE.MANDT`
Real Estate Contract Company Code Company Code Real Estate Contract Company Code Client	`C_RECASHFLOWQ.COMPANYCODE == T001.BUKRS` `C_RECASHFLOWQ.RECONTRACTCOMPANYCODE == T001.BUKRS` `C_RECASHFLOWQ.MANDT == T001.MANDT`
Currency for Contract Client Currency for Contract	`C_RECASHFLOWQ.MANDT == TCURC.MANDT` `C_RECASHFLOWQ.RECONTRACTCURRENCY == TCURC.WAERS`
Contract Type Contract Type Client	`C_RECASHFLOWQ.RECONTRACTTYPE == TIV26.SMVART` `C_RECASHFLOWQ.MANDT == TIV26.MANDT`
Flow Type Flow Type Client	`C_RECASHFLOWQ.REFLOWTYPE == TIVCDFLOWTYPE.FLOWTYPE` `C_RECASHFLOWQ.MANDT == TIVCDFLOWTYPE.MANDT`