P_PurReqnAvgApprvlCrcyConvrsn

Purchase requisiton currency conversion | view: PPREQNAVGAPPRVL | Extraction: Not supported | Component: Reporting
Tables used: SCAL_TT_DATE, MMDOC_EXT_LINKS, EBAN_TECH, FMIOI, EBAN, EKKO, EKPO, EBKN, ADCP, ADRC, T005, FM01, T001W, LFA1, T001K, MMPUR_C_BE_SYREG, FINSC_FISC_DATE
Column Name Description
PurchaseRequisition Purchase requisition number
PurchaseRequisitionItem Item number of purchase requisition
AccountAssignmentNumber Serial number for PReq account assignment segment
Column Name Description
PurchaseRequisitionPrice Purchase Requisition Price
Column Name Description
Column Name Description
PurReqCreationDate Requisition (request) date
CreationDate null
Column Name Description
Column Name Description Domain name
SupplierCountry Supplier Country/Region LAND1
PurchaseRequisitionStatus Release State FRGZU
ReleaseStrategy Release strategy in the purchase requisition FRGST
CreatedByUser Name of Person Responsible for Creating the Object USNAM
CalendarWeek Calendar Week NUM2
CalendarMonth Calendar Month NUM2
CalendarQuarter Calendar Quarter NUM1
CalendarYear Calendar Year NUM4
Master Data Relations Join Conditions
Account Assignment Category
  • Client
  • Account Assignment Category
  • P_PURREQNAVGAPPRVLCRCYCONVRSN.MANDT == T163K.MANDT
  • P_PURREQNAVGAPPRVLCRCYCONVRSN.ACCOUNTASSIGNMENTCATEGORY == T163K.KNTTP
Cost Center
  • Client
  • ?
  • Cost Center
  • ?
  • P_PURREQNAVGAPPRVLCRCYCONVRSN.MANDT == CSKS.MANDT
  • P_PURREQNAVGAPPRVLCRCYCONVRSN.[column in domain "KOKRS"] == CSKS.KOKRS
  • P_PURREQNAVGAPPRVLCRCYCONVRSN.COSTCENTER == CSKS.KOSTL
  • P_PURREQNAVGAPPRVLCRCYCONVRSN.[column in domain "DATBI"] == CSKS.DATBI
Material Number
  • Client
  • Material Number
  • P_PURREQNAVGAPPRVLCRCYCONVRSN.MANDT == MARA.MANDT
  • P_PURREQNAVGAPPRVLCRCYCONVRSN.MATERIAL == MARA.MATNR
Material Group
  • Client
  • Material Group
  • P_PURREQNAVGAPPRVLCRCYCONVRSN.MANDT == T023.MANDT
  • P_PURREQNAVGAPPRVLCRCYCONVRSN.MATERIALGROUP == T023.MATKL
Plant
  • Client
  • Plant
  • P_PURREQNAVGAPPRVLCRCYCONVRSN.MANDT == T001W.MANDT
  • P_PURREQNAVGAPPRVLCRCYCONVRSN.PLANT == T001W.WERKS
Purchase Requisition Document Type
  • Client
  • Purchase Requisition Document Type
  • ?
  • P_PURREQNAVGAPPRVLCRCYCONVRSN.MANDT == T161.MANDT
  • P_PURREQNAVGAPPRVLCRCYCONVRSN.PURCHASEREQUISITIONTYPE == T161.BSART
  • P_PURREQNAVGAPPRVLCRCYCONVRSN.[column in domain "BSTYP"] == T161.BSTYP
Purchasing Group
  • Client
  • Purchasing Group
  • P_PURREQNAVGAPPRVLCRCYCONVRSN.MANDT == T024.MANDT
  • P_PURREQNAVGAPPRVLCRCYCONVRSN.PURCHASINGGROUP == T024.EKGRP
Purchasing organization
  • Client
  • Purchasing organization
  • P_PURREQNAVGAPPRVLCRCYCONVRSN.MANDT == T024E.MANDT
  • P_PURREQNAVGAPPRVLCRCYCONVRSN.PURCHASINGORGANIZATION == T024E.EKORG
Release Indicator
  • Client
  • Release Indicator
  • P_PURREQNAVGAPPRVLCRCYCONVRSN.MANDT == T161S.MANDT
  • P_PURREQNAVGAPPRVLCRCYCONVRSN.RELEASECODE == T161S.FRGKZ
Supplier
  • Client
  • Supplier
  • P_PURREQNAVGAPPRVLCRCYCONVRSN.MANDT == LFA1.MANDT
  • P_PURREQNAVGAPPRVLCRCYCONVRSN.SUPPLIER == LFA1.LIFNR