BPITEM

19 Fields

BPITEM is an SAP database table in S/4HANA. It contains 19 fields.

Fields (19)

KeyField CDS FieldsUsed in Views
KEY CABPItemNumber CABPItemNumber 2
KEY CADocumentNumber CADocumentNumber 1
KEY CARepetitionItemNumber CARepetitionItemNumber 2
KEY CASubItemNumber CASubItemNumber 2
_BusinessPartner _BusinessPartner 1
_CompCode _CompanyCode 1
_ReceivingCountry _ReceivingCountry 1
BusinessPartner BusinessPartner 1
CAAccountDeterminationCode CAAccountDeterminationCode 1
CAAmountInTransactionCurrency CAAmountInTransactionCurrency 1
CANetDueDate CANetDueDate 1
CAReceivingCountry CAReceivingCountry 1
CASEPAPreNotifExecutionDate CASEPAPreNotifExecutionDate 1
CASEPAPreNotificationNumber CASEPAPreNotificationNumber 1
CASEPAPreNotificationRqmtCode CASEPAPreNotificationRqmtCode 1
CASEPAPreNotifOriginCode CASEPAPreNotifOriginCode 1
CompanyCode CompanyCode 1
TaxCode TaxCode 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 BPITEM (
    CABPITEMNUMBER,
    CADOCUMENTNUMBER,
    CAREPETITIONITEMNUMBER,
    CASUBITEMNUMBER,
    _BUSINESSPARTNER,
    _COMPCODE,
    _RECEIVINGCOUNTRY,
    BUSINESSPARTNER,
    CAACCOUNTDETERMINATIONCODE,
    CAAMOUNTINTRANSACTIONCURRENCY,
    CANETDUEDATE,
    CARECEIVINGCOUNTRY,
    CASEPAPRENOTIFEXECUTIONDATE,
    CASEPAPRENOTIFICATIONNUMBER,
    CASEPAPRENOTIFICATIONRQMTCODE,
    CASEPAPRENOTIFORIGINCODE,
    COMPANYCODE,
    TAXCODE,
    TRANSACTIONCURRENCY,
    PRIMARY KEY (CABPITEMNUMBER, CADOCUMENTNUMBER, CAREPETITIONITEMNUMBER, CASUBITEMNUMBER)
);

Learn More