C_PurchaseReqnItem

Purchase Reqn Consumption Item View | view: CPURREQNITM | TRAN | Extraction: Not supported | Component: Purchase Requisitions
Tables used: MMDOC_EXT_LINKS, EBAN_TECH, FMIOI, EBAN, MMPUR_REQ_REWORK, ADCP, ADRC, USR21, T005, KNA1, FM01, T001W, WSI_DESCRIPTION, WSI_ENTITY, T024, T163Y, LFA1, T001K, ADRP, BUT000, BUT0ID, TB039A, TB003, BUT100, MMPUR_C_BE_SYREG, MMPUROCI_DETAILS, MMPUR_CAT_ATTRB, BPU_ROLECAT_WHL, 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
ExpectedOverallLimitAmount Expected Value of Overall Limit
OverallLimitAmount Overall Limit
💲 Currency Key (PurReqnLmtConsumptionCurrency):
PurReqnLimitConsumptionAmt Consumption Value for Limit Items
💲 Currency Key (Currency):
ItemNetAmount null
Column Name Description
📏 Purchase requisition unit of measure (ItemUoM):
RequestedQuantity Purchase requisition quantity
OrderedQuantity Quantity ordered against this purchase requisition
OpenQuantity null
Column Name Description
PurchaseRequisitionReleaseDate Purchase Requisition Release Date
DeliveryDate Item delivery date
CreationDate Requisition (request) date
PurReqCreationDate Requisition (request) date
PerformancePeriodStartDate Start Date for Period of Performance
PerformancePeriodEndDate End Date for Period of Performance
Column Name Description
PurReqnReleaseStatus Requisition Processing State Show values
PurchasingDocumentSubtype Control indicator for purchasing document type Show values
PurchasingDocumentCategory Purchasing Document Category Show values
SourceOfSupplyIsAssigned Assigned Source of Supply Show values
ProcessingStatus Processing status of purchase requisition Show values
MultipleAcctAssgmtDistribution Distribution Indicator for Multiple Account Assignment Show values
PartialInvoiceDistribution Partial invoice indicator Show values
PurReqnSourceOfSupplyType Purchasing Document Category Show values
ConsumptionPosting Consumption posting Show values
PurReqnOrigin Creation indicator (purchase requisition/schedule lines) Show values
IsClosed Purchase requisition closed Show values
ReleaseIsNotCompleted Release Not Yet Completely Effected Show values
GoodsReceiptIsExpected Goods Receipt Indicator Show values
InvoiceIsExpected Invoice receipt indicator Show values
GoodsReceiptIsNonValuated Goods Receipt, Non-Valuated Show values
PurchaseRequisitionIsFixed Purchase requisition is fixed Show values
PurgIsWrkflwScenActvForDocType Checkbox Show values
IsPurReqnOvrlRel Overall release of purchase requisitions Show values
PurReqnIsApplicableForRework PR Rework Indicator Show values
FundMgmtIsActive Truth Value: True/False Show values
PurReqnHasDelegateApproval Boolean Variable (X = True, - = False, Space = Unknown) Show values
Column Name Description Domain name
PurchaseRequisitionItemForEdit Item number of purchase requisition BNFPO
ExternalApprovalStatus External Processing Status
PurgDocItemCategoryName Text for Item Category TEXT20
PurchaseRequisitionItemText Short Text TEXT40
PurReqnPriceQuantity Price unit DEC5
MaterialGoodsReceiptDuration Goods receipt processing time in days DEC3
SupplyingPlant Supplying (issuing) plant in case of stock transport order WERKS
IsDeleted Deletion Indicator in Purchasing Document ELOEK
RequisitionerName Name of requisitioner/requester AFNAM
PurReqnSSPRequestor Requestor
PersonFullName Full Name of Person TEXT80
CreatedByUser Name of Person Responsible for Creating the Object USNAM
UserDescription User Description SUIDTECHDESC
DeliveryAddressID Address ADRNR
MaterialPlannedDeliveryDurn Planned Delivery Time in Days DEC3
IsPurReqnBlocked Purchase Requisition Blocked
ServicePerformer Service Performer BU_PARTNER
ProductType Product Type Group CHAR2
PurchaseRequisitionStatus Release State FRGZU
ReleaseStrategy Release strategy in the purchase requisition FRGST
SupplierMaterialNumber Material Number Used by Supplier IDNEX
Batch Batch Number CHARG
MaterialRevisionLevel Revision Level REVLV
MinRemainingShelfLife Minimum Remaining Shelf Life DEC4
PurchaseOrderPriceType Use Requisition Price in Purchase Order
PurchaseOrderPriceTypeDesc Short Text for Fixed Values DDTEXT
RequirementTracking Requirement Tracking Number CHAR10
TaxCode Tax on sales/purchases code
PurReqnCatalog Technical Key of a Web Service (for Example - a Catalog) BBP_WS_SERVICE_ID
OpnCtlgWebServiceName Description for a Web Service CHAR60K
PurReqnCatalogItem Catalog Item Id
PurReqnCrossCatalogItem Catalog Item Key
PurchaseReqnItemUniqueID Key to identify purchase requisition item MM_PUR_PR_ITEM_KEY
WorkflowScenarioDefinition Number of workflow definition SWD_WFDIDS
PhoneNumber Telephone no.: dialling code+number CHAR30
FaxNumber Fax number of purchasing (buyer) group
PurReqnApproverCommentText Note Text
PurReqnReworkCommentText Note Text
Fund Fund BP_GEBER
BudgetPeriod Budget Period FM_BUDGET_PERIOD
EarmarkedFundsDocument Document Number for Earmarked Funds KBLNR
FundsCenter Funds Center FISTL
CommitmentItem Commitment Item FIPOS
EarmarkedFundsDocumentItem Earmarked Funds: Document Item KBLPOS
GrantID Grant GM_GRANT_NBR
FunctionalArea Functional Area FKBER
GLAccount G/L Account Number SAKNR
CostCenter Cost Center KOSTL
WBSElement Work Breakdown Structure Element (WBS Element) PS_POSNR
FundedProgram null
IsOutline Is Outline
PurchasingParentItem Parent Item No BNFPO
PurgConfigurableItemNumber Hierarchy Number EXLIN
HierarchyNode Hierarchy node RSCHAVLEXT
HierarchyParentNode Hierarchy node RSCHAVLEXT
HierarchyLevel null
HierarchyNodeSubTreeSize null
HierarchyDrillState null
HierarchyNodeOrdinalNumber null
Master Data Relations Join Conditions
Account Assignment Category
  • Account Assignment Category
  • Client
  • C_PURCHASEREQNITEM.ACCOUNTASSIGNMENTCATEGORY == T163K.KNTTP
  • C_PURCHASEREQNITEM.MANDT == T163K.MANDT
Purchase requisition unit of measure
  • Purchase requisition unit of measure
  • Purchase requisition unit of measure
  • Client
  • C_PURCHASEREQNITEM.ITEMUOM == T006.MSEHI
  • C_PURCHASEREQNITEM.BASEUNIT == T006.MSEHI
  • C_PURCHASEREQNITEM.MANDT == T006.MANDT
Currency Key
  • Currency Key
  • Currency Key
  • Currency Key
  • Client
  • C_PURCHASEREQNITEM.PURREQNLMTCONSUMPTIONCURRENCY == TCURC.WAERS
  • C_PURCHASEREQNITEM.CURRENCY == TCURC.WAERS
  • C_PURCHASEREQNITEM.PURREQNITEMCURRENCY == TCURC.WAERS
  • C_PURCHASEREQNITEM.MANDT == TCURC.MANDT
Fixed Vendor
  • Fixed Vendor
  • Client
  • C_PURCHASEREQNITEM.FIXEDSUPPLIER == LFA1.LIFNR
  • C_PURCHASEREQNITEM.MANDT == LFA1.MANDT
Number of delivery address
  • ?
  • ?
  • Number of delivery address
  • Client
  • C_PURCHASEREQNITEM.[column in domain "AD_NATION"] == ADRC.NATION
  • C_PURCHASEREQNITEM.[column in domain "AD_DATE_FR"] == ADRC.DATE_FROM
  • C_PURCHASEREQNITEM.ITEMDELIVERYADDRESSID == ADRC.ADDRNUMBER
  • C_PURCHASEREQNITEM.MANDT == ADRC.CLIENT
Purchase requisition unit of measure
  • Purchase requisition unit of measure
  • Purchase requisition unit of measure
  • Client
  • C_PURCHASEREQNITEM.ITEMUOM == T006.MSEHI
  • C_PURCHASEREQNITEM.BASEUNIT == T006.MSEHI
  • C_PURCHASEREQNITEM.MANDT == T006.MANDT
Language Key C_PURCHASEREQNITEM.LANGUAGE == T002.SPRAS
Link to Central Address Management
  • ?
  • ?
  • Manual address number in purchasing document item
  • Client
  • C_PURCHASEREQNITEM.[column in domain "AD_NATION"] == ADRC.NATION
  • C_PURCHASEREQNITEM.[column in domain "AD_DATE_FR"] == ADRC.DATE_FROM
  • C_PURCHASEREQNITEM.MANUALDELIVERYADDRESSID == ADRC.ADDRNUMBER
  • C_PURCHASEREQNITEM.MANDT == ADRC.CLIENT
Material Number
  • Material Number
  • Client
  • C_PURCHASEREQNITEM.MATERIAL == MARA.MATNR
  • C_PURCHASEREQNITEM.MANDT == MARA.MANDT
Material Group
  • Material Group
  • Client
  • C_PURCHASEREQNITEM.MATERIALGROUP == T023.MATKL
  • C_PURCHASEREQNITEM.MANDT == T023.MANDT
MRP Controller
  • MRP Controller
  • Plant
  • Client
  • C_PURCHASEREQNITEM.MRPCONTROLLER == T024D.DISPO
  • C_PURCHASEREQNITEM.PLANT == T024D.WERKS
  • C_PURCHASEREQNITEM.MANDT == T024D.MANDT
Plant
  • Plant
  • Client
  • C_PURCHASEREQNITEM.PLANT == T001W.WERKS
  • C_PURCHASEREQNITEM.MANDT == T001W.MANDT
Purchase Requisition Document Type
  • Purchase Requisition Document Type
  • Purchasing Document Category
  • Client
  • C_PURCHASEREQNITEM.PURCHASEREQUISITIONTYPE == T161.BSART
  • C_PURCHASEREQNITEM.PURCHASINGDOCUMENTCATEGORY == T161.BSTYP
  • C_PURCHASEREQNITEM.MANDT == T161.MANDT
Item category in purchasing document
  • Item category in purchasing document
  • Client
  • C_PURCHASEREQNITEM.PURCHASINGDOCUMENTITEMCATEGORY == T163.PSTYP
  • C_PURCHASEREQNITEM.MANDT == T163.MANDT
Purchasing Group
  • Purchasing Group
  • Client
  • C_PURCHASEREQNITEM.PURCHASINGGROUP == T024.EKGRP
  • C_PURCHASEREQNITEM.MANDT == T024.MANDT
Number of purchasing info record
  • Number of purchasing info record
  • Client
  • C_PURCHASEREQNITEM.PURCHASINGINFORECORD == EINA.INFNR
  • C_PURCHASEREQNITEM.MANDT == EINA.MANDT
Purchasing organization
  • Purchasing organization
  • Client
  • C_PURCHASEREQNITEM.PURCHASINGORGANIZATION == T024E.EKORG
  • C_PURCHASEREQNITEM.MANDT == T024E.MANDT
Currency Key
  • Currency Key
  • Currency Key
  • Currency Key
  • Client
  • C_PURCHASEREQNITEM.PURREQNLMTCONSUMPTIONCURRENCY == TCURC.WAERS
  • C_PURCHASEREQNITEM.CURRENCY == TCURC.WAERS
  • C_PURCHASEREQNITEM.PURREQNITEMCURRENCY == TCURC.WAERS
  • C_PURCHASEREQNITEM.MANDT == TCURC.MANDT
Currency Key
  • Currency Key
  • Currency Key
  • Currency Key
  • Client
  • C_PURCHASEREQNITEM.PURREQNLMTCONSUMPTIONCURRENCY == TCURC.WAERS
  • C_PURCHASEREQNITEM.CURRENCY == TCURC.WAERS
  • C_PURCHASEREQNITEM.PURREQNITEMCURRENCY == TCURC.WAERS
  • C_PURCHASEREQNITEM.MANDT == TCURC.MANDT
Release Indicator
  • Release Indicator
  • Client
  • C_PURCHASEREQNITEM.RELEASECODE == T161S.FRGKZ
  • C_PURCHASEREQNITEM.MANDT == T161S.MANDT
Storage location
  • Storage location
  • Plant
  • Client
  • C_PURCHASEREQNITEM.STORAGELOCATION == T001L.LGORT
  • C_PURCHASEREQNITEM.PLANT == T001L.WERKS
  • C_PURCHASEREQNITEM.MANDT == T001L.MANDT
Desired Vendor
  • Desired Vendor
  • Client
  • C_PURCHASEREQNITEM.SUPPLIER == LFA1.LIFNR
  • C_PURCHASEREQNITEM.MANDT == LFA1.MANDT
Procedure (Pricing, Output Control, Acct. Det., Costing,...)
  • ?
  • ?
  • Procedure (Pricing, Output Control, Acct. Det., Costing,...)
  • Client
  • C_PURCHASEREQNITEM.[column in domain "KVEWE"] == T683.KVEWE
  • C_PURCHASEREQNITEM.[column in domain "KAPPL"] == T683.KAPPL
  • C_PURCHASEREQNITEM.TAXCALCULATIONPROCEDURE == T683.KALSM
  • C_PURCHASEREQNITEM.MANDT == T683.MANDT
Other Relations | to Master Data Relations ↑ Join Conditions
Category of delivery date
  • ?
  • Category of delivery date
  • Client
  • C_PURCHASEREQNITEM.[column in domain "SPRAS"] == TPRG.SPRAS
  • C_PURCHASEREQNITEM.DELIVDATECATEGORY == TPRG.PRGBZ
  • C_PURCHASEREQNITEM.MANDT == TPRG.MANDT