C_PurchaseRequisitionItmDtls

Purchase requisition item details | view: C_MM_PR_LIST | TRAN | Extraction: Not supported | Component: Purchase Requisitions
Tables used: MMDOC_EXT_LINKS, EBAN_TECH, FMIOI, EBAN, /SRMSMC/D_PUC_RT, /SRMSMC/D_PUCMG, T163I, T163K, ADCP, ADRC, KNA1, FM01, T023T, MAKT, T001W, T024, T024E, LFA1, USR21, 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
PurReqnPrice null
Column Name Description
📏 Purchase requisition unit of measure (BaseUnit):
RequestedQuantity Purchase requisition quantity
OrderedQuantity Quantity ordered against this purchase requisition
Column Name Description
FirstDeliveryDate Item delivery date
DeliveryDate Item delivery date
PurReqCreationDate Requisition (request) date
DueDays null
PurchaseRequisitionReleaseDate Purchase Requisition Release Date
PerformancePeriodStartDate Start Date for Period of Performance
PerformancePeriodEndDate End Date for Period of Performance
Column Name Description
IsPurReqnCmplt Purchase Requisition not yet Complete Show values
PurReqnCmpltnsCat Category of Incompleteness Show values
PurchasingDocumentSubtype Control indicator for purchasing document type Show values
PurReqnHasAdvncdUsrInterface Boolean Variable (X = True, - = False, Space = Unknown) Show values
PurReqnOrigin Creation indicator (purchase requisition/schedule lines) Show values
Column Name Description Domain name
FormattedPurRequisitionItem null
PurchaseRequisitionItemText Short Text
PurchasingDocumentCategory Purchasing Document Category
PurReqnPriceQuantity Price unit
MaterialGoodsReceiptDuration Goods receipt processing time in days
SourceOfSupplyIsAssigned Assigned Source of Supply
SupplyingPlant Supplying (issuing) plant in case of stock transport order
ProcessingStatus Processing status of purchase requisition
IsDeleted Deletion Indicator in Purchasing Document
RequisitionerName Name of requisitioner/requester
CreatedByUser Name of Person Responsible for Creating the Object
PurReqnReleaseStatus Requisition Processing State
MaterialPlannedDeliveryDurn Planned Delivery Time in Days
PurReqnSourceOfSupplyType Purchasing Document Category
PurchasingOrganizationName Purchasing Organization Name
PurchasingGroupName Purchasing Group Name
PurchasingGroupPhoneNumber Telephone number of purchasing group (buyer group)
PhoneNumber Telephone no.: dialling code+number
PhoneNumberExtension Telephone no.: Extension
EmailAddress E-Mail Address
SupplierName Name 1
SupplierSearchText Sort field
MaterialGroupName Product Group Description
MaterialName Material Description
SupplyingPlantName Plant Name
AcctAssignmentCategoryName Account Assignment Category Description
ConsumptionPosting Consumption posting
ProductType Product Type Group CHAR2
FullName Full name of a party (Bus. Partner, Org. Unit, Doc. address)
HouseNumber House Number
District District
NumberOfRecords null
NumberOfInfoRecords null
DeliveryAddressID Address ADRNR
PurReqnSourceOfSupplyCount null
ProcessingStatusName Short Text for Fixed Values
CityName City TEXT40
PurReqnHasFllwOnDoc null
PurchasingCategory Purchasing Category ID /SRMSMC/OBJECT_ID
PurgCatName Name of Purchasing Category /SRMSMC/MEDIUM_NAME
ExtCompanyCodeForPurg Company Code of External System BUKRS
Master Data Relations Join Conditions
Account Assignment Category
  • Account Assignment Category
  • Client
  • C_PURCHASEREQUISITIONITMDTLS.ACCOUNTASSIGNMENTCATEGORY == T163K.KNTTP
  • C_PURCHASEREQUISITIONITMDTLS.MANDT == T163K.MANDT
Purchase requisition unit of measure
  • Client
  • Purchase requisition unit of measure
  • C_PURCHASEREQUISITIONITMDTLS.MANDT == T006.MANDT
  • C_PURCHASEREQUISITIONITMDTLS.BASEUNIT == T006.MSEHI
Company code
  • Company Code
  • Client
  • C_PURCHASEREQUISITIONITMDTLS.COMPANYCODE == T001.BUKRS
  • C_PURCHASEREQUISITIONITMDTLS.MANDT == T001.MANDT
Country key
  • Client
  • Country/Region Key
  • C_PURCHASEREQUISITIONITMDTLS.MANDT == T005.MANDT
  • C_PURCHASEREQUISITIONITMDTLS.COUNTRY == T005.LAND1
Fixed Vendor
  • Fixed Vendor
  • Client
  • C_PURCHASEREQUISITIONITMDTLS.FIXEDSUPPLIER == LFA1.LIFNR
  • C_PURCHASEREQUISITIONITMDTLS.MANDT == LFA1.MANDT
Language key C_PURCHASEREQUISITIONITMDTLS.LANGUAGE == T002.SPRAS
Link to Central Address Management
  • ?
  • ?
  • Client
  • Manual address number in purchasing document item
  • C_PURCHASEREQUISITIONITMDTLS.[column in domain "AD_NATION"] == ADRC.NATION
  • C_PURCHASEREQUISITIONITMDTLS.[column in domain "AD_DATE_FR"] == ADRC.DATE_FROM
  • C_PURCHASEREQUISITIONITMDTLS.MANDT == ADRC.CLIENT
  • C_PURCHASEREQUISITIONITMDTLS.MANUALDELIVERYADDRESSID == ADRC.ADDRNUMBER
Material Number
  • Client
  • Material Number
  • C_PURCHASEREQUISITIONITMDTLS.MANDT == MARA.MANDT
  • C_PURCHASEREQUISITIONITMDTLS.MATERIAL == MARA.MATNR
Material Group
  • Material Group
  • Client
  • C_PURCHASEREQUISITIONITMDTLS.MATERIALGROUP == T023.MATKL
  • C_PURCHASEREQUISITIONITMDTLS.MANDT == T023.MANDT
Purchase Order Unit of Measure
  • Purchase Order Unit of Measure
  • Client
  • C_PURCHASEREQUISITIONITMDTLS.MATERIALORDERUNIT == T006.MSEHI
  • C_PURCHASEREQUISITIONITMDTLS.MANDT == T006.MANDT
Plant
  • Plant
  • Client
  • C_PURCHASEREQUISITIONITMDTLS.PLANT == T001W.WERKS
  • C_PURCHASEREQUISITIONITMDTLS.MANDT == T001W.MANDT
Purchase Requisition Document Type
  • Purchase Requisition Document Type
  • Purchasing Document Category
  • Client
  • C_PURCHASEREQUISITIONITMDTLS.PURCHASEREQUISITIONTYPE == T161.BSART
  • C_PURCHASEREQUISITIONITMDTLS.PURCHASINGDOCUMENTCATEGORY == T161.BSTYP
  • C_PURCHASEREQUISITIONITMDTLS.MANDT == T161.MANDT
Item category in purchasing document
  • Item category in purchasing document
  • Client
  • C_PURCHASEREQUISITIONITMDTLS.PURCHASINGDOCUMENTITEMCATEGORY == T163.PSTYP
  • C_PURCHASEREQUISITIONITMDTLS.MANDT == T163.MANDT
Purchasing Group
  • Purchasing Group
  • Client
  • C_PURCHASEREQUISITIONITMDTLS.PURCHASINGGROUP == T024.EKGRP
  • C_PURCHASEREQUISITIONITMDTLS.MANDT == T024.MANDT
Number of purchasing info record
  • Number of purchasing info record
  • Client
  • C_PURCHASEREQUISITIONITMDTLS.PURCHASINGINFORECORD == EINA.INFNR
  • C_PURCHASEREQUISITIONITMDTLS.MANDT == EINA.MANDT
Purchasing organization
  • Purchasing organization
  • Client
  • C_PURCHASEREQUISITIONITMDTLS.PURCHASINGORGANIZATION == T024E.EKORG
  • C_PURCHASEREQUISITIONITMDTLS.MANDT == T024E.MANDT
Currency Key
  • Currency Key
  • Client
  • C_PURCHASEREQUISITIONITMDTLS.PURREQNITEMCURRENCY == TCURC.WAERS
  • C_PURCHASEREQUISITIONITMDTLS.MANDT == TCURC.MANDT
Release Indicator
  • Release Indicator
  • Client
  • C_PURCHASEREQUISITIONITMDTLS.RELEASECODE == T161S.FRGKZ
  • C_PURCHASEREQUISITIONITMDTLS.MANDT == T161S.MANDT
Desired Vendor
  • Desired Vendor
  • Client
  • C_PURCHASEREQUISITIONITMDTLS.SUPPLIER == LFA1.LIFNR
  • C_PURCHASEREQUISITIONITMDTLS.MANDT == LFA1.MANDT