R_PURCHASECONTRACTITEM
Purchase Contract Item Base view
R_PURCHASECONTRACTITEM is a CDS View in S/4HANA. Purchase Contract Item Base view. It contains 111 fields. 5 CDS views read from this table.
CDS Views using this table (5)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| C_PurContrItmCmplncCriticality | view | from | CONSUMPTION | Criticality of the values of the Product complian |
| I_PPS_PurReqnProcessFlow | view_entity | inner | COMPOSITE | Interface for PPS Process Flow |
| I_PurchaseContractItem | view | from | COMPOSITE | Purchase Contract Item |
| R_PPS_PurchaseContractItemHN_2 | view_entity | from | TRANSACTIONAL | Purchase Contract Item Hierarchy Node |
| R_PurContrHierNodeRltn | view | from | COMPOSITE | Source View for Purchase Contr Hierarchy |
Fields (111)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | PurchaseContract | PurchaseContract | 1 |
| KEY | PurchaseContractItem | PurchaseContractItem | 1 |
| _DocumentCurrency | _DocumentCurrency | 1 | |
| _Material | _Material | 1 | |
| _MaterialGroup | _MaterialGroup | 1 | |
| _OrderPriceUnit | _OrderPriceUnit | 1 | |
| _OrderQuantityUnit | _OrderQuantityUnit | 1 | |
| _Plant | _Plant | 1 | |
| _StorageLocation | _StorageLocation | 1 | |
| _VolumeUnit | _VolumeUnit | 1 | |
| AccountAssignmentCategory | AccountAssignmentCategory | 1 | |
| ActivePurchasingDocument | ActivePurchasingDocument | 1 | |
| CompanyCode | CompanyCode | 1 | |
| ContractNetPriceAmount | ContractNetPriceAmount | 1 | |
| Customer | Customer | 1 | |
| DeliveryAddressID | DeliveryAddressID | 1 | |
| DocumentCurrency | DocumentCurrency | 1 | |
| EvaldRcptSettlmtIsAllowed | EvaldRcptSettlmtIsAllowed | 1 | |
| GoodsReceiptIsExpected | GoodsReceiptIsExpected | 1 | |
| GoodsReceiptIsNonValuated | GoodsReceiptIsNonValuated | 1 | |
| IncotermsClassification | IncotermsClassification | 1 | |
| IncotermsLocation1 | IncotermsLocation1 | 1 | |
| IncotermsLocation2 | IncotermsLocation2 | 1 | |
| IncotermsSupChnDvtgLocAddlUUID | IncotermsSupChnDvtgLocAddlUUID | 1 | |
| IncotermsSupChnLoc1AddlUUID | IncotermsSupChnLoc1AddlUUID | 1 | |
| IncotermsSupChnLoc2AddlUUID | IncotermsSupChnLoc2AddlUUID | 1 | |
| InvoiceIsExpected | InvoiceIsExpected | 1 | |
| InvoiceIsGoodsReceiptBased | InvoiceIsGoodsReceiptBased | 1 | |
| IsEndOfPurposeBlocked | IsEndOfPurposeBlocked | 1 | |
| IsInfoAtRegistration | IsInfoAtRegistration | 1 | |
| IsOrderAcknRqd | IsOrderAcknRqd | 1 | |
| IsStatisticalItem | IsStatisticalItem | 1 | |
| IsToBeAcceptedAtOrigin | IsToBeAcceptedAtOrigin | 1 | |
| ManualDeliveryAddressID | ManualDeliveryAddressID | 1 | |
| Manufacturer | Manufacturer | 1 | |
| ManufacturerMaterial | ManufacturerMaterial | 1 | |
| ManufacturerPartNmbr | ManufacturerPartNmbr | 1 | |
| Material | Material | 1 | |
| MaterialGroup | MaterialGroup | 1 | |
| MaterialType | MaterialType | 1 | |
| MultipleAcctAssgmtDistribution | MultipleAcctAssgmtDistribution | 1 | |
| NetPriceQuantity | NetPriceQuantity | 1 | |
| NoDaysReminder1 | NoDaysReminder1 | 1 | |
| NoDaysReminder2 | NoDaysReminder2 | 1 | |
| NoDaysReminder3 | NoDaysReminder3 | 1 | |
| OrderPriceUnit | OrderPriceUnit | 1 | |
| OrderPriceUnitToOrderUnitNmrtr | OrderPriceUnitToOrderUnitNmrtr | 1 | |
| OrderQuantityUnit | OrderQuantityUnit | 1 | |
| OrdPriceUnitToOrderUnitDnmntr | OrdPriceUnitToOrderUnitDnmntr | 1 | |
| OutlineAgreementTargetAmount | OutlineAgreementTargetAmount | 1 | |
| OverdelivTolrtdLmtRatioInPct | OverdelivTolrtdLmtRatioInPct | 1 | |
| PartialInvoiceDistribution | PartialInvoiceDistribution | 1 | |
| PlannedDeliveryDurationInDays | PlannedDeliveryDurationInDays | 1 | |
| Plant | Plant | 1 | |
| PlndOrderReplnmtElmntType | PlndOrderReplnmtElmntType | 1 | |
| PriceIsToBePrinted | PriceIsToBePrinted | 1 | |
| ProductCharacteristic1 | ProductCharacteristic1 | 1 | |
| ProductCharacteristic2 | ProductCharacteristic2 | 1 | |
| ProductCharacteristic3 | ProductCharacteristic3 | 1 | |
| ProductCollection | ProductCollection | 1 | |
| ProductSeason | ProductSeason | 1 | |
| ProductSeasonYear | ProductSeasonYear | 1 | |
| ProductTheme | ProductTheme | 1 | |
| ProductTypeCode | ProductTypeCode | 1 | |
| PurchaseContractCreatedByUser | PurchaseContractCreatedByUser | 1 | |
| PurchaseContractItemText | PurchaseContractItemText | 1 | |
| PurchaseContractItemUniqueID | PurchaseContractItemUniqueID | 1 | |
| PurchaseContractType | PurchaseContractType | 1 | |
| PurchaseRequisition | PurchaseRequisition | 1 | |
| PurchaseRequisitionItem | PurchaseRequisitionItem | 1 | |
| PurchasingContractDeletionCode | PurchasingContractDeletionCode | 1 | |
| PurchasingDocumentCategory | PurchasingDocumentCategory | 1 | |
| PurchasingDocumentItemCategory | PurchasingDocumentItemCategory | 1 | |
| PurchasingGroup | PurchasingGroup | 1 | |
| PurchasingInfoRecord | PurchasingInfoRecord | 1 | |
| PurchasingInfoRecordUpdateCode | PurchasingInfoRecordUpdateCode | 1 | |
| PurchasingIsCatalogRelevant | PurchasingIsCatalogRelevant | 1 | |
| PurchasingParentItem | PurchasingParentItem | 1 | |
| PurchasingPriceIsEstimated | PurchasingPriceIsEstimated | 1 | |
| PurContrValidityEndDate | PurContrValidityEndDate | 1 | |
| PurContrValidityStartDate | PurContrValidityStartDate | 1 | |
| PurgConfigurableItemNumber | PurgConfigurableItemNumber | 1 | |
| PurgDocAggrgdSubitemCategory | PurgDocAggrgdSubitemCategory | 1 | |
| PurgDocOrderAcknNumber | PurgDocOrderAcknNumber | 1 | |
| PurgDocPriceDate | PurgDocPriceDate | 1 | |
| PurgDocReleaseOrderQuantity | PurgDocReleaseOrderQuantity | 1 | |
| PurgExternalSortNumber | PurgExternalSortNumber | 1 | |
| PurgProdCmplncDngrsGoodsStatus | PurgProdCmplncDngrsGoodsStatus | 1 | |
| PurgProdCmplncSupplierStatus | PurgProdCmplncSupplierStatus | 1 | |
| PurgProductMarketabilityStatus | PurgProductMarketabilityStatus | 1 | |
| PurgSafetyDataSheetStatus | PurgSafetyDataSheetStatus | 1 | |
| ReferenceDeliveryAddressID | ReferenceDeliveryAddressID | 1 | |
| RequirementTracking | RequirementTracking | 1 | |
| ServicePerformer | ServicePerformer | 1 | |
| ShippingInstruction | ShippingInstruction | 1 | |
| ShippingType | ShippingType | 1 | |
| StockSegment | StockSegment | 1 | |
| StockType | InventoryUsabilityCode | 1 | |
| StorageLocation | StorageLocation | 1 | |
| Subcontractor | Subcontractor | 1 | |
| SupplierConfirmationControlKey | SupplierConfirmationControlKey | 1 | |
| SupplierMaterialNumber | SupplierMaterialNumber | 1 | |
| SupplierSubrange | SupplierSubrange | 1 | |
| TargetAmount | TargetAmount | 1 | |
| TargetQuantity | TargetQuantity | 1 | |
| TaxCode | TaxCode | 1 | |
| TaxCountry | TaxCountry | 1 | |
| TaxDeterminationDate | TaxDeterminationDate | 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.
-- Purchase Contract Item Base view
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE R_PURCHASECONTRACTITEM (
PURCHASECONTRACT,
PURCHASECONTRACTITEM,
_DOCUMENTCURRENCY,
_MATERIAL,
_MATERIALGROUP,
_ORDERPRICEUNIT,
_ORDERQUANTITYUNIT,
_PLANT,
_STORAGELOCATION,
_VOLUMEUNIT,
ACCOUNTASSIGNMENTCATEGORY,
ACTIVEPURCHASINGDOCUMENT,
COMPANYCODE,
CONTRACTNETPRICEAMOUNT,
CUSTOMER,
DELIVERYADDRESSID,
DOCUMENTCURRENCY,
EVALDRCPTSETTLMTISALLOWED,
GOODSRECEIPTISEXPECTED,
GOODSRECEIPTISNONVALUATED,
INCOTERMSCLASSIFICATION,
INCOTERMSLOCATION1,
INCOTERMSLOCATION2,
INCOTERMSSUPCHNDVTGLOCADDLUUID,
INCOTERMSSUPCHNLOC1ADDLUUID,
INCOTERMSSUPCHNLOC2ADDLUUID,
INVOICEISEXPECTED,
INVOICEISGOODSRECEIPTBASED,
ISENDOFPURPOSEBLOCKED,
ISINFOATREGISTRATION,
ISORDERACKNRQD,
ISSTATISTICALITEM,
ISTOBEACCEPTEDATORIGIN,
MANUALDELIVERYADDRESSID,
MANUFACTURER,
MANUFACTURERMATERIAL,
MANUFACTURERPARTNMBR,
MATERIAL,
MATERIALGROUP,
MATERIALTYPE,
MULTIPLEACCTASSGMTDISTRIBUTION,
NETPRICEQUANTITY,
NODAYSREMINDER1,
NODAYSREMINDER2,
NODAYSREMINDER3,
ORDERPRICEUNIT,
ORDERPRICEUNITTOORDERUNITNMRTR,
ORDERQUANTITYUNIT,
ORDPRICEUNITTOORDERUNITDNMNTR,
OUTLINEAGREEMENTTARGETAMOUNT,
OVERDELIVTOLRTDLMTRATIOINPCT,
PARTIALINVOICEDISTRIBUTION,
PLANNEDDELIVERYDURATIONINDAYS,
PLANT,
PLNDORDERREPLNMTELMNTTYPE,
PRICEISTOBEPRINTED,
PRODUCTCHARACTERISTIC1,
PRODUCTCHARACTERISTIC2,
PRODUCTCHARACTERISTIC3,
PRODUCTCOLLECTION,
PRODUCTSEASON,
PRODUCTSEASONYEAR,
PRODUCTTHEME,
PRODUCTTYPECODE,
PURCHASECONTRACTCREATEDBYUSER,
PURCHASECONTRACTITEMTEXT,
PURCHASECONTRACTITEMUNIQUEID,
PURCHASECONTRACTTYPE,
PURCHASEREQUISITION,
PURCHASEREQUISITIONITEM,
PURCHASINGCONTRACTDELETIONCODE,
PURCHASINGDOCUMENTCATEGORY,
PURCHASINGDOCUMENTITEMCATEGORY,
PURCHASINGGROUP,
PURCHASINGINFORECORD,
PURCHASINGINFORECORDUPDATECODE,
PURCHASINGISCATALOGRELEVANT,
PURCHASINGPARENTITEM,
PURCHASINGPRICEISESTIMATED,
PURCONTRVALIDITYENDDATE,
PURCONTRVALIDITYSTARTDATE,
PURGCONFIGURABLEITEMNUMBER,
PURGDOCAGGRGDSUBITEMCATEGORY,
PURGDOCORDERACKNNUMBER,
PURGDOCPRICEDATE,
PURGDOCRELEASEORDERQUANTITY,
PURGEXTERNALSORTNUMBER,
PURGPRODCMPLNCDNGRSGOODSSTATUS,
PURGPRODCMPLNCSUPPLIERSTATUS,
PURGPRODUCTMARKETABILITYSTATUS,
PURGSAFETYDATASHEETSTATUS,
REFERENCEDELIVERYADDRESSID,
REQUIREMENTTRACKING,
SERVICEPERFORMER,
SHIPPINGINSTRUCTION,
SHIPPINGTYPE,
STOCKSEGMENT,
STOCKTYPE,
STORAGELOCATION,
SUBCONTRACTOR,
SUPPLIERCONFIRMATIONCONTROLKEY,
SUPPLIERMATERIALNUMBER,
SUPPLIERSUBRANGE,
TARGETAMOUNT,
TARGETQUANTITY,
TAXCODE,
TAXCOUNTRY,
TAXDETERMINATIONDATE,
UNDERDELIVTOLRTDLMTRATIOINPCT,
UNLIMITEDOVERDELIVERYISALLOWED,
VOLUMEUNIT,
PRIMARY KEY (PURCHASECONTRACT, PURCHASECONTRACTITEM)
);Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA