C_ServiceEntrySheetWD

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_ServiceEntrySheetWD.
-- 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: CSRVCENTRSHTWD

CREATE VIEW C_ServiceEntrySheetWD AS
SELECT
  Document.ServiceEntrySheet AS ServiceEntrySheet,
  Document.ServiceEntrySheetName AS ServiceEntrySheetName,
  Document.Supplier AS Supplier,
  Document.SupplierName AS SupplierName,
  Document.PurchaseOrder AS PurchaseOrder,
  Document.PurchaseOrderCurrency AS PurchaseOrderCurrency,
  Document.IsDeleted AS IsDeleted,
  Document.ApprovalStatus AS ApprovalStatus,
  Document.OverallStatusCriticality AS OverallStatusCriticality,
  Document.SESWorkflowStatus AS SESWorkflowStatus,
  Document.StatusCriticality AS StatusCriticality,
  Document.ResponsiblePerson AS ResponsiblePerson,
  Document.ResponsiblePersonName AS ResponsiblePersonName,
  cast('' as contactcardformattedaddress) AS FormattedAddress,
  Document.FormattedAddress AS AddressID,
  Document.NormalizedPhoneNumber AS NormalizedPhoneNumber,
  Document.MobilePhoneNumber AS MobilePhoneNumber,
  Document.DefaultEmailAddress AS DefaultEmailAddress,
  cast( '' as mm_approval_status ) AS ApprovalStatusName,
  cast( '' as mmpur_ses_price_changed ) AS PriceInSESHasChanged,
  cast( '' as mm_approver_name ) AS ApproverName,
  Document.OriginObjectType AS OriginObjectType,
  Document.Currency AS Currency,
  Document.CreationDateTime AS CreationDateTime,
  Document.CreatedByUser AS CreatedByUser,
  Document.LastChangeDateTime AS LastChangeDateTime,
  Document.LastChangeUser AS LastChangeUser,
  Document.IsEndOfPurposeBlocked AS IsEndOfPurposeBlocked,
  Document.PurchasingOrganization AS PurchasingOrganization,
  Document.PurchasingGroup AS PurchasingGroup,
  Document.PostingDate AS PostingDate,
  Document.TotalNetAmount AS TotalNetAmount,
  Document.TotalSESNetAmountInclSalesTax AS TotalSESNetAmountInclSalesTax,
  Document.PricingDocument AS PricingDocument,
  Document.SendToApprovalIsPossible AS SendToApprovalIsPossible,
  Document.CancelApprovalIsPossible AS CancelApprovalIsPossible,
  Document.RevokeIsPossible AS RevokeIsPossible,
  cast( '' as mmpur_ses_revoke_appr_ac preserving type ) AS PurchaseOrderExists,
  Document.PurgDocExternalSystem AS PurgDocExternalSystem,
  Document.ExternalRevisionDateTime AS ExternalRevisionDateTime,
  _CreatedByUser.UserDescription AS UserFullName,
  _LastChangeUser.UserDescription AS LastChangedByUserFullName,
  cast( '' as abap.sstring( 450 ) ) AS NoteTypeListText,
  Document.SESMassEditIsUtilized AS SESMassEditIsUtilized,
  Document._Supplier AS _Supplier,
  Document._SrvcEntrShtPurOrdValueHelp AS _SrvcEntrShtPurOrdValueHelp,
  Document._ResponsiblePersonValueHelp AS _ResponsiblePersonValueHelp,
  Document._ApprovalStatusValueHelp AS _ApprovalStatusValueHelp,
  Document._ApprovalStatusText AS _ApprovalStatusText,
  Document._WorkflowStatusValueHelp AS _WorkflowStatusValueHelp,
  Document._WorkflowStatusText AS _WorkflowStatusText,
  Document._DocumentCurrency AS _DocumentCurrency,
  Document._PurchaseOrderCurrency AS _PurchaseOrderCurrency,
  Document._OriginObjectType AS _OriginObjectType
FROM I_ServiceEntrySheetTP AS Document
LEFT OUTER JOIN C_ServiceEntrySheetItemWD AS _ServiceEntrySheetItem ON _ServiceEntrySheetItem.ServiceEntrySheet = ServiceEntrySheet  -- association [1..*]
LEFT OUTER JOIN C_MM_SupplierValueHelp AS _SupplierValueHelp ON _SupplierValueHelp.Supplier = Supplier  -- association [0..*]
LEFT OUTER JOIN C_PurchasingOrgValueHelp AS _PurgOrgValueHelp ON _PurgOrgValueHelp.PurchasingOrganization = PurchasingOrganization  -- association [0..1]
LEFT OUTER JOIN C_PurchasingGroupValueHelp AS _PurchasingGrpValueHelp ON _PurchasingGrpValueHelp.PurchasingGroup = PurchasingGroup  -- association [0..1]
LEFT OUTER JOIN I_User AS _CreatedByUser ON _CreatedByUser.UserID = CreatedByUser  -- association [0..1]
LEFT OUTER JOIN I_User AS _LastChangeUser ON _LastChangeUser.UserID = LastChangeUser  -- association [0..1]
LEFT OUTER JOIN C_ServiceEntrySheetApprover AS _Approver ON _Approver.ServiceEntrySheet = ServiceEntrySheet  -- association [0..*]
;