P_PurReqnOpenQuantCalc

P view for Open Quantity Calculation | view: PPROPENQUANCALC | Extraction: Not supported | Component: Purchase Requisitions
Tables used: SCAL_TT_DATE, MMDOC_EXT_LINKS, EBAN_TECH, FMIOI, EBAN, /SRMSMC/D_PUC_RT, /SRMSMC/D_PUCMG, EKKO, T001, TKA02, FM01, T001W, T161U, T161, T161T, T163, T163Y, T16FT, LFA1, USR21, T001K, MMPUR_C_BE_SYREG, 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
PurReqnTotalAmountInDspCrcy null
Column Name Description
📏 Purchase requisition unit of measure (BaseUnit):
RequestedQuantity Purchase requisition quantity
OrderedQuantity Quantity ordered against this purchase requisition
OpenQuantity null
Column Name Description
DeliveryDate Item delivery date
PurchaseRequisitionReleaseDate Purchase Requisition Release Date
PurReqCreationDate Requisition (request) date
CreationDate Requisition (request) date
PerformancePeriodStartDate Start Date for Period of Performance
PerformancePeriodEndDate End Date for Period of Performance
LastChangedDate Last Changed On
weekstart null
weekend null
secweekend null
fourthweekend null
weekday5 null
Column Name Description
PurchasingDocumentCategory Purchasing Document Category Show values
PurReqnReleaseStatus Requisition Processing State Show values
ProcessingStatus Processing status of purchase requisition Show values
PurReqnOrigin Creation indicator (purchase requisition/schedule lines) Show values
IsClosed Purchase requisition closed Show values
PurchasingDocumentSubtype Control indicator for purchasing document type Show values
IsPurReqnBlocked Purchase Requisition Blocked Show values
IsPurReqnCmplt Purchase Requisition not yet Complete Show values
ConsumptionPosting Consumption posting Show values
PurchasingIsBlocked Centrally imposed purchasing block Show values
PurchaseRequisitionIsFixed Purchase requisition is fixed Show values
GoodsReceiptIsExpected Goods Receipt Indicator Show values
InvoiceIsExpected Invoice receipt indicator Show values
GoodsReceiptIsNonValuated Goods Receipt, Non-Valuated Show values
SourceOfSupplyIsAssigned Assigned Source of Supply Show values
Column Name Description Domain name
PurgCatUUID Purchasing Category UUID /BOBF/CONF_KEY
PurchasingCategory Purchasing Category ID /SRMSMC/OBJECT_ID
SupplyingPlant Supplying (issuing) plant in case of stock transport order WERKS
PurReqnPriceQuantity Price unit DEC5
PurgDocExternalItemCategory Item Category in Purchasing Document EPSTP
PurgDocItemCategoryName Text for Item Category TEXT20
RequirementTracking Requirement Tracking Number CHAR10
PurchaseRequisitionItemText Short Text TEXT40
SupplierName Name of Supplier TEXT80
PurchasingReleaseIndicatorDesc Description of release indicator TEXT30
PurReqnRequestor Requestor
RequisitionerName Name of requisitioner/requester AFNAM
Batch Batch Number CHARG
DomainText Short Text for Fixed Values DDTEXT
ReleaseStrategy Release strategy in the purchase requisition FRGST
PurchasingReleaseStrategyDesc Description of release strategy TEXT20
CreatedByUser Name of Person Responsible for Creating the Object USNAM
UserDescription User Description SUIDTECHDESC
IsDeleted Deletion Indicator in Purchasing Document ELOEK
CompanyCodeName Name of Company Code or Company TEXT25
PurchaseRequisitionStatus Release State FRGZU
PurchasingDocumentTypeName Short Description of Purchasing Document Type TEXT20
PurchasingIsBlockedForSupplier null
PurchasingDocumentStatus null
ProductType Product Type Group CHAR2
SupplierMaterialNumber Material Number Used by Supplier IDNEX
MaterialRevisionLevel Revision Level VDM_QM_REVLV
ServicePerformer Service Performer BU_PARTNER
MaterialPlannedDeliveryDurn Planned Delivery Time in Days DEC3
MaterialGoodsReceiptDuration Goods receipt processing time in days DEC3
SourceDocument null
PurchasingSourceType null
SupplyingPlantName Plant Name TEXT30
calweek null
weekday1 null
weekday2 null
weekday4 null
StockSegment Stock Segment SGT_SRCA
Master Data Relations Join Conditions
Account Assignment Category
  • Client
  • Account Assignment Category
  • P_PURREQNOPENQUANTCALC.MANDT == T163K.MANDT
  • P_PURREQNOPENQUANTCALC.ACCOUNTASSIGNMENTCATEGORY == T163K.KNTTP
Purchase requisition unit of measure
  • Client
  • Purchase requisition unit of measure
  • P_PURREQNOPENQUANTCALC.MANDT == T006.MANDT
  • P_PURREQNOPENQUANTCALC.BASEUNIT == T006.MSEHI
Company code
  • Client
  • Company Code
  • P_PURREQNOPENQUANTCALC.MANDT == T001.MANDT
  • P_PURREQNOPENQUANTCALC.COMPANYCODE == T001.BUKRS
Fixed Vendor
  • Fixed Vendor
  • Client
  • P_PURREQNOPENQUANTCALC.FIXEDSUPPLIER == LFA1.LIFNR
  • P_PURREQNOPENQUANTCALC.MANDT == LFA1.MANDT
Material Number
  • Client
  • Material Number
  • P_PURREQNOPENQUANTCALC.MANDT == MARA.MANDT
  • P_PURREQNOPENQUANTCALC.MATERIAL == MARA.MATNR
Material Group
  • Client
  • Material Group
  • P_PURREQNOPENQUANTCALC.MANDT == T023.MANDT
  • P_PURREQNOPENQUANTCALC.MATERIALGROUP == T023.MATKL
MRP Controller
  • Client
  • MRP Controller
  • Plant
  • P_PURREQNOPENQUANTCALC.MANDT == T024D.MANDT
  • P_PURREQNOPENQUANTCALC.MRPCONTROLLER == T024D.DISPO
  • P_PURREQNOPENQUANTCALC.PLANT == T024D.WERKS
Plant
  • Client
  • Plant
  • P_PURREQNOPENQUANTCALC.MANDT == T001W.MANDT
  • P_PURREQNOPENQUANTCALC.PLANT == T001W.WERKS
Purchase Requisition Document Type
  • Client
  • Purchase Requisition Document Type
  • Purchasing Document Category
  • P_PURREQNOPENQUANTCALC.MANDT == T161.MANDT
  • P_PURREQNOPENQUANTCALC.PURCHASEREQUISITIONTYPE == T161.BSART
  • P_PURREQNOPENQUANTCALC.PURCHASINGDOCUMENTCATEGORY == T161.BSTYP
Item category in purchasing document
  • Client
  • Item category in purchasing document
  • P_PURREQNOPENQUANTCALC.MANDT == T163.MANDT
  • P_PURREQNOPENQUANTCALC.PURCHASINGDOCUMENTITEMCATEGORY == T163.PSTYP
Purchasing Group
  • Client
  • Purchasing Group
  • P_PURREQNOPENQUANTCALC.MANDT == T024.MANDT
  • P_PURREQNOPENQUANTCALC.PURCHASINGGROUP == T024.EKGRP
Number of purchasing info record
  • Client
  • Number of purchasing info record
  • P_PURREQNOPENQUANTCALC.MANDT == EINA.MANDT
  • P_PURREQNOPENQUANTCALC.PURCHASINGINFORECORD == EINA.INFNR
Purchasing organization
  • Client
  • Purchasing organization
  • P_PURREQNOPENQUANTCALC.MANDT == T024E.MANDT
  • P_PURREQNOPENQUANTCALC.PURCHASINGORGANIZATION == T024E.EKORG
Currency Key
  • Client
  • Currency Key
  • P_PURREQNOPENQUANTCALC.MANDT == TCURC.MANDT
  • P_PURREQNOPENQUANTCALC.PURREQNITEMCURRENCY == TCURC.WAERS
Release Indicator
  • Client
  • Release Indicator
  • P_PURREQNOPENQUANTCALC.MANDT == T161S.MANDT
  • P_PURREQNOPENQUANTCALC.RELEASECODE == T161S.FRGKZ
Release group
  • Client
  • Release group
  • P_PURREQNOPENQUANTCALC.MANDT == T16FG.MANDT
  • P_PURREQNOPENQUANTCALC.RELEASEGROUP == T16FG.FRGGR
Storage location
  • Client
  • Storage location
  • Plant
  • P_PURREQNOPENQUANTCALC.MANDT == T001L.MANDT
  • P_PURREQNOPENQUANTCALC.STORAGELOCATION == T001L.LGORT
  • P_PURREQNOPENQUANTCALC.PLANT == T001L.WERKS
Desired Vendor
  • Client
  • Desired Vendor
  • P_PURREQNOPENQUANTCALC.MANDT == LFA1.MANDT
  • P_PURREQNOPENQUANTCALC.SUPPLIER == LFA1.LIFNR