I_AlignAcctAssgdPurReqItm

Account assignd PR line item for alignment | view: IALIGNAAPURREQ | Extraction: Not supported | Component: Purchasing

Tables used: EBAN, MMDOC_EXT_LINKS, EBAN_TECH, FMIOI, EKAB, EBAN, EKKO, EKPO, EBKN, PRTE, T001, TKA02, TKA01, FM01, MARA, T001W, PROJ, T001K, T000, LFA1, T001K, PRPS, MMPUR_C_BE_SYREG, FINSC_FISC_DATE

🔑 Keys (2)
💰 Amounts
∑ Quantities (3)
📅 Dates (1)
☰ Categorical (1)
Other (5)
🔗 Relations (21)

Column Name	Description
PurchaseRequisition	Purchase requisition number
PurchaseRequisitionItem	Item number of purchase requisition

Column Name	Description

Column Name	Description
📏 Purchase requisition unit of measure (BaseUnit):
RequestedQuantity	Purchase requisition quantity
📏 Purchase Order Unit of Measure (PurchaseContractQuantityUnit):
TargetQuantity	Target Quantity
ReqnItmContrItmOpnQtyInBaseUoM	null

Column Name	Description
DeliveryDate	Item delivery date

Column Name	Description
ProductCategory	Material Category	Show values

Column Name	Description	Domain name
ContractItemQtyToBaseQtyNmrtr	Numerator for Conversion of Order Unit to Base Unit	UMBSZ
ContractItemQtyToBaseQtyDnmntr	Denominator for Conversion of Order Unit to Base Unit	UMBSN
SalesOrder	Sales and Distribution Document Number	VBELN
SalesOrderItem	Sales Document Item	POSNR
PurchaseReqnItemStockSegment	Stock Segment	SGT_SRCA

Master Data Relations	Join Conditions
Purchase requisition unit of measure Client Purchase requisition unit of measure Purchase Order Unit of Measure	`I_ALIGNACCTASSGDPURREQITM.MANDT == T006.MANDT` `I_ALIGNACCTASSGDPURREQITM.BASEUNIT == T006.MSEHI` `I_ALIGNACCTASSGDPURREQITM.PURCHASECONTRACTQUANTITYUNIT == T006.MSEHI`
Company code Company Code Client	`I_ALIGNACCTASSGDPURREQITM.COMPANYCODE == T001.BUKRS` `I_ALIGNACCTASSGDPURREQITM.MANDT == T001.MANDT`
Fixed Vendor Client Fixed Vendor	`I_ALIGNACCTASSGDPURREQITM.MANDT == LFA1.MANDT` `I_ALIGNACCTASSGDPURREQITM.FIXEDSUPPLIER == LFA1.LIFNR`
Material Group Client Material Group	`I_ALIGNACCTASSGDPURREQITM.MANDT == T023.MANDT` `I_ALIGNACCTASSGDPURREQITM.MATERIALGROUP == T023.MATKL`
Plant Client Plant	`I_ALIGNACCTASSGDPURREQITM.MANDT == T001W.MANDT` `I_ALIGNACCTASSGDPURREQITM.PLANT == T001W.WERKS`
Purchase Order Unit of Measure Client Purchase requisition unit of measure Purchase Order Unit of Measure	`I_ALIGNACCTASSGDPURREQITM.MANDT == T006.MANDT` `I_ALIGNACCTASSGDPURREQITM.BASEUNIT == T006.MSEHI` `I_ALIGNACCTASSGDPURREQITM.PURCHASECONTRACTQUANTITYUNIT == T006.MSEHI`
Fashion Collection Client Fashion Collection Season Year Season	`I_ALIGNACCTASSGDPURREQITM.MANDT == FSH_COLLECTIONS.MANDT` `I_ALIGNACCTASSGDPURREQITM.PURCHASEREQNITEMCOLLECTION == FSH_COLLECTIONS.FSH_COLLECTION` `I_ALIGNACCTASSGDPURREQITM.PURCHASEREQNITEMSEASONYEAR == FSH_COLLECTIONS.FSH_SEASON_YEAR` `I_ALIGNACCTASSGDPURREQITM.PURCHASEREQNITEMSEASON == FSH_COLLECTIONS.FSH_SEASON`
Season Client Season Year Season	`I_ALIGNACCTASSGDPURREQITM.MANDT == FSH_SEASONS.MANDT` `I_ALIGNACCTASSGDPURREQITM.PURCHASEREQNITEMSEASONYEAR == FSH_SEASONS.FSH_SEASON_YEAR` `I_ALIGNACCTASSGDPURREQITM.PURCHASEREQNITEMSEASON == FSH_SEASONS.FSH_SEASON`
Season Year Client Season Year Season	`I_ALIGNACCTASSGDPURREQITM.MANDT == FSH_SEASONS.MANDT` `I_ALIGNACCTASSGDPURREQITM.PURCHASEREQNITEMSEASONYEAR == FSH_SEASONS.FSH_SEASON_YEAR` `I_ALIGNACCTASSGDPURREQITM.PURCHASEREQNITEMSEASON == FSH_SEASONS.FSH_SEASON`
Fashion Theme Client Fashion Collection Season Year Fashion Theme Season	`I_ALIGNACCTASSGDPURREQITM.MANDT == FSH_THEMES.MANDT` `I_ALIGNACCTASSGDPURREQITM.PURCHASEREQNITEMCOLLECTION == FSH_THEMES.FSH_COLLECTION` `I_ALIGNACCTASSGDPURREQITM.PURCHASEREQNITEMSEASONYEAR == FSH_THEMES.FSH_SEASON_YEAR` `I_ALIGNACCTASSGDPURREQITM.PURCHASEREQNITEMTHEME == FSH_THEMES.FSH_THEME` `I_ALIGNACCTASSGDPURREQITM.PURCHASEREQNITEMSEASON == FSH_THEMES.FSH_SEASON`
Purchase Requisition Document Type Client Purchase Requisition Document Type ?	`I_ALIGNACCTASSGDPURREQITM.MANDT == T161.MANDT` `I_ALIGNACCTASSGDPURREQITM.PURCHASEREQUISITIONTYPE == T161.BSART` `I_ALIGNACCTASSGDPURREQITM.[column in domain "BSTYP"] == T161.BSTYP`
Purchasing Group Client Purchasing Group	`I_ALIGNACCTASSGDPURREQITM.MANDT == T024.MANDT` `I_ALIGNACCTASSGDPURREQITM.PURCHASINGGROUP == T024.EKGRP`
Number of purchasing info record Client Number of purchasing info record	`I_ALIGNACCTASSGDPURREQITM.MANDT == EINA.MANDT` `I_ALIGNACCTASSGDPURREQITM.PURCHASINGINFORECORD == EINA.INFNR`
Purchasing organization Client Purchasing organization	`I_ALIGNACCTASSGDPURREQITM.MANDT == T024E.MANDT` `I_ALIGNACCTASSGDPURREQITM.PURCHASINGORGANIZATION == T024E.EKORG`
Currency Key Client Currency Key	`I_ALIGNACCTASSGDPURREQITM.MANDT == TCURC.MANDT` `I_ALIGNACCTASSGDPURREQITM.PURREQNITMPLNTCOCODECRCY == TCURC.WAERS`
Desired Vendor Client Desired Vendor	`I_ALIGNACCTASSGDPURREQITM.MANDT == LFA1.MANDT` `I_ALIGNACCTASSGDPURREQITM.SUPPLIER == LFA1.LIFNR`