C_OutputRequestItem

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_OutputRequestItem.
-- 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: COUTREQITEM

CREATE VIEW C_OutputRequestItem AS
SELECT
  OutputRequestItem,
  OutputControlApplObjectType,
  OutputControlApplicationObject,
  OutputRequestItemUUID,
  OutputRequestItemStatus,
  OutputDocumentType,
  OutputChannel,
  cast('' as abap.char(255) ) AS OutputItemReceiverName,
  cast('' as abap.char(255) ) AS OutputItemRecipientRoleDesc,
  DispatchTime,
  LastChangeDateTime,
  PrintQueue,
  OutputQueue,
  OutputItemDataTransferMode,
  Recipient,
  RecipientRole,
  FormTemplate,
  FormTemplateType,
  cast('' as abap.char(255) ) AS FormTemplateDescription,
  SenderOrganizationalCenter,
  cast('' as abap.char(255) ) AS SenderOrganizationalCenterDesc,
  SenderOrganizationalCenterType,
  SenderOrganizationalUnit,
  cast('' as abap.char(255) ) AS SenderOrganizationalUnitDesc,
  SenderOrganizationalUnitType,
  IsChangeDocument,
  tstmp_to_dats( CreationDateTime, abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL' ) as CreationDate AS clientNULLasCreationDate,
  cast('' as boole_d ) AS OutputItemIsSendOutput,
  cast('' as boole_d ) AS OutputItemIsDuplicate,
  cast('' as boole_d ) AS OutputItemIsRetry,
  cast('' as boole_d ) AS OutputItemIsSetToCompleted,
  cast('' as boole_d ) AS OutputItemIsDeletable,
  cast('' as boole_d ) AS IsBusinessPurposeCompleted,
  FormPDFIsUntagged
FROM I_OutputRequestItem
;