_CNTRLPURCHASECONTRACTITEM

23 Fields

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

Fields (23)

KeyField CDS FieldsUsed in Views
KEY CentralPurchaseContractItem CentralPurchaseContractItem 1
ActivePurchasingDocument ActivePurchasingDocument 2
CntrlPurContrItmTargetAmount CntrlPurContrItmTargetAmount 2
ContractNetPriceAmount ContractNetPriceAmount,DistributionNetPriceAmount 5
DocumentCurrency DocumentCurrency 3
MaterialGroup MaterialGroup 4
NetPriceQuantity NetPriceQuantity 1
OrderPriceUnit OrderPriceUnit 1
OrderPriceUnitToOrderUnitNmrtr OrderPriceUnitToOrderUnitNmrtr 2
OrderQuantityUnit OrderQuantityUnit 1
OrdPriceUnitToOrderUnitDnmntr OrdPriceUnitToOrderUnitDnmntr 2
Plant Plant 1
ProductType ProductType 1
ProductTypeCode ProductTypeCode 3
PurchaseContractItemText MaterialDescription,PURCHASECONTRACTITEMTEXT 4
PurchaseContractType PurchaseContractType 2
PurchasingCentralMaterial Material,PURCHASINGCENTRALMATERIAL 5
PurchasingContractDeletionCode PurchasingContractDeletionCode 2
PurchasingDocumentItemCategory PurchasingDocumentItemCategory 2
PurchasingDocumentItemUniqueID PurchasingDocumentItemUniqueID 1
PurgDocItemRenegotiationStatus PurgDocItemRenegotiationStatus 1
TargetAmount TargetAmount 1
TargetQuantity TargetQuantity 3

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 _CNTRLPURCHASECONTRACTITEM (
    CENTRALPURCHASECONTRACTITEM,
    ACTIVEPURCHASINGDOCUMENT,
    CNTRLPURCONTRITMTARGETAMOUNT,
    CONTRACTNETPRICEAMOUNT,
    DOCUMENTCURRENCY,
    MATERIALGROUP,
    NETPRICEQUANTITY,
    ORDERPRICEUNIT,
    ORDERPRICEUNITTOORDERUNITNMRTR,
    ORDERQUANTITYUNIT,
    ORDPRICEUNITTOORDERUNITDNMNTR,
    PLANT,
    PRODUCTTYPE,
    PRODUCTTYPECODE,
    PURCHASECONTRACTITEMTEXT,
    PURCHASECONTRACTTYPE,
    PURCHASINGCENTRALMATERIAL,
    PURCHASINGCONTRACTDELETIONCODE,
    PURCHASINGDOCUMENTITEMCATEGORY,
    PURCHASINGDOCUMENTITEMUNIQUEID,
    PURGDOCITEMRENEGOTIATIONSTATUS,
    TARGETAMOUNT,
    TARGETQUANTITY,
    PRIMARY KEY (CENTRALPURCHASECONTRACTITEM)
);

Learn More