C_SalesOrderFulfillmentIssueQ

SOFM Issue Query | view: CSOFISSUEQ | Extraction: Not supported | Component: Sales Analytics
Tables used: VBRP, 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_HDR, /CPD/D_MP_ITEM, JEST, JSTO, VBPA, VBPA, EKKO, EKPO, TVFS, TVFST, CVI_CUST_CT_LINK, BUT000, TKA01, UKM_KKBER2SGM, UKMCRED_SGM0C, UKMCRED_SGM0T, KNA1, TKUKL, TKUKT, CVI_CUST_LINK, TVLS, TVLST, TVTW, TVTWT, TSPA, TSPAT, AUFK, TVAK, TVAKT, TVKGR, TVGRT, TVBUR, TVKBT, TVKO, TVKOT, T000, CVI_VEND_LINK, USR21, PROJ, TVBST, TVBST, TVBST, TVBST, TVBST, TVBST, TVBST, TJ07, TJ31
Column Name Description
SalesOrder Sales Order
DeliveryDocument Outbound Delivery
BillingDocument Billing Document
PurchasingDocument Purchasing Document 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
SalesOrderDate 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
SDDocumentCategory SD Document Category Show values
ManufacturingOrderCategory Manufacturing Order Category 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
CtrlgObjStatusIsDeliveryBlkd User Status Delivery Blocked Show values
CtrlgObjStatusIsBillingBlkd User Status Invoicing Blocked Show values
Column Name Description Domain name
IssueName Issue Description DDTEXT
IssueCategoryName Issue Category Description DDTEXT
DueDays Next Action in Days DUE_DAYS
DueHorizonDurationInDays Next Action in Days Horizon DUE_DAYS
DueDateStatusDesc Due Date Status Description DDTEXT
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
NmbrOfItemsInDelivery Item Issues in Delivery ITEMS_IN_DELIVERY
NmbrOfItemsInSupply Item Issues in Supply ITEMS_IN_SUPPLY
NmbrOfIssuesIncomplete Number of Issues for Incomplete in Sales Orders NMBR_OF_ISSUES_PER_ISSUETYPE
NmbrOfIssuesDeliveryBlkd Number of Issues for Delivery Block in Sales Orders NMBR_OF_ISSUES_PER_ISSUETYPE
NmbrOfIssuesCreditBlocked Number of Issues for Credit Block in Sales Orders NMBR_OF_ISSUES_PER_ISSUETYPE
NmbrOfIssuesBillingBlocked Number of Issues for Invoicing Block in Sales Orders NMBR_OF_ISSUES_PER_ISSUETYPE
NmbrOfIssuesOverdueDelivery Number of Issues for Delivery in Sales Orders NMBR_OF_ISSUES_PER_ISSUETYPE
NmbrOfIssuesUnconfirmedQts Number of Issues for Unconfirmed Quantities in Sales Orders NMBR_OF_ISSUES_PER_ISSUETYPE
NmbrOfIssuesShippingBlocked Number of Issues for Shipping Block in Sales Orders NMBR_OF_ISSUES_PER_ISSUETYPE
NmbrOfIssuesIncompleteInDeliv Number of Issues for Incomplete in Delivery NMBR_OF_ISSUES_PER_ISSUETYPE
NmbrOfIssuesCreditBlkdInDeliv Number of Issues for Credit Block in Delivery NMBR_OF_ISSUES_PER_ISSUETYPE
NmbrOfIssuesShippingIssue Number of Issues for Shipping Block in Delivery NMBR_OF_ISSUES_PER_ISSUETYPE
NmbrOfIssuesNotTransferred Number of Issues for Accounting in Invoices NMBR_OF_ISSUES_PER_ISSUETYPE
NmbrOfIssuesInvoicingIssue Number of Issues for Invoicing in Delivery NMBR_OF_ISSUES_PER_ISSUETYPE
NmbrOfIssuesPurchasingIssue Number of Issues for Purchasing in Supply NMBR_OF_ISSUES_PER_ISSUETYPE
NmbrOfIssuesMfgIssue Number of Issues for Manufacturing in Supply NMBR_OF_ISSUES_PER_ISSUETYPE
SalesOrderTypeName Sales Document Type Description TEXT20
CreatedByUser Name of Person Responsible for Creating the Object USNAM
CreatedByUserFullName User Description SUIDTECHDESC
SalesOrganizationName Sales Organization Description TEXT20
DistributionChannelName Distribution Channel Description TEXT20
DivisionName Division Description TEXT20
SalesGroupName Sales Group Description TEXT20
SalesOfficeName Sales Office Description TEXT20
SoldToPartyName Name of Sold-to Party TEXT80
ShipToPartyName Name of Ship-to Party TEXT80
CustomerClassificationDesc Customer Classification Description TEXT20
ResponsibleEmployee Employee Responsible PERNR
ResponsibleEmployeeName Full Name TEXT80
PayerPartyName Payer Name TEXT80
CreditSegmentName Name of Credit Segment TEXT50
PurchaseOrderByCustomer Customer Reference BSTKD
DeliveryBlockReasonText Description TEXT20
BillingBlockReasonDescription Billing Block Description TEXT20
HdrGenIncompletionStatusDesc General Incompletion Status Description (Header) TEXT20
HdrDelivIncompletionStatusDesc Delivery Incompletion Status Description (Header) TEXT20
OverallPrcIncompletionStsDesc Overall Items Pricing Incompletion Status Description TEXT20
HdrBillgIncompletionStatusDesc Billing Incompletion Status Description (Header) TEXT20
OvrlItmGenIncompletionStsDesc General Incompletion Status Description (All Items) TEXT20
OvrlItmBillgIncompltnStsDesc Billing Incompletion Status Description (All Items) TEXT20
OvrlItmDelivIncompltnStsDesc Delivery Incompletion Status Description (All Items) TEXT20
CustomerProject Commercial Project ID /CPD/MP_ID
CustomerProjectName Customer Project Name /CPD/SHORT_TEXT
Master Data Relations Join Conditions
Credit Segment
  • Client
  • Credit Segment
  • C_SALESORDERFULFILLMENTISSUEQ.MANDT == UKMCRED_SGM0C.CLIENT
  • C_SALESORDERFULFILLMENTISSUEQ.CREDITSEGMENT == UKMCRED_SGM0C.CREDIT_SGMNT
Customer Classification
  • Customer Classification
  • Client
  • C_SALESORDERFULFILLMENTISSUEQ.CUSTOMERCLASSIFICATION == TKUKL.KUKLA
  • C_SALESORDERFULFILLMENTISSUEQ.MANDT == TKUKL.MANDT
Delivery Block (Document Header)
  • Delivery Block (Document Header)
  • Client
  • C_SALESORDERFULFILLMENTISSUEQ.DELIVERYBLOCKREASON == TVLS.LIFSP
  • C_SALESORDERFULFILLMENTISSUEQ.MANDT == TVLS.MANDT
Distribution channel in order header
  • Sales Organization
  • Client
  • Distribution Channel
  • C_SALESORDERFULFILLMENTISSUEQ.SALESORGANIZATION == TVKOV.VKORG
  • C_SALESORDERFULFILLMENTISSUEQ.MANDT == TVKOV.MANDT
  • C_SALESORDERFULFILLMENTISSUEQ.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
Billing Block in SD Document
  • Billing Block in SD Document
  • Client
  • C_SALESORDERFULFILLMENTISSUEQ.HEADERBILLINGBLOCKREASON == TVFS.FAKSP
  • C_SALESORDERFULFILLMENTISSUEQ.MANDT == TVFS.MANDT
Division in order header
  • Division
  • Sales Organization
  • Client
  • Distribution Channel
  • C_SALESORDERFULFILLMENTISSUEQ.ORGANIZATIONDIVISION == TVTA.SPART
  • C_SALESORDERFULFILLMENTISSUEQ.SALESORGANIZATION == TVTA.VKORG
  • C_SALESORDERFULFILLMENTISSUEQ.MANDT == TVTA.MANDT
  • C_SALESORDERFULFILLMENTISSUEQ.DISTRIBUTIONCHANNEL == TVTA.VTWEG
Customer - Document Customer
  • Ship-to Party
  • Payer
  • Sold-to Party
  • Client
  • C_SALESORDERFULFILLMENTISSUEQ.SHIPTOPARTY == KNA1.KUNNR
  • C_SALESORDERFULFILLMENTISSUEQ.PAYERPARTY == KNA1.KUNNR
  • C_SALESORDERFULFILLMENTISSUEQ.SOLDTOPARTY == KNA1.KUNNR
  • C_SALESORDERFULFILLMENTISSUEQ.MANDT == KNA1.MANDT
Sales group
  • Sales office
  • Client
  • Sales group
  • C_SALESORDERFULFILLMENTISSUEQ.SALESOFFICE == TVBVK.VKBUR
  • C_SALESORDERFULFILLMENTISSUEQ.MANDT == TVBVK.MANDT
  • C_SALESORDERFULFILLMENTISSUEQ.SALESGROUP == TVBVK.VKGRP
Order type in order header
  • Sales Document Type
  • Client
  • C_SALESORDERFULFILLMENTISSUEQ.SALESORDERTYPE == TVAK.AUART
  • C_SALESORDERFULFILLMENTISSUEQ.MANDT == TVAK.MANDT
Sales organization in order header
  • Sales Organization
  • Client
  • C_SALESORDERFULFILLMENTISSUEQ.SALESORGANIZATION == TVKO.VKORG
  • C_SALESORDERFULFILLMENTISSUEQ.MANDT == TVKO.MANDT
Customer - Document Customer
  • Ship-to Party
  • Payer
  • Sold-to Party
  • Client
  • C_SALESORDERFULFILLMENTISSUEQ.SHIPTOPARTY == KNA1.KUNNR
  • C_SALESORDERFULFILLMENTISSUEQ.PAYERPARTY == KNA1.KUNNR
  • C_SALESORDERFULFILLMENTISSUEQ.SOLDTOPARTY == KNA1.KUNNR
  • C_SALESORDERFULFILLMENTISSUEQ.MANDT == KNA1.MANDT
Sold-to Party
  • Ship-to Party
  • Payer
  • Sold-to Party
  • Client
  • C_SALESORDERFULFILLMENTISSUEQ.SHIPTOPARTY == KNA1.KUNNR
  • C_SALESORDERFULFILLMENTISSUEQ.PAYERPARTY == KNA1.KUNNR
  • C_SALESORDERFULFILLMENTISSUEQ.SOLDTOPARTY == KNA1.KUNNR
  • C_SALESORDERFULFILLMENTISSUEQ.MANDT == KNA1.MANDT
Statistics Currency
  • Client
  • Statistics Currency
  • C_SALESORDERFULFILLMENTISSUEQ.MANDT == TCURC.MANDT
  • C_SALESORDERFULFILLMENTISSUEQ.STATISTICSCURRENCY == TCURC.WAERS
Currency in order header
  • Client
  • SD Document Currency
  • C_SALESORDERFULFILLMENTISSUEQ.MANDT == TCURC.MANDT
  • C_SALESORDERFULFILLMENTISSUEQ.TRANSACTIONCURRENCY == TCURC.WAERS
Other Relations | to Master Data Relations ↑ Join Conditions
Sales office
  • Division
  • Sales office
  • Sales Organization
  • Client
  • Distribution Channel
  • C_SALESORDERFULFILLMENTISSUEQ.ORGANIZATIONDIVISION == TVKBZ.SPART
  • C_SALESORDERFULFILLMENTISSUEQ.SALESOFFICE == TVKBZ.VKBUR
  • C_SALESORDERFULFILLMENTISSUEQ.SALESORGANIZATION == TVKBZ.VKORG
  • C_SALESORDERFULFILLMENTISSUEQ.MANDT == TVKBZ.MANDT
  • C_SALESORDERFULFILLMENTISSUEQ.DISTRIBUTIONCHANNEL == TVKBZ.VTWEG