C_ServiceEntrySheetProcessFlow

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_ServiceEntrySheetProcessFlow.
-- 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: CSESPROCESSFLOW

CREATE VIEW C_ServiceEntrySheetProcessFlow AS
SELECT
  case when PurchasingDocument.ReferenceDocument = '' or PurchasingDocument.ReferenceDocument = PurchasingDocument.MaterialDocument then ltrim(cast(PurchasingDocument.PurchaseOrder as abap.char( 12 )),'0') else ltrim(cast(PurchasingDocument.ReferenceDocument as abap.char( 12 )),'0') end as PrecedingDocument AS char120endasPrecedingDocument,
  case when PurchasingDocument.ReferenceDocument = '' or PurchasingDocument.ReferenceDocument = PurchasingDocument.MaterialDocument then lpad(cast(ltrim(PurchasingDocument.PurchaseOrderItem,'0') as abap.char( 5 )),5, '0') else lpad(cast(ltrim(PurchasingDocument.ReferenceDocumentItem,'0') as abap.char( 4 )),4, '0') end as PrecedingDocumentItem AS char440endasPrecedingDocumentItem,
  case when ServiceEntrySheet.ServiceEntrySheet is not null and ServiceEntrySheet.OriginObjectType = 'TS' and PurchasingDocument.PurchaseOrderTransactionType = 'S' then ltrim(ServiceEntrySheetItem.OriginObject, '0') else ltrim(cast(PurchasingDocument.MaterialDocument as abap.char( 12 )),'0') end as SubsequentDocument AS char120endasSubsequentDocument,
  case when ServiceEntrySheet.ServiceEntrySheet is not null and ServiceEntrySheet.OriginObjectType = 'TS' and PurchasingDocument.PurchaseOrderTransactionType = 'S' then '00000' else lpad(cast(ltrim(PurchasingDocument.MaterialDocumentItem,'0') as abap.char( 4 )),4, '0') end as SubsequentDocumentItem AS char440endasSubsequentDocumentItem,
  PurchasingDocument.AccountAssignmentNumber AS AccountAssignmentNumber,
  case when PurchasingDocument.ReferenceDocument = '' then ltrim(PurchasingDocument.MaterialDocument,'0') else ltrim(PurchasingDocument.ReferenceDocument,'0') end as ServiceEntrySheet AS ReferenceDocument0endasServiceEntrySheet,
  case when PurchasingDocument.ReferenceDocumentItem = '0000' then lpad(cast(ltrim(PurchasingDocument.MaterialDocumentItem,'0') as abap.char( 4 )),4, '0') else lpad(cast(ltrim(PurchasingDocument.ReferenceDocumentItem,'0') as abap.char( 4 )),4, '0') end as ServiceEntrySheetItem AS char440endasServiceEntrySheetItem,
  Plant.PlantName AS PlantName,
  case when PurchasingDocument.DebitCreditCode = 'S' then PurchasingDocument.Quantity else PurchasingDocument.Quantity * (-1) end as Quantity AS Quantity1endasQuantity,
  PurchasingDocument.PostingDate AS PostingDate,
  PurchasingDocument.Currency AS Currency,
  ServiceEntrySheet.PurchasingGroup AS PurchasingGroup,
  ServiceEntrySheet.PurchasingOrganization AS PurchasingOrganization,
  ServiceEntrySheet.IsEndOfPurposeBlocked AS IsEndOfPurposeBlocked,
  ServiceEntrySheet.ApprovalStatus AS char120asPrecedingDocument,
  '00000' AS PrecedingDocumentItem,
  'T' AS PrecedingDocumentCategory,
  ltrim(ServiceEntrySheetItem.ServiceEntrySheet,'0') AS SubsequentDocument,
  lpad(cast(ltrim(ServiceEntrySheetItem.ServiceEntrySheetItem, '0') as abap.char( 4 )), 4, '0') AS SubsequentDocumentItem,
  '0000' AS MaterialDocumentYear,
  'S' AS SubsequentDocumentCategory,
  ltrim(ServiceEntrySheetItem.ServiceEntrySheet,'0') AS ServiceEntrySheet,
  lpad(cast(ltrim(substring(ServiceEntrySheetItem.ServiceEntrySheetItem, 2, 5), '0') as abap.char( 4 )), 4, '0') AS ServiceEntrySheetItem,
  cast( 0 as abap.dec( 13, 3 ) ) AS Quantity,
  '0000' AS FiscalYear,
  0 AS SupplierInvoiceItemAmount,
  ServiceEntrySheet.ApprovalStatus AS PurchaseContract0endasPrecedingDocument,
  case when ServiceEntrySheetItem.PurchaseContract is not initial then lpad(cast(ltrim(ServiceEntrySheetItem.PurchaseContractItem,'0') as abap.char( 5 )),5,'0') when PO.PurchaseContract is not initial then lpad(cast(ltrim(PO.PurchaseContractItem,'0') as abap.char( 5 )),5, '0') end as PrecedingDocumentItem AS char550endasPrecedingDocumentItem,
  '' AS ApprovalStatus
FROM I_PurchaseOrderHistory AS PurchasingDocument
INNER JOIN I_ServiceEntrySheetBasic AS ServiceEntrySheet ON /* join condition not captured in parsed metadata */
RIGHT OUTER JOIN I_ServiceEntrySheetItemBasic AS ServiceEntrySheetItem ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN C_PlantVH AS Plant ON /* join condition not captured in parsed metadata */
INNER JOIN I_ServiceEntrySheetItemBasic AS ServiceEntrySheetItem ON /* join condition not captured in parsed metadata */
INNER JOIN R_PurchaseOrderItem AS PO ON /* join condition not captured in parsed metadata */
INNER JOIN I_PurchaseContractItem AS PC ON /* join condition not captured in parsed metadata */
INNER JOIN I_PurchaseOrder AS PO ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): I_PurchaseOrderHistory, I_ServiceEntrySheetBasic, I_ServiceEntrySheetItemBasic, C_PurReqnProcessFlow
;