I_SalesOrderFulfillmentIssue

SOFM Issue | view: ISOFISSUE | 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, VBPA, VBPA, EKKO, EKPO, CVI_CUST_CT_LINK, BUT000, TKA01, UKM_KKBER2SGM, KNA1, CVI_CUST_LINK, AUFK, T000, CVI_VEND_LINK, USR21, PROJ
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
Column Name Description Domain name
DueDays Next Action in Days DUE_DAYS
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
CreatedByUser Name of Person Responsible for Creating the Object USNAM
CreatedByUserFullName User Description SUIDTECHDESC
SoldToPartyName Name of Sold-to Party TEXT80
ShipToPartyName Name of Ship-to Party TEXT80
ResponsibleEmployee Employee Responsible PERNR
ResponsibleEmployeeName Full Name TEXT80
PayerPartyName Payer Name TEXT80
PurchaseOrderByCustomer Customer Reference BSTKD
CustomerProjectUUID Engagement Project UUID /BOBF/CONF_KEY
CustomerProject Commercial Project ID /CPD/MP_ID
CustomerProjectName Customer Project Name /CPD/SHORT_TEXT
Master Data Relations Join Conditions
Credit control area
  • Client
  • Credit control area
  • I_SALESORDERFULFILLMENTISSUE.MANDT == T014.MANDT
  • I_SALESORDERFULFILLMENTISSUE.CREDITCONTROLAREA == T014.KKBER
Credit Segment
  • Client
  • Credit Segment
  • I_SALESORDERFULFILLMENTISSUE.MANDT == UKMCRED_SGM0C.CLIENT
  • I_SALESORDERFULFILLMENTISSUE.CREDITSEGMENT == UKMCRED_SGM0C.CREDIT_SGMNT
Customer Classification
  • Client
  • Customer Classification
  • I_SALESORDERFULFILLMENTISSUE.MANDT == TKUKL.MANDT
  • I_SALESORDERFULFILLMENTISSUE.CUSTOMERCLASSIFICATION == TKUKL.KUKLA
Delivery Block (Document Header)
  • Delivery Block (Document Header)
  • Client
  • I_SALESORDERFULFILLMENTISSUE.DELIVERYBLOCKREASON == TVLS.LIFSP
  • I_SALESORDERFULFILLMENTISSUE.MANDT == TVLS.MANDT
Distribution channel in order header
  • Client
  • Distribution Channel
  • Sales Organization
  • I_SALESORDERFULFILLMENTISSUE.MANDT == TVKOV.MANDT
  • I_SALESORDERFULFILLMENTISSUE.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
  • I_SALESORDERFULFILLMENTISSUE.SALESORGANIZATION == TVKOV.VKORG
Billing Block in SD Document
  • Client
  • Billing Block in SD Document
  • I_SALESORDERFULFILLMENTISSUE.MANDT == TVFS.MANDT
  • I_SALESORDERFULFILLMENTISSUE.HEADERBILLINGBLOCKREASON == TVFS.FAKSP
Division in order header
  • Client
  • Distribution Channel
  • Division
  • Sales Organization
  • I_SALESORDERFULFILLMENTISSUE.MANDT == TVTA.MANDT
  • I_SALESORDERFULFILLMENTISSUE.DISTRIBUTIONCHANNEL == TVTA.VTWEG
  • I_SALESORDERFULFILLMENTISSUE.ORGANIZATIONDIVISION == TVTA.SPART
  • I_SALESORDERFULFILLMENTISSUE.SALESORGANIZATION == TVTA.VKORG
Customer - Document Customer
  • Client
  • Sold-to Party
  • Ship-to Party
  • Payer
  • I_SALESORDERFULFILLMENTISSUE.MANDT == KNA1.MANDT
  • I_SALESORDERFULFILLMENTISSUE.SOLDTOPARTY == KNA1.KUNNR
  • I_SALESORDERFULFILLMENTISSUE.SHIPTOPARTY == KNA1.KUNNR
  • I_SALESORDERFULFILLMENTISSUE.PAYERPARTY == KNA1.KUNNR
Sales group
  • Client
  • Sales group
  • Sales office
  • I_SALESORDERFULFILLMENTISSUE.MANDT == TVBVK.MANDT
  • I_SALESORDERFULFILLMENTISSUE.SALESGROUP == TVBVK.VKGRP
  • I_SALESORDERFULFILLMENTISSUE.SALESOFFICE == TVBVK.VKBUR
Order type in order header
  • Sales Document Type
  • Client
  • I_SALESORDERFULFILLMENTISSUE.SALESORDERTYPE == TVAK.AUART
  • I_SALESORDERFULFILLMENTISSUE.MANDT == TVAK.MANDT
Sales organization in order header
  • Client
  • Sales Organization
  • I_SALESORDERFULFILLMENTISSUE.MANDT == TVKO.MANDT
  • I_SALESORDERFULFILLMENTISSUE.SALESORGANIZATION == TVKO.VKORG
Customer - Document Customer
  • Client
  • Sold-to Party
  • Ship-to Party
  • Payer
  • I_SALESORDERFULFILLMENTISSUE.MANDT == KNA1.MANDT
  • I_SALESORDERFULFILLMENTISSUE.SOLDTOPARTY == KNA1.KUNNR
  • I_SALESORDERFULFILLMENTISSUE.SHIPTOPARTY == KNA1.KUNNR
  • I_SALESORDERFULFILLMENTISSUE.PAYERPARTY == KNA1.KUNNR
Sold-to Party
  • Client
  • Sold-to Party
  • Ship-to Party
  • Payer
  • I_SALESORDERFULFILLMENTISSUE.MANDT == KNA1.MANDT
  • I_SALESORDERFULFILLMENTISSUE.SOLDTOPARTY == KNA1.KUNNR
  • I_SALESORDERFULFILLMENTISSUE.SHIPTOPARTY == KNA1.KUNNR
  • I_SALESORDERFULFILLMENTISSUE.PAYERPARTY == KNA1.KUNNR
Statistics Currency
  • Client
  • Statistics Currency
  • I_SALESORDERFULFILLMENTISSUE.MANDT == TCURC.MANDT
  • I_SALESORDERFULFILLMENTISSUE.STATISTICSCURRENCY == TCURC.WAERS
Currency in order header
  • Client
  • SD Document Currency
  • I_SALESORDERFULFILLMENTISSUE.MANDT == TCURC.MANDT
  • I_SALESORDERFULFILLMENTISSUE.TRANSACTIONCURRENCY == TCURC.WAERS
Other Relations | to Master Data Relations ↑ Join Conditions
Sales office
  • Client
  • Distribution Channel
  • Sales office
  • Division
  • Sales Organization
  • I_SALESORDERFULFILLMENTISSUE.MANDT == TVKBZ.MANDT
  • I_SALESORDERFULFILLMENTISSUE.DISTRIBUTIONCHANNEL == TVKBZ.VTWEG
  • I_SALESORDERFULFILLMENTISSUE.SALESOFFICE == TVKBZ.VKBUR
  • I_SALESORDERFULFILLMENTISSUE.ORGANIZATIONDIVISION == TVKBZ.SPART
  • I_SALESORDERFULFILLMENTISSUE.SALESORGANIZATION == TVKBZ.VKORG