I_SlsDocFulfillmentIssue

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 I_SlsDocFulfillmentIssue.
-- 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.

CREATE VIEW I_SlsDocFulfillmentIssue AS
SELECT
  SlsDocFlfmtIssue.salesdocument AS SalesDocument,
  SlsDocFlfmtIssue.salesdocumentitem AS SalesDocumentItem,
  SlsDocFlfmtIssue.issue AS Issue,
  SlsDocFlfmtIssue.issuedocument AS IssueDocument,
  SlsDocFlfmtIssue.issuedocumentitem AS IssueDocumentItem,
  SlsDocFlfmtIssue.issuedocumentcategory AS IssueDocumentCategory,
  SlsDocFlfmtIssue.deliverydocument AS DeliveryDocument,
  SlsDocFlfmtIssue.deliverydocumentitem AS DeliveryDocumentItem,
  SlsDocFlfmtIssue.billingdocument AS BillingDocument,
  SlsDocFlfmtIssue.billingdocumentitem AS BillingDocumentItem,
  SlsDocFlfmtIssue.purchasingdocument AS PurchasingDocument,
  SlsDocFlfmtIssue.purchasingdocumentitem AS PurchasingDocumentItem,
  SlsDocFlfmtIssue.manufacturingorder AS ManufacturingOrder,
  SlsDocFlfmtIssue.manufacturingorderitem AS ManufacturingOrderItem,
  SlsDocFlfmtIssue.issuecategory AS IssueCategory,
  SlsDocFlfmtIssue.duedate AS DueDate,
  SlsDocFlfmtIssue.issueprocessingstatus AS IssueProcessingStatus,
  SlsDocFlfmtIssue.salessddocumentcategory AS SalesSDDocumentCategory,
  SlsDocFlfmtIssue.salesdocumenttype AS SalesDocumentType,
  SlsDocFlfmtIssue.salesorganization AS SalesOrganization,
  SlsDocFlfmtIssue.distributionchannel AS DistributionChannel,
  SlsDocFlfmtIssue.organizationdivision AS OrganizationDivision,
  SlsDocBusienssData.bstkd AS PurchaseOrderByCustomer,
  _SalesDocument.BusinessSolutionOrder AS BusinessSolutionOrder,
  _SalesDocument.SoldToParty AS SoldToParty,
  cast(ShipToParty.kunnr as kunwe preserving type) AS ShipToParty,
  cast(BillToParty.kunnr as kunre preserving type) AS BillToParty,
  cast(PayerParty.kunnr as kunrg preserving type) AS PayerParty,
  cast(SalesEmployee.pernr as sales_empl preserving type) AS SalesEmployee,
  cast(ResponsibleEmployee.pernr as resp_empl preserving type) AS ResponsibleEmployee,
  _Item.Product AS Product,
  _Item.BusinessSolutionOrderItem AS BusinessSolutionOrderItem,
  SlsDocFlfmtIssue.lastchangedby AS LastChangedByUser,
  SlsDocFlfmtIssue.lastchangeddatetime AS LastChangeDateTime
FROM sdsls_sofi AS SlsDocFlfmtIssue
LEFT OUTER JOIN I_SalesDocument AS _SalesDocument ON SalesDocument = _SalesDocument.SalesDocument  -- association [1..1]
LEFT OUTER JOIN I_SalesDocumentItem AS _Item ON SalesDocument = _Item.SalesDocument AND SalesDocumentItem = _Item.SalesDocumentItem  -- association [0..1]
LEFT OUTER JOIN I_IssueType AS _Issue ON Issue = _Issue.Issue  -- association [0..1]
LEFT OUTER JOIN I_IssueCategory AS _IssueCategory ON IssueCategory = _IssueCategory.IssueCategory  -- association [0..1]
LEFT OUTER JOIN I_IssueDocumentCategory AS _IssueDocumentCategory ON IssueDocumentCategory = _IssueDocumentCategory.IssueDocumentCategory  -- association [0..1]
LEFT OUTER JOIN I_SDDocumentCategory AS _SalesSDDocumentCategory ON SalesSDDocumentCategory = _SalesSDDocumentCategory.SDDocumentCategory  -- association [0..1]
LEFT OUTER JOIN I_SalesDocumentType AS _SalesDocumentType ON SalesDocumentType = _SalesDocumentType.SalesDocumentType  -- association [0..1]
LEFT OUTER JOIN I_SalesOrganization AS _SalesOrganization ON SalesOrganization = _SalesOrganization.SalesOrganization  -- association [0..1]
LEFT OUTER JOIN I_DistributionChannel AS _DistributionChannel ON DistributionChannel = _DistributionChannel.DistributionChannel  -- association [0..1]
LEFT OUTER JOIN I_Division AS _OrganizationDivision ON OrganizationDivision = _OrganizationDivision.Division  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _SoldToParty ON SoldToParty = _SoldToParty.Customer  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _ShipToParty ON ShipToParty = _ShipToParty.Customer  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _BillToParty ON BillToParty = _BillToParty.Customer  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _PayerParty ON PayerParty = _PayerParty.Customer  -- association [0..1]
LEFT OUTER JOIN I_PersonWorkAgreement_1 AS _SalesEmployee ON SalesEmployee = _SalesEmployee.PersonWorkAgreement  -- association [0..1]
LEFT OUTER JOIN I_PersonWorkAgreement_1 AS _ResponsibleEmployee ON ResponsibleEmployee = _ResponsibleEmployee.PersonWorkAgreement  -- association [0..1]
LEFT OUTER JOIN I_Product AS _Product ON Product = _Product.Product  -- association [0..1]
LEFT OUTER JOIN I_ServiceDocumentEnhcd AS _SolutionOrder ON BusinessSolutionOrder = _SolutionOrder.ServiceDocument AND _SolutionOrder.ServiceObjectType = 'BUS2000172'  -- association [0..1]
LEFT OUTER JOIN I_ServiceDocumentItemEnhcd AS _SolutionOrderItem ON BusinessSolutionOrder = _SolutionOrderItem.ServiceDocument AND BusinessSolutionOrderItem = _SolutionOrderItem.ServiceDocumentItem AND _SolutionOrderItem.ServiceObjectType = 'BUS2000172'  -- association [0..1]
;