_CENTRALPURCHASECONTRACTITEM

_CENTRALPURCHASECONTRACTITEM is an SAP database table in S/4HANA. It contains 26 fields.

Fields (26)

KeyField CDS FieldsUsed in Views
EvaldRcptSettlmtIsAllowed EvaldRcptSettlmtIsAllowed 4
GoodsReceiptIsExpected GoodsReceiptIsExpected 4
GoodsReceiptIsNonValuated GoodsReceiptIsNonValuated 4
InvoiceIsExpected InvoiceIsExpected 4
InvoiceIsGoodsReceiptBased InvoiceIsGoodsReceiptBased 4
IsInfoAtRegistration IsInfoAtRegistration 4
IsOrderAcknRqd IsOrderAcknRqd 4
NoDaysReminder1 NoDaysReminder1 4
NoDaysReminder2 NoDaysReminder2 4
NoDaysReminder3 NoDaysReminder3 4
OrderQuantityUnit OrderQuantityUnit 4
OverdelivTolrtdLmtRatioInPct OverdelivTolrtdLmtRatioInPct 4
PriceIsToBePrinted PriceIsToBePrinted 4
PurchaseContractItemText PurchaseContractItemText 4
PurgDocEstimatedPrice PurchasingPriceIsEstimated 4
PurgDocOrderAcknNumber PurgDocOrderAcknNumber 4
PurgDocReleaseOrderQuantity PurgDocReleaseOrderQuantity 4
RequirementTracking RequirementTracking 4
ShippingInstruction ShippingInstruction 4
StockType StockType 4
SupplierConfirmationControlKey SupplierConfirmationControlKey 4
SupplierMaterialNumber SupplierMaterialNumber 4
TargetQuantity TargetQuantity 4
TaxCode TaxCode 4
UnderdelivTolrtdLmtRatioInPct UnderdelivTolrtdLmtRatioInPct 4
UnlimitedOverdeliveryIsAllowed UnlimitedOverdeliveryIsAllowed 4

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 _CENTRALPURCHASECONTRACTITEM (
    EVALDRCPTSETTLMTISALLOWED,
    GOODSRECEIPTISEXPECTED,
    GOODSRECEIPTISNONVALUATED,
    INVOICEISEXPECTED,
    INVOICEISGOODSRECEIPTBASED,
    ISINFOATREGISTRATION,
    ISORDERACKNRQD,
    NODAYSREMINDER1,
    NODAYSREMINDER2,
    NODAYSREMINDER3,
    ORDERQUANTITYUNIT,
    OVERDELIVTOLRTDLMTRATIOINPCT,
    PRICEISTOBEPRINTED,
    PURCHASECONTRACTITEMTEXT,
    PURGDOCESTIMATEDPRICE,
    PURGDOCORDERACKNNUMBER,
    PURGDOCRELEASEORDERQUANTITY,
    REQUIREMENTTRACKING,
    SHIPPINGINSTRUCTION,
    STOCKTYPE,
    SUPPLIERCONFIRMATIONCONTROLKEY,
    SUPPLIERMATERIALNUMBER,
    TARGETQUANTITY,
    TAXCODE,
    UNDERDELIVTOLRTDLMTRATIOINPCT,
    UNLIMITEDOVERDELIVERYISALLOWED
);