C_Arberp_Ordrout_Po_Item

CDS View of purchase order items for ORDR OUT | view: CARBORDROUT_ITEM | Extraction: Not supported | Component: Ariba Integration with S/4HANA Materials Management

Tables used: ESUH, EKKO, EKPO, EKET, EKBE, EKBEH, APOC_D_OR_ITEM, APOC_D_OR_ITEM, APOC_D_OR_ITEM, APOC_D_OR_ITEM, NAST, T001, TKA02, T005T, KNA1, TINCT, T023T, T001W, LFA1, T163B, T163Y, LFA1, LFB1, T163G, T163D, T163G, T161M

🔑 Keys (2)
💰 Amounts (4)
∑ Quantities (1)
📅 Dates
☰ Categorical (7)
Other (18)
🔗 Relations (18)

Column Name	Description
PurchaseOrder FK	Purchasing Document Number
PurchaseOrderItem	Item Number of Purchase Order

Column Name	Description
NetPriceAmount	Net Price in Purchasing Document (in Document Currency)
EffectiveAmount	Effective value of item
OverallLimitAmount	Overall Limit
ExpectedOverallLimitAmount	Expected Value of Overall Limit

Column Name	Description
📏 Purchase Order Unit of Measure (PurchaseOrderQuantityUnit):
OrderQuantity	Purchase Order Quantity

Column Name	Description

Column Name	Description
IsReturnsItem	Returns Item	Show values
IsCompletelyDelivered	"Delivery Completed" Indicator	Show values
UnlimitedOverdeliveryIsAllowed	Unlimited Overdelivery Allowed	Show values
PriceIsToBePrinted	Price Printout	Show values
EvaldRcptSettlmtIsAllowed	Evaluated Receipt Settlement (ERS)	Show values
GoodsReceiptIsExpected	Goods Receipt Indicator	Show values
InvoiceIsExpected	Invoice receipt indicator	Show values

Column Name	Description	Domain name
ProductType	Product Type Group	CHAR2
PurchaseOrderItemText	Short Text	TEXT40
SupplierMaterialNumber	Material Number Used by Supplier	IDNEX
PurchasingDocumentDeletionCode	Deletion Indicator in Purchasing Document	ELOEK
OrderPriceUnitToOrderUnitNmrtr	Numerator for Conversion of Order Price Unit into Order Unit	UMBSZ
OrdPriceUnitToOrderUnitDnmntr	Denominator for Conv. of Order Price Unit into Order Unit	UMBSN
PurchaseOrderNetPriceQuantity	Price Unit	DEC5
OverdelivTolrtdLmtRatioInPct	Overdelivery Tolerance	PRZ21
UnderdelivTolrtdLmtRatioInPct	Underdelivery Tolerance	PRZ21
ItemDeliveryAddressID	Manual address number in purchasing document item	AD_ADDRNUM
IncotermsTransferLocation	Incoterms (Part 2)	INCO2
IncotermsClassificationName	null
ManufacturerPartNmbr	Manufacturer Part Number	CHAR40
ManufacturerName	Name of Supplier	TEXT80
InternationalArticleNumber	International Article Number (EAN/UPC)	EAN11
PurReqItemCategoryName	null
PermittedPriceOverrunInPct	Permitted Price Overrun in % (Inbound EDI/SOA)	PRZ22
MaterialGroupText	null

Master Data Relations	Join Conditions
Incoterms (Part 1) Incoterms (Part 1) Client	`C_ARBERP_ORDROUT_PO_ITEM.INCOTERMSCLASSIFICATION == TINC.INCO1` `C_ARBERP_ORDROUT_PO_ITEM.MANDT == TINC.MANDT`
Language Key	`C_ARBERP_ORDROUT_PO_ITEM.LANGUAGE == T002.SPRAS`
Manufacturer number Client Manufacturer number	`C_ARBERP_ORDROUT_PO_ITEM.MANDT == LFA1.MANDT` `C_ARBERP_ORDROUT_PO_ITEM.MANUFACTURER == LFA1.LIFNR`
Material number Client Material number	`C_ARBERP_ORDROUT_PO_ITEM.MANDT == MARA.MANDT` `C_ARBERP_ORDROUT_PO_ITEM.MANUFACTURERMATERIAL == MARA.MATNR`
Material Number Client Material Number	`C_ARBERP_ORDROUT_PO_ITEM.MANDT == MARA.MANDT` `C_ARBERP_ORDROUT_PO_ITEM.MATERIAL == MARA.MATNR`
Material Group Client Material Group	`C_ARBERP_ORDROUT_PO_ITEM.MANDT == T023.MANDT` `C_ARBERP_ORDROUT_PO_ITEM.MATERIALGROUP == T023.MATKL`
Order Price Unit (Purchasing) Order Price Unit (Purchasing) Client	`C_ARBERP_ORDROUT_PO_ITEM.ORDERPRICEUNIT == T006.MSEHI` `C_ARBERP_ORDROUT_PO_ITEM.MANDT == T006.MANDT`
Plant Client Plant	`C_ARBERP_ORDROUT_PO_ITEM.MANDT == T001W.MANDT` `C_ARBERP_ORDROUT_PO_ITEM.PLANT == T001W.WERKS`
Item category in purchasing document Client Item category in purchasing document	`C_ARBERP_ORDROUT_PO_ITEM.MANDT == T163.MANDT` `C_ARBERP_ORDROUT_PO_ITEM.PURCHASEORDERITEMCATEGORY == T163.PSTYP`
Purchase Order Unit of Measure Client Purchase Order Unit of Measure	`C_ARBERP_ORDROUT_PO_ITEM.MANDT == T006.MANDT` `C_ARBERP_ORDROUT_PO_ITEM.PURCHASEORDERQUANTITYUNIT == T006.MSEHI`
Purchase Order Type Client ? Purchase Order Type	`C_ARBERP_ORDROUT_PO_ITEM.MANDT == T161.MANDT` `C_ARBERP_ORDROUT_PO_ITEM.[column in domain "BSTYP"] == T161.BSTYP` `C_ARBERP_ORDROUT_PO_ITEM.PURCHASEORDERTYPE == T161.BSART`
Purchasing Group Client Purchasing Group	`C_ARBERP_ORDROUT_PO_ITEM.MANDT == T024.MANDT` `C_ARBERP_ORDROUT_PO_ITEM.PURCHASINGGROUP == T024.EKGRP`
Purchasing organization Client Purchasing organization	`C_ARBERP_ORDROUT_PO_ITEM.MANDT == T024E.MANDT` `C_ARBERP_ORDROUT_PO_ITEM.PURCHASINGORGANIZATION == T024E.EKORG`
Package number Client Package number	`C_ARBERP_ORDROUT_PO_ITEM.MANDT == ESLH.MANDT` `C_ARBERP_ORDROUT_PO_ITEM.SERVICEPACKAGE == ESLH.PACKNO`
Confirmation Category Confirmation Category Confirmation Category Client	`C_ARBERP_ORDROUT_PO_ITEM.SHIPPINGNOTIFICATIONCATEGORY == T163E.EBTYP` `C_ARBERP_ORDROUT_PO_ITEM.SUPPLIERCONFIRMATIONCATEGORY == T163E.EBTYP` `C_ARBERP_ORDROUT_PO_ITEM.MANDT == T163E.MANDT`
Confirmation Category Confirmation Category Confirmation Category Client	`C_ARBERP_ORDROUT_PO_ITEM.SHIPPINGNOTIFICATIONCATEGORY == T163E.EBTYP` `C_ARBERP_ORDROUT_PO_ITEM.SUPPLIERCONFIRMATIONCATEGORY == T163E.EBTYP` `C_ARBERP_ORDROUT_PO_ITEM.MANDT == T163E.MANDT`
Confirmation Control Key Confirmation Control Key Client	`C_ARBERP_ORDROUT_PO_ITEM.SUPPLIERCONFIRMATIONCONTROLKEY == T163L.BSTAE` `C_ARBERP_ORDROUT_PO_ITEM.MANDT == T163L.MANDT`