P_SlsDocFlfllmntAnalyzer2

SOFA Main List Step 2 | view: PSOFANALYSIS2 | Extraction: Not supported | Component: Sales Analytics
Tables used: BKPFVBRKLIKPAFKOAFPOEKKOEKPOEKKNVBKDVEDAVBAKVBFABSEGEKKOEKPOT001TKA02TKA01AUFKT000PRPST001T014
Column Name Description
SalesDocument Sales Document
SDDocumentCategory SD Document 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
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
  • Sales Organization
  • Distribution Channel
  • P_SLSDOCFLFLLMNTANALYZER2.MANDT == TVKOV.MANDT
  • P_SLSDOCFLFLLMNTANALYZER2.SALESORGANIZATION == TVKOV.VKORG
  • P_SLSDOCFLFLLMNTANALYZER2.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
Division in order header
  • Client
  • Sales Organization
  • Distribution Channel
  • Division
  • P_SLSDOCFLFLLMNTANALYZER2.MANDT == TVTA.MANDT
  • P_SLSDOCFLFLLMNTANALYZER2.SALESORGANIZATION == TVTA.VKORG
  • P_SLSDOCFLFLLMNTANALYZER2.DISTRIBUTIONCHANNEL == TVTA.VTWEG
  • P_SLSDOCFLFLLMNTANALYZER2.ORGANIZATIONDIVISION == TVTA.SPART
Order type in order header
  • Client
  • Sales Document Type
  • P_SLSDOCFLFLLMNTANALYZER2.MANDT == TVAK.MANDT
  • P_SLSDOCFLFLLMNTANALYZER2.SALESDOCUMENTTYPE == TVAK.AUART
Sales group
  • Client
  • Sales office
  • Sales group
  • P_SLSDOCFLFLLMNTANALYZER2.MANDT == TVBVK.MANDT
  • P_SLSDOCFLFLLMNTANALYZER2.SALESOFFICE == TVBVK.VKBUR
  • P_SLSDOCFLFLLMNTANALYZER2.SALESGROUP == TVBVK.VKGRP
Sales organization in order header
  • Client
  • Sales Organization
  • P_SLSDOCFLFLLMNTANALYZER2.MANDT == TVKO.MANDT
  • P_SLSDOCFLFLLMNTANALYZER2.SALESORGANIZATION == TVKO.VKORG
Sold-to Party
  • Client
  • Sold-to Party
  • P_SLSDOCFLFLLMNTANALYZER2.MANDT == KNA1.MANDT
  • P_SLSDOCFLFLLMNTANALYZER2.SOLDTOPARTY == KNA1.KUNNR
Other Relations | to Master Data Relations ↑ Join Conditions
Sales office
  • Client
  • Sales office
  • Sales Organization
  • Distribution Channel
  • Division
  • P_SLSDOCFLFLLMNTANALYZER2.MANDT == TVKBZ.MANDT
  • P_SLSDOCFLFLLMNTANALYZER2.SALESOFFICE == TVKBZ.VKBUR
  • P_SLSDOCFLFLLMNTANALYZER2.SALESORGANIZATION == TVKBZ.VKORG
  • P_SLSDOCFLFLLMNTANALYZER2.DISTRIBUTIONCHANNEL == TVKBZ.VTWEG
  • P_SLSDOCFLFLLMNTANALYZER2.ORGANIZATIONDIVISION == TVKBZ.SPART