C_PurgDataForTimeSheet

Purchasing Data for Time Sheet | view: CMMTIMESHEETDATA | Extraction: Not supported | Component: Purchase Orders
Tables used: EKKOEKPOEKKNTKA01T001WT000LFA1PRPS
Column Name Description
PurchaseOrder Purchase Order Number
PurchaseOrderItem Item Number of Purchase Order
AccountAssignmentNumber Sequential Number of Account Assignment
Column Name Description
Column Name Description
📏 Purchase Order Unit of Measure (PurchaseOrderQuantityUnit):
OrderQuantity Purchase Order Quantity
Column Name Description
Column Name Description
IsCompletelyDelivered "Delivery Completed" Indicator Show values
UnlimitedOverdeliveryIsAllowed Unlimited Overdelivery Allowed Show values
Column Name Description Domain name
SupplierFullName Supplier Full Name TEXT220
PlantName Plant Name TEXT30
OverdelivTolrtdLmtRatioInPct Overdelivery Tolerance PRZ21
ServicePerformer Service Performer BU_PARTNER
Master Data Relations Join Conditions
Account Assignment Category
  • Account Assignment Category
  • Client
  • C_PURGDATAFORTIMESHEET.ACCOUNTASSIGNMENTCATEGORY == T163K.KNTTP
  • C_PURGDATAFORTIMESHEET.MANDT == T163K.MANDT
G/L Account Number
  • ?
  • Client
  • G/L Account Number
  • C_PURGDATAFORTIMESHEET.[column in domain "KTOPL"] == SKA1.KTOPL
  • C_PURGDATAFORTIMESHEET.MANDT == SKA1.MANDT
  • C_PURGDATAFORTIMESHEET.GLACCOUNT == SKA1.SAKNR
Material Number
  • Material Number
  • Client
  • C_PURGDATAFORTIMESHEET.MATERIAL == MARA.MATNR
  • C_PURGDATAFORTIMESHEET.MANDT == MARA.MANDT
Plant
  • Client
  • Plant
  • C_PURGDATAFORTIMESHEET.MANDT == T001W.MANDT
  • C_PURGDATAFORTIMESHEET.PLANT == T001W.WERKS
Purchase Order Unit of Measure
  • Purchase Order Unit of Measure
  • Client
  • C_PURGDATAFORTIMESHEET.PURCHASEORDERQUANTITYUNIT == T006.MSEHI
  • C_PURGDATAFORTIMESHEET.MANDT == T006.MANDT
Purchase Order Type
  • Client
  • Purchase Order Type
  • ?
  • C_PURGDATAFORTIMESHEET.MANDT == T161.MANDT
  • C_PURGDATAFORTIMESHEET.PURCHASEORDERTYPE == T161.BSART
  • C_PURGDATAFORTIMESHEET.[column in domain "BSTYP"] == T161.BSTYP
Purchasing Group
  • Purchasing Group
  • Client
  • C_PURGDATAFORTIMESHEET.PURCHASINGGROUP == T024.EKGRP
  • C_PURGDATAFORTIMESHEET.MANDT == T024.MANDT
Purchasing organization
  • Purchasing organization
  • Client
  • C_PURGDATAFORTIMESHEET.PURCHASINGORGANIZATION == T024E.EKORG
  • C_PURGDATAFORTIMESHEET.MANDT == T024E.MANDT
Supplier
  • Supplier
  • Client
  • C_PURGDATAFORTIMESHEET.SUPPLIER == LFA1.LIFNR
  • C_PURGDATAFORTIMESHEET.MANDT == LFA1.MANDT