P_SlsOrdFlfmt2ndLvlSDProcSqnc1

Sales Order Fulfillment Second Level SD Process Sequence 1 | view: PSDSOFPROCSQSD21 | Extraction: Not supported | Component: Sales Analytics
Tables used: VBRKLIKPVBAKVBFATVAK
Column Name Description
SalesDocument Sales Document
SalesDocumentCategory SD Document Category Show values
L1SubsequentDoc Subsequent Sales and Distribution Document
L1SubsequentDocCat Document Category of Subsequent Document Show values
L2SubsequentDoc Subsequent Sales and Distribution Document
L2SubsequentDocCat Document Category of Subsequent Document Show values
Column Name Description
💲 SD Document Currency (TransactionCurrency):
TotalNetAmount Net Value of the Sales Order in Document Currency
Column Name Description
Column Name Description
Column Name Description
SalesDocumentCategory SD Document Category Show values
L1SubsequentDocCat Document Category of Subsequent Document Show values
L2SubsequentDocCat Document Category of Subsequent Document Show values
L0OverallSDProcessStatus Overall Processing Status (Header/All Items) Show values
OverallSDDocumentRejectionSts Rejection Status (All Items) Show values
L0OverallDeliveryStatus Delivery Status (All Items) Show values
OverallTotalDeliveryStatus Overall Delivery Status (All Items) Show values
L0OverallOrdReltdBillgStatus Order-Related Billing Status (All Items) Show values
L1OverallSDProcessStatus Overall Processing Status (Header/All Items) Show values
L1OverallGoodsMovementStatus Goods Movement Status (All Items) Show values
L1OverallDelivReltdBillgStatus Delivery-Related Billing Status (All Items) Show values
L1OverallOrdReltdBillgStatus Order-Related Billing Status (All Items) Show values
L1AccountingTransferStatus Status for Transfer to Accounting Show values
L2OverallSDProcessStatus Overall Processing Status (Header/All Items) Show values
L2AccountingTransferStatus Status for Transfer to Accounting Show values
Column Name Description Domain name
SalesOrderIsProjectBased null
L1BillingDocumentType Billing Type FKART
L1DeliveryDocumentType Delivery Type LFART
L1SalesDocumentType Sales Document Type AUART
L2BillingDocumentType Billing Type FKART
L2BillgDocIsCancelled null
Master Data Relations Join Conditions
Distribution channel in order header
  • Client
  • Sales Organization
  • Distribution Channel
  • P_SLSORDFLFMT2NDLVLSDPROCSQNC1.MANDT == TVKOV.MANDT
  • P_SLSORDFLFMT2NDLVLSDPROCSQNC1.SALESORGANIZATION == TVKOV.VKORG
  • P_SLSORDFLFMT2NDLVLSDPROCSQNC1.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
Division in order header
  • Client
  • Division
  • Sales Organization
  • Distribution Channel
  • P_SLSORDFLFMT2NDLVLSDPROCSQNC1.MANDT == TVTA.MANDT
  • P_SLSORDFLFMT2NDLVLSDPROCSQNC1.ORGANIZATIONDIVISION == TVTA.SPART
  • P_SLSORDFLFMT2NDLVLSDPROCSQNC1.SALESORGANIZATION == TVTA.VKORG
  • P_SLSORDFLFMT2NDLVLSDPROCSQNC1.DISTRIBUTIONCHANNEL == TVTA.VTWEG
Order type in order header
  • Sales Document Type
  • Client
  • P_SLSORDFLFMT2NDLVLSDPROCSQNC1.SALESDOCUMENTTYPE == TVAK.AUART
  • P_SLSORDFLFMT2NDLVLSDPROCSQNC1.MANDT == TVAK.MANDT
Sales organization in order header
  • Client
  • Sales Organization
  • P_SLSORDFLFMT2NDLVLSDPROCSQNC1.MANDT == TVKO.MANDT
  • P_SLSORDFLFMT2NDLVLSDPROCSQNC1.SALESORGANIZATION == TVKO.VKORG
Currency in order header
  • SD Document Currency
  • Client
  • P_SLSORDFLFMT2NDLVLSDPROCSQNC1.TRANSACTIONCURRENCY == TCURC.WAERS
  • P_SLSORDFLFMT2NDLVLSDPROCSQNC1.MANDT == TCURC.MANDT