P_SlsDocFlfllmntAnalyzerIss1

SOFA Main List: Issues Step 1 | view: PSOFANALYSISI1 | Extraction: Not supported | Component: Sales Analytics
Tables used: VBRP, LIKP, LIPS, AFKO, AFPO, EKKO, EKPO, EKKN, EKET, EKES, VBAK, FPLT, VBAP, VBEP, VBFA, TKA01, AUFK, T000
Column Name Description
SalesOrder Sales Order
IssueCategory Issue Category Show values
Column Name Description
Column Name Description
Column Name Description
RequestedDeliveryDate Requested Delivery Date
SalesDocumentDate Document Date (Date Received/Sent)
Column Name Description
IssueCategory Issue Category Show values
Column Name Description Domain name
DueDays null
NmbrOfIssuesInOrder null
DueDaysInOrder Next Action in Days DUE_DAYS
NmbrOfIssuesInDelivery null
DueDaysInDelivery Next Action in Days DUE_DAYS
NmbrOfIssuesInInvoice null
DueDaysInInvoice Next Action in Days DUE_DAYS
NmbrOfIssuesInSupply null
DueDaysInSupply Next Action in Days DUE_DAYS
NmbrOfAllIssues null
Master Data Relations Join Conditions
Distribution channel in order header
  • Client
  • Sales Organization
  • Distribution Channel
  • P_SLSDOCFLFLLMNTANALYZERISS1.MANDT == TVKOV.MANDT
  • P_SLSDOCFLFLLMNTANALYZERISS1.SALESORGANIZATION == TVKOV.VKORG
  • P_SLSDOCFLFLLMNTANALYZERISS1.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
Division in order header
  • Division
  • Client
  • Sales Organization
  • Distribution Channel
  • P_SLSDOCFLFLLMNTANALYZERISS1.ORGANIZATIONDIVISION == TVTA.SPART
  • P_SLSDOCFLFLLMNTANALYZERISS1.MANDT == TVTA.MANDT
  • P_SLSDOCFLFLLMNTANALYZERISS1.SALESORGANIZATION == TVTA.VKORG
  • P_SLSDOCFLFLLMNTANALYZERISS1.DISTRIBUTIONCHANNEL == TVTA.VTWEG
Sales group
  • Client
  • Sales group
  • Sales office
  • P_SLSDOCFLFLLMNTANALYZERISS1.MANDT == TVBVK.MANDT
  • P_SLSDOCFLFLLMNTANALYZERISS1.SALESGROUP == TVBVK.VKGRP
  • P_SLSDOCFLFLLMNTANALYZERISS1.SALESOFFICE == TVBVK.VKBUR
Order type in order header
  • Sales Document Type
  • Client
  • P_SLSDOCFLFLLMNTANALYZERISS1.SALESORDERTYPE == TVAK.AUART
  • P_SLSDOCFLFLLMNTANALYZERISS1.MANDT == TVAK.MANDT
Sales organization in order header
  • Client
  • Sales Organization
  • P_SLSDOCFLFLLMNTANALYZERISS1.MANDT == TVKO.MANDT
  • P_SLSDOCFLFLLMNTANALYZERISS1.SALESORGANIZATION == TVKO.VKORG
Sold-to Party
  • Sold-to Party
  • Client
  • P_SLSDOCFLFLLMNTANALYZERISS1.SOLDTOPARTY == KNA1.KUNNR
  • P_SLSDOCFLFLLMNTANALYZERISS1.MANDT == KNA1.MANDT
Other Relations | to Master Data Relations ↑ Join Conditions
Sales office
  • Division
  • Client
  • Sales office
  • Sales Organization
  • Distribution Channel
  • P_SLSDOCFLFLLMNTANALYZERISS1.ORGANIZATIONDIVISION == TVKBZ.SPART
  • P_SLSDOCFLFLLMNTANALYZERISS1.MANDT == TVKBZ.MANDT
  • P_SLSDOCFLFLLMNTANALYZERISS1.SALESOFFICE == TVKBZ.VKBUR
  • P_SLSDOCFLFLLMNTANALYZERISS1.SALESORGANIZATION == TVKBZ.VKORG
  • P_SLSDOCFLFLLMNTANALYZERISS1.DISTRIBUTIONCHANNEL == TVKBZ.VTWEG