I_PurchaseContractItemWD

BO View for I_PurchaseContractItemWD | view: IPURCHASECT000WD | Extraction: Not supported | Component: Vendor Outline Agreements

Tables used: /SRMSMC/D_PUC_RT, /SRMSMC/D_PUCMG, EKKO, EKPO, T001W, T163Y

🔑 Keys (2)
💰 Amounts (2)
∑ Quantities (2)
📅 Dates (2)
☰ Categorical (16)
Other (34)
🔗 Relations (26)

Column Name	Description
PurchaseContractItem	Item Number of Purchasing Contract
PurchaseContract FK	Purchasing Contract Header

Column Name	Description
💲 Currency Key (DocumentCurrency):
ContractNetPriceAmount	Net Price in Purchasing Document (in Document Currency)
TargetAmount	Target Value for Outline Agreement in Document Currency

Column Name	Description
📏 Purchase Order Unit of Measure (OrderQuantityUnit):
TargetQuantity	Target Quantity
PurgDocReleaseOrderQuantity	Standard release order quantity

Column Name	Description
PurgDocPriceDate	Date of Price Determination
TaxDeterminationDate	Date for Determining Tax Rates

Column Name	Description
GoodsReceiptIsExpected	Goods Receipt Indicator	Show values
MultipleAcctAssgmtDistribution	Distribution Indicator for Multiple Account Assignment	Show values
PartialInvoiceDistribution	Partial invoice indicator	Show values
EvaldRcptSettlmtIsAllowed	Evaluated Receipt Settlement (ERS)	Show values
PriceIsToBePrinted	Price Printout	Show values
UnlimitedOverdeliveryIsAllowed	Unlimited Overdelivery Allowed	Show values
InvoiceIsExpected	Invoice receipt indicator	Show values
InvoiceIsGoodsReceiptBased	Indicator: GR-Based Invoice Verification	Show values
IsInfoRecordUpdated	Indicator: Update Info Record	Show values
PurgDocEstimatedPrice	Indicator: Estimated Price	Show values
IsInfoAtRegistration	Info at Registration	Show values
StockType	Stock Type	Show values
IsOrderAcknRqd	Order Acknowledgment Requirement	Show values
GoodsReceiptIsNonValuated	Goods Receipt, Non-Valuated	Show values
IsStatisticalItem	Item is statistical	Show values
IsOutline	Checkbox	Show values

Column Name	Description	Domain name
PurchaseContractItemForEdit	Item Number of Purchasing Contract	EBELP
PurchaseContractItemText	Short Text	TEXT40
ManualDeliveryAddressID	Manual address number in purchasing document item	AD_ADDRNUM
NetPriceQuantity	Price Unit	DEC5
OrdPriceUnitToOrderUnitDnmntr	Denominator for Conv. of Order Price Unit into Order Unit	UMBSN
OrderPriceUnitToOrderUnitNmrtr	Numerator for Conversion of Order Price Unit into Order Unit	UMBSZ
SupplierMaterialNumber	Material Number Used by Supplier	IDNEX
UnderdelivTolrtdLmtRatioInPct	Underdelivery Tolerance	PRZ21
OverdelivTolrtdLmtRatioInPct	Overdelivery Tolerance	PRZ21
IncotermsLocation1	Incoterms Location 1	INCO_L
PurgDocOrderAcknNumber	Order Acknowledgment Number	TEXT20
NoDaysReminder1	Number of Days for First Reminder/Expediter	MAHNT
NoDaysReminder2	Number of Days for Second Reminder/Expediter	MAHNT
NoDaysReminder3	Number of Days for Third Reminder/Expediter	MAHNT
PlannedDeliveryDurationInDays	Planned Delivery Time in Days	DEC3
TaxCountry	Tax Reporting Country/Region	LAND1
RequirementTracking	Requirement Tracking Number	CHAR10
ServicePerformer	Service Performer	BU_PARTNER
ProductType	Product Type Group	CHAR2
FormattedPurchaseContractItem	null
PurchaseContractItemFormatted	null
PurchaseRequisition	Purchase Requisition Number	BANFN
PurchasingContractDeletionCode	Deletion Indicator in Purchasing Document	ELOEK
HierarchyNode	Hierarchy node	RSCHAVLEXT
HierarchyParentNode	Hierarchy node	RSCHAVLEXT
HierarchyLevel	null
HierarchyNodeSubTreeSize	null
HierarchyDrillState	null
HierarchyNodeOrdinalNumber	null
PurgConfigurableItemNumber	Hierarchy Number	EXLIN
PurgDocAggrgdSubitemCategory	Subitems Exist	CHAR1
PurgExternalSortNumber	External Sort Number	EXSNR
PurgDocExternalItemCategory	Item Category in Purchasing Document	EPSTP
PurgDocItemCategoryName	Text for Item Category	TEXT20

Master Data Relations	Join Conditions
Account Assignment Category Account Assignment Category Client	`I_PURCHASECONTRACTITEMWD.ACCOUNTASSIGNMENTCATEGORY == T163K.KNTTP` `I_PURCHASECONTRACTITEMWD.MANDT == T163K.MANDT`
Company Code Company Code Client	`I_PURCHASECONTRACTITEMWD.COMPANYCODE == T001.BUKRS` `I_PURCHASECONTRACTITEMWD.MANDT == T001.MANDT`
Confirmation Control Key Client Confirmation Control Key	`I_PURCHASECONTRACTITEMWD.MANDT == T163L.MANDT` `I_PURCHASECONTRACTITEMWD.CONFIRMATIONCONTROL == T163L.BSTAE`
Customer Customer Client	`I_PURCHASECONTRACTITEMWD.CUSTOMER == KNA1.KUNNR` `I_PURCHASECONTRACTITEMWD.MANDT == KNA1.MANDT`
Currency Key Currency Key Client	`I_PURCHASECONTRACTITEMWD.DOCUMENTCURRENCY == TCURC.WAERS` `I_PURCHASECONTRACTITEMWD.MANDT == TCURC.MANDT`
Incoterms (Part 1) Client Incoterms (Part 1)	`I_PURCHASECONTRACTITEMWD.MANDT == TINC.MANDT` `I_PURCHASECONTRACTITEMWD.INCOTERMSCLASSIFICATION == TINC.INCO1`
Material Number Material Number Client	`I_PURCHASECONTRACTITEMWD.MATERIAL == MARA.MATNR` `I_PURCHASECONTRACTITEMWD.MANDT == MARA.MANDT`
Material Group Material Group Client	`I_PURCHASECONTRACTITEMWD.MATERIALGROUP == T023.MATKL` `I_PURCHASECONTRACTITEMWD.MANDT == T023.MANDT`
Material type Material type Client	`I_PURCHASECONTRACTITEMWD.MATERIALTYPE == T134.MTART` `I_PURCHASECONTRACTITEMWD.MANDT == T134.MANDT`
Order Price Unit (Purchasing) Order Price Unit (Purchasing) Order Price Unit (Purchasing) Client	`I_PURCHASECONTRACTITEMWD.ORDPRCUNITTOORDERUNITNMRTRUOM == T006.MSEHI` `I_PURCHASECONTRACTITEMWD.ORDERPRICEUNIT == T006.MSEHI` `I_PURCHASECONTRACTITEMWD.MANDT == T006.MANDT`
Purchase Order Unit of Measure Purchase Order Unit of Measure Purchase Order Unit of Measure Client	`I_PURCHASECONTRACTITEMWD.ORDERQUANTITYUNIT == T006.MSEHI` `I_PURCHASECONTRACTITEMWD.ORDPRCUNITTOORDERUNITDNMNTRUOM == T006.MSEHI` `I_PURCHASECONTRACTITEMWD.MANDT == T006.MANDT`
Purchase Order Unit of Measure Purchase Order Unit of Measure Purchase Order Unit of Measure Client	`I_PURCHASECONTRACTITEMWD.ORDERQUANTITYUNIT == T006.MSEHI` `I_PURCHASECONTRACTITEMWD.ORDPRCUNITTOORDERUNITDNMNTRUOM == T006.MSEHI` `I_PURCHASECONTRACTITEMWD.MANDT == T006.MANDT`
Order Price Unit (Purchasing) Order Price Unit (Purchasing) Order Price Unit (Purchasing) Client	`I_PURCHASECONTRACTITEMWD.ORDPRCUNITTOORDERUNITNMRTRUOM == T006.MSEHI` `I_PURCHASECONTRACTITEMWD.ORDERPRICEUNIT == T006.MSEHI` `I_PURCHASECONTRACTITEMWD.MANDT == T006.MANDT`
Plant Client Plant	`I_PURCHASECONTRACTITEMWD.MANDT == T001W.MANDT` `I_PURCHASECONTRACTITEMWD.PLANT == T001W.WERKS`
Purchasing Document Type ? Client Purchasing Document Type	`I_PURCHASECONTRACTITEMWD.[column in domain "BSTYP"] == T161.BSTYP` `I_PURCHASECONTRACTITEMWD.MANDT == T161.MANDT` `I_PURCHASECONTRACTITEMWD.PURCHASECONTRACTTYPE == T161.BSART`
Item category in purchasing document Client Item category in purchasing document	`I_PURCHASECONTRACTITEMWD.MANDT == T163.MANDT` `I_PURCHASECONTRACTITEMWD.PURCHASINGDOCUMENTITEMCATEGORY == T163.PSTYP`
Reference Delivery Address ? ? Reference Delivery Address Client	`I_PURCHASECONTRACTITEMWD.[column in domain "AD_NATION"] == ADRC.NATION` `I_PURCHASECONTRACTITEMWD.[column in domain "AD_DATE_FR"] == ADRC.DATE_FROM` `I_PURCHASECONTRACTITEMWD.REFERENCEDELIVERYADDRESSID == ADRC.ADDRNUMBER` `I_PURCHASECONTRACTITEMWD.MANDT == ADRC.CLIENT`
Shipping Instructions Shipping Instructions Client	`I_PURCHASECONTRACTITEMWD.SHIPPINGINSTRUCTION == T027A.EVERS` `I_PURCHASECONTRACTITEMWD.MANDT == T027A.MANDT`
Storage Location Storage Location Client Plant	`I_PURCHASECONTRACTITEMWD.STORAGELOCATION == T001L.LGORT` `I_PURCHASECONTRACTITEMWD.MANDT == T001L.MANDT` `I_PURCHASECONTRACTITEMWD.PLANT == T001L.WERKS`
Supplier to be Supplied/Who is to Receive Delivery Supplier to be Supplied/Who is to Receive Delivery Client	`I_PURCHASECONTRACTITEMWD.SUBCONTRACTOR == LFA1.LIFNR` `I_PURCHASECONTRACTITEMWD.MANDT == LFA1.MANDT`
Tax on sales/purchases code ? Tax on sales/purchases code Client	`I_PURCHASECONTRACTITEMWD.[column in domain "KALSM_D"] == T007A.KALSM` `I_PURCHASECONTRACTITEMWD.TAXCODE == T007A.MWSKZ` `I_PURCHASECONTRACTITEMWD.MANDT == T007A.MANDT`
Volume unit Volume unit Client	`I_PURCHASECONTRACTITEMWD.VOLUMEUNIT == T006.MSEHI` `I_PURCHASECONTRACTITEMWD.MANDT == T006.MANDT`