P_PurOrdItmAcctAssgmt1

Purchase Order Item Account Assignment1 | view: PMMPOIACCASGMT1 | Extraction: Not supported | Component: Reporting
Tables used: EKKO, EKPO, EKKN, TKA01, T000
Column Name Description
PurchaseOrder FK Purchasing Document Number
PurchaseOrderItem Item Number of Purchase Order
AccountAssignmentNumber Sequential Number of Account Assignment
Column Name Description
PurOrdNetAmountInDisplayCrcy Purchase Order Net Amount
Column Name Description
Quantity Quantity
PurchaseOrderQty Purchase Order Quantity
📏 Purchase Order Unit of Measure (PurchaseOrderQuantityUnit):
OrderQuantity Purchase Order Quantity
Column Name Description
PurchaseOrderDate Purchase Order Date
Column Name Description
MultipleAcctAssgmtDistribution Distribution Indicator for Multiple Account Assignment Show values
Column Name Description Domain name
CreatedByUser User of person who created a purchasing document USNAM
ProductType Product Type Group CHAR2
ServicePerformer Service Performer BU_PARTNER
MultipleAcctAssgmtDistrPercent Distribution percentage in the case of multiple acct assgt VPROZ
ProfitCenter Profit Center PRCTR
ReturnsItem 2 Byte Signed Integer INT2
Master Data Relations Join Conditions
Account Assignment Category
  • Account Assignment Category
  • Client
  • P_PURORDITMACCTASSGMT1.ACCOUNTASSIGNMENTCATEGORY == T163K.KNTTP
  • P_PURORDITMACCTASSGMT1.MANDT == T163K.MANDT
Company Code
  • Company Code
  • Client
  • P_PURORDITMACCTASSGMT1.COMPANYCODE == T001.BUKRS
  • P_PURORDITMACCTASSGMT1.MANDT == T001.MANDT
Controlling Area
  • Controlling Area
  • Client
  • P_PURORDITMACCTASSGMT1.CONTROLLINGAREA == TKA01.KOKRS
  • P_PURORDITMACCTASSGMT1.MANDT == TKA01.MANDT
Cost Center
  • ?
  • Controlling Area
  • Cost Center
  • Client
  • P_PURORDITMACCTASSGMT1.[column in domain "DATBI"] == CSKS.DATBI
  • P_PURORDITMACCTASSGMT1.CONTROLLINGAREA == CSKS.KOKRS
  • P_PURORDITMACCTASSGMT1.COSTCENTER == CSKS.KOSTL
  • P_PURORDITMACCTASSGMT1.MANDT == CSKS.MANDT
Currency Key
  • Currency Key
  • Client
  • P_PURORDITMACCTASSGMT1.CURRENCY == TCURC.WAERS
  • P_PURORDITMACCTASSGMT1.MANDT == TCURC.MANDT
G/L Account Number
  • ?
  • Client
  • G/L Account Number
  • P_PURORDITMACCTASSGMT1.[column in domain "KTOPL"] == SKA1.KTOPL
  • P_PURORDITMACCTASSGMT1.MANDT == SKA1.MANDT
  • P_PURORDITMACCTASSGMT1.GLACCOUNT == SKA1.SAKNR
Material Number
  • Material Number
  • Client
  • P_PURORDITMACCTASSGMT1.MATERIAL == MARA.MATNR
  • P_PURORDITMACCTASSGMT1.MANDT == MARA.MANDT
Material Group
  • Client
  • Material Group
  • P_PURORDITMACCTASSGMT1.MANDT == T023.MANDT
  • P_PURORDITMACCTASSGMT1.MATERIALGROUP == T023.MATKL
Plant
  • Plant
  • Client
  • P_PURORDITMACCTASSGMT1.PLANT == T001W.WERKS
  • P_PURORDITMACCTASSGMT1.MANDT == T001W.MANDT
Purchase Order Unit of Measure
  • Purchase Order Unit of Measure
  • Client
  • P_PURORDITMACCTASSGMT1.PURCHASEORDERQUANTITYUNIT == T006.MSEHI
  • P_PURORDITMACCTASSGMT1.MANDT == T006.MANDT
Purchase Order Type
  • Purchase Order Type
  • ?
  • Client
  • P_PURORDITMACCTASSGMT1.PURCHASEORDERTYPE == T161.BSART
  • P_PURORDITMACCTASSGMT1.[column in domain "BSTYP"] == T161.BSTYP
  • P_PURORDITMACCTASSGMT1.MANDT == T161.MANDT
Purchasing Group
  • Purchasing Group
  • Client
  • P_PURORDITMACCTASSGMT1.PURCHASINGGROUP == T024.EKGRP
  • P_PURORDITMACCTASSGMT1.MANDT == T024.MANDT
Purchasing organization
  • Purchasing organization
  • Client
  • P_PURORDITMACCTASSGMT1.PURCHASINGORGANIZATION == T024E.EKORG
  • P_PURORDITMACCTASSGMT1.MANDT == T024E.MANDT
Supplier
  • Supplier
  • Client
  • P_PURORDITMACCTASSGMT1.SUPPLIER == LFA1.LIFNR
  • P_PURORDITMACCTASSGMT1.MANDT == LFA1.MANDT