I_AlignAcctAssgdSlsItmSl

Acct assg SO line item with sch. lines | view: IALIGNAASLSITMSL | Extraction: Not supported | Component: Purchasing
Tables used: VBAK, VBAP, VBEP, VBPA, VBPA, MARA, TVEP, CVI_CUST_CT_LINK, BUT000, KNA1, CVI_CUST_LINK, MARA, MARA, MAKT, CVI_VEND_LINK
Column Name Description
SalesDocument FK Sales Document
SalesDocumentItem Sales Document Item
ScheduleLine Schedule Line Number
Column Name Description
Column Name Description
Column Name Description
CreationDate Date on which the record was created
FashionCancelDate Cancellation Date
Column Name Description
ProductCategory Product Category Show values
AlignmentProductCategory Product Category Show values
Column Name Description Domain name
BillOfMaterial Bill of Material STNUM
OrganizationBPName1 Name 1 NAME
Product Material Number MATNR
ProductName Product Description TEXT40
HigherLevelItem Higher-Level Item in Bill of Material Structures POSNR
SalesAccountAssignmentType Single-Character Flag CHAR1
ProdCharc1InternalNumber Internal Charactieristic Number for Color Characteristics ATINN
ProductCharacteristic1 Characteristic Value for Colors of Variants WRF_ATWRT
ProductCharacteristic2 Characteristic Value for Main Sizes of Variants WRF_ATWRT
ProdCharc2InternalNumber Internal Char. Number for Characteristics for Main Sizes ATINN
ProductCharacteristic3 Characteristic Value for Second Size for Variants WRF_ATWRT
ProdCharc3InternalNumber Internal Char. Number for Characteristics for Second Sizes ATINN
Master Data Relations Join Conditions
Cross-Plant Configurable Material
  • Client
  • Cross-Plant Configurable Material
  • I_ALIGNACCTASSGDSLSITMSL.MANDT == MARA.MANDT
  • I_ALIGNACCTASSGDSLSITMSL.CROSSPLANTCONFIGURABLEPRODUCT == MARA.MATNR
Delivery Priority
  • Client
  • Delivery Priority
  • I_ALIGNACCTASSGDSLSITMSL.MANDT == TPRIO.MANDT
  • I_ALIGNACCTASSGDSLSITMSL.DELIVERYPRIORITY == TPRIO.LPRIO
Distribution channel in order header
  • Client
  • Sales Organization
  • Distribution Channel
  • I_ALIGNACCTASSGDSLSITMSL.MANDT == TVKOV.MANDT
  • I_ALIGNACCTASSGDSLSITMSL.SALESORGANIZATION == TVKOV.VKORG
  • I_ALIGNACCTASSGDSLSITMSL.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
Division in order header
  • Division
  • Client
  • Sales Organization
  • Distribution Channel
  • I_ALIGNACCTASSGDSLSITMSL.ORGANIZATIONDIVISION == TVTA.SPART
  • I_ALIGNACCTASSGDSLSITMSL.MANDT == TVTA.MANDT
  • I_ALIGNACCTASSGDSLSITMSL.SALESORGANIZATION == TVTA.VKORG
  • I_ALIGNACCTASSGDSLSITMSL.DISTRIBUTIONCHANNEL == TVTA.VTWEG
Material: order item
  • Material Number
  • Material Number
  • Client
  • I_ALIGNACCTASSGDSLSITMSL.PRODUCT == MARA.MATNR
  • I_ALIGNACCTASSGDSLSITMSL.PRODUCTOFHIGHERLEVELITEM == MARA.MATNR
  • I_ALIGNACCTASSGDSLSITMSL.MANDT == MARA.MANDT
Order type in order header
  • Client
  • Sales Document Type
  • I_ALIGNACCTASSGDSLSITMSL.MANDT == TVAK.MANDT
  • I_ALIGNACCTASSGDSLSITMSL.SALESDOCUMENTTYPE == TVAK.AUART
Sales organization in order header
  • Client
  • Sales Organization
  • I_ALIGNACCTASSGDSLSITMSL.MANDT == TVKO.MANDT
  • I_ALIGNACCTASSGDSLSITMSL.SALESORGANIZATION == TVKO.VKORG
Schedule line category
  • Schedule line category
  • Client
  • I_ALIGNACCTASSGDSLSITMSL.SCHEDULELINECATEGORY == TVEP.ETTYP
  • I_ALIGNACCTASSGDSLSITMSL.MANDT == TVEP.MANDT
Order Reason (Reason for the Business Transaction)
  • Order Reason (Reason for the Business Transaction)
  • Client
  • I_ALIGNACCTASSGDSLSITMSL.SDDOCUMENTREASON == TVAU.AUGRU
  • I_ALIGNACCTASSGDSLSITMSL.MANDT == TVAU.MANDT
Customer - Document Customer
  • Customer Number
  • Sold-to Party
  • Client
  • I_ALIGNACCTASSGDSLSITMSL.SHIPTOPARTY == KNA1.KUNNR
  • I_ALIGNACCTASSGDSLSITMSL.SOLDTOPARTY == KNA1.KUNNR
  • I_ALIGNACCTASSGDSLSITMSL.MANDT == KNA1.MANDT
Sold-to Party
  • Customer Number
  • Sold-to Party
  • Client
  • I_ALIGNACCTASSGDSLSITMSL.SHIPTOPARTY == KNA1.KUNNR
  • I_ALIGNACCTASSGDSLSITMSL.SOLDTOPARTY == KNA1.KUNNR
  • I_ALIGNACCTASSGDSLSITMSL.MANDT == KNA1.MANDT
Other Relations | to Master Data Relations ↑ Join Conditions
Sales office
  • Division
  • Client
  • Sales Organization
  • Sales office
  • Distribution Channel
  • I_ALIGNACCTASSGDSLSITMSL.ORGANIZATIONDIVISION == TVKBZ.SPART
  • I_ALIGNACCTASSGDSLSITMSL.MANDT == TVKBZ.MANDT
  • I_ALIGNACCTASSGDSLSITMSL.SALESORGANIZATION == TVKBZ.VKORG
  • I_ALIGNACCTASSGDSLSITMSL.SALESOFFICE == TVKBZ.VKBUR
  • I_ALIGNACCTASSGDSLSITMSL.DISTRIBUTIONCHANNEL == TVKBZ.VTWEG