P_PurOrdSchedAcctAssgmt

Pur Ord Schedue Lines Account Assignment | view: PMMPOSCHEDACCT | Extraction: Not supported | Component: Reporting
Tables used: EKKO, EKPO, EKET
Column Name Description
PurchaseOrder FK Purchasing Document Number
PurchaseOrderItem Item Number of Purchase Order
ScheduleLine Delivery Schedule Line Counter
Column Name Description
💲 Display Currency (DisplayCurrency):
PurOrdNetAmountInDisplayCrcy Purchase Order Net Amount
Column Name Description
📏 Purchase Order Unit of Measure (PurchaseOrderQuantityUnit):
ScheduleLineOrderQuantity Scheduled Quantity
RoughGoodsReceiptQty Quantity of goods received
Column Name Description
PurchaseOrderDate Purchase Order Date
ScheduleLineDeliveryDate Item delivery date
SchedLineStscDeliveryDate Statistics-Relevant Delivery Date
PerformancePeriodStartDate Start Date for Period of Performance
PerformancePeriodEndDate End Date for Period of Performance
ScheduleLineDeliveryTime Delivery Date Time-Spot
Column Name Description
PurchaseOrderCategory Purchasing Document Category Show values
MultipleAcctAssgmtDistribution Distribution Indicator for Multiple Account Assignment Show values
Column Name Description Domain name
PurchaseRequisition Purchase Requisition Number BANFN
ProductType Product Type Group CHAR2
ServicePerformer Service Performer BU_PARTNER
CreatedByUser User of person who created a purchasing document USNAM
Master Data Relations Join Conditions
Account Assignment Category
  • Client
  • Account Assignment Category
  • P_PURORDSCHEDACCTASSGMT.MANDT == T163K.MANDT
  • P_PURORDSCHEDACCTASSGMT.ACCOUNTASSIGNMENTCATEGORY == T163K.KNTTP
Company Code
  • Client
  • Company Code
  • P_PURORDSCHEDACCTASSGMT.MANDT == T001.MANDT
  • P_PURORDSCHEDACCTASSGMT.COMPANYCODE == T001.BUKRS
Currency Key
  • Currency Key
  • Client
  • P_PURORDSCHEDACCTASSGMT.CURRENCY == TCURC.WAERS
  • P_PURORDSCHEDACCTASSGMT.MANDT == TCURC.MANDT
Material Number
  • Client
  • Material Number
  • P_PURORDSCHEDACCTASSGMT.MANDT == MARA.MANDT
  • P_PURORDSCHEDACCTASSGMT.MATERIAL == MARA.MATNR
Material Group
  • Client
  • Material Group
  • P_PURORDSCHEDACCTASSGMT.MANDT == T023.MANDT
  • P_PURORDSCHEDACCTASSGMT.MATERIALGROUP == T023.MATKL
Plant
  • Client
  • Plant
  • P_PURORDSCHEDACCTASSGMT.MANDT == T001W.MANDT
  • P_PURORDSCHEDACCTASSGMT.PLANT == T001W.WERKS
Item category in purchasing document
  • Client
  • Item category in purchasing document
  • P_PURORDSCHEDACCTASSGMT.MANDT == T163.MANDT
  • P_PURORDSCHEDACCTASSGMT.PURCHASEORDERITEMCATEGORY == T163.PSTYP
Purchase Order Unit of Measure
  • Client
  • Purchase Order Unit of Measure
  • P_PURORDSCHEDACCTASSGMT.MANDT == T006.MANDT
  • P_PURORDSCHEDACCTASSGMT.PURCHASEORDERQUANTITYUNIT == T006.MSEHI
Purchase Order Type
  • Purchase Order Type
  • Client
  • Purchasing Document Category
  • P_PURORDSCHEDACCTASSGMT.PURCHASEORDERTYPE == T161.BSART
  • P_PURORDSCHEDACCTASSGMT.MANDT == T161.MANDT
  • P_PURORDSCHEDACCTASSGMT.PURCHASEORDERCATEGORY == T161.BSTYP
Purchasing Group
  • Client
  • Purchasing Group
  • P_PURORDSCHEDACCTASSGMT.MANDT == T024.MANDT
  • P_PURORDSCHEDACCTASSGMT.PURCHASINGGROUP == T024.EKGRP
Purchasing organization
  • Client
  • Purchasing organization
  • P_PURORDSCHEDACCTASSGMT.MANDT == T024E.MANDT
  • P_PURORDSCHEDACCTASSGMT.PURCHASINGORGANIZATION == T024E.EKORG
Supplier
  • Client
  • Supplier
  • P_PURORDSCHEDACCTASSGMT.MANDT == LFA1.MANDT
  • P_PURORDSCHEDACCTASSGMT.SUPPLIER == LFA1.LIFNR