C_RequirementTrackingPurReq

Purchase Requisitions by Tracking number | view: CREQTRACKPR | TRAN | Extraction: Not supported | Component: Purchase Orders
Tables used: MMDOC_EXT_LINKS, EBAN_TECH, FMIOI, EBAN, /SRMSMC/D_PUC_RT, /SRMSMC/D_PUCMG, FM01, T001W, T161U, T161, T161T, EINA, T163, T163Y, LFA1, USR21, T001K, MMPUR_C_BE_SYREG, FINSC_FISC_DATE
Column Name Description
PurchaseRequisition Purchase requisition number
PurchaseRequisitionItem Item number of purchase requisition
Column Name Description
💲 Currency Key (PurReqnItemCurrency):
PurchaseRequisitionPrice Price in Purchase Requisition
PurReqnTotalAmountInDspCrcy null
Column Name Description
📏 Purchase requisition unit of measure (BaseUnit):
RequestedQuantity Purchase requisition quantity
Column Name Description
DeliveryDate Item delivery date
CreationDate Requisition (request) date
PurReqCreationDate Requisition (request) date
PurchaseRequisitionReleaseDate Purchase Requisition Release Date
Column Name Description
ConsumptionPosting Consumption posting Show values
Column Name Description Domain name
FormattedPurRequisitionItem null
RequirementTracking Requirement Tracking Number
PurchasingText Short Text TEXT40
SupplierName Name of Supplier
PurchasingDocumentType Purchasing Document Type
PurchasingDocumentCategory Purchasing Document Category
PurchasingDocumentTypeName Short Description of Purchasing Document Type
PurgDocExternalItemCategory Item Category in Purchasing Document
PurgDocItemCategoryName Text for Item Category
PurchasingCategory Purchasing Category ID /SRMSMC/OBJECT_ID
PurgCatName Name of Purchasing Category
PurReqnReleaseStatus Requisition Processing State
PurchasingReleaseIndicatorDesc Description of release indicator TEXT30
ProcessingStatus Processing status of purchase requisition
PurchasingInfoRecordDesc Short Text for Purchasing Info Record TEXT40
PurReqnRequestor Requestor
RequisitionerName Name of requisitioner/requester AFNAM
Batch Batch Number CHARG
PurReqnOrigin Creation indicator (purchase requisition/schedule lines)
DomainText Short Text for Fixed Values DDTEXT
ReleaseStrategy Release strategy in the purchase requisition
CreatedByUser Name of Person Responsible for Creating the Object USNAM
UserDescription User Description
PurchasingIsBlockedForSupplier null
Master Data Relations Join Conditions
Account Assignment Category
  • Account Assignment Category
  • Client
  • C_REQUIREMENTTRACKINGPURREQ.ACCOUNTASSIGNMENTCATEGORY == T163K.KNTTP
  • C_REQUIREMENTTRACKINGPURREQ.MANDT == T163K.MANDT
Purchase requisition unit of measure
  • Client
  • Purchase requisition unit of measure
  • C_REQUIREMENTTRACKINGPURREQ.MANDT == T006.MANDT
  • C_REQUIREMENTTRACKINGPURREQ.BASEUNIT == T006.MSEHI
Company code
  • Company Code
  • Client
  • C_REQUIREMENTTRACKINGPURREQ.COMPANYCODE == T001.BUKRS
  • C_REQUIREMENTTRACKINGPURREQ.MANDT == T001.MANDT
Fixed Vendor
  • Fixed Vendor
  • Client
  • C_REQUIREMENTTRACKINGPURREQ.FIXEDSUPPLIER == LFA1.LIFNR
  • C_REQUIREMENTTRACKINGPURREQ.MANDT == LFA1.MANDT
Material Number
  • Client
  • Material Number
  • C_REQUIREMENTTRACKINGPURREQ.MANDT == MARA.MANDT
  • C_REQUIREMENTTRACKINGPURREQ.MATERIAL == MARA.MATNR
Material Group
  • Material Group
  • Client
  • C_REQUIREMENTTRACKINGPURREQ.MATERIALGROUP == T023.MATKL
  • C_REQUIREMENTTRACKINGPURREQ.MANDT == T023.MANDT
MRP Controller
  • Client
  • MRP Controller
  • Plant
  • C_REQUIREMENTTRACKINGPURREQ.MANDT == T024D.MANDT
  • C_REQUIREMENTTRACKINGPURREQ.MRPCONTROLLER == T024D.DISPO
  • C_REQUIREMENTTRACKINGPURREQ.PLANT == T024D.WERKS
Plant
  • Client
  • Plant
  • C_REQUIREMENTTRACKINGPURREQ.MANDT == T001W.MANDT
  • C_REQUIREMENTTRACKINGPURREQ.PLANT == T001W.WERKS
Purchase Requisition Document Type
  • Purchasing Document Category
  • Purchasing Document Type
  • Purchase Requisition Document Type
  • Client
  • C_REQUIREMENTTRACKINGPURREQ.PURCHASINGDOCUMENTCATEGORY == T161.BSTYP
  • C_REQUIREMENTTRACKINGPURREQ.PURCHASINGDOCUMENTTYPE == T161.BSART
  • C_REQUIREMENTTRACKINGPURREQ.PURCHASEREQUISITIONTYPE == T161.BSART
  • C_REQUIREMENTTRACKINGPURREQ.MANDT == T161.MANDT
Item category in purchasing document
  • Item category in purchasing document
  • Client
  • C_REQUIREMENTTRACKINGPURREQ.PURCHASINGDOCUMENTITEMCATEGORY == T163.PSTYP
  • C_REQUIREMENTTRACKINGPURREQ.MANDT == T163.MANDT
Purchasing Group
  • Purchasing Group
  • Client
  • C_REQUIREMENTTRACKINGPURREQ.PURCHASINGGROUP == T024.EKGRP
  • C_REQUIREMENTTRACKINGPURREQ.MANDT == T024.MANDT
Number of purchasing info record
  • Number of purchasing info record
  • Client
  • C_REQUIREMENTTRACKINGPURREQ.PURCHASINGINFORECORD == EINA.INFNR
  • C_REQUIREMENTTRACKINGPURREQ.MANDT == EINA.MANDT
Purchasing organization
  • Purchasing organization
  • Client
  • C_REQUIREMENTTRACKINGPURREQ.PURCHASINGORGANIZATION == T024E.EKORG
  • C_REQUIREMENTTRACKINGPURREQ.MANDT == T024E.MANDT
Currency Key
  • Currency Key
  • Client
  • C_REQUIREMENTTRACKINGPURREQ.PURREQNITEMCURRENCY == TCURC.WAERS
  • C_REQUIREMENTTRACKINGPURREQ.MANDT == TCURC.MANDT
Release Indicator
  • Release Indicator
  • Client
  • C_REQUIREMENTTRACKINGPURREQ.RELEASECODE == T161S.FRGKZ
  • C_REQUIREMENTTRACKINGPURREQ.MANDT == T161S.MANDT
Storage location
  • Storage location
  • Client
  • Plant
  • C_REQUIREMENTTRACKINGPURREQ.STORAGELOCATION == T001L.LGORT
  • C_REQUIREMENTTRACKINGPURREQ.MANDT == T001L.MANDT
  • C_REQUIREMENTTRACKINGPURREQ.PLANT == T001L.WERKS
Desired Vendor
  • Desired Vendor
  • Client
  • C_REQUIREMENTTRACKINGPURREQ.SUPPLIER == LFA1.LIFNR
  • C_REQUIREMENTTRACKINGPURREQ.MANDT == LFA1.MANDT