P_CASHFLOWCOMBN

CDS View

P_CASHFLOWCOMBN is a CDS View in S/4HANA. It contains 60 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_CashFlow view from BASIC Cash Flow
I_CashFlowItemExtendBasic view from BASIC Cash Flow Item Basic
I_CashRecnclnCashFlowBasic view from BASIC Cash Reconciliation Cash Flow

Fields (60)

KeyField CDS FieldsUsed in Views
KEY CashFlow CashFlow 1
KEY flow_id CashFlowID 2
KEY OriginApplication OriginApplication 2
KEY OriginDocument OriginDocument 2
KEY OriginSystem OriginSystem 1
KEY OriginTransaction OriginTransaction 1
KEY OriginTransQualifier OriginTransactionQualifier 1
KEY ValidFrom ValidFrom 1
AccountingDocument AccountingDocument 2
AccountingDocumentItem AccountingDocumentItem 1
AccountingDocumentType AccountingDocumentType 1
AmountInCompanyCodeCurrency AmountInCompanyCodeCurrency 1
AmountInTransactionCurrency AmountInTransactionCurrency 2
BankAccountInternalID BankAccountInternalID 2
BankStatementItem BankStatementItem 2
BusinessArea BusinessArea 1
BusinessPartner BusinessPartner 1
CashPlanningGroup CashPlanningGroup 1
CertaintyLevel CertaintyLevel 2
cmm_state MemoRecordStatus 1
cmm_statistics_indicator MemoRecordStatisticItem 1
CompanyCode CompanyCode 2
CompanyCodeCurrency CompanyCodeCurrency 1
ContractNumber AssetContract 1
CostCenter CostCenter 1
CreatedByUser CreatedByUser 1
Customer Customer 1
DocumentItemText DocumentItemText 2
ExpirationDate ExpirationDate 2
fi_due_date NetDueDate 1
FinancialAccountType FinancialAccountType 1
FinancialTransactionType FinancialTransactionType 1
FiscalPeriod PostingFiscalPeriod 1
FiscalYear FiscalYear 1
Fund Fund 1
GLAccount GLAccount 1
GrantID GrantID 1
HouseBank HouseBank 1
HouseBankAccount HouseBankAccount 1
IsValid IsValid 2
LastChangedByUser LastChangedByUser 1
LiquidityItem LiquidityItem 2
Material Material 1
Owner CashTransactionOwner 1
PartnerCompany PartnerCompany 1
PaymentMethod PaymentMethod 1
PlanningLevel PlanningLevel 2
Portfolio Portfolio 1
PostingDate PostingDate 1
ProductType FinancialInstrumentProductType 1
ProfitCenter ProfitCenter 1
rel_status CashReleaseStatus 2
SecurityClass SecurityClass 1
Segment Segment 1
SourceCompanyCode SourceCompanyCode 1
TransactionCurrency TransactionCurrency 2
TransactionDate TransactionDate 2
TrmSecurityAccount SecurityAccount 1
ValueDate ValueDate 1
Vendor Supplier 1

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_CASHFLOWCOMBN (
    CASHFLOW,
    FLOW_ID,
    ORIGINAPPLICATION,
    ORIGINDOCUMENT,
    ORIGINSYSTEM,
    ORIGINTRANSACTION,
    ORIGINTRANSQUALIFIER,
    VALIDFROM,
    ACCOUNTINGDOCUMENT,
    ACCOUNTINGDOCUMENTITEM,
    ACCOUNTINGDOCUMENTTYPE,
    AMOUNTINCOMPANYCODECURRENCY,
    AMOUNTINTRANSACTIONCURRENCY,
    BANKACCOUNTINTERNALID,
    BANKSTATEMENTITEM,
    BUSINESSAREA,
    BUSINESSPARTNER,
    CASHPLANNINGGROUP,
    CERTAINTYLEVEL,
    CMM_STATE,
    CMM_STATISTICS_INDICATOR,
    COMPANYCODE,
    COMPANYCODECURRENCY,
    CONTRACTNUMBER,
    COSTCENTER,
    CREATEDBYUSER,
    CUSTOMER,
    DOCUMENTITEMTEXT,
    EXPIRATIONDATE,
    FI_DUE_DATE,
    FINANCIALACCOUNTTYPE,
    FINANCIALTRANSACTIONTYPE,
    FISCALPERIOD,
    FISCALYEAR,
    FUND,
    GLACCOUNT,
    GRANTID,
    HOUSEBANK,
    HOUSEBANKACCOUNT,
    ISVALID,
    LASTCHANGEDBYUSER,
    LIQUIDITYITEM,
    MATERIAL,
    OWNER,
    PARTNERCOMPANY,
    PAYMENTMETHOD,
    PLANNINGLEVEL,
    PORTFOLIO,
    POSTINGDATE,
    PRODUCTTYPE,
    PROFITCENTER,
    REL_STATUS,
    SECURITYCLASS,
    SEGMENT,
    SOURCECOMPANYCODE,
    TRANSACTIONCURRENCY,
    TRANSACTIONDATE,
    TRMSECURITYACCOUNT,
    VALUEDATE,
    VENDOR,
    PRIMARY KEY (CASHFLOW, FLOW_ID, ORIGINAPPLICATION, ORIGINDOCUMENT, ORIGINSYSTEM, ORIGINTRANSACTION, ORIGINTRANSQUALIFIER, VALIDFROM)
);