C_SlsDocFlfmtIssue

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view C_SlsDocFlfmtIssue.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: CSOFISSUE

CREATE VIEW C_SlsDocFlfmtIssue AS
SELECT
  SalesDocument.SalesDocument AS SalesDocument,
  Issue.DeliveryDocument AS DeliveryDocument,
  Issue.BillingDocument AS BillingDocument,
  cast (Issue.PurchasingDocument as vdm_purchaseorder preserving type) AS PurchasingDocument,
  Issue.ManufacturingOrder AS ManufacturingOrder,
  Issue.IssueCategory AS IssueCategory,
  Issue.DueDays AS DueDays,
  cast(Issue.DueDays as duehorizondurationindays) AS DueHorizonDurationInDays,
  Issue.DueDateStatus AS DueDateStatus,
  Issue.IsPotentialFutureIssue AS IsPotentialFutureIssue,
  Issue.NmbrOfIssuesInOrder AS NmbrOfIssuesInOrder,
  Issue.NmbrOfIssuesInDelivery AS NmbrOfIssuesInDelivery,
  Issue.NmbrOfIssuesInInvoice AS NmbrOfIssuesInInvoice,
  Issue.NmbrOfIssuesInSupply AS NmbrOfIssuesInSupply,
  Issue.NmbrOfAllIssues AS NmbrOfAllIssues,
  cast(NmbrOfItemsInOrder as item_issues) AS NmbrOfItemsInOrder,
  SalesDocument.SalesDocumentType AS SalesDocumentType,
  SalesDocument.SalesDocumentProcessingType AS SalesDocumentProcessingType,
  SalesDocument.SDDocumentCategory AS SDDocumentCategory,
  SalesDocument.CreatedByUser AS CreatedByUser,
  _CreatedByUser.UserDescription AS CreatedByUserName,
  SalesDocument.LastChangedByUser AS LastChangedByUser,
  _LastChangedByUser.UserDescription AS LastChangedByUserName,
  SalesDocument.SalesOrganization AS SalesOrganization,
  SalesDocument.DistributionChannel AS DistributionChannel,
  SalesDocument.OrganizationDivision AS OrganizationDivision,
  SalesDocument.SalesGroup AS SalesGroup,
  SalesDocument.SalesOffice AS SalesOffice,
  SalesDocument.SoldToParty AS SoldToParty,
  cast (Partner._SoldToParty.CustomerName as vdm_sold_to_name) AS SoldToPartyName,
  cast(SoldToPartyAddressInfo.PartnerIsOneTimeAccount as isonetimeaccountsoldtoparty) AS SoldToPartyIsOneTimeAccount,
  cast(SoldToPartyAddressInfo._Address.FullName as fullnamesoldtoparty) AS SoldToPartyFullName,
  Partner.ShipToParty AS ShipToParty,
  cast (Partner._ShipToParty.CustomerName as ship_to_name) AS ShipToPartyName,
  cast(ShipToPartyAddressInfo.PartnerIsOneTimeAccount as isonetimeaccountshiptoparty) AS ShipToPartyIsOneTimeAccount,
  cast(ShipToPartyAddressInfo._Address.FullName as fullnameshiptoparty) AS ShipToPartyFullName,
  Partner.ResponsibleEmployee AS ResponsibleEmployee,
  cast (Partner._ResponsibleEmployee.PersonFullName as resp_empl_name) AS ResponsibleEmployeeName,
  Partner.PayerParty AS PayerParty,
  cast( Partner._PayerParty.CustomerName as payer_name) AS PayerPartyName,
  SalesDocument._SoldToParty.CustomerClassification AS CustomerClassification,
  SalesDocument.SalesDocumentDate AS SalesDocumentDate,
  SalesDocument._CreditControlArea._CreditControlArea2Segment.CreditSegment AS CreditSegment,
  SalesDocument.PurchaseOrderByCustomer AS PurchaseOrderByCustomer,
  SalesDocument.TotalNetAmount AS TotalNetAmount,
  SalesDocument.TransactionCurrency AS TransactionCurrency,
  SalesDocument.StatisticsCurrency AS StatisticsCurrency,
  SalesDocument.RequestedDeliveryDate AS RequestedDeliveryDate,
  cast(ReqdDelivCalendarDate.YearWeek as reqd_deliv_date_year_week) AS ReqdDelivDateYearWeek,
  SalesDocument.DeliveryBlockReason AS DeliveryBlockReason,
  SalesDocument.HeaderBillingBlockReason AS HeaderBillingBlockReason,
  cast( ' ' as abgru_va) AS SalesDocumentRjcnReason,
  cast(SalesDocument.OverallPurchaseConfStatus as totpurchaseconfsts preserving type ) AS OverallPurchaseConfStatus,
  cast(SalesDocument.HdrGeneralIncompletionStatus as hdr_general_incompltn_status preserving type) AS HdrGeneralIncompletionStatus,
  cast(SalesDocument.HeaderDelivIncompletionStatus as hdrdelivincompletionstatus preserving type) AS HeaderDelivIncompletionStatus,
  cast(SalesDocument.OverallPricingIncompletionSts as ovrl_pricing_incompletion_sts preserving type) AS OverallPricingIncompletionSts,
  cast(SalesDocument.HeaderBillgIncompletionStatus as hdrbillgincompletionstatus preserving type) AS HeaderBillgIncompletionStatus,
  cast(SalesDocument.OvrlItmGeneralIncompletionSts as itms_ovrl_incompletion_status preserving type) AS OvrlItmGeneralIncompletionSts,
  cast(SalesDocument.OvrlItmBillingIncompletionSts as ovrl_itms_incompltn_sts_billg preserving type) AS OvrlItmBillingIncompletionSts,
  cast(SalesDocument.OvrlItmDelivIncompletionSts as ovrl_items_dlv_incompltn_sts preserving type) AS OvrlItmDelivIncompletionSts,
  SalesDocument.PaytAuthsnCreditCheckSts AS PaytAuthsnCreditCheckSts,
  SalesDocument.SalesDocApprovalStatus AS SalesDocApprovalStatus,
  cast(SalesDocument.OverallChmlCmplncStatus as mon_tdd_total_pcsta preserving type) AS OverallChmlCmplncStatus,
  cast(SalesDocument.OverallDangerousGoodsStatus as mon_tdd_total_dgsta preserving type) AS OverallDangerousGoodsStatus,
  cast(SalesDocument.OverallSafetyDataSheetStatus as mon_tdd_total_sdssta preserving type) AS OverallSafetyDataSheetStatus,
  cast(SalesDocument.OverallTrdCmplncEmbargoSts as totembargochksts preserving type) AS OverallTrdCmplncEmbargoSts,
  cast(SalesDocument.OvrlTrdCmplncSnctndListChkSts as totwatchlistscrngchksts preserving type) AS OvrlTrdCmplncSnctndListChkSts,
  cast(SalesDocument.OvrlTrdCmplncLegalCtrlChkSts as totlglctrlchksts preserving type) AS OvrlTrdCmplncLegalCtrlChkSts,
  SalesDocument._EngagementProjectItem.EngagementProject AS CustomerProject,
  SalesDocument._EngagementProjectItem._EngagementProject.EngagementProjectName AS CustomerProjectName,
  SalesDocument.BusinessSolutionOrder AS BusinessSolutionOrder,
  Issue._IssueCategory AS _IssueCategory,
  Issue._DueDateStatus AS _DueDateStatus,
  Issue._IsPotentialFutureIssue AS _IsPotentialFutureIssue,
  SalesDocument._SalesDocumentType AS _SalesDocumentType,
  SalesDocument._SDDocumentCategory AS _SDDocumentCategory,
  SalesDocument._SalesOrganization AS _SalesOrganization,
  Partner._ShipToParty AS _ShipToParty,
  Partner._PayerParty AS _PayerParty,
  Partner._ResponsibleEmployee AS _ResponsibleEmployee,
  SalesDocument._SoldToParty._CustomerClassification AS _CustomerClassification,
  SalesDocument._DeliveryBlockReason AS _DeliveryBlockReason,
  SalesDocument._HeaderBillingBlockReason AS _HeaderBillingBlockReason,
  SalesDocument._OverallPurchaseConfStatus AS _OverallPurchaseConfStatus,
  SalesDocument._HdrGeneralIncompletionStatus AS _HdrGeneralIncompletionStatus,
  SalesDocument._HeaderDelivIncompletionStatus AS _HeaderDelivIncompletionStatus,
  SalesDocument._OverallPricingIncompletionSts AS _OverallPricingIncompletionSts,
  SalesDocument._HeaderBillgIncompletionStatus AS _HeaderBillgIncompletionStatus,
  SalesDocument._OvrlItmGeneralIncompletionSts AS _OvrlItmGeneralIncompletionSts,
  SalesDocument._OvrlItmBillingIncompletionSts AS _OvrlItmBillingIncompletionSts,
  SalesDocument._OvrlItmDelivIncompletionSts AS _OvrlItmDelivIncompletionSts,
  SalesDocument._PaytAuthsnCreditCheckSts AS _PaytAuthsnCreditCheckSts,
  SalesDocument._SalesDocApprovalStatus AS _SalesDocApprovalStatus,
  SalesDocument._OverallChmlCmplncStatus AS _OverallChmlCmplncStatus,
  SalesDocument._OverallDangerousGoodsStatus AS _OverallDangerousGoodsStatus,
  SalesDocument._OvrlSftyDataSheetSts AS _OvrlSftyDataSheetSts,
  SalesDocument._OvrlTradeCmplncEmbargoStatus AS _OvrlTradeCmplncEmbargoStatus,
  SalesDocument._OvTrdCmplncSnctndListChkSts AS _OvTrdCmplncSnctndListChkSts,
  SalesDocument._OvrlTrdCmplncLegalCtrlChkSts AS _OvrlTrdCmplncLegalCtrlChkSts,
  SalesDocument._TransactionCurrency AS _TransactionCurrency,
  SalesDocument._StatisticsCurrency AS _StatisticsCurrency,
  SalesDocument._SoldToParty.OrganizationBPName1 AS OrganizationBPName1,
  SalesDocument._SoldToParty.OrganizationBPName2 AS OrganizationBPName2,
  SalesDocument._SolutionOrder AS _SolutionOrderATAddedforCE2008
FROM I_SalesDocument AS SalesDocument
INNER JOIN I_SalesOrderFlfmtIssueBasic AS Issue ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_CreditManagementSegment AS _CreditSegment ON creditsegment = _CreditSegment.CreditSegment  -- association [0..1]
LEFT OUTER JOIN I_SalesDocumentRjcnReason AS _SalesDocumentRjcnReason ON SalesDocumentRjcnReason = _SalesDocumentRjcnReason.SalesDocumentRjcnReason  -- association [0..1]
LEFT OUTER JOIN I_IssueText AS _IssueText ON Issue = _IssueText.Issue  -- association [0..*]
LEFT OUTER JOIN I_IssueCategoryText AS _IssueCategoryText ON IssueCategory = _IssueCategoryText.IssueCategory  -- association [0..*]
LEFT OUTER JOIN I_SalesOrganizationText AS _SalesOrganizationText ON SalesOrganization = _SalesOrganizationText.SalesOrganization  -- association [0..*]
LEFT OUTER JOIN I_DistributionChannelText AS _DistributionChannelText ON DistributionChannel = _DistributionChannelText.DistributionChannel  -- association [0..*]
LEFT OUTER JOIN I_DivisionText AS _DivisionText ON OrganizationDivision = _DivisionText.Division  -- association [0..*]
LEFT OUTER JOIN I_SalesGroupText AS _SalesGroupText ON SalesGroup = _SalesGroupText.SalesGroup  -- association [0..*]
LEFT OUTER JOIN I_SalesOfficeText AS _SalesOfficeText ON SalesOffice = _SalesOfficeText.SalesOffice  -- association [0..*]
LEFT OUTER JOIN I_CreditManagementSegmentTxt AS _CreditSegmentText ON creditsegment = _CreditSegmentText.CreditSegment association[0..*] to I_CustomerClassificationText as _CustomerClassificationText on customerclassification = _CustomerClassificationText.CustomerClassification  -- association [0..*]
LEFT OUTER JOIN I_DueDateStatusText AS _DueDateStatusText ON DueDateStatus = _DueDateStatusText.DueDateStatus  -- association [0..*]
LEFT OUTER JOIN I_IsPotentialFutureIssText AS _IsPotentialFutureIssText ON IsPotentialFutureIssue = _IsPotentialFutureIssText.IsPotentialFutureIssue  -- association [0..*]
LEFT OUTER JOIN I_SalesDocumentTypeText AS _SalesDocumentTypeText ON SalesDocumentType = _SalesDocumentTypeText.SalesDocumentType  -- association [0..*]
LEFT OUTER JOIN I_SDDocumentCategoryText AS _SDDocumentCategoryText ON SDDocumentCategory = _SDDocumentCategoryText.SDDocumentCategory  -- association [0..*]
LEFT OUTER JOIN I_DeliveryBlockReasonText AS _DeliveryBlockReasonText ON DeliveryBlockReason = _DeliveryBlockReasonText.DeliveryBlockReason  -- association [0..*]
LEFT OUTER JOIN I_BillingBlockReasonText AS _BillingBlockReasonText ON HeaderBillingBlockReason = _BillingBlockReasonText.BillingBlockReason  -- association [0..*]
LEFT OUTER JOIN I_OverallPurchaseConfStatusT AS _OverallPurchaseConfStatusT ON OverallPurchaseConfStatus = _OverallPurchaseConfStatusT.OverallPurchaseConfStatus  -- association [0..*]
LEFT OUTER JOIN I_HdrGenIncompletionStatusT AS _HdrGenIncompletionStatusT ON HdrGeneralIncompletionStatus = _HdrGenIncompletionStatusT.HdrGeneralIncompletionStatus  -- association [0..*]
LEFT OUTER JOIN I_HdrDelivIncompletionStatusT AS _HdrDelivIncompletionStatusT ON HeaderDelivIncompletionStatus = _HdrDelivIncompletionStatusT.HeaderDelivIncompletionStatus  -- association [0..*]
LEFT OUTER JOIN I_OverallPrcIncompletionStsT AS _OverallPrcIncompletionStsT ON OverallPricingIncompletionSts = _OverallPrcIncompletionStsT.OverallPricingIncompletionSts  -- association [0..*]
LEFT OUTER JOIN I_HdrBillgIncompletionStatusT AS _HdrBillgIncompletionStatusT ON HeaderBillgIncompletionStatus = _HdrBillgIncompletionStatusT.HeaderBillgIncompletionStatus  -- association [0..*]
LEFT OUTER JOIN I_OvrlItmGenIncompletionStsT AS _OvrlItmGenIncompletionStsT ON OvrlItmGeneralIncompletionSts = _OvrlItmGenIncompletionStsT.OvrlItmGeneralIncompletionSts  -- association [0..*]
LEFT OUTER JOIN I_OvrlItmBillgIncompltnStsText AS _OvrlItmBillgIncompltnStsT ON OvrlItmBillingIncompletionSts = _OvrlItmBillgIncompltnStsT.OvrlItmBillingIncompletionSts  -- association [0..*]
LEFT OUTER JOIN I_OvrlItmDelivIncompletionStsT AS _OvrlItmDelivIncompletionStsT ON OvrlItmDelivIncompletionSts = _OvrlItmDelivIncompletionStsT.OvrlItmDelivIncompletionSts  -- association [0..*]
LEFT OUTER JOIN I_PaytAuthsnCreditCheckStsText AS _PaytAuthsnCreditCheckStsText ON PaytAuthsnCreditCheckSts = _PaytAuthsnCreditCheckStsText.PaytAuthsnCreditCheckSts  -- association [0..*]
LEFT OUTER JOIN I_SalesDocApprovalStatusT AS _SalesDocApprovalStatusT ON SalesDocApprovalStatus = _SalesDocApprovalStatusT.SalesDocApprovalStatus  -- association [0..*]
LEFT OUTER JOIN I_OverallChmlCmplncStatusText AS _OverallChmlCmplncStatusText ON OverallChmlCmplncStatus = _OverallChmlCmplncStatusText.OverallChmlCmplncStatus  -- association [0..*]
LEFT OUTER JOIN I_OverallDangerousGoodsStsTxt AS _OverallDangerousGoodsStsTxt ON OverallDangerousGoodsStatus = _OverallDangerousGoodsStsTxt.OverallDangerousGoodsStatus  -- association [0..*]
LEFT OUTER JOIN I_OvrlSftyDataSheetStsTxt AS _OvrlSftyDataSheetStsTxt ON OverallSafetyDataSheetStatus = _OvrlSftyDataSheetStsTxt.OverallSafetyDataSheetStatus  -- association [0..*]
LEFT OUTER JOIN I_OvrlTradeCmplncEmbargoStsTxt AS _OvrlTradeCmplncEmbargoStsTxt ON OverallTrdCmplncEmbargoSts = _OvrlTradeCmplncEmbargoStsTxt.OverallTrdCmplncEmbargoSts  -- association [0..*]
LEFT OUTER JOIN I_OvTrdComplSanctListChkStsTxt AS _OvTrdComplSanctListChkStsTxt ON OvrlTrdCmplncSnctndListChkSts = _OvTrdComplSanctListChkStsTxt.OvrlTrdCmplncSnctndListChkSts  -- association [0..*]
LEFT OUTER JOIN I_OvTrdComplLegalCtrlChkStsTxt AS _OvTrdComplLegalCtrlChkStsTxt ON OvrlTrdCmplncLegalCtrlChkSts = _OvTrdComplLegalCtrlChkStsTxt.OvrlTrdCmplncLegalCtrlChkSts  -- association [0..*]
LEFT OUTER JOIN I_CurrencyText AS _TransactionCurrencyText ON TransactionCurrency = _TransactionCurrencyText.Currency  -- association [0..*]
LEFT OUTER JOIN I_CurrencyText AS _StatisticsCurrencyText ON StatisticsCurrency = _StatisticsCurrencyText.Currency  -- association [0..*]
LEFT OUTER JOIN C_Dischannelvaluehelp AS _DistributionChannelVH ON SalesOrganization = _DistributionChannelVH.SalesOrganization AND DistributionChannel = _DistributionChannelVH.DistributionChannel  -- association [0..1]
LEFT OUTER JOIN C_OrgDivisionValueHelp AS _OrganizationDivisionVH ON SalesOrganization = _OrganizationDivisionVH.SalesOrganization AND DistributionChannel = _OrganizationDivisionVH.DistributionChannel AND OrganizationDivision = _OrganizationDivisionVH.Division  -- association [0..1]
LEFT OUTER JOIN C_SalesOfficeValueHelp AS _SalesOfficeVH ON SalesOrganization = _SalesOfficeVH.SalesOrganization AND DistributionChannel = _SalesOfficeVH.DistributionChannel AND OrganizationDivision = _SalesOfficeVH.OrganizationDivision AND SalesOffice = _SalesOfficeVH.SalesOffice  -- association [0..1]
LEFT OUTER JOIN C_SalesGroupValueHelp AS _SalesGroupVH ON SalesOffice = _SalesGroupVH.SalesOffice AND SalesGroup = _SalesGroupVH.SalesGroup  -- association [0..1]
LEFT OUTER JOIN E_SalesDocumentBasic AS _Extension ON SalesDocument.SalesDocument = _Extension.SalesDocument  -- association [0..1]
;