P_PurDocItemCurConv

Purchase Document with Currency Conversion for dates | view: PURDOCITEMCUR | Extraction: Not supported | Component: Reporting
Tables used: SCAL_TT_DATE, EKKO, EKPO, ADCP, ADRC, T024, LFA1
Column Name Description
PurchasingDocument FK Purchasing Document Number
PurchasingDocumentItem Item Number of Purchasing Document
Column Name Description
💲 null (DisplayCurrency):
NetAmountInDisplayCurrency null
Column Name Description
Column Name Description
PurchasingDocumentOrderDate Purchasing Document Date
Column Name Description
PurchasingDocumentCategory Purchasing Document Category Show values
PurchasingDocumentOrigin Status of Purchasing Document Show values
MultipleAcctAssgmtDistribution Distribution Indicator for Multiple Account Assignment Show values
Column Name Description Domain name
PurchasingDocumentItemNo null
PurchasingGroupName Purchasing Group Name TEXT18
CreatedByUser User of person who created a purchasing document USNAM
CalendarYear Calendar Year NUM4
CalendarMonth Calendar Month NUM2
CalendarQuarter Calendar Quarter NUM1
CalendarWeek Calendar Week NUM2
Master Data Relations Join Conditions
Account Assignment Category
  • Account Assignment Category
  • Client
  • P_PURDOCITEMCURCONV.ACCOUNTASSIGNMENTCATEGORY == T163K.KNTTP
  • P_PURDOCITEMCURCONV.MANDT == T163K.MANDT
Company Code
  • Company Code
  • Client
  • P_PURDOCITEMCURCONV.COMPANYCODE == T001.BUKRS
  • P_PURDOCITEMCURCONV.MANDT == T001.MANDT
Currency Key
  • Client
  • Currency Key
  • P_PURDOCITEMCURCONV.MANDT == TCURC.MANDT
  • P_PURDOCITEMCURCONV.DOCUMENTCURRENCY == TCURC.WAERS
Material Number
  • Material Number
  • Client
  • P_PURDOCITEMCURCONV.MATERIAL == MARA.MATNR
  • P_PURDOCITEMCURCONV.MANDT == MARA.MANDT
Material Group
  • Material Group
  • Client
  • P_PURDOCITEMCURCONV.MATERIALGROUP == T023.MATKL
  • P_PURDOCITEMCURCONV.MANDT == T023.MANDT
Order Price Unit (Purchasing)
  • Order Price Unit (Purchasing)
  • Client
  • P_PURDOCITEMCURCONV.ORDERPRICEUNIT == T006.MSEHI
  • P_PURDOCITEMCURCONV.MANDT == T006.MANDT
Plant
  • Client
  • Plant
  • P_PURDOCITEMCURCONV.MANDT == T001W.MANDT
  • P_PURDOCITEMCURCONV.PLANT == T001W.WERKS
Profit Center
  • ?
  • Purchasing Document Date
  • Profit Center
  • Client
  • P_PURDOCITEMCURCONV.[column in domain "KOKRS"] == CEPC.KOKRS
  • P_PURDOCITEMCURCONV.PURCHASINGDOCUMENTORDERDATE == CEPC.DATBI
  • P_PURDOCITEMCURCONV.PROFITCENTER == CEPC.PRCTR
  • P_PURDOCITEMCURCONV.MANDT == CEPC.MANDT
Purchasing Group
  • Purchasing Group
  • Client
  • P_PURDOCITEMCURCONV.PURCHASINGGROUP == T024.EKGRP
  • P_PURDOCITEMCURCONV.MANDT == T024.MANDT
Purchasing Organization
  • Purchasing Organization
  • Client
  • P_PURDOCITEMCURCONV.PURCHASINGORGANIZATION == T024E.EKORG
  • P_PURDOCITEMCURCONV.MANDT == T024E.MANDT
Supplier
  • Supplier
  • Client
  • P_PURDOCITEMCURCONV.SUPPLIER == LFA1.LIFNR
  • P_PURDOCITEMCURCONV.MANDT == LFA1.MANDT
Country key
  • Client
  • Supplier Country/Region
  • P_PURDOCITEMCURCONV.MANDT == T005.MANDT
  • P_PURDOCITEMCURCONV.SUPPLIERCOUNTRY == T005.LAND1