I_AlignSlsOrdHdrItm

Sales Order Header Item | view: IALIGNSOHDRITM | Extraction: Not supported | Component: Purchasing
Tables used: VBAK, VBAP, VBPA, CVI_CUST_CT_LINK, BUT000, KNA1, CVI_CUST_LINK, MARA, CVI_VEND_LINK
Column Name Description
SalesDocument FK Sales Document
SalesDocumentItem Sales Document Item
Column Name Description
Column Name Description
Column Name Description
CreationDate Date on which the record was created
FashionCancelDate Cancellation Date
Column Name Description
SDDocumentCategory SD Document Category Show values
Column Name Description Domain name
BillOfMaterial Bill of Material STNUM
OrganizationBPName1 Name 1 NAME
Product Material Number MATNR
HigherLevelItem Higher-Level Item in Bill of Material Structures POSNR
ProductCharacteristic1 Characteristic Value 1 WRF_CHARSTC
ProductCharacteristic2 Characteristic Value 2 WRF_CHARSTC
ProductCharacteristic3 Characteristic Value 3 WRF_CHARSTC
Master Data Relations Join Conditions
Cross-Plant Configurable Material
  • Cross-Plant Configurable Material
  • Client
  • I_ALIGNSLSORDHDRITM.CROSSPLANTCONFIGURABLEPRODUCT == MARA.MATNR
  • I_ALIGNSLSORDHDRITM.MANDT == MARA.MANDT
Delivery Priority
  • Delivery Priority
  • Client
  • I_ALIGNSLSORDHDRITM.DELIVERYPRIORITY == TPRIO.LPRIO
  • I_ALIGNSLSORDHDRITM.MANDT == TPRIO.MANDT
Distribution channel in order header
  • Distribution Channel
  • Client
  • Sales Organization
  • I_ALIGNSLSORDHDRITM.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
  • I_ALIGNSLSORDHDRITM.MANDT == TVKOV.MANDT
  • I_ALIGNSLSORDHDRITM.SALESORGANIZATION == TVKOV.VKORG
Division in order header
  • Division
  • Distribution Channel
  • Client
  • Sales Organization
  • I_ALIGNSLSORDHDRITM.ORGANIZATIONDIVISION == TVTA.SPART
  • I_ALIGNSLSORDHDRITM.DISTRIBUTIONCHANNEL == TVTA.VTWEG
  • I_ALIGNSLSORDHDRITM.MANDT == TVTA.MANDT
  • I_ALIGNSLSORDHDRITM.SALESORGANIZATION == TVTA.VKORG
Material: order item
  • Material Number
  • Material Number
  • Client
  • I_ALIGNSLSORDHDRITM.PRODUCT == MARA.MATNR
  • I_ALIGNSLSORDHDRITM.PRODUCTOFHIGHERLEVELITEM == MARA.MATNR
  • I_ALIGNSLSORDHDRITM.MANDT == MARA.MANDT
Order type in order header
  • Sales Document Type
  • Client
  • I_ALIGNSLSORDHDRITM.SALESDOCUMENTTYPE == TVAK.AUART
  • I_ALIGNSLSORDHDRITM.MANDT == TVAK.MANDT
Sales organization in order header
  • Client
  • Sales Organization
  • I_ALIGNSLSORDHDRITM.MANDT == TVKO.MANDT
  • I_ALIGNSLSORDHDRITM.SALESORGANIZATION == TVKO.VKORG
Order Reason (Reason for the Business Transaction)
  • Order Reason (Reason for the Business Transaction)
  • Client
  • I_ALIGNSLSORDHDRITM.SDDOCUMENTREASON == TVAU.AUGRU
  • I_ALIGNSLSORDHDRITM.MANDT == TVAU.MANDT
Customer - Document Customer
  • Customer Number
  • Sold-to Party
  • Client
  • I_ALIGNSLSORDHDRITM.SHIPTOPARTY == KNA1.KUNNR
  • I_ALIGNSLSORDHDRITM.SOLDTOPARTY == KNA1.KUNNR
  • I_ALIGNSLSORDHDRITM.MANDT == KNA1.MANDT
Sold-to Party
  • Customer Number
  • Sold-to Party
  • Client
  • I_ALIGNSLSORDHDRITM.SHIPTOPARTY == KNA1.KUNNR
  • I_ALIGNSLSORDHDRITM.SOLDTOPARTY == KNA1.KUNNR
  • I_ALIGNSLSORDHDRITM.MANDT == KNA1.MANDT
Other Relations | to Master Data Relations ↑ Join Conditions
Sales office
  • Division
  • Distribution Channel
  • Client
  • Sales office
  • Sales Organization
  • I_ALIGNSLSORDHDRITM.ORGANIZATIONDIVISION == TVKBZ.SPART
  • I_ALIGNSLSORDHDRITM.DISTRIBUTIONCHANNEL == TVKBZ.VTWEG
  • I_ALIGNSLSORDHDRITM.MANDT == TVKBZ.MANDT
  • I_ALIGNSLSORDHDRITM.SALESOFFICE == TVKBZ.VKBUR
  • I_ALIGNSLSORDHDRITM.SALESORGANIZATION == TVKBZ.VKORG