I_Purchaserequisitionitem_Wd

Purchase Requisition Item BO view | view: IPURREQNITEMWD | Extraction: Not supported | Component: Purchase Requisitions
Tables used: MMPUR_CAT_ATMAIN, MMDOC_EXT_LINKS, EBAN_TECH, FMIOI, OCIITM_PROPS, MMPUR_CAT_LNGTXT, MMPUR_CAT_MGPTXT, MMPUR_CAT_PRCONV, EBAN, MMPUR_CAT_ATHTXT, MMPUR_CAT_ATTCHM, MMPUR_REQ_REWORK, ADCP, ADRC, ADR6, ADR2, MMPUR_CAT_ITM, USR21, T001, TKA02, FM01, T001W, T001K, LFA1, ADRP, BUT000, BUT0ID, TB039A, TB003, BUT100, MMPUR_C_BE_SYREG, MMPUR_CAT_CRCUST, BPU_ROLECAT_WHL, FINSC_FISC_DATE
Column Name Description
PurchaseRequisition Purchase requisition number
PurchaseRequisitionItem Item number of purchase requisition
Column Name Description
💲 Currency Key (Currency):
PurchaseRequisitionPrice Price in Purchase Requisition
TotalNetAmount null
ExpectedOverallLimitAmount Expected Value of Overall Limit
OverallLimitAmount Overall Limit
Column Name Description
📏 Purchase requisition unit of measure (BaseUnit):
RequestedQuantity Purchase requisition quantity
Column Name Description
DeliveryDate Item delivery date
PerformancePeriodStartDate Start Date for Period of Performance
PerformancePeriodEndDate End Date for Period of Performance
Column Name Description
SSPPurReqnItmIsInComposing SSP PR Item in Composing State Show values
ExternalApprovalStatus External Processing Status Show values
PurReqnIsValdInCntrlReqnProcg Is PR relevant for Central PR Processing Show values
PurReqnRejectionIsCancelled Cancellation Indicator for Rejected PR Show values
PurReqnReleaseStatus Requisition Processing State Show values
AddressType Purchase Requisition Address Type Show values
MultipleAcctAssgmtDistribution Distribution Indicator for Multiple Account Assignment Show values
ProcessingStatus Processing status of purchase requisition Show values
PurchaseOrderPriceType Use Requisition Price in Purchase Order Show values
FundMgmtIsActive Truth Value: True/False Show values
Column Name Description Domain name
NetPriceQuantity Price unit DEC5
PurchaseRequisitionItemText Short Text TEXT40
PurReqnSSPCatalog Technical Key of a Web Service (for Example - a Catalog) BBP_WS_SERVICE_ID
PurReqnSSPCatalogItem Catalog Item
PurReqnSSPCrossCatalogItem Catalog Item Key
IsDeleted Deletion Indicator in Purchasing Document ELOEK
Reservation Number of reservation/dependent requirements RSNUM
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
ExtSourceSystem Communication System ID
ExtPurchaseRequisitionType PR Document Type of Connected System BSART
ProcurementHubSourceSystem Connected System ID
SupplierMaterialNumber Material Number Used by Supplier IDNEX
StatusCriticality null
PurReqnItemLifeCycleStatus null
OpnCtlgMainImageURL Catalog Main Image URL
OpnCtlgHasPriceScale If price scale exist CHAR1
FullName Full name of a party (Bus. Partner, Org. Unit, Doc. address) TEXT80
CareOfName c/o name TEXT40
AddressStreetName Street TEXT60
AddressHouseNumber House Number TEXT10
AddressPostalCode City postal code CHAR10
AddressCityName City TEXT40
PhoneNumber1 Telephone no.: dialling code+number CHAR30
FaxNumber First Fax No.: Area Code + Number CHAR30
EmailAddress E-Mail Address AD_SMTPADR
ProductType Product Type Group CHAR2
ServicePerformer Service Performer BU_PARTNER
CommitmentItem Commitment Item FIPOS
FundsCenter Funds Center FISTL
Fund Fund BP_GEBER
GrantID Grant GM_GRANT_NBR
FunctionalArea Functional Area FKBER
EarmarkedFundsDocument Document Number for Earmarked Funds KBLNR
EarmarkedFundsDocumentItem Earmarked Funds: Document Item KBLPOS
BudgetPeriod Budget Period FM_BUDGET_PERIOD
FundedProgram null
CostCenter Cost Center KOSTL
WBSElement Work Breakdown Structure Element (WBS Element) PS_POSNR
GLAccount G/L Account Number SAKNR
TaxCode Tax on sales/purchases code MWSKZ
PurReqnSSPAuthor Author of Requisition UNAME
PurReqnSSPRequestor Requestor
SourcePurchaseRequisition Source Purchase Requisition BANFN
SourcePurchaseRequisitionItem Source Purchase Requisition Item BNFPO
PurReqnLifeCycleStatusName Short Text for Fixed Values DDTEXT
SupplierName Name of Supplier TEXT80
PurReqnReworkCommentText Note Text
Master Data Relations Join Conditions
Account Assignment Category
  • Account Assignment Category
  • Client
  • I_PURCHASEREQUISITIONITEM_WD.ACCOUNTASSIGNMENTCATEGORY == T163K.KNTTP
  • I_PURCHASEREQUISITIONITEM_WD.MANDT == T163K.MANDT
Country key
  • Client
  • Country/Region Key
  • I_PURCHASEREQUISITIONITEM_WD.MANDT == T005.MANDT
  • I_PURCHASEREQUISITIONITEM_WD.ADDRESSCOUNTRY == T005.LAND1
Region code
  • Client
  • Country/Region Key
  • Region (State, Province, County)
  • I_PURCHASEREQUISITIONITEM_WD.MANDT == T005S.MANDT
  • I_PURCHASEREQUISITIONITEM_WD.ADDRESSCOUNTRY == T005S.LAND1
  • I_PURCHASEREQUISITIONITEM_WD.ADDRESSREGION == T005S.BLAND
Purchase requisition unit of measure
  • Client
  • Purchase requisition unit of measure
  • I_PURCHASEREQUISITIONITEM_WD.MANDT == T006.MANDT
  • I_PURCHASEREQUISITIONITEM_WD.BASEUNIT == T006.MSEHI
Address key assignment to users
  • User ID
  • Client
  • I_PURCHASEREQUISITIONITEM_WD.BUSINESSUSER == USR02.BNAME
  • I_PURCHASEREQUISITIONITEM_WD.MANDT == USR02.MANDT
Company code
  • Company Code
  • Client
  • I_PURCHASEREQUISITIONITEM_WD.COMPANYCODE == T001.BUKRS
  • I_PURCHASEREQUISITIONITEM_WD.MANDT == T001.MANDT
Currency Key
  • Currency Key
  • Currency Key
  • Client
  • I_PURCHASEREQUISITIONITEM_WD.CURRENCY == TCURC.WAERS
  • I_PURCHASEREQUISITIONITEM_WD.PURREQNITEMCURRENCY == TCURC.WAERS
  • I_PURCHASEREQUISITIONITEM_WD.MANDT == TCURC.MANDT
Fixed Vendor
  • Fixed Vendor
  • Client
  • I_PURCHASEREQUISITIONITEM_WD.FIXEDSUPPLIER == LFA1.LIFNR
  • I_PURCHASEREQUISITIONITEM_WD.MANDT == LFA1.MANDT
Form-of-Address Key
  • Form-of-Address Key
  • Client
  • I_PURCHASEREQUISITIONITEM_WD.FORMOFADDRESS == TSAD3.TITLE
  • I_PURCHASEREQUISITIONITEM_WD.MANDT == TSAD3.CLIENT
Language Key I_PURCHASEREQUISITIONITEM_WD.LANGUAGE == T002.SPRAS
Link to Central Address Management
  • Manual address number in purchasing document item
  • ?
  • ?
  • Client
  • I_PURCHASEREQUISITIONITEM_WD.MANUALDELIVERYADDRESSID == ADRC.ADDRNUMBER
  • I_PURCHASEREQUISITIONITEM_WD.[column in domain "AD_NATION"] == ADRC.NATION
  • I_PURCHASEREQUISITIONITEM_WD.[column in domain "AD_DATE_FR"] == ADRC.DATE_FROM
  • I_PURCHASEREQUISITIONITEM_WD.MANDT == ADRC.CLIENT
Material Number
  • Material Number
  • Client
  • I_PURCHASEREQUISITIONITEM_WD.MATERIAL == MARA.MATNR
  • I_PURCHASEREQUISITIONITEM_WD.MANDT == MARA.MANDT
Material Group
  • Material Group
  • Client
  • I_PURCHASEREQUISITIONITEM_WD.MATERIALGROUP == T023.MATKL
  • I_PURCHASEREQUISITIONITEM_WD.MANDT == T023.MANDT
Plant
  • Plant
  • Client
  • I_PURCHASEREQUISITIONITEM_WD.PLANT == T001W.WERKS
  • I_PURCHASEREQUISITIONITEM_WD.MANDT == T001W.MANDT
Purchase Requisition Document Type
  • Purchase Requisition Document Type
  • ?
  • Client
  • I_PURCHASEREQUISITIONITEM_WD.PURCHASEREQUISITIONTYPE == T161.BSART
  • I_PURCHASEREQUISITIONITEM_WD.[column in domain "BSTYP"] == T161.BSTYP
  • I_PURCHASEREQUISITIONITEM_WD.MANDT == T161.MANDT
Item category in purchasing document
  • Item category in purchasing document
  • Client
  • I_PURCHASEREQUISITIONITEM_WD.PURCHASINGDOCUMENTITEMCATEGORY == T163.PSTYP
  • I_PURCHASEREQUISITIONITEM_WD.MANDT == T163.MANDT
Purchasing Group
  • Purchasing Group
  • Client
  • I_PURCHASEREQUISITIONITEM_WD.PURCHASINGGROUP == T024.EKGRP
  • I_PURCHASEREQUISITIONITEM_WD.MANDT == T024.MANDT
Number of purchasing info record
  • Number of purchasing info record
  • Client
  • I_PURCHASEREQUISITIONITEM_WD.PURCHASINGINFORECORD == EINA.INFNR
  • I_PURCHASEREQUISITIONITEM_WD.MANDT == EINA.MANDT
Purchasing organization
  • Purchasing organization
  • Client
  • I_PURCHASEREQUISITIONITEM_WD.PURCHASINGORGANIZATION == T024E.EKORG
  • I_PURCHASEREQUISITIONITEM_WD.MANDT == T024E.MANDT
Currency Key
  • Currency Key
  • Currency Key
  • Client
  • I_PURCHASEREQUISITIONITEM_WD.CURRENCY == TCURC.WAERS
  • I_PURCHASEREQUISITIONITEM_WD.PURREQNITEMCURRENCY == TCURC.WAERS
  • I_PURCHASEREQUISITIONITEM_WD.MANDT == TCURC.MANDT
Desired Vendor
  • Desired Vendor
  • Client
  • I_PURCHASEREQUISITIONITEM_WD.SUPPLIER == LFA1.LIFNR
  • I_PURCHASEREQUISITIONITEM_WD.MANDT == LFA1.MANDT