P_SlsDocFlfllmntAnalyzer1

SOFA Main List Step 1 | view: PSOFANALYSIS1 | Extraction: Not supported | Component: Sales Analytics
Tables used: BKPF, VBRK, LIKP, AFKO, AFPO, EKKO, EKPO, EKKN, VBKD, VEDA, VBAK, VBFA, BSEG, EKKO, EKPO, T001, TKA02, TKA01, AUFK, T000, PRPS, T001, T014
Column Name Description
SalesDocument Sales Document
SDDocumentCategory SD Document Category Show values
SubsequentDocument Subsequent Document
SubsequentDocumentCategory Category of the subsequent document
Column Name Description
Column Name Description
Column Name Description
RequestedDeliveryDate Requested Delivery Date
SalesDocumentDate Document Date (Date Received/Sent)
Column Name Description
SDDocumentCategory SD Document Category Show values
OverallSDProcessStatus Overall Processing Status (Header/All Items) Show values
OverallTotalDeliveryStatus Overall Delivery Status (All Items) Show values
OverallOrdReltdBillgStatus Order-Related Billing Status (All Items) Show values
Column Name Description Domain name
PurchaseOrderByCustomer Customer Reference BSTKD
NbrOfDeliveryGMStatusA 2 Byte Signed Integer INT2
NbrOfDeliveryGMStatusB 2 Byte Signed Integer INT2
NbrOfDeliveryGMStatusC 2 Byte Signed Integer INT2
NbrOfDeliveryPODStatusA 2 Byte Signed Integer INT2
NbrOfDeliveryPODStatusB 2 Byte Signed Integer INT2
NbrOfDeliveryPODStatusC 2 Byte Signed Integer INT2
NbrOfDeliveryInvoiceStatusA 2 Byte Signed Integer INT2
NbrOfDeliveryInvoiceStatusB 2 Byte Signed Integer INT2
NbrOfDeliveryInvoiceStatusC 2 Byte Signed Integer INT2
NbrOfDebitMemoReqOvrlSDStsA 2 Byte Signed Integer INT2
NbrOfDebitMemoReqOvrlSDStsB 2 Byte Signed Integer INT2
NbrOfDebitMemoReqOvrlSDStsC 2 Byte Signed Integer INT2
NbrOfInvAccStatusD 2 Byte Signed Integer INT2
NbrOfInvAccStatusA 2 Byte Signed Integer INT2
NbrOfInvAccStatusC 2 Byte Signed Integer INT2
NbrOfDebitorLinesOpen 2 Byte Signed Integer INT2
NbrOfDebitorLinesCleared 2 Byte Signed Integer INT2
NbrOfPurchseOrderLinesOpen 2 Byte Signed Integer INT2
NbrOfPurchseOrderLinesCmplt 2 Byte Signed Integer INT2
NbrOfMfgOrdersOpen 2 Byte Signed Integer INT2
NbrOfMfgOrdersCmplt 2 Byte Signed Integer INT2
Master Data Relations Join Conditions
Distribution channel in order header
  • Client
  • Distribution Channel
  • Sales Organization
  • P_SLSDOCFLFLLMNTANALYZER1.MANDT == TVKOV.MANDT
  • P_SLSDOCFLFLLMNTANALYZER1.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
  • P_SLSDOCFLFLLMNTANALYZER1.SALESORGANIZATION == TVKOV.VKORG
Division in order header
  • Client
  • Division
  • Distribution Channel
  • Sales Organization
  • P_SLSDOCFLFLLMNTANALYZER1.MANDT == TVTA.MANDT
  • P_SLSDOCFLFLLMNTANALYZER1.ORGANIZATIONDIVISION == TVTA.SPART
  • P_SLSDOCFLFLLMNTANALYZER1.DISTRIBUTIONCHANNEL == TVTA.VTWEG
  • P_SLSDOCFLFLLMNTANALYZER1.SALESORGANIZATION == TVTA.VKORG
Order type in order header
  • Sales Document Type
  • Client
  • P_SLSDOCFLFLLMNTANALYZER1.SALESDOCUMENTTYPE == TVAK.AUART
  • P_SLSDOCFLFLLMNTANALYZER1.MANDT == TVAK.MANDT
Sales group
  • Client
  • Sales office
  • Sales group
  • P_SLSDOCFLFLLMNTANALYZER1.MANDT == TVBVK.MANDT
  • P_SLSDOCFLFLLMNTANALYZER1.SALESOFFICE == TVBVK.VKBUR
  • P_SLSDOCFLFLLMNTANALYZER1.SALESGROUP == TVBVK.VKGRP
Sales organization in order header
  • Client
  • Sales Organization
  • P_SLSDOCFLFLLMNTANALYZER1.MANDT == TVKO.MANDT
  • P_SLSDOCFLFLLMNTANALYZER1.SALESORGANIZATION == TVKO.VKORG
Sold-to Party
  • Client
  • Sold-to Party
  • P_SLSDOCFLFLLMNTANALYZER1.MANDT == KNA1.MANDT
  • P_SLSDOCFLFLLMNTANALYZER1.SOLDTOPARTY == KNA1.KUNNR
Other Relations | to Master Data Relations ↑ Join Conditions
Sales office
  • Client
  • Division
  • Sales office
  • Distribution Channel
  • Sales Organization
  • P_SLSDOCFLFLLMNTANALYZER1.MANDT == TVKBZ.MANDT
  • P_SLSDOCFLFLLMNTANALYZER1.ORGANIZATIONDIVISION == TVKBZ.SPART
  • P_SLSDOCFLFLLMNTANALYZER1.SALESOFFICE == TVKBZ.VKBUR
  • P_SLSDOCFLFLLMNTANALYZER1.DISTRIBUTIONCHANNEL == TVKBZ.VTWEG
  • P_SLSDOCFLFLLMNTANALYZER1.SALESORGANIZATION == TVKBZ.VKORG