I_AlignAcctAssgdPurReqCore

Align AA PR core | view: IALIGNAAPRCORE | Extraction: Not supported | Component: Purchasing

Tables used: EKET, EKPO, EBAN, MMDOC_EXT_LINKS, EBAN_TECH, FMIOI, EKAB, EKKO, EBKN, VBAK, VBAP, VBEP, PRTE, VBPA, MARA, ARUN_BDBS, TVEP, CVI_CUST_CT_LINK, BUT000, T001, TKA02, TKA01, KNA1, CVI_CUST_LINK, FM01, T001W, MAKT, PROJ, T001K, WRF_CHARVALT, T000, LFA1, CVI_VEND_LINK, PRPS, MMPUR_C_BE_SYREG, FINSC_FISC_DATE

🔑 Keys (9)
💰 Amounts
∑ Quantities (4)
📅 Dates (2)
☰ Categorical (5)
Other (19)
🔗 Relations (40)

Column Name	Description
Product	Material Number
PurchaseRequisition	Purchase requisition number
PurchaseRequisitionItem	Item number of purchase requisition
SalesOrder	Sales and Distribution Document Number
SalesOrderItem	Sales Document Item
SalesOrderScheduleLine FK	Schedule Line Number
PurchasingDocument FK	Purchasing Document Number
PurchasingDocumentItem	Item Number of Purchasing Document
ScheduleLine	Delivery Schedule Line Counter

Column Name	Description

Column Name	Description
ReqnItmContrItmOpnQtyInBaseUoM	null
OpenQuantityInBaseUnit	Scheduled Quantity
📏 Base Unit of Measure (PurchaseOrderQuantityUnit):
RequestedQuantity	Purchase requisition quantity
OrderQuantityInBaseUnit	Purchase Order Quantity

Column Name	Description
DeliveryDate	Item delivery date
ScheduleLineDeliveryDate	Item delivery date

Column Name	Description
ProductCategory	Material Category	Show values
PurReqnHasCrossPlantAlignment	Checkbox	Show values
PurReqnHasCrossSgmtAlignment	Checkbox	Show values
PurReqnHasCrossSeasonAlignment	Checkbox	Show values
DiversionStatus	Status of Diversion process	Show values

Column Name	Description	Domain name
ProductName	Product Description	TEXT40
ProductCharacteristic1	Characteristic Value 1	WRF_CHARSTC
ProductCharacteristic1Desc	Characteristic Description 1	TEXT70
ProductCharacteristic2	Characteristic Value 2	WRF_CHARSTC
ProductCharacteristic2Desc	Characteristic Description 2	TEXT70
ProductCharacteristic3	Characteristic Value 3	WRF_CHARSTC
ProductCharacteristic3Desc	Characteristic Description 3	TEXT70
SalesAccountAssignmentType	Single-Character Flag	CHAR1
ProductCategoryName	Product Category Text	DDTEXT
BillOfMaterial	Bill of Material	STNUM
PurchaseReqnItemStockSegment	Stock Segment	SGT_SRCA
ContractItemQtyToBaseQtyNmrtr	Numerator for Conversion of Order Unit to Base Unit	UMBSZ
ContractItemQtyToBaseQtyDnmntr	Denominator for Conversion of Order Unit to Base Unit	UMBSN
HigherLevelItem	Higher-Level Item in Bill of Material Structures	POSNR
PurchaseOrderItemSeasonYear	Season Year	FSH_CJAHR
PurchaseOrderItemSeason	Season	RFM_SAISO
PurchaseOrderItemCollection	Fashion Collection	FSH_COLLECTION
PurchaseOrderItemTheme	Fashion Theme	FSH_THEME
PurchaseOrderItemStockSegment	Stock Segment	SGT_SRCA

Master Data Relations	Join Conditions
Company code Client Company Code	`I_ALIGNACCTASSGDPURREQCORE.MANDT == T001.MANDT` `I_ALIGNACCTASSGDPURREQCORE.COMPANYCODE == T001.BUKRS`
Cross-Plant Configurable Material Client Cross-Plant Configurable Material	`I_ALIGNACCTASSGDPURREQCORE.MANDT == MARA.MANDT` `I_ALIGNACCTASSGDPURREQCORE.CROSSPLANTCONFIGURABLEPRODUCT == MARA.MATNR`
Distribution channel in order header Client Sales Organization Distribution Channel	`I_ALIGNACCTASSGDPURREQCORE.MANDT == TVKOV.MANDT` `I_ALIGNACCTASSGDPURREQCORE.SALESORGANIZATION == TVKOV.VKORG` `I_ALIGNACCTASSGDPURREQCORE.DISTRIBUTIONCHANNEL == TVKOV.VTWEG`
Fixed Vendor Client Fixed Vendor	`I_ALIGNACCTASSGDPURREQCORE.MANDT == LFA1.MANDT` `I_ALIGNACCTASSGDPURREQCORE.FIXEDSUPPLIER == LFA1.LIFNR`
Material Number Client Material Number Material Number Material Number	`I_ALIGNACCTASSGDPURREQCORE.MANDT == MARA.MANDT` `I_ALIGNACCTASSGDPURREQCORE.MATERIAL == MARA.MATNR` `I_ALIGNACCTASSGDPURREQCORE.PRODUCT == MARA.MATNR` `I_ALIGNACCTASSGDPURREQCORE.PRODUCTOFHIGHERLEVELITEM == MARA.MATNR`
Material Group Client Material Group	`I_ALIGNACCTASSGDPURREQCORE.MANDT == T023.MANDT` `I_ALIGNACCTASSGDPURREQCORE.MATERIALGROUP == T023.MATKL`
Purchase Order Unit of Measure Client Purchase requisition unit of measure Purchase Order Unit of Measure Purchase Order Unit of Measure	`I_ALIGNACCTASSGDPURREQCORE.MANDT == T006.MANDT` `I_ALIGNACCTASSGDPURREQCORE.PURCHASEREQUISITIONUNIT == T006.MSEHI` `I_ALIGNACCTASSGDPURREQCORE.ORDERQUANTITYUNIT == T006.MSEHI` `I_ALIGNACCTASSGDPURREQCORE.PURCHASECONTRACTQUANTITYUNIT == T006.MSEHI`
Division in order header Client Sales Organization Division Distribution Channel	`I_ALIGNACCTASSGDPURREQCORE.MANDT == TVTA.MANDT` `I_ALIGNACCTASSGDPURREQCORE.SALESORGANIZATION == TVTA.VKORG` `I_ALIGNACCTASSGDPURREQCORE.ORGANIZATIONDIVISION == TVTA.SPART` `I_ALIGNACCTASSGDPURREQCORE.DISTRIBUTIONCHANNEL == TVTA.VTWEG`
Material: order item Client Material Number Material Number Material Number	`I_ALIGNACCTASSGDPURREQCORE.MANDT == MARA.MANDT` `I_ALIGNACCTASSGDPURREQCORE.MATERIAL == MARA.MATNR` `I_ALIGNACCTASSGDPURREQCORE.PRODUCT == MARA.MATNR` `I_ALIGNACCTASSGDPURREQCORE.PRODUCTOFHIGHERLEVELITEM == MARA.MATNR`
Purchase Order Unit of Measure Client Purchase requisition unit of measure Purchase Order Unit of Measure Purchase Order Unit of Measure	`I_ALIGNACCTASSGDPURREQCORE.MANDT == T006.MANDT` `I_ALIGNACCTASSGDPURREQCORE.PURCHASEREQUISITIONUNIT == T006.MSEHI` `I_ALIGNACCTASSGDPURREQCORE.ORDERQUANTITYUNIT == T006.MSEHI` `I_ALIGNACCTASSGDPURREQCORE.PURCHASECONTRACTQUANTITYUNIT == T006.MSEHI`
Base Unit of Measure Client Base Unit of Measure	`I_ALIGNACCTASSGDPURREQCORE.MANDT == T006.MANDT` `I_ALIGNACCTASSGDPURREQCORE.PURCHASEORDERQUANTITYUNIT == T006.MSEHI`
Supplier Client Supplier Desired Vendor	`I_ALIGNACCTASSGDPURREQCORE.MANDT == LFA1.MANDT` `I_ALIGNACCTASSGDPURREQCORE.PURCHASEORDERSUPPLIER == LFA1.LIFNR` `I_ALIGNACCTASSGDPURREQCORE.PURCHASEREQITEMSUPPLIER == LFA1.LIFNR`
Desired Vendor Client Supplier Desired Vendor	`I_ALIGNACCTASSGDPURREQCORE.MANDT == LFA1.MANDT` `I_ALIGNACCTASSGDPURREQCORE.PURCHASEORDERSUPPLIER == LFA1.LIFNR` `I_ALIGNACCTASSGDPURREQCORE.PURCHASEREQITEMSUPPLIER == LFA1.LIFNR`
Fashion Collection Season Year Season Year Client Fashion Collection Fashion Collection Season Season	`I_ALIGNACCTASSGDPURREQCORE.PURCHASEORDERITEMSEASONYEAR == FSH_COLLECTIONS.FSH_SEASON_YEAR` `I_ALIGNACCTASSGDPURREQCORE.PURCHASEREQNITEMSEASONYEAR == FSH_COLLECTIONS.FSH_SEASON_YEAR` `I_ALIGNACCTASSGDPURREQCORE.MANDT == FSH_COLLECTIONS.MANDT` `I_ALIGNACCTASSGDPURREQCORE.PURCHASEORDERITEMCOLLECTION == FSH_COLLECTIONS.FSH_COLLECTION` `I_ALIGNACCTASSGDPURREQCORE.PURCHASEREQNITEMCOLLECTION == FSH_COLLECTIONS.FSH_COLLECTION` `I_ALIGNACCTASSGDPURREQCORE.PURCHASEREQNITEMSEASON == FSH_COLLECTIONS.FSH_SEASON` `I_ALIGNACCTASSGDPURREQCORE.PURCHASEORDERITEMSEASON == FSH_COLLECTIONS.FSH_SEASON`
Season Season Year Season Year Client Season Season	`I_ALIGNACCTASSGDPURREQCORE.PURCHASEORDERITEMSEASONYEAR == FSH_SEASONS.FSH_SEASON_YEAR` `I_ALIGNACCTASSGDPURREQCORE.PURCHASEREQNITEMSEASONYEAR == FSH_SEASONS.FSH_SEASON_YEAR` `I_ALIGNACCTASSGDPURREQCORE.MANDT == FSH_SEASONS.MANDT` `I_ALIGNACCTASSGDPURREQCORE.PURCHASEREQNITEMSEASON == FSH_SEASONS.FSH_SEASON` `I_ALIGNACCTASSGDPURREQCORE.PURCHASEORDERITEMSEASON == FSH_SEASONS.FSH_SEASON`
Season Year Season Year Season Year Client Season Season	`I_ALIGNACCTASSGDPURREQCORE.PURCHASEORDERITEMSEASONYEAR == FSH_SEASONS.FSH_SEASON_YEAR` `I_ALIGNACCTASSGDPURREQCORE.PURCHASEREQNITEMSEASONYEAR == FSH_SEASONS.FSH_SEASON_YEAR` `I_ALIGNACCTASSGDPURREQCORE.MANDT == FSH_SEASONS.MANDT` `I_ALIGNACCTASSGDPURREQCORE.PURCHASEREQNITEMSEASON == FSH_SEASONS.FSH_SEASON` `I_ALIGNACCTASSGDPURREQCORE.PURCHASEORDERITEMSEASON == FSH_SEASONS.FSH_SEASON`
Fashion Theme Season Year Season Year Client Fashion Collection Fashion Collection Season Season Fashion Theme Fashion Theme	`I_ALIGNACCTASSGDPURREQCORE.PURCHASEORDERITEMSEASONYEAR == FSH_THEMES.FSH_SEASON_YEAR` `I_ALIGNACCTASSGDPURREQCORE.PURCHASEREQNITEMSEASONYEAR == FSH_THEMES.FSH_SEASON_YEAR` `I_ALIGNACCTASSGDPURREQCORE.MANDT == FSH_THEMES.MANDT` `I_ALIGNACCTASSGDPURREQCORE.PURCHASEORDERITEMCOLLECTION == FSH_THEMES.FSH_COLLECTION` `I_ALIGNACCTASSGDPURREQCORE.PURCHASEREQNITEMCOLLECTION == FSH_THEMES.FSH_COLLECTION` `I_ALIGNACCTASSGDPURREQCORE.PURCHASEREQNITEMSEASON == FSH_THEMES.FSH_SEASON` `I_ALIGNACCTASSGDPURREQCORE.PURCHASEORDERITEMSEASON == FSH_THEMES.FSH_SEASON` `I_ALIGNACCTASSGDPURREQCORE.PURCHASEORDERITEMTHEME == FSH_THEMES.FSH_THEME` `I_ALIGNACCTASSGDPURREQCORE.PURCHASEREQNITEMTHEME == FSH_THEMES.FSH_THEME`
Plant Client Plant Plant	`I_ALIGNACCTASSGDPURREQCORE.MANDT == T001W.MANDT` `I_ALIGNACCTASSGDPURREQCORE.PURCHASEREQUISITIONITEMPLANT == T001W.WERKS` `I_ALIGNACCTASSGDPURREQCORE.PURORDERITEMPLANT == T001W.WERKS`
Purchase Requisition Document Type Client ? Purchase Requisition Document Type Purchasing Document Type	`I_ALIGNACCTASSGDPURREQCORE.MANDT == T161.MANDT` `I_ALIGNACCTASSGDPURREQCORE.[column in domain "BSTYP"] == T161.BSTYP` `I_ALIGNACCTASSGDPURREQCORE.PURCHASEREQUISITIONTYPE == T161.BSART` `I_ALIGNACCTASSGDPURREQCORE.PURCHASINGDOCUMENTTYPE == T161.BSART`
Purchase requisition unit of measure Client Purchase requisition unit of measure Purchase Order Unit of Measure Purchase Order Unit of Measure	`I_ALIGNACCTASSGDPURREQCORE.MANDT == T006.MANDT` `I_ALIGNACCTASSGDPURREQCORE.PURCHASEREQUISITIONUNIT == T006.MSEHI` `I_ALIGNACCTASSGDPURREQCORE.ORDERQUANTITYUNIT == T006.MSEHI` `I_ALIGNACCTASSGDPURREQCORE.PURCHASECONTRACTQUANTITYUNIT == T006.MSEHI`
Purchasing Document Type Client ? Purchase Requisition Document Type Purchasing Document Type	`I_ALIGNACCTASSGDPURREQCORE.MANDT == T161.MANDT` `I_ALIGNACCTASSGDPURREQCORE.[column in domain "BSTYP"] == T161.BSTYP` `I_ALIGNACCTASSGDPURREQCORE.PURCHASEREQUISITIONTYPE == T161.BSART` `I_ALIGNACCTASSGDPURREQCORE.PURCHASINGDOCUMENTTYPE == T161.BSART`
Number of purchasing info record Number of purchasing info record Client	`I_ALIGNACCTASSGDPURREQCORE.PURCHASINGINFORECORD == EINA.INFNR` `I_ALIGNACCTASSGDPURREQCORE.MANDT == EINA.MANDT`
Plant Client Plant Plant	`I_ALIGNACCTASSGDPURREQCORE.MANDT == T001W.MANDT` `I_ALIGNACCTASSGDPURREQCORE.PURCHASEREQUISITIONITEMPLANT == T001W.WERKS` `I_ALIGNACCTASSGDPURREQCORE.PURORDERITEMPLANT == T001W.WERKS`
Currency Key Client Currency Key Currency Key	`I_ALIGNACCTASSGDPURREQCORE.MANDT == TCURC.MANDT` `I_ALIGNACCTASSGDPURREQCORE.PURORDITMPLNTCOCODECRCY == TCURC.WAERS` `I_ALIGNACCTASSGDPURREQCORE.PURREQNITMPLNTCOCODECRCY == TCURC.WAERS`
Purchasing Group Client Purchasing Group Purchasing Group	`I_ALIGNACCTASSGDPURREQCORE.MANDT == T024.MANDT` `I_ALIGNACCTASSGDPURREQCORE.PURORDPURCHASINGGROUP == T024.EKGRP` `I_ALIGNACCTASSGDPURREQCORE.PURREQNITEMPURCHASINGGROUP == T024.EKGRP`
Purchasing organization Client Purchasing organization Purchasing organization	`I_ALIGNACCTASSGDPURREQCORE.MANDT == T024E.MANDT` `I_ALIGNACCTASSGDPURREQCORE.PURORDPURCHASINGORGANIZATION == T024E.EKORG` `I_ALIGNACCTASSGDPURREQCORE.PURREQNITEMPURCHASINGORG == T024E.EKORG`
Purchasing Group Client Purchasing Group Purchasing Group	`I_ALIGNACCTASSGDPURREQCORE.MANDT == T024.MANDT` `I_ALIGNACCTASSGDPURREQCORE.PURORDPURCHASINGGROUP == T024.EKGRP` `I_ALIGNACCTASSGDPURREQCORE.PURREQNITEMPURCHASINGGROUP == T024.EKGRP`
Purchasing organization Client Purchasing organization Purchasing organization	`I_ALIGNACCTASSGDPURREQCORE.MANDT == T024E.MANDT` `I_ALIGNACCTASSGDPURREQCORE.PURORDPURCHASINGORGANIZATION == T024E.EKORG` `I_ALIGNACCTASSGDPURREQCORE.PURREQNITEMPURCHASINGORG == T024E.EKORG`
Currency Key Client Currency Key Currency Key	`I_ALIGNACCTASSGDPURREQCORE.MANDT == TCURC.MANDT` `I_ALIGNACCTASSGDPURREQCORE.PURORDITMPLNTCOCODECRCY == TCURC.WAERS` `I_ALIGNACCTASSGDPURREQCORE.PURREQNITMPLNTCOCODECRCY == TCURC.WAERS`
Order type in order header Sales Document Type Client	`I_ALIGNACCTASSGDPURREQCORE.SALESDOCUMENTTYPE == TVAK.AUART` `I_ALIGNACCTASSGDPURREQCORE.MANDT == TVAK.MANDT`
Sales organization in order header Client Sales Organization	`I_ALIGNACCTASSGDPURREQCORE.MANDT == TVKO.MANDT` `I_ALIGNACCTASSGDPURREQCORE.SALESORGANIZATION == TVKO.VKORG`
Schedule line category Client Schedule line category	`I_ALIGNACCTASSGDPURREQCORE.MANDT == TVEP.MANDT` `I_ALIGNACCTASSGDPURREQCORE.SCHEDULELINECATEGORY == TVEP.ETTYP`
Customer - Document Customer Customer Number Sold-to Party Client	`I_ALIGNACCTASSGDPURREQCORE.SHIPTOPARTY == KNA1.KUNNR` `I_ALIGNACCTASSGDPURREQCORE.SOLDTOPARTY == KNA1.KUNNR` `I_ALIGNACCTASSGDPURREQCORE.MANDT == KNA1.MANDT`
Sold-to Party Customer Number Sold-to Party Client	`I_ALIGNACCTASSGDPURREQCORE.SHIPTOPARTY == KNA1.KUNNR` `I_ALIGNACCTASSGDPURREQCORE.SOLDTOPARTY == KNA1.KUNNR` `I_ALIGNACCTASSGDPURREQCORE.MANDT == KNA1.MANDT`