C_AlternateSupplierPOSituation

Alternate Suppliers for a Purchase Order Situation | view: CPOALTSUPLRSIT | TRAN | Extraction: Not supported | Component: Purchase Orders
Tables used: EKKOEKPOEINAEINELFA1
Column Name Description
Supplier FK Supplier
Material FK Material Number
Plant FK Plant
PurchasingOrganization FK Purchasing organization
PurchaseOrderItemCategory FK Item category in purchasing document
Column Name Description
💲 Currency Key (DocumentCurrency):
NetPriceAmount Net Price in Purchasing Document (in Document Currency)
Column Name Description
Column Name Description
CreationDate null
Column Name Description
Column Name Description Domain name
PurchaseOrder null
PurchaseOrderItem null
MaterialPlannedDeliveryDurn Planned Delivery Time in Days
PurchasingInfoRecord Number of purchasing info record INFNR
NetPriceQuantity Price Unit
SupplierName Name of Supplier TEXT80
Master Data Relations Join Conditions
Company Code
  • Client
  • Company Code
  • C_ALTERNATESUPPLIERPOSITUATION.MANDT == T001.MANDT
  • C_ALTERNATESUPPLIERPOSITUATION.COMPANYCODE == T001.BUKRS
Currency Key
  • Client
  • Currency Key
  • C_ALTERNATESUPPLIERPOSITUATION.MANDT == TCURC.MANDT
  • C_ALTERNATESUPPLIERPOSITUATION.DOCUMENTCURRENCY == TCURC.WAERS
Material Number
  • Material Number
  • Client
  • C_ALTERNATESUPPLIERPOSITUATION.MATERIAL == MARA.MATNR
  • C_ALTERNATESUPPLIERPOSITUATION.MANDT == MARA.MANDT
Order Price Unit (Purchasing)
  • Order Price Unit (Purchasing)
  • Client
  • C_ALTERNATESUPPLIERPOSITUATION.ORDERPRICEUNIT == T006.MSEHI
  • C_ALTERNATESUPPLIERPOSITUATION.MANDT == T006.MANDT
Plant
  • Plant
  • Client
  • C_ALTERNATESUPPLIERPOSITUATION.PLANT == T001W.WERKS
  • C_ALTERNATESUPPLIERPOSITUATION.MANDT == T001W.MANDT
Item category in purchasing document
  • Client
  • Item category in purchasing document
  • C_ALTERNATESUPPLIERPOSITUATION.MANDT == T163.MANDT
  • C_ALTERNATESUPPLIERPOSITUATION.PURCHASEORDERITEMCATEGORY == T163.PSTYP
Purchasing Group
  • Purchasing Group
  • Client
  • C_ALTERNATESUPPLIERPOSITUATION.PURCHASINGGROUP == T024.EKGRP
  • C_ALTERNATESUPPLIERPOSITUATION.MANDT == T024.MANDT
Purchasing organization
  • Client
  • Purchasing organization
  • C_ALTERNATESUPPLIERPOSITUATION.MANDT == T024E.MANDT
  • C_ALTERNATESUPPLIERPOSITUATION.PURCHASINGORGANIZATION == T024E.EKORG
Supplier
  • Client
  • Supplier
  • C_ALTERNATESUPPLIERPOSITUATION.MANDT == LFA1.MANDT
  • C_ALTERNATESUPPLIERPOSITUATION.SUPPLIER == LFA1.LIFNR