DOCCTNDOCBPITEMSUMFORDC

DOCCTNDOCBPITEMSUMFORDC is an SAP database table in S/4HANA. It contains 38 fields.

Fields (38)

KeyField CDS FieldsUsed in Views
_ApplArea _ApplArea 1
_BusinessArea _BusinessArea 1
_Currency _Currency 1
_DisplayCurrency _DisplayCurrency 1
_MainTransaction _MainTransaction 1
_Segment _Segment 1
_SubTransaction _SubTransaction 1
AmountInDisplayCurrency AmountInDisplayCurrency 1
BusinessArea BusinessArea 1
CAAmountInTransactionCurrency CAAmountInTransactionCurrency 1
CAApplicationArea CAApplicationArea 1
CABPItemText CABPItemText 1
CACashDiscountAmtInTransCrcy CACashDiscountAmtInTransCrcy 1
CACashDiscountDueDate CACashDiscountDueDate 1
CACashDiscountRate CACashDiscountRate 1
CAClearingAmountInDisplayCrcy CAClearingAmountInDisplayCrcy 1
CAClearingDate CAClearingDate 1
CAClearingReason CAClearingReason 1
CADeferralDate CADeferralDate 1
CADocumentOriginCode CADocumentOriginCode 1
CAEligibleAmountForCshDiscInDC CAEligibleAmountForCshDiscInDC 1
CAEligibleAmountForCshDiscInTC CAEligibleAmountForCshDiscInTC 1
CAGroupingForPayment CAGroupingForPayment 1
CAMainTransaction CAMainTransaction 1
CANetDueDate CANetDueDate 1
CAOpenAmountInTransactionCrcy CAOpenAmountInTransactionCrcy 1
CAPostingDate CAPostingDate 1
CAReleasedAmtInDisplayCurrency CAReleasedAmtInDisplayCurrency 1
CAReleasedAmtInTransCurrency CAReleasedAmtInTransCurrency 1
CashDiscountAmountInDspCrcy CashDiscountAmountInDspCrcy 1
CASubTransaction CASubTransaction 1
CAValueDateForClearing CAValueDateForClearing 1
DisplayCurrency DisplayCurrency 1
DocumentDate DocumentDate 1
ExchangeRateDate ExchangeRateDate 1
OpenAmountInDisplayCrcy OpenAmountInDisplayCrcy 1
Segment Segment 1
TransactionCurrency TransactionCurrency 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 DOCCTNDOCBPITEMSUMFORDC (
    _APPLAREA,
    _BUSINESSAREA,
    _CURRENCY,
    _DISPLAYCURRENCY,
    _MAINTRANSACTION,
    _SEGMENT,
    _SUBTRANSACTION,
    AMOUNTINDISPLAYCURRENCY,
    BUSINESSAREA,
    CAAMOUNTINTRANSACTIONCURRENCY,
    CAAPPLICATIONAREA,
    CABPITEMTEXT,
    CACASHDISCOUNTAMTINTRANSCRCY,
    CACASHDISCOUNTDUEDATE,
    CACASHDISCOUNTRATE,
    CACLEARINGAMOUNTINDISPLAYCRCY,
    CACLEARINGDATE,
    CACLEARINGREASON,
    CADEFERRALDATE,
    CADOCUMENTORIGINCODE,
    CAELIGIBLEAMOUNTFORCSHDISCINDC,
    CAELIGIBLEAMOUNTFORCSHDISCINTC,
    CAGROUPINGFORPAYMENT,
    CAMAINTRANSACTION,
    CANETDUEDATE,
    CAOPENAMOUNTINTRANSACTIONCRCY,
    CAPOSTINGDATE,
    CARELEASEDAMTINDISPLAYCURRENCY,
    CARELEASEDAMTINTRANSCURRENCY,
    CASHDISCOUNTAMOUNTINDSPCRCY,
    CASUBTRANSACTION,
    CAVALUEDATEFORCLEARING,
    DISPLAYCURRENCY,
    DOCUMENTDATE,
    EXCHANGERATEDATE,
    OPENAMOUNTINDISPLAYCRCY,
    SEGMENT,
    TRANSACTIONCURRENCY
);