P_SlsOrdFlfmt1stLvlSDProcSqnc2

Sales Order Fulfillment First Level SD Process Sequence 2 | view: PSDSOFPROCSQSD12 | Extraction: Not supported | Component: Sales Analytics
Tables used: VBRKLIKPVBAKVBFATVAK
Column Name Description
SalesDocument Sales Document
SalesDocumentCategory SD Document Category Show values
SubsequentDocument Subsequent Sales and Distribution Document
SubsequentDocumentCategory 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
SubsequentDocumentCategory Document Category of Subsequent Document Show values
OverallSDProcessStatus Overall Processing Status (Header/All Items) Show values
OverallDeliveryStatus Delivery Status (All Items) Show values
OverallTotalDeliveryStatus Overall Delivery Status (All Items) Show values
OverallOrdReltdBillgStatus Order-Related Billing Status (All Items) Show values
OverallSDDocumentRejectionSts Rejection Status (All Items) Show values
L1OverallGoodsMovementStatus Goods Movement Status (All Items) Show values
L1OverallDelivReltdBillgStatus Delivery-Related Billing Status (All Items) Show values
L1AccountingTransferStatus Status for Transfer to Accounting Show values
L1OverallOrdReltdBillgStatus Order-Related Billing Status (All Items) Show values
L1OvrlSDDocumentRejectionSts Order-Related Billing Status (All Items) Show values
L1OverallTotalDeliveryStatus Order-Related Billing Status (All Items) Show values
L1OverallSDProcessStatus Overall Processing Status (Header/All Items) Show values
Column Name Description Domain name
SalesOrderIsProjectBased null
L1DeliveryDocumentType Delivery Type LFART
BillingDocumentIsCancelled null
L1BillingDocumentType Billing Type FKART
L1SalesDocumentType Sales Document Type AUART
Master Data Relations Join Conditions
Distribution channel in order header
  • Distribution Channel
  • Client
  • Sales Organization
  • P_SLSORDFLFMT1STLVLSDPROCSQNC2.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
  • P_SLSORDFLFMT1STLVLSDPROCSQNC2.MANDT == TVKOV.MANDT
  • P_SLSORDFLFMT1STLVLSDPROCSQNC2.SALESORGANIZATION == TVKOV.VKORG
Division in order header
  • Distribution Channel
  • Client
  • Division
  • Sales Organization
  • P_SLSORDFLFMT1STLVLSDPROCSQNC2.DISTRIBUTIONCHANNEL == TVTA.VTWEG
  • P_SLSORDFLFMT1STLVLSDPROCSQNC2.MANDT == TVTA.MANDT
  • P_SLSORDFLFMT1STLVLSDPROCSQNC2.ORGANIZATIONDIVISION == TVTA.SPART
  • P_SLSORDFLFMT1STLVLSDPROCSQNC2.SALESORGANIZATION == TVTA.VKORG
Order type in order header
  • Sales Document Type
  • Client
  • P_SLSORDFLFMT1STLVLSDPROCSQNC2.SALESDOCUMENTTYPE == TVAK.AUART
  • P_SLSORDFLFMT1STLVLSDPROCSQNC2.MANDT == TVAK.MANDT
Sales organization in order header
  • Client
  • Sales Organization
  • P_SLSORDFLFMT1STLVLSDPROCSQNC2.MANDT == TVKO.MANDT
  • P_SLSORDFLFMT1STLVLSDPROCSQNC2.SALESORGANIZATION == TVKO.VKORG
Currency in order header
  • Client
  • SD Document Currency
  • P_SLSORDFLFMT1STLVLSDPROCSQNC2.MANDT == TCURC.MANDT
  • P_SLSORDFLFMT1STLVLSDPROCSQNC2.TRANSACTIONCURRENCY == TCURC.WAERS