I_ServiceEntrySheet

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_ServiceEntrySheet.
-- 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: ISRVCENTRSHT

CREATE VIEW I_ServiceEntrySheet AS
SELECT
  Document.ServiceEntrySheet AS ServiceEntrySheet,
  Document.ServiceEntrySheetName AS ServiceEntrySheetName,
  Document.Supplier AS Supplier,
  cast(_Supplier.SupplierName as bu_name1tx) AS SupplierName,
  Document.PurchaseOrder AS PurchaseOrder,
  _PurchaseOrder.DocumentCurrency AS PurchaseOrderCurrency,
  Document.IsDeleted AS IsDeleted,
  Document.ApprovalStatus AS ApprovalStatus,
  _SESWorkflowStatus.SESWorkflowStatus AS SESWorkflowStatus,
  Document.ApprovalDateTime AS ApprovalDateTime,
  Document.ResponsiblePerson AS ResponsiblePerson,
  Document.OriginObjectType AS OriginObjectType,
  Document.Currency AS Currency,
  Document.MaterialDocument AS MaterialDocument,
  Document.MaterialDocumentYear AS MaterialDocumentYear,
  cast(CreationDateTime as mmpur_ses_created_on) AS CreationDateTime,
  Document.CreatedByUser AS CreatedByUser,
  cast(Document.LastChangeDateTime as mmpur_ses_changed_on) AS LastChangeDateTime,
  Document.LastChangeUser AS LastChangeUser,
  Document.PurchasingOrganization AS PurchasingOrganization,
  Document.PurchasingGroup AS PurchasingGroup,
  Document.IsEndOfPurposeBlocked AS IsEndOfPurposeBlocked,
  Document.PurgDocExternalSystem AS PurgDocExternalSystem,
  Document.PurgDocExternalReference AS PurgDocExternalReference,
  Document.ExternalRevisionDateTime AS ExternalRevisionDateTime,
  Document.PostingDate AS PostingDate,
  Document.PricingDocument AS PricingDocument,
  cast( 0 as mmpur_ses_confirmedvalue ) AS TotalNetAmount,
  cast( 0 as mmpur_ses_total_conf_val_w_tax ) AS TotalSESNetAmountInclSalesTax,
  Document._ApprovalStatusValueHelp AS _ApprovalStatusValueHelp,
  Document._ResponsiblePersonValueHelp AS _ResponsiblePersonValueHelp,
  Document._Supplier AS _Supplier,
  _PurchaseOrder._DocumentCurrency AS _PurchaseOrderCurrency
FROM I_ServiceEntrySheetBasic AS Document
LEFT OUTER JOIN I_ServiceEntrySheetItem AS _ServiceEntrySheetItem ON ServiceEntrySheet = _ServiceEntrySheetItem.ServiceEntrySheet  -- association [1..*]
LEFT OUTER JOIN I_SrvcEntrShtApprvlStsTxt AS _ApprovalStatusText ON ApprovalStatus = _ApprovalStatusText.ApprovalStatus  -- association [0..*]
LEFT OUTER JOIN I_SESWorkflowStatus AS _SESWorkflowStatus ON ServiceEntrySheet = _SESWorkflowStatus.ServiceEntrySheet  -- association [1..1]
LEFT OUTER JOIN I_SESWorkflowStatusValueHelp AS _WorkflowStatusValueHelp ON sesworkflowstatus = _WorkflowStatusValueHelp.SESWorkflowStatus  -- association [0..1]
LEFT OUTER JOIN I_SESWorkflowStatusText AS _WorkflowStatusText ON sesworkflowstatus = _WorkflowStatusText.SESWorkflowStatus  -- association [0..*]
LEFT OUTER JOIN I_SrvcEntrShtPurOrdValueHelp AS _SrvcEntrShtPurOrdValueHelp ON _SrvcEntrShtPurOrdValueHelp.PurchaseOrder = PurchaseOrder  -- association [0..*]
LEFT OUTER JOIN I_PurchaseOrder AS _PurchaseOrder ON PurchaseOrder = _PurchaseOrder.PurchaseOrder  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _DocumentCurrency ON Currency = _DocumentCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN E_ServiceEntrySheet AS _ServiceEntrySheetExtension ON ServiceEntrySheet = _ServiceEntrySheetExtension.ServiceEntrySheet  -- association [1..1]
;