C_PurReqItemAcctMntr

PR Items by Account Assignment | view: CPREQITMACCMNTR | Extraction: Not supported | Component: Purchase Requisitions

Tables used: MMDOC_EXT_LINKS, EBAN_TECH, FMIOI, AFKO, AFKO, EBAN, /SRMSMC/D_PUC_RT, /SRMSMC/D_PUCMG, EKKO, EBKN, T163I, T163K, FMBUDGETPDT, TGSB, TGSBT, T001, TKA02, TKA01, CSKS, CSKS, CSKT, FM01, TFKBT, FMFINT, GMGRTEXTS, AUFK, MARA, T023, T023T, MAKT, T024D, AUFK, T001W, CEPC, CEPCT, PROJ, T161U, T161, T161T, T024, EINA, T024E, T163, T163Y, T000, T001L, LFA1, USR21, T001K, PRPS, ANKA, FAAC_ACLS0, ANKT, FAAC_ACLS0_T, ANLA, FAAT_MD, FAAT_MD_ROOT, T001, ANLA, FAAT_MD_LD, FINSC_LEDGER, SKAT, T004, MMPUR_C_BE_SYREG, FINSC_FISC_DATE

🔑 Keys (3)
💰 Amounts (2)
∑ Quantities (4)
📅 Dates (6)
☰ Categorical (1)
Other (79)
🔗 Relations (37)

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 (SalesPlanCurrency):
PurchaseRequisitionPrice	Price in Purchase Requisition
💲 Currency Key (PurReqnItemCurrency):
PurgDocNetAmount	null

Column Name	Description
📏 Purchase requisition unit of measure (BaseUnit):
Quantity	Purchase requisition quantity
RequestedQuantity	Purchase requisition quantity
OrderedQuantity	Quantity ordered against this purchase requisition
MaterialShortageQuantity	Shortage (stock undercoverage) quantity

Column Name	Description
ValidityDate	null
DeliveryDate	Item delivery date
PurchaseRequisitionReleaseDate	Purchase Requisition Release Date
PurReqCreationDate	Requisition (request) date
LastChangeDate	Requisition (request) date
PurchaseOrderDate	Purchase Order Date

Column Name	Description
IsPurReqnCmplt	Purchase Requisition not yet Complete	Show values

Column Name	Description	Domain name
CompanyCodeName	Name of Company Code or Company
FormattedPurRequisitionItem	null
MaterialName	Material Description
AcctAssignmentCategoryName	Account Assignment Category Description	TEXT20
SenderCostCenterName	Cost Center Name
PurchasingDocumentTypeName	Short Description of Purchasing Document Type
WBSElement	Work Breakdown Structure Element (WBS Element)
WBSDescription	WBS Element Name	TEXT40
MaterialGroupName	Product Group Description
SupplierName	Name of Supplier	TEXT80
PurchasingOrganizationName	Purchasing Organization Name
PurchasingGroupName	Purchasing Group Name
ProjectNetworkDescription	Description	TEXT40
PurReqnRequestor	Requestor
RequirementTracking	Requirement Tracking Number
MultipleAcctAssgmtDistrPercent	null
PlantName	Plant Name	TEXT30
PreferredSupplierName	Name of Supplier
PurchaseRequisitionStatus	Processing status of purchase requisition
ProcessingStatusName	Short Text for Fixed Values
PurchasingReleaseIndicatorDesc	Description of release indicator
StorageLocationName	Storage Location Name
PurchasingInfoRecordDesc	Short Text for Purchasing Info Record
PurReqnOrigin	Creation indicator (purchase requisition/schedule lines)
DomainText	Short Text for Fixed Values
ProcmtHubMRPController	MRP Controller Name
ReleaseStrategy	Release strategy in the purchase requisition
OrderDescription	Order Description
Batch	Batch Number	CHARG
SDDocument	Sales and Distribution Document Number
FixedAssetDescription	Asset Description
ControllingAreaName	Controlling Area Name
BusinessAreaName	Business Area Description
ProfitCenter	Profit Center
ProfitCenterName	Description of Profit Center
ProfitabilitySegment	null
GrantID	Grant	GM_GRANT_NBR
GrantName	Short Description of the Grant
ControlObjectFundsCenter	Funds Center
Fund	Fund	BP_GEBER
FundName	Fund Name
BudgetPeriod	Budget Period	FM_BUDGET_PERIOD
BudgetPeriodName	Budget Period Name
GLAccountName	G/L Account Short Text
UserDescription	User Description
PurchasingCategory	Purchasing Category ID	/SRMSMC/OBJECT_ID
PurgCatName	Name of Purchasing Category
PurgCatUUID	Purchasing Category UUID	/BOBF/CONF_KEY
Language	null
PrimaryCostObjectCategory	Consumption posting
SalesOrderItem	Sales Document Item	POSNR
PurchaseRequisitionItemText	Short Text
PurgDocExternalItemCategory	Item Category in Purchasing Document	EPSTP
PurgDocItemCategoryName	Text for Item Category
NumberOfPurchaseOrders	Number of Purchase Orders
PurchasingIsBlockedForSupplier	Boolean Variable (X = True, - = False, Space = Unknown)
PurReqnReleaseStatus	Requisition Processing State
PurReqnReleaseStatusName	Short Text for Fixed Values
IsPurReqnBlocked	Boolean Variable (X = True, - = False, Space = Unknown)
SourceOfSupplyIsAssignedOnce	Boolean Variable (X = True, - = False, Space = Unknown)
IsClosed	Boolean Variable (X = True, - = False, Space = Unknown)
IsPurReqnOvrlRel	Boolean Variable (X = True, - = False, Space = Unknown)
SupplyingPlant	Supplying (issuing) plant in case of stock transport order	WERKS
SupplyingPlantName	Plant Name
ManufacturerName	Material Description
RequisitionIsPartlyOrdered	Boolean Variable (X = True, - = False, Space = Unknown)
RequisitionsAreReleased	Boolean Variable (X = True, - = False, Space = Unknown)
PurReqnCmpltnsCat	Category of Incompleteness
PurReqnReleaseStatusDesc	null
IsHeld	Boolean Variable (X = True, - = False, Space = Unknown)
ReceivingPlantName	Plant Name
ProjectNetworkInternalID	Routing number of operations in the order
UnloadingPointName	Unloading Point	TEXT25
CostObject	Cost Object	KSTRG
EarmarkedFundsDocument	Document Number for Earmarked Funds	KBLNR
FunctionalArea	Functional Area	FKBER
FunctionalAreaName	Name of the Functional Area
EarmarkedFundsItem	Earmarked Funds: Document Item
AssetClassName	Short Text for Asset Class Name

Master Data Relations	Join Conditions
Account Assignment Category Client Account Assignment Category	`C_PURREQITEMACCTMNTR.MANDT == T163K.MANDT` `C_PURREQITEMACCTMNTR.ACCOUNTASSIGNMENTCATEGORY == T163K.KNTTP`
Purchase requisition unit of measure Client Purchase requisition unit of measure	`C_PURREQITEMACCTMNTR.MANDT == T006.MANDT` `C_PURREQITEMACCTMNTR.BASEUNIT == T006.MSEHI`
Business Area Client Business Area	`C_PURREQITEMACCTMNTR.MANDT == TGSB.MANDT` `C_PURREQITEMACCTMNTR.BUSINESSAREA == TGSB.GSBER`
Commitment Item ? Client Commitment Item ?	`C_PURREQITEMACCTMNTR.[column in domain "FIKRS"] == FMFPO.FIKRS` `C_PURREQITEMACCTMNTR.MANDT == FMFPO.MANDT` `C_PURREQITEMACCTMNTR.COMMITMENTITEM == FMFPO.FIPOS` `C_PURREQITEMACCTMNTR.[column in domain "FM_DATBIS"] == FMFPO.DATBIS`
Company code Client Company Code	`C_PURREQITEMACCTMNTR.MANDT == T001.MANDT` `C_PURREQITEMACCTMNTR.COMPANYCODE == T001.BUKRS`
Controlling Area Client Controlling Area	`C_PURREQITEMACCTMNTR.MANDT == TKA01.MANDT` `C_PURREQITEMACCTMNTR.CONTROLLINGAREA == TKA01.KOKRS`
Cost Center Cost Center Client Controlling Area ?	`C_PURREQITEMACCTMNTR.COSTCENTER == CSKS.KOSTL` `C_PURREQITEMACCTMNTR.MANDT == CSKS.MANDT` `C_PURREQITEMACCTMNTR.CONTROLLINGAREA == CSKS.KOKRS` `C_PURREQITEMACCTMNTR.[column in domain "DATBI"] == CSKS.DATBI`
Desired Vendor Client Desired Vendor	`C_PURREQITEMACCTMNTR.MANDT == LFA1.MANDT` `C_PURREQITEMACCTMNTR.EXTDESIREDSUPPLIERFORPURG == LFA1.LIFNR`
Asset Subnumber Main Asset Number Asset Subnumber Client Company Code	`C_PURREQITEMACCTMNTR.MASTERFIXEDASSET == ANLA.ANLN1` `C_PURREQITEMACCTMNTR.FIXEDASSET == ANLA.ANLN2` `C_PURREQITEMACCTMNTR.MANDT == ANLA.MANDT` `C_PURREQITEMACCTMNTR.COMPANYCODE == ANLA.BUKRS`
G/L Account Number Client ? G/L Account Number	`C_PURREQITEMACCTMNTR.MANDT == SKA1.MANDT` `C_PURREQITEMACCTMNTR.[column in domain "KTOPL"] == SKA1.KTOPL` `C_PURREQITEMACCTMNTR.GLACCOUNT == SKA1.SAKNR`
Material number corresponding to manufacturer part number Material number corresponding to manufacturer part number Client	`C_PURREQITEMACCTMNTR.MANUFACTURERMATERIAL == MARA.MATNR` `C_PURREQITEMACCTMNTR.MANDT == MARA.MANDT`
Material Number Client Material Number	`C_PURREQITEMACCTMNTR.MANDT == MARA.MANDT` `C_PURREQITEMACCTMNTR.MATERIAL == MARA.MATNR`
Material Group Client Material Group	`C_PURREQITEMACCTMNTR.MANDT == T023.MANDT` `C_PURREQITEMACCTMNTR.MATERIALGROUP == T023.MATKL`
MRP Controller Client Plant MRP Controller	`C_PURREQITEMACCTMNTR.MANDT == T024D.MANDT` `C_PURREQITEMACCTMNTR.PLANT == T024D.WERKS` `C_PURREQITEMACCTMNTR.MRPCONTROLLER == T024D.DISPO`
Plant Client Plant	`C_PURREQITEMACCTMNTR.MANDT == T001W.MANDT` `C_PURREQITEMACCTMNTR.PLANT == T001W.WERKS`
Order Number Order Number Client	`C_PURREQITEMACCTMNTR.PROCESSORDER == AUFK.AUFNR` `C_PURREQITEMACCTMNTR.MANDT == AUFK.MANDT`
Procuring Plant Client Procuring Plant	`C_PURREQITEMACCTMNTR.MANDT == T001W.MANDT` `C_PURREQITEMACCTMNTR.PROCURINGPLANT == T001W.WERKS`
Network Number for Account Assignment Client Network Number for Account Assignment	`C_PURREQITEMACCTMNTR.MANDT == AUFK.MANDT` `C_PURREQITEMACCTMNTR.PROJECTNETWORK == AUFK.AUFNR`
Purchase Requisition Document Type ? Client Purchase Requisition Document Type	`C_PURREQITEMACCTMNTR.[column in domain "BSTYP"] == T161.BSTYP` `C_PURREQITEMACCTMNTR.MANDT == T161.MANDT` `C_PURREQITEMACCTMNTR.PURCHASEREQUISITIONTYPE == T161.BSART`
Item category in purchasing document Client Item category in purchasing document	`C_PURREQITEMACCTMNTR.MANDT == T163.MANDT` `C_PURREQITEMACCTMNTR.PURCHASINGDOCUMENTITEMCATEGORY == T163.PSTYP`
Purchasing Group Purchasing Group Client	`C_PURREQITEMACCTMNTR.PURCHASINGGROUP == T024.EKGRP` `C_PURREQITEMACCTMNTR.MANDT == T024.MANDT`
Number of purchasing info record Client Number of purchasing info record	`C_PURREQITEMACCTMNTR.MANDT == EINA.MANDT` `C_PURREQITEMACCTMNTR.PURCHASINGINFORECORD == EINA.INFNR`
Purchasing organization Purchasing organization Client	`C_PURREQITEMACCTMNTR.PURCHASINGORGANIZATION == T024E.EKORG` `C_PURREQITEMACCTMNTR.MANDT == T024E.MANDT`
Currency Key Currency Key Currency Key Client	`C_PURREQITEMACCTMNTR.PURREQNITEMCURRENCY == TCURC.WAERS` `C_PURREQITEMACCTMNTR.SALESPLANCURRENCY == TCURC.WAERS` `C_PURREQITEMACCTMNTR.MANDT == TCURC.MANDT`
Release Indicator Client Release Indicator	`C_PURREQITEMACCTMNTR.MANDT == T161S.MANDT` `C_PURREQITEMACCTMNTR.RELEASECODE == T161S.FRGKZ`
Currency Key Currency Key Currency Key Client	`C_PURREQITEMACCTMNTR.PURREQNITEMCURRENCY == TCURC.WAERS` `C_PURREQITEMACCTMNTR.SALESPLANCURRENCY == TCURC.WAERS` `C_PURREQITEMACCTMNTR.MANDT == TCURC.MANDT`
Storage location Storage location Client Plant	`C_PURREQITEMACCTMNTR.STORAGELOCATION == T001L.LGORT` `C_PURREQITEMACCTMNTR.MANDT == T001L.MANDT` `C_PURREQITEMACCTMNTR.PLANT == T001L.WERKS`
Fixed Vendor Fixed Vendor Client	`C_PURREQITEMACCTMNTR.SUPPLIER == LFA1.LIFNR` `C_PURREQITEMACCTMNTR.MANDT == LFA1.MANDT`

Other Relations \| to Master Data Relations ↑	Join Conditions
Category of delivery date Category of delivery date ? Client	`C_PURREQITEMACCTMNTR.DELIVDATECATEGORY == TPRG.PRGBZ` `C_PURREQITEMACCTMNTR.[column in domain "SPRAS"] == TPRG.SPRAS` `C_PURREQITEMACCTMNTR.MANDT == TPRG.MANDT`