P_PurchOrdReleased

Purchase Order Items released | view: PPURCHORDREL | Extraction: Not supported | Component: Reporting

Tables used: EKKO, EKPO

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

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

Column Name	Description
💲 Currency Key (DocumentCurrency):
NetAmount	Net Order Value in PO Currency

Column Name	Description

Column Name	Description
PurchaseOrderDate	Purchase Order Date

Column Name	Description

Column Name	Description	Domain name

Master Data Relations	Join Conditions
Company Code Client Company Code	`P_PURCHORDRELEASED.MANDT == T001.MANDT` `P_PURCHORDRELEASED.COMPANYCODE == T001.BUKRS`
Currency Key Client Currency Key	`P_PURCHORDRELEASED.MANDT == TCURC.MANDT` `P_PURCHORDRELEASED.DOCUMENTCURRENCY == TCURC.WAERS`
Plant Client Plant	`P_PURCHORDRELEASED.MANDT == T001W.MANDT` `P_PURCHORDRELEASED.PLANT == T001W.WERKS`
Purchase Order Type Client ? Purchase Order Type	`P_PURCHORDRELEASED.MANDT == T161.MANDT` `P_PURCHORDRELEASED.[column in domain "BSTYP"] == T161.BSTYP` `P_PURCHORDRELEASED.PURCHASEORDERTYPE == T161.BSART`
Purchasing Group Purchasing Group Client	`P_PURCHORDRELEASED.PURCHASINGGROUP == T024.EKGRP` `P_PURCHORDRELEASED.MANDT == T024.MANDT`
Number of purchasing info record Client Number of purchasing info record	`P_PURCHORDRELEASED.MANDT == EINA.MANDT` `P_PURCHORDRELEASED.PURCHASINGINFORECORD == EINA.INFNR`
Purchasing organization Client Purchasing organization	`P_PURCHORDRELEASED.MANDT == T024E.MANDT` `P_PURCHORDRELEASED.PURCHASINGORGANIZATION == T024E.EKORG`