ESH_N_SRVCQTAN

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 ESH_N_SRVCQTAN.
-- 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: ESH_L_SRVCQTAN
-- Parameters: P_Language : abap.lang

CREATE VIEW ESH_N_SRVCQTAN AS
SELECT
  SERVICEDOCUMENT,
  SERVICEOBJECTTYPE,
  DISTRIBUTIONCHANNEL,
  DIVISION,
  _RESPEMPLOYEE.FIRSTNAME AS EMPFIRSTNAME,
  _SOLDTOPARTY.FIRSTNAME AS SOLDTOFIRSTNAME,
  _RESPEMPLOYEE.LASTNAME AS EMPLASTNAME,
  _SOLDTOPARTY.LASTNAME AS SOLDTOLASTNAME,
  _SOLDTOPARTY.ORGANIZATIONBPNAME1 AS SOLDTOORGFNAME,
  _SOLDTOPARTY.ORGANIZATIONBPNAME2 AS SOLDTOORGLNAME,
  POSTINGDATE,
  REFINHOUSEREPAIRISEXISTING,
  RESPONSIBLEEMPLOYEE,
  SALESGROUP,
  SALESGROUPORGUNITID,
  SALESOFFICE,
  SALESOFFICEORGUNITID,
  SALESORGANIZATION,
  SALESORGANIZATIONORGUNITID,
  SERVICEDOCUMENTDESCRIPTION,
  SERVICEDOCUMENTISQUOTATION,
  _SRVCDOCHEADERLONGTEXT.SERVICEDOCUMENTLONGTEXT AS SERVICEDOCUMENTLONGTEXT,
  SERVICEDOCUMENTSTATUS,
  _SERVICEDOCUMENTSTATUS[1: ddlanguage = $parameters. P_Language].ddtext AS SERVICEDOCUMENTSTATUSNAME,
  SERVICEDOCUMENTTYPE,
  _SERVICEDOCUMENTTYPE._SERVICEDOCUMENTTYPETEXT[1: LANGUAGE = $parameters. P_Language].SERVICEDOCUMENTTYPENAME AS SERVICEDOCUMENTTYPENAME,
  SERVICEORGANIZATION,
  SOLDTOPARTY,
  SRVCDOCISMAINTSERVICEORDER
FROM I_SERVICEDOCUMENTENHCD
LEFT OUTER JOIN dd07t AS _SERVICEDOCUMENTSTATUS ON ServiceDocumentStatus=_SERVICEDOCUMENTSTATUS.domvalue_l AND _SERVICEDOCUMENTSTATUS.domname='CRMS4_STAT_LIFECYCLE' AND _SERVICEDOCUMENTSTATUS.as4local='A'  -- association [0..*]
;