I_CNTRLPURCHASECONTRACTITEM

CDS View
70 Fields 16 CDS Views

Central PC Basic Item View

I_CNTRLPURCHASECONTRACTITEM is a CDS View in S/4HANA. Central PC Basic Item View. It contains 70 fields. 16 CDS views read from this table.

CDS Views using this table (16)

ViewTypeJoinVDMDescription
A_CntrlPurchaseContractItem view from BASIC Item
C_CntrlContrItmEnhcdValHelp view from CONSUMPTION Central Contract Item Value Help
C_CntrlContrItmValHelp view from CONSUMPTION Central Contract Item Value Help
C_CntrlPurContrHierItmMassUpdt view from CONSUMPTION Mass Changes to Items of Central Purchase Contract Hierarchy
C_PurCntrlContrItmMassUpdt view from CONSUMPTION Mass Changes to Central Contract Items
I_CntrlPurchaseContractItemTP view from TRANSACTIONAL Central PC BO Item View
I_CntrlPurContractItemAPI01 view from COMPOSITE Item in Central Purchase Contract
I_CntrlPurContrConsumption view from COMPOSITE Consumption of Central Purchase Contract
P_Cctr_Curr_Conv view from COMPOSITE
P_CePuCoItemHierSource view from COMPOSITE Source View for Cntrl Contract Item hier
P_CntrlContrRelDocnValues view from CONSUMPTION
P_CntrlContrRelDocnValues view union_all CONSUMPTION
P_CntrlPurContractItems view from CONSUMPTION Central Purchase Contract Items
P_CntrlPurContrItemMonitor1 view from CONSUMPTION Central Purchase Contract Items
P_UnusedPurCentralContract view from CONSUMPTION Unused Central Purchase Contracts
R_CntrlPurchaseContractItemTP view_entity from TRANSACTIONAL Central Purchase Contract Item

Fields (70)

KeyField CDS FieldsUsed in Views
KEY CentralPurchaseContract CentralPurchaseContract 7
KEY CentralPurchaseContractItem CentralPurchaseContractItem 6
KEY MaterialGroup MaterialGroup 5
AccountAssignmentCategory AccountAssignmentCategory 1
CntrlPurContrItmTargetAmount CntrlPurContrItmTargetAmount 1
ContractNetPriceAmount ContractNetPriceAmount 3
Customer Customer 1
DocumentCurrency DocumentCurrency,ReleaseOrderCurrency 4
EvaldRcptSettlmtIsAllowed EvaldRcptSettlmtIsAllowed 1
FormattedPurchaseContractItem FormattedPurchaseContractItem 1
GoodsReceiptIsExpected GoodsReceiptIsExpected 1
GoodsReceiptIsNonValuated GoodsReceiptIsNonValuated 1
InvoiceIsExpected InvoiceIsExpected 1
InvoiceIsGoodsReceiptBased InvoiceIsGoodsReceiptBased 1
IsEndOfPurposeBlocked IsEndOfPurposeBlocked 1
IsInfoAtRegistration IsInfoAtRegistration 1
IsInfoRecordUpdated IsInfoRecordUpdated 1
IsOrderAcknRqd IsOrderAcknRqd 1
IsStatisticalItem IsStatisticalItem 1
ManualDeliveryAddressID ManualDeliveryAddressID 1
Material Material 4
MaterialType MaterialType 1
MultipleAcctAssgmtDistribution MultipleAcctAssgmtDistribution 1
NetPriceQuantity NetPriceQuantity 2
NoDaysReminder1 NoDaysReminder1 1
NoDaysReminder2 NoDaysReminder2 1
NoDaysReminder3 NoDaysReminder3 1
OrderPriceUnit OrderPriceUnit 1
OrderPriceUnitToOrderUnitNmrtr OrderPriceUnitToOrderUnitNmrtr 1
OrderQuantityUnit OrderQuantityUnit,ReleaseOrderItemQuantityUnit 4
OrdPriceUnitToOrderUnitDnmntr OrdPriceUnitToOrderUnitDnmntr 1
OverdelivTolrtdLmtRatioInPct OverdelivTolrtdLmtRatioInPct 1
PartialInvoiceDistribution PartialInvoiceDistribution 1
PlannedDeliveryDurationInDays PlannedDeliveryDurationInDays 1
Plant Plant 4
PriceIsToBePrinted PriceIsToBePrinted 1
ProcmtHubExtReferencedMaterial PurchasingCentralMaterial 1
ProcmtHubRefcdConnectedSystem ProcmtHubRefcdConnectedSystem 1
ProductType ProductType 1
PurchaseContractItemText PurchaseContractItemText 2
PurchaseContractType PurchaseContractType 1
PurchaseRequisition PurchaseRequisition 1
PurchaseRequisitionItem PurchaseRequisitionItem 1
PurchasingContractDeletionCode PurchasingContractDeletionCode 1
PurchasingDocumentItemCategory PurchasingDocumentItemCategory 1
PurchasingParentItem PurchasingParentItem 1
PurgConfigurableItemNumber PurgConfigurableItemNumber 1
PurgDocAggrgdSubitemCategory PurgDocAggrgdSubitemCategory 1
PurgDocEstimatedPrice PurgDocEstimatedPrice 1
PurgDocItemRenegotiationStatus PurgDocItemRenegotiationStatus 1
PurgDocItmBlkRsnCode PurgDocItmBlkRsnCode 1
PurgDocOrderAcknNumber PurgDocOrderAcknNumber 1
PurgDocPriceDate PurgDocPriceDate 1
PurgDocReleaseOrderQuantity PurgDocReleaseOrderQuantity 1
PurgExternalSortNumber PurgExternalSortNumber 1
ReferenceDeliveryAddressID ReferenceDeliveryAddressID 1
RequirementTracking RequirementTracking 1
ServicePerformer ServicePerformer 1
ShippingInstruction ShippingInstruction 1
StockType StockType 1
StorageLocation StorageLocation 1
Subcontractor Subcontractor 1
SupplierConfirmationControlKey SupplierConfirmationControlKey 1
SupplierMaterialNumber SupplierMaterialNumber 1
TargetAmount TargetAmount 1
TargetQuantity TargetQuantity 2
TaxCode TaxCode 1
UnderdelivTolrtdLmtRatioInPct UnderdelivTolrtdLmtRatioInPct 1
UnlimitedOverdeliveryIsAllowed UnlimitedOverdeliveryIsAllowed 1
VolumeUnit VolumeUnit 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.

-- Central PC Basic Item View
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_CNTRLPURCHASECONTRACTITEM (
    CENTRALPURCHASECONTRACT,
    CENTRALPURCHASECONTRACTITEM,
    MATERIALGROUP,
    ACCOUNTASSIGNMENTCATEGORY,
    CNTRLPURCONTRITMTARGETAMOUNT,
    CONTRACTNETPRICEAMOUNT,
    CUSTOMER,
    DOCUMENTCURRENCY,
    EVALDRCPTSETTLMTISALLOWED,
    FORMATTEDPURCHASECONTRACTITEM,
    GOODSRECEIPTISEXPECTED,
    GOODSRECEIPTISNONVALUATED,
    INVOICEISEXPECTED,
    INVOICEISGOODSRECEIPTBASED,
    ISENDOFPURPOSEBLOCKED,
    ISINFOATREGISTRATION,
    ISINFORECORDUPDATED,
    ISORDERACKNRQD,
    ISSTATISTICALITEM,
    MANUALDELIVERYADDRESSID,
    MATERIAL,
    MATERIALTYPE,
    MULTIPLEACCTASSGMTDISTRIBUTION,
    NETPRICEQUANTITY,
    NODAYSREMINDER1,
    NODAYSREMINDER2,
    NODAYSREMINDER3,
    ORDERPRICEUNIT,
    ORDERPRICEUNITTOORDERUNITNMRTR,
    ORDERQUANTITYUNIT,
    ORDPRICEUNITTOORDERUNITDNMNTR,
    OVERDELIVTOLRTDLMTRATIOINPCT,
    PARTIALINVOICEDISTRIBUTION,
    PLANNEDDELIVERYDURATIONINDAYS,
    PLANT,
    PRICEISTOBEPRINTED,
    PROCMTHUBEXTREFERENCEDMATERIAL,
    PROCMTHUBREFCDCONNECTEDSYSTEM,
    PRODUCTTYPE,
    PURCHASECONTRACTITEMTEXT,
    PURCHASECONTRACTTYPE,
    PURCHASEREQUISITION,
    PURCHASEREQUISITIONITEM,
    PURCHASINGCONTRACTDELETIONCODE,
    PURCHASINGDOCUMENTITEMCATEGORY,
    PURCHASINGPARENTITEM,
    PURGCONFIGURABLEITEMNUMBER,
    PURGDOCAGGRGDSUBITEMCATEGORY,
    PURGDOCESTIMATEDPRICE,
    PURGDOCITEMRENEGOTIATIONSTATUS,
    PURGDOCITMBLKRSNCODE,
    PURGDOCORDERACKNNUMBER,
    PURGDOCPRICEDATE,
    PURGDOCRELEASEORDERQUANTITY,
    PURGEXTERNALSORTNUMBER,
    REFERENCEDELIVERYADDRESSID,
    REQUIREMENTTRACKING,
    SERVICEPERFORMER,
    SHIPPINGINSTRUCTION,
    STOCKTYPE,
    STORAGELOCATION,
    SUBCONTRACTOR,
    SUPPLIERCONFIRMATIONCONTROLKEY,
    SUPPLIERMATERIALNUMBER,
    TARGETAMOUNT,
    TARGETQUANTITY,
    TAXCODE,
    UNDERDELIVTOLRTDLMTRATIOINPCT,
    UNLIMITEDOVERDELIVERYISALLOWED,
    VOLUMEUNIT,
    PRIMARY KEY (CENTRALPURCHASECONTRACT, CENTRALPURCHASECONTRACTITEM, MATERIALGROUP)
);

Learn More