I_PURCHASECONTRACTITEM

CDS View
97 Fields 74 CDS Views

Purchase Contract Item

I_PURCHASECONTRACTITEM is a CDS View in S/4HANA. Purchase Contract Item. It contains 97 fields. 74 CDS views read from this table.

CDS Views using this table (74)

ViewTypeJoinVDMDescription
A_PurchaseContractItem view from COMPOSITE Item
A_PurchaseContractItem_2 view from COMPOSITE Purchase Contract Item
C_ContractConsumption view inner CONSUMPTION Contract Consumption
C_ContractItemFs view from CONSUMPTION Purchase Contract Item
C_MMNonDeletedContractVH view from CONSUMPTION Active Purchase Contract Value Help
C_PPS_PurReqnSOSContractVH view_entity from CONSUMPTION PPS Contracts for PurReqn Assingn SOS
C_PurchaseContractItem view from CONSUMPTION Purchase Contract Item Consumption View
C_PurchaseReqnContractVH view from CONSUMPTION Ctr Value help for PurReqn Assingn SoS
C_PurContractItemHierFactSheet view from CONSUMPTION Item Hierarchy in Purchase Contract
C_PurOrdMaintainCtrItemValHelp view from CONSUMPTION Contract Item Value Help
C_PurOrdRefDocPC view from CONSUMPTION Reference Documents PO Creation - Purchase Contract Items
C_RequirementTrackingPurCtr view from CONSUMPTION Purchase Contracts by Requirement Tracking
C_ServiceEntrySheetProcessFlow view inner CONSUMPTION Process Flow For Service Entry Sheet
C_SitnForContrRdyToUse view from CONSUMPTION Sitn Contract ready to use
C_SSPPurchaseContractItemVH view_entity from CONSUMPTION Contract Item for Enhanced Limit
I_Activepurchasecontractitem view from COMPOSITE I view for active purchase contract item
I_ATPSourceOfSupply view_entity from COMPOSITE ATP Source of Supply
I_PPS_MixedPurchaseContractVH view_entity from COMPOSITE PPS Mixed Contract Purchasing Document
I_PPS_PurchaseOrderProcessFlow view_entity inner COMPOSITE PPS Purchase Order Business Process FLow
I_PPS_PurContrDocTotOptnlC view_entity from COMPOSITE PPS Purchase Contr DocTot Optnl - Cube
I_PPS_PurContrDocTotOptnlC view_entity union COMPOSITE PPS Purchase Contr DocTot Optnl - Cube
I_PPS_PurContrItmDocTotBase view_entity from COMPOSITE PPS Pur Contr Item Document Totals
I_PPS_PurContrItmDocTotCallOff view_entity from COMPOSITE Pur Contr Item Document Total Call Off
I_PPS_PurContrProcessFlow view_entity inner COMPOSITE PPS Process Flow for Purchase Contract
I_PurchaseContractItemAPI01 view from COMPOSITE Purchase Contract Item
I_PurchaseContractItemStdVH view from COMPOSITE Purchase Contract Item
I_PurchaseContractItemWD view from TRANSACTIONAL BO View for I_PurchaseContractItemWD
I_PurContractServiceItemVH view_entity from COMPOSITE Purchase Contract Service Item
I_PurContrItemCndnValdty view inner COMPOSITE Purchase Ctr Item Condition Validity
I_PurCtrAccount view inner COMPOSITE Account Assignment For Contracts
I_Purctraddressint view from COMPOSITE Purchase Contract Address Information
I_SrvcEntrShtItmProcessFlow view_entity inner COMPOSITE Process Flow Service Entry Sheet Item
I_SrvcEntrShtPurgContrItmVH view from COMPOSITE Purchase Contract Item
P_Comonavg_Quantity view inner COMPOSITE
P_Contract_Curr_Conv view left_outer COMPOSITE
P_CONTRACTAMOUNT view from CONSUMPTION Private View for Casting Amount
P_ContractItemCount view from CONSUMPTION view for Contract item count
P_ContractItemMonitoring view from CONSUMPTION Contract Item Monitoring
P_ContractItemRelQuan view from CONSUMPTION Private view for Purchase Contract Item Released Quantity
P_ContrItemRelease view from CONSUMPTION Contract Item Release
P_ContrItmMonitoringCastAmt view from CONSUMPTION Purchase Contract Items Cast Amounts
P_ContrWithRelevantValidity view from COMPOSITE
P_MatlGrpPurgCat view from CONSUMPTION Material Group and Purchasing Category
P_OpnPurReqnForContr view from COMPOSITE
P_POCountInQtyContract view inner CONSUMPTION Purchase Order Count in Quantity Contract
P_PurcContractLeakagePC view from CONSUMPTION P_PurcContractLeakagePC
P_PurchaseContractExpiry1 view from CONSUMPTION Purchase Contract Expiry1
P_PurchaseContractItem view from COMPOSITE
P_PurchaseContractItem1 view inner CONSUMPTION Purchase Contract Changes
P_PurchaseContractItemSOS view from COMPOSITE
P_PurchaseContractMassUpdate view union_all CONSUMPTION Mass Changes to Purchase Contracts
P_PurchaseContractStatus view inner CONSUMPTION Contract Status
P_PurchaseContractTargetAmount view from CONSUMPTION
P_PurchaseOrderItemPAI_04 view left_outer CONSUMPTION
P_PurContractItemConsumption view inner CONSUMPTION
P_PURCONTRACTPRICEVARIANCE view from CONSUMPTION
P_PurContractPriceVariance1 view from CONSUMPTION
P_PurCTRItemConsumptionCalc view from CONSUMPTION Purchase Contract Item Consumption Calc
P_PurOrdMaintainRefDocumentAll view union_all CONSUMPTION
P_QtyContractReleasedAmount view inner CONSUMPTION
P_QuantityContract view from CONSUMPTION
P_QuantityContractWithHistory view inner CONSUMPTION
P_QuantityContractWithHistory1 view inner CONSUMPTION Quantity Contract with History Detail
P_QuantityContractWithPOCount view from CONSUMPTION Quantity Contract With PO Count
P_QuantityContrWthUnusedAmtPAI view inner CONSUMPTION
P_ReleaseAmtInValueContract1 view inner CONSUMPTION Release Amount Calc for Value Contract1
P_ReleaseDocumentationForPC view inner CONSUMPTION Release Documentation For Contracts
P_ReleaseDocumentationValues4 view from CONSUMPTION
P_ReleaseDocumentationValues5 view inner CONSUMPTION Release Documentation Values 5
P_ReleaseDocumentationValues8 view inner CONSUMPTION
P_UnusedPurchaseContract3 view from CONSUMPTION Unused Purchase Contract 3
P_ValueContractReleasedAmount2 view inner CONSUMPTION
R_PPS_PurchaseContractItemTP view_entity from TRANSACTIONAL Purchase Contract Item - TP
R_PurchaseContractItemTP view_entity from TRANSACTIONAL Purchase Contract Item

Fields (97)

KeyField CDS FieldsUsed in Views
KEY Plant ContractPlant,Plant 17
KEY PurchaseContract ParentNode,PurchaseContract,PurchaseOrder,PurchasingDocument,SubsequentDocument 33
KEY PurchaseContractItem PurchaseContractItem,PurchaseContractItemForEdit,PurchaseOrderItem 33
KEY PurchaseRequisitionItem PrecedingDocumentItem,PurchaseRequisitionItem 3
_PurchaseContract _PurchaseContract 3
AccountAssignmentCategory AccountAssignmentCategory 3
ActivePurchasingDocument ActivePurchasingDocument 1
CompanyCode CompanyCode 2
ConfirmationControl ConfirmationControl,SupplierConfirmationControlKey 2
ContractNetPriceAmount ContractNetPriceAmount,PurchaseOrderNetPriceAmount 8
Customer Customer 2
DeliveryAddressID DeliveryAddressID,DeliveryAddressID_2 2
DocumentCurrency ContractCurrency,DocumentCurrency,ReleaseOrderCurrency 9
EvaldRcptSettlmtIsAllowed EvaldRcptSettlmtIsAllowed 2
FormattedPurchaseContractItem FormattedPurchaseContractItem 2
GoodsReceiptIsExpected GoodsReceiptIsExpected 2
GoodsReceiptIsNonValuated GoodsReceiptIsNonValuated 2
IncotermsClassification IncotermsClassification 2
IncotermsLocation1 IncotermsLocation1 2
IncotermsLocation2 IncotermsLocation2 2
IncotermsSupChnDvtgLocAddlUUID IncotermsSupChnDvtgLocAddlUUID 1
IncotermsSupChnLoc1AddlUUID IncotermsSupChnLoc1AddlUUID 1
IncotermsSupChnLoc2AddlUUID IncotermsSupChnLoc2AddlUUID 1
InvoiceIsExpected InvoiceIsExpected 2
InvoiceIsGoodsReceiptBased InvoiceIsGoodsReceiptBased 2
IsInfoAtRegistration IsInfoAtRegistration 3
IsInfoRecordUpdated IsInfoRecordUpdated 3
IsOrderAcknRqd IsOrderAcknRqd 3
IsStatisticalItem IsStatisticalItem 3
IsToBeAcceptedAtOrigin IsToBeAcceptedAtOrigin 2
ManualDeliveryAddressID ManualDeliveryAddressID 2
ManufacturerMaterial ManufacturerMaterial 1
Material Material,Service 11
MaterialGroup MaterialGroup 12
MaterialType MaterialType 2
MultipleAcctAssgmtDistribution MultipleAcctAssgmtDistribution 2
NetPriceQuantity NetPriceQuantity,PurchaseOrderNetPriceQuantity 4
NoDaysReminder1 NoDaysReminder1 3
NoDaysReminder2 NoDaysReminder2 3
NoDaysReminder3 NoDaysReminder3 3
OrderPriceUnit OrderPriceUnit,OrdPrcUnitToOrderUnitNmrtrUoM,PurchaseOrderPriceUnit 5
OrderPriceUnitToOrderUnitNmrtr OrderPriceUnitToOrderUnitNmrtr 2
OrderQuantityUnit OrderQuantityUnit,OrdPrcUnitToOrderUnitDnmntrUoM,PurchaseOrderQuantityUnit,ReleaseOrderQuantityUnit 9
OrdPriceUnitToOrderUnitDnmntr OrdPriceUnitToOrderUnitDnmntr 2
OutlineAgreementTargetAmount PurchaseContractTargetAmount 1
OverdelivTolrtdLmtRatioInPct OverdelivTolrtdLmtRatioInPct 2
PartialInvoiceDistribution PartialInvoiceDistribution 2
PlannedDeliveryDurationInDays PlannedDeliveryDurationInDays 2
PriceIsToBePrinted PriceIsToBePrinted 2
ProductType ProductType 2
ProductTypeCode ProductTypeCode 2
PurchaseContractCreatedByUser CreatedByUser 1
PurchaseContractItemFormatted PurchaseContractItemFormatted 2
PurchaseContractItemText PurchaseContractItemText,PurchasingDocumentItemText 9
PurchaseContractItemUniqueID PurchaseContractItemUniqueID 1
PurchaseContractType PurchaseContractType 7
PurchaseRequisition PurchaseRequisition 2
PurchasingCategory PurchasingCategory 1
PurchasingContractDeletionCode PurchasingContractDeletionCode 4
PurchasingDocumentItemCategory ContractItemCategory,PurchasingDocumentItemCategory 6
PurchasingGroup PurchasingGroup 1
PurchasingInfoRecord PurchasingInfoRecord 2
PurchasingInfoRecordUpdateCode PurchasingInfoRecordUpdateCode 1
PurchasingIsCatalogRelevant PurchasingIsCatalogRelevant 2
PurchasingObjectCategory Purchasingdocumentcategory 1
PurchasingOrganization PurchasingOrganization 1
PurchasingParentItem PurchasingParentItem,PurchasingParentItemForEdit 4
PurContractItmReplnmtElmntType PurContractItmReplnmtElmntType 2
PurContrValidityStartDate ValidityStartDate 1
PurgCatName PurgCatName 2
PurgConfigurableItemNumber PurgConfigurableItemNumber 4
PurgDocAggrgdSubitemCategory PurgDocAggrgdSubitemCategory 2
PurgDocEstimatedPrice PurgDocEstimatedPrice 3
PurgDocOrderAcknNumber PurgDocOrderAcknNumber 3
PurgDocPriceDate PurgDocPriceDate 3
PurgDocReleaseOrderQuantity PurgDocReleaseOrderQuantity 4
PurgExternalSortNumber PurgExternalSortNumber 3
PurgProdCmplncSupplierStatus PurgProdCmplncSupplierStatus 2
ReferenceDeliveryAddressID ReferenceDeliveryAddressID 2
RequirementTracking RequirementTracking 3
ServicePerformer ServicePerformer 2
ShippingInstruction ShippingInstruction 3
ShippingType ShippingType 1
StockType StockType 3
StorageLocation StorageLocation 5
Subcontractor Subcontractor 3
SupplierConfirmationControlKey SupplierConfirmationControlKey 1
SupplierMaterialNumber SupplierMaterialNumber 2
SupplierSubrange SupplierSubrange 2
TargetAmount TargetAmount 6
TargetQuantity TargetQuantity 9
TaxCode TaxCode 2
TaxCountry TaxCountry 2
TaxDeterminationDate TaxDeterminationDate 2
UnderdelivTolrtdLmtRatioInPct UnderdelivTolrtdLmtRatioInPct 2
UnlimitedOverdeliveryIsAllowed UnlimitedOverdeliveryIsAllowed 2
VolumeUnit VolumeUnit 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.

-- Purchase Contract Item
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_PURCHASECONTRACTITEM (
    PLANT,
    PURCHASECONTRACT,
    PURCHASECONTRACTITEM,
    PURCHASEREQUISITIONITEM,
    _PURCHASECONTRACT,
    ACCOUNTASSIGNMENTCATEGORY,
    ACTIVEPURCHASINGDOCUMENT,
    COMPANYCODE,
    CONFIRMATIONCONTROL,
    CONTRACTNETPRICEAMOUNT,
    CUSTOMER,
    DELIVERYADDRESSID,
    DOCUMENTCURRENCY,
    EVALDRCPTSETTLMTISALLOWED,
    FORMATTEDPURCHASECONTRACTITEM,
    GOODSRECEIPTISEXPECTED,
    GOODSRECEIPTISNONVALUATED,
    INCOTERMSCLASSIFICATION,
    INCOTERMSLOCATION1,
    INCOTERMSLOCATION2,
    INCOTERMSSUPCHNDVTGLOCADDLUUID,
    INCOTERMSSUPCHNLOC1ADDLUUID,
    INCOTERMSSUPCHNLOC2ADDLUUID,
    INVOICEISEXPECTED,
    INVOICEISGOODSRECEIPTBASED,
    ISINFOATREGISTRATION,
    ISINFORECORDUPDATED,
    ISORDERACKNRQD,
    ISSTATISTICALITEM,
    ISTOBEACCEPTEDATORIGIN,
    MANUALDELIVERYADDRESSID,
    MANUFACTURERMATERIAL,
    MATERIAL,
    MATERIALGROUP,
    MATERIALTYPE,
    MULTIPLEACCTASSGMTDISTRIBUTION,
    NETPRICEQUANTITY,
    NODAYSREMINDER1,
    NODAYSREMINDER2,
    NODAYSREMINDER3,
    ORDERPRICEUNIT,
    ORDERPRICEUNITTOORDERUNITNMRTR,
    ORDERQUANTITYUNIT,
    ORDPRICEUNITTOORDERUNITDNMNTR,
    OUTLINEAGREEMENTTARGETAMOUNT,
    OVERDELIVTOLRTDLMTRATIOINPCT,
    PARTIALINVOICEDISTRIBUTION,
    PLANNEDDELIVERYDURATIONINDAYS,
    PRICEISTOBEPRINTED,
    PRODUCTTYPE,
    PRODUCTTYPECODE,
    PURCHASECONTRACTCREATEDBYUSER,
    PURCHASECONTRACTITEMFORMATTED,
    PURCHASECONTRACTITEMTEXT,
    PURCHASECONTRACTITEMUNIQUEID,
    PURCHASECONTRACTTYPE,
    PURCHASEREQUISITION,
    PURCHASINGCATEGORY,
    PURCHASINGCONTRACTDELETIONCODE,
    PURCHASINGDOCUMENTITEMCATEGORY,
    PURCHASINGGROUP,
    PURCHASINGINFORECORD,
    PURCHASINGINFORECORDUPDATECODE,
    PURCHASINGISCATALOGRELEVANT,
    PURCHASINGOBJECTCATEGORY,
    PURCHASINGORGANIZATION,
    PURCHASINGPARENTITEM,
    PURCONTRACTITMREPLNMTELMNTTYPE,
    PURCONTRVALIDITYSTARTDATE,
    PURGCATNAME,
    PURGCONFIGURABLEITEMNUMBER,
    PURGDOCAGGRGDSUBITEMCATEGORY,
    PURGDOCESTIMATEDPRICE,
    PURGDOCORDERACKNNUMBER,
    PURGDOCPRICEDATE,
    PURGDOCRELEASEORDERQUANTITY,
    PURGEXTERNALSORTNUMBER,
    PURGPRODCMPLNCSUPPLIERSTATUS,
    REFERENCEDELIVERYADDRESSID,
    REQUIREMENTTRACKING,
    SERVICEPERFORMER,
    SHIPPINGINSTRUCTION,
    SHIPPINGTYPE,
    STOCKTYPE,
    STORAGELOCATION,
    SUBCONTRACTOR,
    SUPPLIERCONFIRMATIONCONTROLKEY,
    SUPPLIERMATERIALNUMBER,
    SUPPLIERSUBRANGE,
    TARGETAMOUNT,
    TARGETQUANTITY,
    TAXCODE,
    TAXCOUNTRY,
    TAXDETERMINATIONDATE,
    UNDERDELIVTOLRTDLMTRATIOINPCT,
    UNLIMITEDOVERDELIVERYISALLOWED,
    VOLUMEUNIT,
    PRIMARY KEY (PLANT, PURCHASECONTRACT, PURCHASECONTRACTITEM, PURCHASEREQUISITIONITEM)
);

Learn More