P_PurchaseRequisitionItem2

Puchaser Reqn Item for change document 2 | view: PPURREQN2 | TRAN | Extraction: Not supported | Component: Reporting
Column Name Description
PurchaseRequisition Purchase requisition number
PurchaseRequisitionItem Item number of purchase requisition
Column Name Description
Column Name Description
Column Name Description
CreationDate Requisition (request) date
Column Name Description
PurReqnReleaseStatus Requisition Processing State Show values
PurReqnOrigin Creation indicator (purchase requisition/schedule lines) Show values
Column Name Description Domain name
PurchaseRequisitionItemKey null
CreatedByUser Name of Person Responsible for Creating the Object USNAM
PurchaseRequisitionStatus Release State FRGZU
ReleaseStrategy Release strategy in the purchase requisition FRGST
PurReqnSSPCatalog Technical Key of a Web Service (for Example - a Catalog) BBP_WS_SERVICE_ID
CalendarYear Calendar Year NUM4
CalendarQuarter Calendar Quarter NUM1
CalendarMonth Calendar Month NUM2
CalendarWeek Calendar Week NUM2
Master Data Relations Join Conditions
Company code
  • Company Code
  • Client
  • P_PURCHASEREQUISITIONITEM2.COMPANYCODE == T001.BUKRS
  • P_PURCHASEREQUISITIONITEM2.MANDT == T001.MANDT
Fixed Vendor
  • Client
  • Fixed Vendor
  • P_PURCHASEREQUISITIONITEM2.MANDT == LFA1.MANDT
  • P_PURCHASEREQUISITIONITEM2.FIXEDSUPPLIER == LFA1.LIFNR
Material Number
  • Material Number
  • Client
  • P_PURCHASEREQUISITIONITEM2.MATERIAL == MARA.MATNR
  • P_PURCHASEREQUISITIONITEM2.MANDT == MARA.MANDT
Material Group
  • Client
  • Material Group
  • P_PURCHASEREQUISITIONITEM2.MANDT == T023.MANDT
  • P_PURCHASEREQUISITIONITEM2.MATERIALGROUP == T023.MATKL
Plant
  • Plant
  • Client
  • P_PURCHASEREQUISITIONITEM2.PLANT == T001W.WERKS
  • P_PURCHASEREQUISITIONITEM2.MANDT == T001W.MANDT
Purchase Requisition Document Type
  • Client
  • Purchase Requisition Document Type
  • ?
  • P_PURCHASEREQUISITIONITEM2.MANDT == T161.MANDT
  • P_PURCHASEREQUISITIONITEM2.PURCHASEREQUISITIONTYPE == T161.BSART
  • P_PURCHASEREQUISITIONITEM2.[column in domain "BSTYP"] == T161.BSTYP
Purchasing Group
  • Purchasing Group
  • Client
  • P_PURCHASEREQUISITIONITEM2.PURCHASINGGROUP == T024.EKGRP
  • P_PURCHASEREQUISITIONITEM2.MANDT == T024.MANDT
Purchasing organization
  • Client
  • Purchasing organization
  • P_PURCHASEREQUISITIONITEM2.MANDT == T024E.MANDT
  • P_PURCHASEREQUISITIONITEM2.PURCHASINGORGANIZATION == T024E.EKORG
Release Indicator
  • Release Indicator
  • Client
  • P_PURCHASEREQUISITIONITEM2.RELEASECODE == T161S.FRGKZ
  • P_PURCHASEREQUISITIONITEM2.MANDT == T161S.MANDT