I_SalesOrderInDelivIncomplete

SOFM Incompleteness In Delivery | view: ISOFISSUEDE03 | Extraction: Not supported | Component: Sales Analytics
Tables used: LIKP, LIPS, VBAK
Column Name Description
SalesOrder Sales Order
DeliveryDocument FK Outbound Delivery
DeliveryDocumentItem Outbound 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
  • Client
  • Sales Organization
  • Distribution Channel
  • I_SALESORDERINDELIVINCOMPLETE.MANDT == TVKOV.MANDT
  • I_SALESORDERINDELIVINCOMPLETE.SALESORGANIZATION == TVKOV.VKORG
  • I_SALESORDERINDELIVINCOMPLETE.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
Division in order header
  • Division
  • Client
  • Sales Organization
  • Distribution Channel
  • I_SALESORDERINDELIVINCOMPLETE.ORGANIZATIONDIVISION == TVTA.SPART
  • I_SALESORDERINDELIVINCOMPLETE.MANDT == TVTA.MANDT
  • I_SALESORDERINDELIVINCOMPLETE.SALESORGANIZATION == TVTA.VKORG
  • I_SALESORDERINDELIVINCOMPLETE.DISTRIBUTIONCHANNEL == TVTA.VTWEG
Sales group
  • Sales group
  • Sales office
  • Client
  • I_SALESORDERINDELIVINCOMPLETE.SALESGROUP == TVBVK.VKGRP
  • I_SALESORDERINDELIVINCOMPLETE.SALESOFFICE == TVBVK.VKBUR
  • I_SALESORDERINDELIVINCOMPLETE.MANDT == TVBVK.MANDT
Order type in order header
  • Sales Document Type
  • Client
  • I_SALESORDERINDELIVINCOMPLETE.SALESORDERTYPE == TVAK.AUART
  • I_SALESORDERINDELIVINCOMPLETE.MANDT == TVAK.MANDT
Sales organization in order header
  • Client
  • Sales Organization
  • I_SALESORDERINDELIVINCOMPLETE.MANDT == TVKO.MANDT
  • I_SALESORDERINDELIVINCOMPLETE.SALESORGANIZATION == TVKO.VKORG
Sold-to Party
  • Sold-to Party
  • Client
  • I_SALESORDERINDELIVINCOMPLETE.SOLDTOPARTY == KNA1.KUNNR
  • I_SALESORDERINDELIVINCOMPLETE.MANDT == KNA1.MANDT
Other Relations | to Master Data Relations ↑ Join Conditions
Sales office
  • Division
  • Sales office
  • Client
  • Sales Organization
  • Distribution Channel
  • I_SALESORDERINDELIVINCOMPLETE.ORGANIZATIONDIVISION == TVKBZ.SPART
  • I_SALESORDERINDELIVINCOMPLETE.SALESOFFICE == TVKBZ.VKBUR
  • I_SALESORDERINDELIVINCOMPLETE.MANDT == TVKBZ.MANDT
  • I_SALESORDERINDELIVINCOMPLETE.SALESORGANIZATION == TVKBZ.VKORG
  • I_SALESORDERINDELIVINCOMPLETE.DISTRIBUTIONCHANNEL == TVKBZ.VTWEG