_BPITEM

_BPITEM is an SAP database table in S/4HANA. It contains 13 fields.

Fields (13)

KeyField CDS FieldsUsed in Views
KEY BusinessPartner BusinessPartner 1
KEY CAContract CAContract 1
KEY ContractAccount ContractAccount 1
_BusinessPartner _BusinessPartner 1
_CAPartner _CAPartner 1
_Currency _Currency 1
_ProviderContract _ProviderContract 1
BusinessArea BusinessArea 1
CADocumentOriginCode CADocumentOriginCode 1
CASubApplication CASubApplication 1
CompanyCode CompanyCode 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 _BPITEM (
    BUSINESSPARTNER,
    CACONTRACT,
    CONTRACTACCOUNT,
    _BUSINESSPARTNER,
    _CAPARTNER,
    _CURRENCY,
    _PROVIDERCONTRACT,
    BUSINESSAREA,
    CADOCUMENTORIGINCODE,
    CASUBAPPLICATION,
    COMPANYCODE,
    SEGMENT,
    TRANSACTIONCURRENCY,
    PRIMARY KEY (BUSINESSPARTNER, CACONTRACT, CONTRACTACCOUNT)
);