_PURCHASECONTRACTITEM

23 Fields

_PURCHASECONTRACTITEM is an SAP database table in S/4HANA. It contains 23 fields.

Fields (23)

KeyField CDS FieldsUsed in Views
AccountAssignmentCategory AccountAssignmentCategory 1
CONTRACTNETPRICEAMOUNT CONTRACTNETPRICEAMOUNT 2
DOCUMENTCURRENCY CURRENCY,DocumentCurrency 2
MATERIAL MATERIAL 4
MATERIALGROUP MATERIALGROUP 5
matkl MaterialGroup 1
MultipleAcctAssgmtDistribution MultipleAcctAssgmtDistribution 1
NETPRICEQUANTITY NETPRICEQUANTITY 2
ORDERPRICEUNIT ORDERPRICEUNIT 2
ORDERQUANTITYUNIT ORDERQUANTITYUNIT 4
PLANT PLANT 3
PURCHASECONTRACTITEM PURCHASECONTRACTITEM 1
PURCHASECONTRACTITEMTEXT PURCHASECONTRACTITEMTEXT 2
PurchasingCategory PurchasingCategory 1
PURCHASINGCONTRACTDELETIONCODE DELETIONCODEHDR,PurchasingContractDeletionCode 2
PurchasingDocumentItemCategory PurchasingDocumentItemCategory 2
StorageLocation StorageLocation 1
TARGETAMOUNT TARGETAMOUNT 2
TARGETQUANTITY TARGETQUANTITY 4
TaxCode TaxCode 1
uniqueid PurchaseContractItemUniqueID 1
werks Plant 1
zwert TargetAmount 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 _PURCHASECONTRACTITEM (
    ACCOUNTASSIGNMENTCATEGORY,
    CONTRACTNETPRICEAMOUNT,
    DOCUMENTCURRENCY,
    MATERIAL,
    MATERIALGROUP,
    MATKL,
    MULTIPLEACCTASSGMTDISTRIBUTION,
    NETPRICEQUANTITY,
    ORDERPRICEUNIT,
    ORDERQUANTITYUNIT,
    PLANT,
    PURCHASECONTRACTITEM,
    PURCHASECONTRACTITEMTEXT,
    PURCHASINGCATEGORY,
    PURCHASINGCONTRACTDELETIONCODE,
    PURCHASINGDOCUMENTITEMCATEGORY,
    STORAGELOCATION,
    TARGETAMOUNT,
    TARGETQUANTITY,
    TAXCODE,
    UNIQUEID,
    WERKS,
    ZWERT
);

Learn More