P_PurReqItemAcctmntr

PR Items by Account Assignment | view: PPREQITMACCMNTR | TRAN | Extraction: Not supported | Component: Purchase Requisitions
Tables used: MMDOC_EXT_LINKS, EBAN_TECH, FMIOI, AFKO, EBAN, /SRMSMC/D_PUC_RT, /SRMSMC/D_PUCMG, EKKO, EBKN, T163I, T163K, TGSB, TGSBT, T001, TKA02, TKA01, FM01, MARA, T023, T023T, MAKT, T024D, AUFK, T001W, T161U, T161, T161T, T024, EINA, T024E, T163, T163Y, T000, T001L, LFA1, USR21, T001K, ANLA, FAAT_MD, FAAT_MD_ROOT, T001, ANLA, FAAT_MD_LD, FINSC_LEDGER, MMPUR_C_BE_SYREG, FINSC_FISC_DATE
Column Name Description
PurchaseRequisition Purchase Requisition Number
PurchaseRequisitionItem FK Item number of purchase requisition
PurchaseReqnAcctAssgmtNumber Serial number for PReq account assignment segment
Column Name Description
💲 Currency Key (PurReqnItemCurrency):
PurchaseRequisitionPrice Price in Purchase Requisition
💲 Currency Key (DisplayCurrency):
PurReqnNetAmount Net Order Value in PO Currency
Column Name Description
📏 Purchase requisition unit of measure (BaseUnit):
OrderedQuantity Quantity ordered against this purchase requisition
RequestedQuantity Purchase requisition quantity
MaterialShortageQuantity Shortage (stock undercoverage) quantity
Quantity Purchase requisition quantity
Column Name Description
ValidityDate null
DeliveryDate Item delivery date
PurchaseRequisitionReleaseDate Purchase Requisition Release Date
CreationDate Requisition (request) date
PurReqCreationDate Requisition (request) date
PurchaseOrderDate Purchase Order Date
Column Name Description
PurReqnOrigin Creation indicator (purchase requisition/schedule lines) Show values
IsPurReqnCmplt Purchase Requisition not yet Complete Show values
PurReqnCmpltnsCat Category of Incompleteness Show values
PurchasingDocumentCategory Purchasing Document Category Show values
PurchasingDocumentSubtype Control indicator for purchasing document type Show values
ProcessingStatus Processing status of purchase requisition Show values
ConsumptionPosting Consumption posting Show values
MultipleAcctAssgmtDistribution Distribution Indicator for Multiple Account Assignment Show values
IsClosed Boolean Variable (X = True, - = False, Space = Unknown) Show values
PurReqnReleaseStatus Requisition Processing State Show values
PurchasingIsBlocked Centrally imposed purchasing block Show values
Column Name Description Domain name
PurchasingDocumentTypeName Short Description of Purchasing Document Type TEXT20
PurReqnRequestor Requestor
RequirementTracking Requirement Tracking Number CHAR10
PurReqnPriceQuantity Price unit DEC5
PurchasingReleaseIndicatorDesc Description of release indicator TEXT30
DomainText Short Text for Fixed Values DDTEXT
MRPControllerName MRP Controller Name TEXT18
UserDescription User Description SUIDTECHDESC
PurgCatUUID Purchasing Category UUID /BOBF/CONF_KEY
PurchasingCategory Purchasing Category ID /SRMSMC/OBJECT_ID
PurgCatName Name of Purchasing Category /SRMSMC/MEDIUM_NAME
PreferredSupplierName Name of Supplier TEXT80
ReleaseStrategy Release strategy in the purchase requisition FRGST
Batch Batch Number CHARG
IsDeleted Deletion Indicator in Purchasing Document ELOEK
SupplyingPlant Supplying (issuing) plant in case of stock transport order WERKS
MultipleAcctAssgmtDistrPercent Distribution percentage in the case of multiple acct assgt VPROZ
OrderDescription Order Description TEXT40
SalesOrder Sales and Distribution Document Number VBELN
ControllingAreaName Controlling Area Name TEXT25
BusinessAreaName Business Area Description TEXT30
ProfitCenter Profit Center PRCTR
ProfitabilitySegment Profitability Segment Number (CO-PA) RKEOBJNR
GrantID Grant GM_GRANT_NBR
FundsCenter Funds Center FISTL
Fund Fund BP_GEBER
BudgetPeriod Budget Period FM_BUDGET_PERIOD
SalesOrderItem Sales Document Item POSNR
ProjectNetworkInternalID Routing number of operations in the order AUFPL
UnloadingPointName Unloading Point TEXT25
CostObject Cost Object KSTRG
EarmarkedFunds Document Number for Earmarked Funds KBLNR
FunctionalArea Functional Area FKBER
EarmarkedFundsItem Earmarked Funds: Document Item KBLPOS
PlantName Plant Name TEXT30
MaterialName Material Description TEXT40
AcctAssignmentCategoryName Account Assignment Category Description TEXT20
MaterialGroupName Product Group Description TEXT20
StorageLocationName Storage Location Name TEXT16
PurchasingInfoRecordDesc Short Text for Purchasing Info Record TEXT40
PurchasingGroupName Purchasing Group Name TEXT18
PurchasingOrganizationName Purchasing Organization Name TEXT20
PurchaseRequisitionItemText Short Text TEXT40
PurgDocExternalItemCategory Item Category in Purchasing Document EPSTP
PurgDocItemCategoryName Text for Item Category TEXT20
FixedAssetDescription Asset Description TEXT50
Language null
Master Data Relations Join Conditions
Account Assignment Category
  • Account Assignment Category
  • Client
  • P_PURREQITEMACCTMNTR.ACCOUNTASSIGNMENTCATEGORY == T163K.KNTTP
  • P_PURREQITEMACCTMNTR.MANDT == T163K.MANDT
Purchase requisition unit of measure
  • Purchase requisition unit of measure
  • Client
  • P_PURREQITEMACCTMNTR.BASEUNIT == T006.MSEHI
  • P_PURREQITEMACCTMNTR.MANDT == T006.MANDT
Business Area
  • Client
  • Business Area
  • P_PURREQITEMACCTMNTR.MANDT == TGSB.MANDT
  • P_PURREQITEMACCTMNTR.BUSINESSAREA == TGSB.GSBER
Chart of Accounts
  • Chart of Accounts
  • Client
  • P_PURREQITEMACCTMNTR.CHARTOFACCOUNTS == T004.KTOPL
  • P_PURREQITEMACCTMNTR.MANDT == T004.MANDT
Commitment Item
  • ?
  • ?
  • Client
  • Commitment Item
  • P_PURREQITEMACCTMNTR.[column in domain "FIKRS"] == FMFPO.FIKRS
  • P_PURREQITEMACCTMNTR.[column in domain "FM_DATBIS"] == FMFPO.DATBIS
  • P_PURREQITEMACCTMNTR.MANDT == FMFPO.MANDT
  • P_PURREQITEMACCTMNTR.COMMITMENTITEM == FMFPO.FIPOS
Company code
  • Company Code
  • Client
  • P_PURREQITEMACCTMNTR.COMPANYCODE == T001.BUKRS
  • P_PURREQITEMACCTMNTR.MANDT == T001.MANDT
Controlling Area
  • Controlling Area
  • Client
  • P_PURREQITEMACCTMNTR.CONTROLLINGAREA == TKA01.KOKRS
  • P_PURREQITEMACCTMNTR.MANDT == TKA01.MANDT
Cost Center
  • Controlling Area
  • ?
  • Cost Center
  • Client
  • P_PURREQITEMACCTMNTR.CONTROLLINGAREA == CSKS.KOKRS
  • P_PURREQITEMACCTMNTR.[column in domain "DATBI"] == CSKS.DATBI
  • P_PURREQITEMACCTMNTR.COSTCENTER == CSKS.KOSTL
  • P_PURREQITEMACCTMNTR.MANDT == CSKS.MANDT
Currency Key
  • Client
  • Currency Key
  • Currency Key
  • P_PURREQITEMACCTMNTR.MANDT == TCURC.MANDT
  • P_PURREQITEMACCTMNTR.PURREQNITEMCURRENCY == TCURC.WAERS
  • P_PURREQITEMACCTMNTR.DISPLAYCURRENCY == TCURC.WAERS
Desired Vendor
  • Desired Vendor
  • Client
  • P_PURREQITEMACCTMNTR.EXTDESIREDSUPPLIERFORPURG == LFA1.LIFNR
  • P_PURREQITEMACCTMNTR.MANDT == LFA1.MANDT
Asset Subnumber
  • Company Code
  • Main Asset Number
  • Client
  • Asset Subnumber
  • P_PURREQITEMACCTMNTR.COMPANYCODE == ANLA.BUKRS
  • P_PURREQITEMACCTMNTR.MASTERFIXEDASSET == ANLA.ANLN1
  • P_PURREQITEMACCTMNTR.MANDT == ANLA.MANDT
  • P_PURREQITEMACCTMNTR.FIXEDASSET == ANLA.ANLN2
G/L Account Number
  • Chart of Accounts
  • G/L Account Number
  • Client
  • P_PURREQITEMACCTMNTR.CHARTOFACCOUNTS == SKA1.KTOPL
  • P_PURREQITEMACCTMNTR.GLACCOUNT == SKA1.SAKNR
  • P_PURREQITEMACCTMNTR.MANDT == SKA1.MANDT
Material number corresponding to manufacturer part number
  • Client
  • Material number corresponding to manufacturer part number
  • P_PURREQITEMACCTMNTR.MANDT == MARA.MANDT
  • P_PURREQITEMACCTMNTR.MANUFACTURERMATERIAL == MARA.MATNR
Material Number
  • Material Number
  • Client
  • P_PURREQITEMACCTMNTR.MATERIAL == MARA.MATNR
  • P_PURREQITEMACCTMNTR.MANDT == MARA.MANDT
Material Group
  • Material Group
  • Client
  • P_PURREQITEMACCTMNTR.MATERIALGROUP == T023.MATKL
  • P_PURREQITEMACCTMNTR.MANDT == T023.MANDT
MRP Controller
  • Plant
  • Client
  • MRP Controller
  • P_PURREQITEMACCTMNTR.PLANT == T024D.WERKS
  • P_PURREQITEMACCTMNTR.MANDT == T024D.MANDT
  • P_PURREQITEMACCTMNTR.MRPCONTROLLER == T024D.DISPO
Plant
  • Plant
  • Client
  • P_PURREQITEMACCTMNTR.PLANT == T001W.WERKS
  • P_PURREQITEMACCTMNTR.MANDT == T001W.MANDT
Order Number
  • Order Number
  • Client
  • P_PURREQITEMACCTMNTR.PROCESSORDER == AUFK.AUFNR
  • P_PURREQITEMACCTMNTR.MANDT == AUFK.MANDT
Procuring Plant
  • Procuring Plant
  • Client
  • P_PURREQITEMACCTMNTR.PROCURINGPLANT == T001W.WERKS
  • P_PURREQITEMACCTMNTR.MANDT == T001W.MANDT
Network Number for Account Assignment
  • Network Number for Account Assignment
  • Client
  • P_PURREQITEMACCTMNTR.PROJECTNETWORK == AUFK.AUFNR
  • P_PURREQITEMACCTMNTR.MANDT == AUFK.MANDT
Purchase Requisition Document Type
  • Purchasing Document Category
  • Purchase Requisition Document Type
  • Client
  • P_PURREQITEMACCTMNTR.PURCHASINGDOCUMENTCATEGORY == T161.BSTYP
  • P_PURREQITEMACCTMNTR.PURCHASEREQUISITIONTYPE == T161.BSART
  • P_PURREQITEMACCTMNTR.MANDT == T161.MANDT
Item category in purchasing document
  • Item category in purchasing document
  • Client
  • P_PURREQITEMACCTMNTR.PURCHASINGDOCUMENTITEMCATEGORY == T163.PSTYP
  • P_PURREQITEMACCTMNTR.MANDT == T163.MANDT
Purchasing Group
  • Client
  • Purchasing Group
  • P_PURREQITEMACCTMNTR.MANDT == T024.MANDT
  • P_PURREQITEMACCTMNTR.PURCHASINGGROUP == T024.EKGRP
Number of purchasing info record
  • Number of purchasing info record
  • Client
  • P_PURREQITEMACCTMNTR.PURCHASINGINFORECORD == EINA.INFNR
  • P_PURREQITEMACCTMNTR.MANDT == EINA.MANDT
Purchasing organization
  • Purchasing organization
  • Client
  • P_PURREQITEMACCTMNTR.PURCHASINGORGANIZATION == T024E.EKORG
  • P_PURREQITEMACCTMNTR.MANDT == T024E.MANDT
Currency Key
  • Client
  • Currency Key
  • Currency Key
  • P_PURREQITEMACCTMNTR.MANDT == TCURC.MANDT
  • P_PURREQITEMACCTMNTR.PURREQNITEMCURRENCY == TCURC.WAERS
  • P_PURREQITEMACCTMNTR.DISPLAYCURRENCY == TCURC.WAERS
Release Indicator
  • Release Indicator
  • Client
  • P_PURREQITEMACCTMNTR.RELEASECODE == T161S.FRGKZ
  • P_PURREQITEMACCTMNTR.MANDT == T161S.MANDT
Storage location
  • Storage location
  • Plant
  • Client
  • P_PURREQITEMACCTMNTR.STORAGELOCATION == T001L.LGORT
  • P_PURREQITEMACCTMNTR.PLANT == T001L.WERKS
  • P_PURREQITEMACCTMNTR.MANDT == T001L.MANDT
Fixed Vendor
  • Fixed Vendor
  • Client
  • P_PURREQITEMACCTMNTR.SUPPLIER == LFA1.LIFNR
  • P_PURREQITEMACCTMNTR.MANDT == LFA1.MANDT
Other Relations | to Master Data Relations ↑ Join Conditions
Category of delivery date
  • ?
  • Category of delivery date
  • Client
  • P_PURREQITEMACCTMNTR.[column in domain "SPRAS"] == TPRG.SPRAS
  • P_PURREQITEMACCTMNTR.DELIVDATECATEGORY == TPRG.PRGBZ
  • P_PURREQITEMACCTMNTR.MANDT == TPRG.MANDT