A_PurchaseRequisitionItem

Item | view: APURREQITM | Extraction: Not supported | Component: Purchase Requisitions
Tables used: MMDOC_EXT_LINKS, EBAN_TECH, FMIOI, EBAN, ADCP, ADRC, ADRP, ADCP, ADRC, BUT000, KNA1, CVI_CUST_LINK, FM01, T001W, LFA1, T001K, MMPUR_C_BE_SYREG, TWLAD, 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
ItemNetAmount null
ExpectedOverallLimitAmount Expected Value of Overall Limit
OverallLimitAmount Overall Limit
Column Name Description
📏 Purchase requisition unit of measure (BaseUnit):
RequestedQuantity Purchase requisition quantity
OrderedQuantity Quantity ordered against this purchase requisition
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
ExternalApprovalStatus External Processing Status Show values
MultipleAcctAssgmtDistribution Distribution Indicator for Multiple Account Assignment Show values
PurReqnSourceOfSupplyType Purchasing Document Category Show values
ConsumptionPosting Consumption posting Show values
PurReqnOrigin Creation indicator (purchase requisition/schedule lines) Show values
IsPurReqnBlocked Purchase Requisition Blocked Show values
IsClosed Purchase requisition closed Show values
ReleaseIsNotCompleted Release Not Yet Completely Effected Show values
PurchaseOrderPriceType Use Requisition Price in Purchase Order 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
PurReqnExternalSystemType Type of External System Show values
PurReqnProcessingType Processing State Show values
Column Name Description Domain name
PurchaseRequisitionItemText Short Text TEXT40
Material Material Number MATNR
PurReqnPriceQuantity Price unit DEC5
MaterialGoodsReceiptDuration Goods receipt processing time in days DEC3
PurchasingOrganization Purchasing organization EKORG
Plant Plant WERKS
CompanyCode Company Code of External System BUKRS
SupplyingPlant Supplying (issuing) plant in case of stock transport order WERKS
PurchasingInfoRecord Number of purchasing info record INFNR
Supplier Desired Vendor LIFNR
IsDeleted Deletion Indicator in Purchasing Document ELOEK
FixedSupplier Fixed Vendor LIFNR
RequisitionerName Name of requisitioner/requester AFNAM
CreatedByUser Name of Person Responsible for Creating the Object USNAM
DeliveryAddressID Address ADRNR
MaterialPlannedDeliveryDurn Planned Delivery Time in Days DEC3
PurReqnSSPRequestor Requestor
PurReqnSSPAuthor Author of Requisition UNAME
PurchaseContract Number of principal purchase agreement EBELN
PurchaseContractItem Item number of principal purchase agreement EBELP
PurReqnSSPCatalog Technical Key of a Web Service (for Example - a Catalog) BBP_WS_SERVICE_ID
PurReqnSSPCatalogItem Catalog Item Id
PurReqnSSPCrossCatalogItem Catalog Item Key
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
RequirementTracking Requirement Tracking Number CHAR10
TaxCode Tax on sales/purchases code MWSKZ
LastChangeDateTime UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) TZNTSTMPL
Reservation Number of reservation/dependent requirements RSNUM
PurReqnExternalReference Document Number of External Document ME_EXT_DOC_ID
PurReqnItemExternalReference Item Number of External Document ME_EXT_DOC_ITEM_ID
PurReqnExternalSystemId External System ID MMPUR_EXT_SYSTEM
PurReqnTypeExternalReference External Document Type ME_EXT_DOC_TYPE
PurReqnProcessingDateTime Timestamp TIMESTAMP
ExtMaterialForPurg Material of External System MATNR
ExtFixedSupplierForPurg Fixed Supplier of External System LIFNR
ExtDesiredSupplierForPurg Desired Supplier of External System LIFNR
ExtContractForPurg Contract of External System EBELN
ExtContractItemForPurg Contract Item of External System EBELP
ExtInfoRecordForPurg Info Record of External System INFNR
ExtPlantForPurg Plant of External System WERKS
ExtCompanyCodeForPurg Company Code of External System BUKRS
ExtPurgOrgForPurg Purchasing Organization EKORG
ProcurementHubSourceSystem Connected System ID
ProcmtHubBackendBusSyst Connected System TEXT60
SSPAuthorExternalBPIdnNumber BP ID of Author CHAR60
SSPReqrUserId Requestor User ID UNAME
StockSegment Stock Segment SGT_SRCA
RequirementSegment Requirement Segment SGT_SRCA
Master Data Relations Join Conditions
Account Assignment Category
  • Account Assignment Category
  • Client
  • A_PURCHASEREQUISITIONITEM.ACCOUNTASSIGNMENTCATEGORY == T163K.KNTTP
  • A_PURCHASEREQUISITIONITEM.MANDT == T163K.MANDT
Link to Central Address Management
  • Client
  • Manual address number in purchasing document item
  • Manual address number in purchasing document item
  • ?
  • ?
  • A_PURCHASEREQUISITIONITEM.MANDT == ADRC.CLIENT
  • A_PURCHASEREQUISITIONITEM.MANUALDELIVERYADDRESSID == ADRC.ADDRNUMBER
  • A_PURCHASEREQUISITIONITEM.ADDRESSID == ADRC.ADDRNUMBER
  • A_PURCHASEREQUISITIONITEM.[column in domain "AD_NATION"] == ADRC.NATION
  • A_PURCHASEREQUISITIONITEM.[column in domain "AD_DATE_FR"] == ADRC.DATE_FROM
Purchase requisition unit of measure
  • Purchase requisition unit of measure
  • Client
  • A_PURCHASEREQUISITIONITEM.BASEUNIT == T006.MSEHI
  • A_PURCHASEREQUISITIONITEM.MANDT == T006.MANDT
Number of delivery address
  • Number of delivery address
  • Client
  • ?
  • ?
  • A_PURCHASEREQUISITIONITEM.ITEMDELIVERYADDRESSID == ADRC.ADDRNUMBER
  • A_PURCHASEREQUISITIONITEM.MANDT == ADRC.CLIENT
  • A_PURCHASEREQUISITIONITEM.[column in domain "AD_NATION"] == ADRC.NATION
  • A_PURCHASEREQUISITIONITEM.[column in domain "AD_DATE_FR"] == ADRC.DATE_FROM
Language Key A_PURCHASEREQUISITIONITEM.LANGUAGE == T002.SPRAS
Link to Central Address Management
  • Client
  • Manual address number in purchasing document item
  • Manual address number in purchasing document item
  • ?
  • ?
  • A_PURCHASEREQUISITIONITEM.MANDT == ADRC.CLIENT
  • A_PURCHASEREQUISITIONITEM.MANUALDELIVERYADDRESSID == ADRC.ADDRNUMBER
  • A_PURCHASEREQUISITIONITEM.ADDRESSID == ADRC.ADDRNUMBER
  • A_PURCHASEREQUISITIONITEM.[column in domain "AD_NATION"] == ADRC.NATION
  • A_PURCHASEREQUISITIONITEM.[column in domain "AD_DATE_FR"] == ADRC.DATE_FROM
Material Group
  • Client
  • Material Group
  • A_PURCHASEREQUISITIONITEM.MANDT == T023.MANDT
  • A_PURCHASEREQUISITIONITEM.MATERIALGROUP == T023.MATKL
MRP Controller
  • Client
  • MRP Controller
  • ?
  • A_PURCHASEREQUISITIONITEM.MANDT == T024D.MANDT
  • A_PURCHASEREQUISITIONITEM.MRPCONTROLLER == T024D.DISPO
  • A_PURCHASEREQUISITIONITEM.[column in domain "WERKS_D"] == T024D.WERKS
Purchase Requisition Document Type
  • Client
  • Purchasing Document Category
  • Purchase Requisition Document Type
  • A_PURCHASEREQUISITIONITEM.MANDT == T161.MANDT
  • A_PURCHASEREQUISITIONITEM.PURCHASINGDOCUMENTCATEGORY == T161.BSTYP
  • A_PURCHASEREQUISITIONITEM.PURCHASEREQUISITIONTYPE == T161.BSART
Item category in purchasing document
  • Client
  • Item category in purchasing document
  • A_PURCHASEREQUISITIONITEM.MANDT == T163.MANDT
  • A_PURCHASEREQUISITIONITEM.PURCHASINGDOCUMENTITEMCATEGORY == T163.PSTYP
Purchasing Group
  • Client
  • Purchasing Group
  • A_PURCHASEREQUISITIONITEM.MANDT == T024.MANDT
  • A_PURCHASEREQUISITIONITEM.PURCHASINGGROUP == T024.EKGRP
Currency Key
  • Currency Key
  • Client
  • A_PURCHASEREQUISITIONITEM.PURREQNITEMCURRENCY == TCURC.WAERS
  • A_PURCHASEREQUISITIONITEM.MANDT == TCURC.MANDT
Release Indicator
  • Release Indicator
  • Client
  • A_PURCHASEREQUISITIONITEM.RELEASECODE == T161S.FRGKZ
  • A_PURCHASEREQUISITIONITEM.MANDT == T161S.MANDT
Storage location
  • Client
  • Storage location
  • ?
  • A_PURCHASEREQUISITIONITEM.MANDT == T001L.MANDT
  • A_PURCHASEREQUISITIONITEM.STORAGELOCATION == T001L.LGORT
  • A_PURCHASEREQUISITIONITEM.[column in domain "WERKS_D"] == T001L.WERKS
Other Relations | to Master Data Relations ↑ Join Conditions
Category of delivery date
  • Category of delivery date
  • Client
  • ?
  • A_PURCHASEREQUISITIONITEM.DELIVDATECATEGORY == TPRG.PRGBZ
  • A_PURCHASEREQUISITIONITEM.MANDT == TPRG.MANDT
  • A_PURCHASEREQUISITIONITEM.[column in domain "SPRAS"] == TPRG.SPRAS