I_AlignAcctAssgdSlsPurItm

AA Sales and PR line item for alignment | view: IALIGNAASLPURITM | Extraction: Not supported | Component: Purchasing

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

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

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

Column Name	Description

Column Name	Description
📏 Purchase requisition unit of measure (PurchaseRequisitionUnit):
RequestedQuantity	Purchase requisition quantity
ReqnItmContrItmOpnQtyInBaseUoM	null

Column Name	Description
DeliveryDate	Item delivery date
CreationDate	Date on which the record was created
FashionCancelDate	Cancellation Date

Column Name	Description
ProductCategory	Material Category	Show values

Column Name	Description	Domain name
ProductCategoryName	Product Category Text	DDTEXT
PurchaseReqnItemStockSegment	Stock Segment	SGT_SRCA
SalesOrder	Sales and Distribution Document Number	VBELN
SalesOrderItem	Sales Document Item	POSNR
ContractItemQtyToBaseQtyNmrtr	Numerator for Conversion of Order Unit to Base Unit	UMBSZ
ContractItemQtyToBaseQtyDnmntr	Denominator for Conversion of Order Unit to Base Unit	UMBSN
Product	Material Number	MATNR
BillOfMaterial	Bill of Material	STNUM
ProductName	Product Description	TEXT40
HigherLevelItem	Higher-Level Item in Bill of Material Structures	POSNR
SalesAccountAssignmentType	Single-Character Flag	CHAR1
ProductCharacteristic1	Characteristic Value for Colors of Variants	WRF_ATWRT
ProductCharacteristic1Desc	Characteristic value description	ATWRT
ProductCharacteristic2	Characteristic Value for Main Sizes of Variants	WRF_ATWRT
ProductCharacteristic2Desc	Characteristic value description	ATWRT
ProductCharacteristic3	Characteristic Value for Second Size for Variants	WRF_ATWRT
ProductCharacteristic3Desc	Characteristic value description	ATWRT
OrganizationBPName1	Name 1	NAME

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

Other Relations \| to Master Data Relations ↑	Join Conditions
Sales office Client Division Sales Organization Distribution Channel Sales office	`I_ALIGNACCTASSGDSLSPURITM.MANDT == TVKBZ.MANDT` `I_ALIGNACCTASSGDSLSPURITM.ORGANIZATIONDIVISION == TVKBZ.SPART` `I_ALIGNACCTASSGDSLSPURITM.SALESORGANIZATION == TVKBZ.VKORG` `I_ALIGNACCTASSGDSLSPURITM.DISTRIBUTIONCHANNEL == TVKBZ.VTWEG` `I_ALIGNACCTASSGDSLSPURITM.SALESOFFICE == TVKBZ.VKBUR`