BUSINESSPARTNERITEM

BUSINESSPARTNERITEM is an SAP database table in S/4HANA. It contains 28 fields.

Fields (28)

KeyField CDS FieldsUsed in Views
_BusinessArea _BusinessArea 1
_ControllingArea _ControllingArea 1
_CostCenter _CostCenter 1
_Customer _Customer 1
_FunctionalArea _FunctionalArea 1
_InventoryValuationType _InventoryValuationType 1
_Material _Material 1
_ProfitCenter _ProfitCenter 1
_Segment _Segment 1
_Supplier _Supplier 1
AmountInCompanyCodeCurrency TaxBaseAmountInCoCodeCrcy 1
AssetClass AssetClass 2
AssignmentReference AssignmentReference 2
BusinessArea BusinessArea 2
ControllingArea ControllingArea 2
CostCenter CostCenter 2
Customer Customer 2
FixedAsset FixedAsset 2
FunctionalArea FunctionalArea 2
InventoryValuationType InventoryValuationType 2
MasterFixedAsset MasterFixedAsset 2
Material Material 2
Plant Plant 2
Product Product 1
ProfitCenter ProfitCenter 2
Segment Segment 2
Supplier Supplier 3
ValuationArea ValuationArea 2

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 BUSINESSPARTNERITEM (
    _BUSINESSAREA,
    _CONTROLLINGAREA,
    _COSTCENTER,
    _CUSTOMER,
    _FUNCTIONALAREA,
    _INVENTORYVALUATIONTYPE,
    _MATERIAL,
    _PROFITCENTER,
    _SEGMENT,
    _SUPPLIER,
    AMOUNTINCOMPANYCODECURRENCY,
    ASSETCLASS,
    ASSIGNMENTREFERENCE,
    BUSINESSAREA,
    CONTROLLINGAREA,
    COSTCENTER,
    CUSTOMER,
    FIXEDASSET,
    FUNCTIONALAREA,
    INVENTORYVALUATIONTYPE,
    MASTERFIXEDASSET,
    MATERIAL,
    PLANT,
    PRODUCT,
    PROFITCENTER,
    SEGMENT,
    SUPPLIER,
    VALUATIONAREA
);