I_CADOCUMENTBPITEMLOGICAL

CDS View
38 Fields 26 CDS Views

Document Logical Business Partner Item

I_CADOCUMENTBPITEMLOGICAL is a CDS View in S/4HANA. Document Logical Business Partner Item. It contains 38 fields. 26 CDS views read from this table.

CDS Views using this table (26)

ViewTypeJoinVDMDescription
C_CABusinessPartnerLineItem view from CONSUMPTION
C_CACreditItemAnalysis view from CONSUMPTION Analyse von Guthabenposten
C_CALockedOpenItem view from CONSUMPTION Gesperrte offene Posten
C_CANotDisputedDocumentItem view from CONSUMPTION Not Disputed Document item
C_CAOpenItemLockedOnBP view from CONSUMPTION Offene Posten gesperrt auf Partner
C_CAOpenItemLockedOnContrAcct view from CONSUMPTION Offene Posten gesperrt auf Vertragskonto
C_CAOpenItemLockedOnContract view from CONSUMPTION Offene Posten gesperrt auf Vertrag
C_CAOpenItemLockedOnContrItem view from CONSUMPTION Offene Posten gesperrt auf Vertragspos.
C_CAOverdueItemAnalysis view from CONSUMPTION Überfällige Posten analysieren
I_CAAccountBalanceItem view from COMPOSITE Kontoauszug - Position
I_CAAccountBalanceItem view union_all COMPOSITE Kontoauszug - Position
I_CABalanceNotificationItem view from COMPOSITE FI-CAC: balance notification
I_CABalanceNotificationItem view union_all COMPOSITE FI-CAC: balance notification
I_CADocSeparatedAmounts view from COMPOSITE Aufgeteilte Beträge eines Belegs
I_CADocumentBPItemLogicalEnhcd view_entity from COMPOSITE Enhanced Document Logical BP Item
I_CADocumentTotalAmountOpen view from COMPOSITE Offener Betrag eines Beleges
I_ContractAcctOpenAmtPerCrcy view from COMPOSITE Offener Betrag pro Vertragskonto und Währung
P_CAAnalyzeReceivables view from CONSUMPTION
P_CAClearingReasonAnalysis view_entity from COMPOSITE Prepare the data for clearing reason
P_CAClearingReasonAnalysis view_entity union_all COMPOSITE Prepare the data for clearing reason
P_CADocCreditItemBPAmount view_entity from COMPOSITE Document with business partner amounts
P_CADocumentBPItem view from COMPOSITE
P_CAInstallmentPlnBPItmLogical view from CONSUMPTION
P_CAInterestNoticeTotalAmount view from COMPOSITE
P_CANotDisputedDocBPItem view from COMPOSITE
P_CAOverdueItemSelection view_entity from COMPOSITE

Fields (38)

KeyField CDS FieldsUsed in Views
KEY CABPItemNumber CABPItemNumber 13
KEY CADocumentNumber CADocumentNumber 12
KEY CARepetitionItemNumber CARepetitionItemNumber 13
KEY CASubItemNumber CASubItemNumber 13
_BusinessPartner _BusinessPartner 1
_CAPartner _CAPartner 1
_CompCode _CompCode 1
_ProviderContract _ProviderContract 1
BusinessArea BusinessArea 11
BusinessPartner BusinessPartner 12
CAAccountDeterminationCode CAAccountDeterminationCode 4
CAAmountInTransactionCurrency AmountInDisplayCurrency,CAAmountInTransactionCurrency 5
CAApplicationArea CAApplicationArea 2
CAClearingCurrency TransactionCurrency 2
CAClearingDate CAClearingDate 1
CAClearingReason CAClearingReason 2
CAClearingStatus CAClearingStatus 5
CAContract CAContract 12
CADocumentOriginCode CADocumentOriginCode 1
CADocumentType CADocumentType 5
CADoubtfulOrValueAdjmtCode CADoubtfulOrValueAdjmtCode 1
CADunningProcedure CADunningProcedure 4
CAMainTransaction CAMainTransaction 12
CANetDueDate CANetDueDate 3
CAPaymentMethod CAPaymentMethod 6
CAPostingDate CAPostingDate 2
CAPostingDateOfClearingDoc CAPostingDate,CAPostingDateOfClearingDoc 4
CAProviderContractItemNumber CAProviderContractItemNumber 2
CAStatisticalItemCode CAStatisticalItemCode 5
CASubApplication CASubApplication 5
CASubTransaction CASubTransaction 12
CAValueDateForClearing CAValueDateForClearing 2
CompanyCode CompanyCode 12
ContractAccount ContractAccount 12
Country Country 1
Division Division 10
Segment Segment 11
TransactionCurrency TransactionCurrency 11

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 Logical Business Partner Item
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_CADOCUMENTBPITEMLOGICAL (
    CABPITEMNUMBER,
    CADOCUMENTNUMBER,
    CAREPETITIONITEMNUMBER,
    CASUBITEMNUMBER,
    _BUSINESSPARTNER,
    _CAPARTNER,
    _COMPCODE,
    _PROVIDERCONTRACT,
    BUSINESSAREA,
    BUSINESSPARTNER,
    CAACCOUNTDETERMINATIONCODE,
    CAAMOUNTINTRANSACTIONCURRENCY,
    CAAPPLICATIONAREA,
    CACLEARINGCURRENCY,
    CACLEARINGDATE,
    CACLEARINGREASON,
    CACLEARINGSTATUS,
    CACONTRACT,
    CADOCUMENTORIGINCODE,
    CADOCUMENTTYPE,
    CADOUBTFULORVALUEADJMTCODE,
    CADUNNINGPROCEDURE,
    CAMAINTRANSACTION,
    CANETDUEDATE,
    CAPAYMENTMETHOD,
    CAPOSTINGDATE,
    CAPOSTINGDATEOFCLEARINGDOC,
    CAPROVIDERCONTRACTITEMNUMBER,
    CASTATISTICALITEMCODE,
    CASUBAPPLICATION,
    CASUBTRANSACTION,
    CAVALUEDATEFORCLEARING,
    COMPANYCODE,
    CONTRACTACCOUNT,
    COUNTRY,
    DIVISION,
    SEGMENT,
    TRANSACTIONCURRENCY,
    PRIMARY KEY (CABPITEMNUMBER, CADOCUMENTNUMBER, CAREPETITIONITEMNUMBER, CASUBITEMNUMBER)
);

Learn More