C_Purchasereqitmdtlsext

Purchase Requisition Data | view: C_MM_PRLIST_EXT | TRAN | Extraction: Not supported | Component: Purchase Requisitions
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
DeliveryDate Item delivery date
FirstDeliveryDate Item delivery date
PurReqCreationDate Requisition (request) date
PerformancePeriodStartDate Start Date for Period of Performance
PerformancePeriodEndDate End Date for Period of Performance
DueDays null
PurchaseRequisitionReleaseDate Purchase Requisition Release Date
Column Name Description
PurReqnHasAdvncdUsrInterface Boolean Variable (X = True, - = False, Space = Unknown) 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
PurchasingDocumentSubtype Control indicator for purchasing document type
PurReqnSourceOfSupplyCount null
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
MaterialName Material Description
SupplyingPlantName Plant Name
AcctAssignmentCategoryName Account Assignment Category Description
ConsumptionPosting Consumption posting
FullName Full name of a party (Bus. Partner, Org. Unit, Doc. address)
HouseNumber House Number
District District
NumberOfRecords null
NumberOfInfoRecords null
CityName City TEXT40
ProcessingStatusName Short Text for Fixed Values DDTEXT
PurchasingCategory Purchasing Category ID /SRMSMC/OBJECT_ID
PurgCatName Name of Purchasing Category /SRMSMC/MEDIUM_NAME
ProductType Product Type Group CHAR2
MaterialGroupName Product Group Description TEXT20
PurReqnHasFllwOnDoc null
PurReqnOrigin Creation indicator (purchase requisition/schedule lines)
IsPurReqnCmplt Purchase Requisition not yet Complete
PurReqnCmpltnsCat Category of Incompleteness
PurgDocExternalItemCategory Item Category in Purchasing Document EPSTP
Master Data Relations Join Conditions
Account Assignment Category
  • Client
  • Account Assignment Category
  • C_PURCHASEREQITMDTLSEXT.MANDT == T163K.MANDT
  • C_PURCHASEREQITMDTLSEXT.ACCOUNTASSIGNMENTCATEGORY == T163K.KNTTP
Purchase requisition unit of measure
  • Client
  • Purchase requisition unit of measure
  • C_PURCHASEREQITMDTLSEXT.MANDT == T006.MANDT
  • C_PURCHASEREQITMDTLSEXT.BASEUNIT == T006.MSEHI
Country key
  • Client
  • Country/Region Key
  • C_PURCHASEREQITMDTLSEXT.MANDT == T005.MANDT
  • C_PURCHASEREQITMDTLSEXT.COUNTRY == T005.LAND1
Fixed Vendor
  • Client
  • Fixed Vendor
  • C_PURCHASEREQITMDTLSEXT.MANDT == LFA1.MANDT
  • C_PURCHASEREQITMDTLSEXT.FIXEDSUPPLIER == LFA1.LIFNR
Language key C_PURCHASEREQITMDTLSEXT.LANGUAGE == T002.SPRAS
Link to Central Address Management
  • Manual address number in purchasing document item
  • Client
  • ?
  • ?
  • C_PURCHASEREQITMDTLSEXT.MANUALDELIVERYADDRESSID == ADRC.ADDRNUMBER
  • C_PURCHASEREQITMDTLSEXT.MANDT == ADRC.CLIENT
  • C_PURCHASEREQITMDTLSEXT.[column in domain "AD_NATION"] == ADRC.NATION
  • C_PURCHASEREQITMDTLSEXT.[column in domain "AD_DATE_FR"] == ADRC.DATE_FROM
Material Number
  • Client
  • Material Number
  • C_PURCHASEREQITMDTLSEXT.MANDT == MARA.MANDT
  • C_PURCHASEREQITMDTLSEXT.MATERIAL == MARA.MATNR
Material Group
  • Client
  • Material Group
  • C_PURCHASEREQITMDTLSEXT.MANDT == T023.MANDT
  • C_PURCHASEREQITMDTLSEXT.MATERIALGROUP == T023.MATKL
Purchase Order Unit of Measure
  • Client
  • Purchase Order Unit of Measure
  • C_PURCHASEREQITMDTLSEXT.MANDT == T006.MANDT
  • C_PURCHASEREQITMDTLSEXT.MATERIALORDERUNIT == T006.MSEHI
Plant
  • Client
  • Plant
  • C_PURCHASEREQITMDTLSEXT.MANDT == T001W.MANDT
  • C_PURCHASEREQITMDTLSEXT.PLANT == T001W.WERKS
Purchase Requisition Document Type
  • Client
  • Purchasing Document Category
  • Purchase Requisition Document Type
  • C_PURCHASEREQITMDTLSEXT.MANDT == T161.MANDT
  • C_PURCHASEREQITMDTLSEXT.PURCHASINGDOCUMENTCATEGORY == T161.BSTYP
  • C_PURCHASEREQITMDTLSEXT.PURCHASEREQUISITIONTYPE == T161.BSART
Item category in purchasing document
  • Client
  • Item category in purchasing document
  • C_PURCHASEREQITMDTLSEXT.MANDT == T163.MANDT
  • C_PURCHASEREQITMDTLSEXT.PURCHASINGDOCUMENTITEMCATEGORY == T163.PSTYP
Purchasing Group
  • Purchasing Group
  • Client
  • C_PURCHASEREQITMDTLSEXT.PURCHASINGGROUP == T024.EKGRP
  • C_PURCHASEREQITMDTLSEXT.MANDT == T024.MANDT
Number of purchasing info record
  • Number of purchasing info record
  • Client
  • C_PURCHASEREQITMDTLSEXT.PURCHASINGINFORECORD == EINA.INFNR
  • C_PURCHASEREQITMDTLSEXT.MANDT == EINA.MANDT
Purchasing organization
  • Client
  • Purchasing organization
  • C_PURCHASEREQITMDTLSEXT.MANDT == T024E.MANDT
  • C_PURCHASEREQITMDTLSEXT.PURCHASINGORGANIZATION == T024E.EKORG
Currency Key
  • Client
  • Currency Key
  • C_PURCHASEREQITMDTLSEXT.MANDT == TCURC.MANDT
  • C_PURCHASEREQITMDTLSEXT.PURREQNITEMCURRENCY == TCURC.WAERS
Release Indicator
  • Client
  • Release Indicator
  • C_PURCHASEREQITMDTLSEXT.MANDT == T161S.MANDT
  • C_PURCHASEREQITMDTLSEXT.RELEASECODE == T161S.FRGKZ
Desired Vendor
  • Desired Vendor
  • Client
  • C_PURCHASEREQITMDTLSEXT.SUPPLIER == LFA1.LIFNR
  • C_PURCHASEREQITMDTLSEXT.MANDT == LFA1.MANDT