C_SlsDocFlfmtIssue

Sales Order Fulfillment Issues | view: CSOFISSUE | Extraction: Not supported | Component: Sales Analytics
Tables used: VBRP, SCAL_TT_DATE, LIKP, LIPS, AFKO, AFPO, EKKO, EKPO, EKKN, EKET, EKES, VBKD, VEDA, VBAK, FPLT, VBAP, VBEP, VBFA, /CPD/D_MP_HDR, /CPD/D_MP_HDR_S, /CPD/D_MP_ITEM, VBPA, ADCP, ADRC, CVI_CUST_CT_LINK, BUT000, TKA01, T014, UKM_KKBER2SGM, KNA1, CVI_CUST_LINK, AUFK, T000, CVI_VEND_LINK, USR21, PROJ
Column Name Description
SalesDocument Sales Document
DeliveryDocument Outbound Delivery
BillingDocument Billing Document
PurchasingDocument Purchase Order Number
ManufacturingOrder Manufacturing Order ID
Issue Issue Show values
Column Name Description
💲 SD Document Currency (TransactionCurrency):
TotalNetAmount Net Value of the Sales Order in Document Currency
💲 Statistics Currency (StatisticsCurrency):
TotalNetAmountInStatisticsCrcy Net Amount in Statistics Currency
Column Name Description
Column Name Description
SalesDocumentDate Document Date (Date Received/Sent)
RequestedDeliveryDate Requested Delivery Date
Column Name Description
Issue Issue Show values
IssueCategory Issue Category Show values
DueDateStatus Due Date Status Show values
IsPotentialFutureIssue Potential Issue Show values
SalesDocumentProcessingType SD document indicator Show values
SDDocumentCategory SD Document Category Show values
SoldToPartyIsOneTimeAccount Is the sold-to party a one-time account? Show values
ShipToPartyIsOneTimeAccount Is the ship-to party a one-time account? Show values
OverallPurchaseConfStatus Purchasing Confirmation Status (All Items) Show values
HdrGeneralIncompletionStatus Incompletion Status (Header) Show values
HeaderDelivIncompletionStatus Delivery Incompletion Status (Header) Show values
OverallPricingIncompletionSts Pricing Incompletion Status (All Items) Show values
HeaderBillgIncompletionStatus Billing Incompletion Status (Header) Show values
OvrlItmGeneralIncompletionSts Incompletion Status (All Items) Show values
OvrlItmBillingIncompletionSts Billing Incompletion Status (All Items) Show values
OvrlItmDelivIncompletionSts Delivery Incompletion Status (All Items) Show values
PaytAuthsnCreditCheckSts Status of Credit Check Against Payment Card Authorization Show values
SalesDocApprovalStatus Document Approval Status Show values
OverallChmlCmplncStatus Product Marketability Status (All Items) Show values
OverallDangerousGoodsStatus Dangerous Goods Status (All Items) Show values
OverallSafetyDataSheetStatus Safety Data Sheet Status (All Items) Show values
OverallTrdCmplncEmbargoSts Embargo Status (All Items) Show values
OvrlTrdCmplncSnctndListChkSts Screening Status (All Items) Show values
OvrlTrdCmplncLegalCtrlChkSts Legal Control Status (All Items) Show values
Column Name Description Domain name
DueDays Next Action in Days DUE_DAYS
DueHorizonDurationInDays Next Action in Days Horizon DUE_DAYS
SemanticObject null
ManufacturingObject null
NmbrOfIssuesInOrder Issues in Order ISSUES_IN_ORDER
NmbrOfIssuesInDelivery Issues in Delivery ISSUES_IN_DELIV
NmbrOfIssuesInInvoice Issues in Invoice ISSUES_IN_INVC
NmbrOfIssuesInSupply Issues In Supply ISSUES_IN_SUPPLY
NmbrOfAllIssues Issues Total ISSUES_TOT
NmbrOfItemsInOrder Item Issues in Order ITEM_ISSUES
CreatedByUser Name of Person Responsible for Creating the Object USNAM
CreatedByUserName User Description SUIDTECHDESC
LastChangedByUser User Who Last Changed the Business Document USNAM
LastChangedByUserName User Description SUIDTECHDESC
SoldToPartyName Name of Sold-to Party TEXT80
SoldToPartyFullName Full Name of Sold-to Party TEXT80
ShipToPartyName Name of Ship-to Party TEXT80
ShipToPartyFullName Full Name of Ship-to Party TEXT80
ResponsibleEmployee Employee Responsible PERNR
ResponsibleEmployeeName Name of Employee Responsible TEXT80
PayerPartyName Payer Name TEXT80
PurchaseOrderByCustomer Customer Reference BSTKD
ReqdDelivDateYearWeek Week of Requested Delivery Date NUM6
SalesDocumentRjcnReason Reason for Rejection of Sales Documents ABGRU_VA
CustomerProject Commercial Project ID /CPD/MP_ID
CustomerProjectName Customer Project Name /CPD/SHORT_TEXT
BusinessSolutionOrder Solution Order CRM_OBJECT_ID
OrganizationBPName1 Name 1 NAME
OrganizationBPName2 Name 2 NAME
Master Data Relations Join Conditions
Credit Segment
  • Credit Segment
  • Client
Customer Classification
  • Client
  • Customer Classification
  • C_SLSDOCFLFMTISSUE.MANDT == TKUKL.MANDT
  • C_SLSDOCFLFMTISSUE.CUSTOMERCLASSIFICATION == TKUKL.KUKLA
Delivery Block (Document Header)
  • Delivery Block (Document Header)
  • Client
  • C_SLSDOCFLFMTISSUE.DELIVERYBLOCKREASON == TVLS.LIFSP
  • C_SLSDOCFLFMTISSUE.MANDT == TVLS.MANDT
Distribution channel in order header
  • Sales Organization
  • Distribution Channel
  • Client
  • C_SLSDOCFLFMTISSUE.SALESORGANIZATION == TVKOV.VKORG
  • C_SLSDOCFLFMTISSUE.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
  • C_SLSDOCFLFMTISSUE.MANDT == TVKOV.MANDT
Billing Block in SD Document
  • Client
  • Billing Block in SD Document
  • C_SLSDOCFLFMTISSUE.MANDT == TVFS.MANDT
  • C_SLSDOCFLFMTISSUE.HEADERBILLINGBLOCKREASON == TVFS.FAKSP
Division in order header
  • Sales Organization
  • Distribution Channel
  • Client
  • Division
  • C_SLSDOCFLFMTISSUE.SALESORGANIZATION == TVTA.VKORG
  • C_SLSDOCFLFMTISSUE.DISTRIBUTIONCHANNEL == TVTA.VTWEG
  • C_SLSDOCFLFMTISSUE.MANDT == TVTA.MANDT
  • C_SLSDOCFLFMTISSUE.ORGANIZATIONDIVISION == TVTA.SPART
Customer - Document Customer
  • Payer
  • Sold-to Party
  • Ship-to Party
  • Client
  • C_SLSDOCFLFMTISSUE.PAYERPARTY == KNA1.KUNNR
  • C_SLSDOCFLFMTISSUE.SOLDTOPARTY == KNA1.KUNNR
  • C_SLSDOCFLFMTISSUE.SHIPTOPARTY == KNA1.KUNNR
  • C_SLSDOCFLFMTISSUE.MANDT == KNA1.MANDT
Order type in order header
  • Sales Document Type
  • Client
  • C_SLSDOCFLFMTISSUE.SALESDOCUMENTTYPE == TVAK.AUART
  • C_SLSDOCFLFMTISSUE.MANDT == TVAK.MANDT
Sales group
  • Client
  • Sales office
  • Sales group
  • C_SLSDOCFLFMTISSUE.MANDT == TVBVK.MANDT
  • C_SLSDOCFLFMTISSUE.SALESOFFICE == TVBVK.VKBUR
  • C_SLSDOCFLFMTISSUE.SALESGROUP == TVBVK.VKGRP
Sales organization in order header
  • Sales Organization
  • Client
  • C_SLSDOCFLFMTISSUE.SALESORGANIZATION == TVKO.VKORG
  • C_SLSDOCFLFMTISSUE.MANDT == TVKO.MANDT
Customer - Document Customer
  • Payer
  • Sold-to Party
  • Ship-to Party
  • Client
  • C_SLSDOCFLFMTISSUE.PAYERPARTY == KNA1.KUNNR
  • C_SLSDOCFLFMTISSUE.SOLDTOPARTY == KNA1.KUNNR
  • C_SLSDOCFLFMTISSUE.SHIPTOPARTY == KNA1.KUNNR
  • C_SLSDOCFLFMTISSUE.MANDT == KNA1.MANDT
Sold-to Party
  • Payer
  • Sold-to Party
  • Ship-to Party
  • Client
  • C_SLSDOCFLFMTISSUE.PAYERPARTY == KNA1.KUNNR
  • C_SLSDOCFLFMTISSUE.SOLDTOPARTY == KNA1.KUNNR
  • C_SLSDOCFLFMTISSUE.SHIPTOPARTY == KNA1.KUNNR
  • C_SLSDOCFLFMTISSUE.MANDT == KNA1.MANDT
Statistics Currency
  • Client
  • Statistics Currency
  • C_SLSDOCFLFMTISSUE.MANDT == TCURC.MANDT
  • C_SLSDOCFLFMTISSUE.STATISTICSCURRENCY == TCURC.WAERS
Currency in order header
  • Client
  • SD Document Currency
  • C_SLSDOCFLFMTISSUE.MANDT == TCURC.MANDT
  • C_SLSDOCFLFMTISSUE.TRANSACTIONCURRENCY == TCURC.WAERS
Other Relations | to Master Data Relations ↑ Join Conditions
Sales office
  • Sales Organization
  • Distribution Channel
  • Client
  • Division
  • Sales office
  • C_SLSDOCFLFMTISSUE.SALESORGANIZATION == TVKBZ.VKORG
  • C_SLSDOCFLFMTISSUE.DISTRIBUTIONCHANNEL == TVKBZ.VTWEG
  • C_SLSDOCFLFMTISSUE.MANDT == TVKBZ.MANDT
  • C_SLSDOCFLFMTISSUE.ORGANIZATIONDIVISION == TVKBZ.SPART
  • C_SLSDOCFLFMTISSUE.SALESOFFICE == TVKBZ.VKBUR