P_CADOCUMENTBPITEMPHYSENHCD

CDS View
15 Fields 6 CDS Views

Document Items without Rep Item Template

P_CADOCUMENTBPITEMPHYSENHCD is a CDS View in S/4HANA. Document Items without Rep Item Template. It contains 15 fields. 6 CDS views read from this table.

CDS Views using this table (6)

ViewTypeJoinVDMDescription
C_CADocumentBPItemLogical view_entity from CONSUMPTION Contr Acct Business Partner Item
P_CADocumentBPItemCount view_entity from COMPOSITE Count of Document BP Items
P_CADocumentClearedAmountInTC view_entity from COMPOSITE Cleared Amount in Transaction Currency
P_CADocumentDueAmountInTC view_entity from COMPOSITE Due Amount of a Ca Document in TC
P_CADocumentOpenAmountInTC view_entity from COMPOSITE Open Amount of a Contr Acctg Document
P_CADocumentSumBPItem view_entity from COMPOSITE Summarized Business Partner Items

Fields (15)

KeyField CDS FieldsUsed in Views
KEY BusinessPartner BusinessPartner 1
KEY CAApplicationArea CAApplicationArea 1
KEY CADocumentNumber CADocumentNumber 5
KEY CAMainTransaction CAMainTransaction 1
KEY CASubTransaction CASubTransaction 1
KEY CompanyCode CompanyCode 1
KEY ContractAccount ContractAccount 1
KEY TransactionCurrency TransactionCurrency 4
_BusinessPartner _BusinessPartner 1
_CAPartner _CAPartner 1
_CompCode _CompCode 1
_Currency _Currency 4
_DocHeader _DocHeader 1
_MainTransaction _MainTransaction 1
_SubTransaction _SubTransaction 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.

-- Document Items without Rep Item Template
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_CADOCUMENTBPITEMPHYSENHCD (
    BUSINESSPARTNER,
    CAAPPLICATIONAREA,
    CADOCUMENTNUMBER,
    CAMAINTRANSACTION,
    CASUBTRANSACTION,
    COMPANYCODE,
    CONTRACTACCOUNT,
    TRANSACTIONCURRENCY,
    _BUSINESSPARTNER,
    _CAPARTNER,
    _COMPCODE,
    _CURRENCY,
    _DOCHEADER,
    _MAINTRANSACTION,
    _SUBTRANSACTION,
    PRIMARY KEY (BUSINESSPARTNER, CAAPPLICATIONAREA, CADOCUMENTNUMBER, CAMAINTRANSACTION, CASUBTRANSACTION, COMPANYCODE, CONTRACTACCOUNT, TRANSACTIONCURRENCY)
);

Learn More