P_PurchaseOrderCalc

PurchaseOrderCalc | view: PPURCHORDERCALC | Extraction: Not supported | Component: Reporting
Tables used: SCAL_TT_DATEEKKOEKPO
Column Name Description
PurchasingOrganization FK Purchasing organization
PurchasingGroup FK Purchasing Group
Supplier FK Supplier
CompanyCode FK Company Code
Column Name Description
PurchaseOrderAmount Purchase Order Net Amount
Column Name Description
Column Name Description
Column Name Description
PurchasingDocumentCategory Purchasing Document Category Show values
PurchasingDocumentStatus Status of Purchasing Document Show values
Column Name Description Domain name
CalendarYear Calendar Year NUM4
CalendarMonth Calendar Month NUM2
CalendarQuarter Calendar Quarter NUM1
CalendarWeek Calendar Week NUM2
PurchasingDocument null
PurchasingDocumentItem null
Master Data Relations Join Conditions
Company Code
  • Client
  • Company Code
  • P_PURCHASEORDERCALC.MANDT == T001.MANDT
  • P_PURCHASEORDERCALC.COMPANYCODE == T001.BUKRS
Purchasing Group
  • Client
  • Purchasing Group
  • P_PURCHASEORDERCALC.MANDT == T024.MANDT
  • P_PURCHASEORDERCALC.PURCHASINGGROUP == T024.EKGRP
Purchasing organization
  • Client
  • Purchasing organization
  • P_PURCHASEORDERCALC.MANDT == T024E.MANDT
  • P_PURCHASEORDERCALC.PURCHASINGORGANIZATION == T024E.EKORG
Supplier
  • Supplier
  • Client
  • P_PURCHASEORDERCALC.SUPPLIER == LFA1.LIFNR
  • P_PURCHASEORDERCALC.MANDT == LFA1.MANDT