I_SalesOrdInDelivTrdCmplncIss

SOFM Trade Compliance Issue In Delivery | view: ISOFISSUEDE07 | Extraction: Not supported | Component: Sales Analytics
Tables used: LIKP, LIPS, VBAK
Column Name Description
SalesOrder Sales Document
DeliveryDocument FK Delivery
DeliveryDocumentItem Delivery Item
Column Name Description
Column Name Description
Column Name Description
RequestedDeliveryDate Requested Delivery Date
SalesDocumentDate Document Date (Date Received/Sent)
Column Name Description
Issue Issue Show values
IssueCategory Issue Category Show values
OverallSDProcessStatus Overall Processing Status (Header/All Items) Show values
Column Name Description Domain name
DueDays Next Action in Days DUE_DAYS
NmbrOfItemsInDelivery Item Issues in Delivery ITEMS_IN_DELIVERY
Master Data Relations Join Conditions
Distribution channel in order header
  • Sales Organization
  • Distribution Channel
  • Client
  • I_SALESORDINDELIVTRDCMPLNCISS.SALESORGANIZATION == TVKOV.VKORG
  • I_SALESORDINDELIVTRDCMPLNCISS.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
  • I_SALESORDINDELIVTRDCMPLNCISS.MANDT == TVKOV.MANDT
Division in order header
  • Division
  • Sales Organization
  • Distribution Channel
  • Client
  • I_SALESORDINDELIVTRDCMPLNCISS.ORGANIZATIONDIVISION == TVTA.SPART
  • I_SALESORDINDELIVTRDCMPLNCISS.SALESORGANIZATION == TVTA.VKORG
  • I_SALESORDINDELIVTRDCMPLNCISS.DISTRIBUTIONCHANNEL == TVTA.VTWEG
  • I_SALESORDINDELIVTRDCMPLNCISS.MANDT == TVTA.MANDT
Sales group
  • Sales group
  • Client
  • Sales office
  • I_SALESORDINDELIVTRDCMPLNCISS.SALESGROUP == TVBVK.VKGRP
  • I_SALESORDINDELIVTRDCMPLNCISS.MANDT == TVBVK.MANDT
  • I_SALESORDINDELIVTRDCMPLNCISS.SALESOFFICE == TVBVK.VKBUR
Order type in order header
  • Sales Document Type
  • Client
  • I_SALESORDINDELIVTRDCMPLNCISS.SALESORDERTYPE == TVAK.AUART
  • I_SALESORDINDELIVTRDCMPLNCISS.MANDT == TVAK.MANDT
Sales organization in order header
  • Sales Organization
  • Client
  • I_SALESORDINDELIVTRDCMPLNCISS.SALESORGANIZATION == TVKO.VKORG
  • I_SALESORDINDELIVTRDCMPLNCISS.MANDT == TVKO.MANDT
Sold-to Party
  • Sold-to Party
  • Client
  • I_SALESORDINDELIVTRDCMPLNCISS.SOLDTOPARTY == KNA1.KUNNR
  • I_SALESORDINDELIVTRDCMPLNCISS.MANDT == KNA1.MANDT
Other Relations | to Master Data Relations ↑ Join Conditions
Sales office
  • Division
  • Sales Organization
  • Distribution Channel
  • Client
  • Sales office
  • I_SALESORDINDELIVTRDCMPLNCISS.ORGANIZATIONDIVISION == TVKBZ.SPART
  • I_SALESORDINDELIVTRDCMPLNCISS.SALESORGANIZATION == TVKBZ.VKORG
  • I_SALESORDINDELIVTRDCMPLNCISS.DISTRIBUTIONCHANNEL == TVKBZ.VTWEG
  • I_SALESORDINDELIVTRDCMPLNCISS.MANDT == TVKBZ.MANDT
  • I_SALESORDINDELIVTRDCMPLNCISS.SALESOFFICE == TVKBZ.VKBUR