P_SalesOrderFlfmtIssueUnion

SOFM Issue Union | view: PSOFISSUEUNION | Extraction: Not supported | Component: Sales Analytics
Tables used: VBRPLIKPLIPSAFKOAFPOEKKOEKPOEKKNEKETEKESVBAKFPLTVBAPVBEPVBFAEKKOEKPOTKA01AUFKT000
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
Column Name Description
Column Name Description
RequestedDeliveryDate Requested Delivery Date
SalesDocumentDate Document Date (Date Received/Sent)
Column Name Description
Issue Issue Show values
IssueCategory Issue Category Show values
ManufacturingOrderCategory Manufacturing Order Category Show values
Column Name Description Domain name
DueDays 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 null
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
NmbrOfIssuesTradeCmplncIssue Number of Issues for Compliance Issue in Sales Orders NMBR_OF_ISSUES_PER_ISSUETYPE
NmbrOfIssuesMisgPurgOrder Number of Issues for Missing Purchase Order 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
NmbrOfIssuesTrdCmplncIssInDeli Number of Issues for Compliance Issue 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
Master Data Relations Join Conditions
Distribution channel in order header
  • Distribution Channel
  • Client
  • Sales Organization
  • P_SALESORDERFLFMTISSUEUNION.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
  • P_SALESORDERFLFMTISSUEUNION.MANDT == TVKOV.MANDT
  • P_SALESORDERFLFMTISSUEUNION.SALESORGANIZATION == TVKOV.VKORG
Division in order header
  • Division
  • Distribution Channel
  • Client
  • Sales Organization
  • P_SALESORDERFLFMTISSUEUNION.ORGANIZATIONDIVISION == TVTA.SPART
  • P_SALESORDERFLFMTISSUEUNION.DISTRIBUTIONCHANNEL == TVTA.VTWEG
  • P_SALESORDERFLFMTISSUEUNION.MANDT == TVTA.MANDT
  • P_SALESORDERFLFMTISSUEUNION.SALESORGANIZATION == TVTA.VKORG
Sales group
  • Sales group
  • Client
  • Sales office
  • P_SALESORDERFLFMTISSUEUNION.SALESGROUP == TVBVK.VKGRP
  • P_SALESORDERFLFMTISSUEUNION.MANDT == TVBVK.MANDT
  • P_SALESORDERFLFMTISSUEUNION.SALESOFFICE == TVBVK.VKBUR
Order type in order header
  • Sales Document Type
  • Client
  • P_SALESORDERFLFMTISSUEUNION.SALESORDERTYPE == TVAK.AUART
  • P_SALESORDERFLFMTISSUEUNION.MANDT == TVAK.MANDT
Sales organization in order header
  • Client
  • Sales Organization
  • P_SALESORDERFLFMTISSUEUNION.MANDT == TVKO.MANDT
  • P_SALESORDERFLFMTISSUEUNION.SALESORGANIZATION == TVKO.VKORG
Sold-to Party
  • Sold-to Party
  • Client
  • P_SALESORDERFLFMTISSUEUNION.SOLDTOPARTY == KNA1.KUNNR
  • P_SALESORDERFLFMTISSUEUNION.MANDT == KNA1.MANDT
Other Relations | to Master Data Relations ↑ Join Conditions
Sales office
  • Division
  • Distribution Channel
  • Client
  • Sales office
  • Sales Organization
  • P_SALESORDERFLFMTISSUEUNION.ORGANIZATIONDIVISION == TVKBZ.SPART
  • P_SALESORDERFLFMTISSUEUNION.DISTRIBUTIONCHANNEL == TVKBZ.VTWEG
  • P_SALESORDERFLFMTISSUEUNION.MANDT == TVKBZ.MANDT
  • P_SALESORDERFLFMTISSUEUNION.SALESOFFICE == TVKBZ.VKBUR
  • P_SALESORDERFLFMTISSUEUNION.SALESORGANIZATION == TVKBZ.VKORG