I_ChmlCmplncReq

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_ChmlCmplncReq.
-- 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: ICCMPLCNREQ

CREATE VIEW I_ChmlCmplncReq AS
SELECT
  ChmlCmplncRequestUUID,
  cast(creationutcdatetime as ehfnd_bo_crea_date_time preserving type) AS CreationUTCDateTime,
  cast(createdbyuser as ehfnd_bo_crea_uname preserving type) AS CreatedByUser,
  cast(lastchangeutcdatetime as ehfnd_bo_lchg_date_time preserving type) AS LastChangeUTCDateTime,
  cast(lastchangedbyuser as ehfnd_bo_lchg_uname preserving type) AS LastChangedByUser,
  ChmlCmplncRequestDueDate,
  ChmlCmplncReqCmplncProc,
  ChmlCmplncRequestOriginType,
  ChmlCmplncReqOriginProc,
  ChmlCmplncRequestPrgrsStatus,
  ChmlCmplncBusinessProcess,
  ChmlCmplncReqBPProcessor,
  ChmlCmplncReqBPRequester,
  ChmlCmplncReqRequester,
  ChmlCmplncInfoUUID,
  ChmlCmplncProdUUID,
  ChemicalCustomerMaterialUUID,
  Material,
  SalesDocument,
  SalesDocumentItem,
  ChmlCmplncReqLogisticDocCat,
  MultiComponentProduct,
  ChmlCmplncRequestRemark,
  ChmlCmplncReqDetails,
  ProdCmplncLogsDocument,
  cast(prodcmplnclogsdocument as ehfnd_log_doc_number_nc preserving type) AS ProdCmplncLogsDocNotCnvrtd,
  ProdCmplncLogsDocumentUUID,
  ProdCmplncLogsDocumentItem,
  BusinessSystemName,
  DngrsGoodsModeOfTransport,
  Supplier,
  Customer,
  ProductComplianceRequest,
  DngrsGdsLogsPackgInstrnUUID
FROM ehfndv_crq
LEFT OUTER JOIN I_ChmlCmplncInfo AS _ChmlCmplncInfo ON ChmlCmplncInfoUUID = _ChmlCmplncInfo.ChmlCmplncInfoUUID  -- association [0..1]
LEFT OUTER JOIN I_ChmlCmplncInfo AS _ChmlCmplncInfoProd ON ChmlCmplncProdUUID = _ChmlCmplncInfoProd.ChmlCmplncInfoUUID  -- association [0..1]
LEFT OUTER JOIN I_User AS _CreatedByUser ON CreatedByUser = _CreatedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_User AS _LastChangedByUser ON LastChangedByUser = _LastChangedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_User AS _RequesterUser ON ChmlCmplncReqRequester = _RequesterUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_Product AS _Product ON Material = _Product.Product  -- association [0..1]
LEFT OUTER JOIN I_Product AS _MultiComponentProduct ON MultiComponentProduct = _MultiComponentProduct.Product  -- association [0..1]
LEFT OUTER JOIN I_BusinessUserBasic AS _BusinessUserRequester ON ChmlCmplncReqBPRequester = _BusinessUserRequester.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_BusinessUserBasic AS _BusinessUserProcessor ON ChmlCmplncReqBPProcessor = _BusinessUserProcessor.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_ChmlCmplncReqCmplncProc AS _ChmlCmplncReqCmplncProc ON ChmlCmplncReqCmplncProc = _ChmlCmplncReqCmplncProc.ChmlCmplncReqCmplncProc  -- association [0..1]
LEFT OUTER JOIN I_ChmlCmplncBusProc AS _BusinessProcess ON ChmlCmplncBusinessProcess = _BusinessProcess.ChmlCmplncBusinessProcess  -- association [0..1]
LEFT OUTER JOIN I_ChmlCmplncReqOriginType AS _OriginType ON ChmlCmplncRequestOriginType = _OriginType.ChmlCmplncRequestOriginType  -- association [0..1]
LEFT OUTER JOIN I_ChmlCmplncReqOriginProc AS _OriginProcess ON ChmlCmplncReqOriginProc = _OriginProcess.ChmlCmplncReqOriginProc  -- association [0..1]
LEFT OUTER JOIN I_ChmlCmplncReqStatus AS _RequestStatus ON ChmlCmplncRequestPrgrsStatus = _RequestStatus.ChmlCmplncReqStatus  -- association [0..1]
LEFT OUTER JOIN I_ChemicalCustomerMaterial AS _ChemicalCustomerMaterial ON ChemicalCustomerMaterialUUID = _ChemicalCustomerMaterial.ChemicalCustomerMaterialUUID  -- association [0..1]
LEFT OUTER JOIN I_ChmlCmplncReqMkt AS _RequestedMarket ON ChmlCmplncRequestUUID = _RequestedMarket.ChmlCmplncRequestUUID  -- association [0..*]
LEFT OUTER JOIN I_ChmlCmplncReqApplication AS _RequestedApplication ON ChmlCmplncRequestUUID = _RequestedApplication.ChmlCmplncRequestUUID  -- association [0..*]
LEFT OUTER JOIN I_ChmlCmplncReqPrpsAssgmt AS _RequestedPurpose ON ChmlCmplncRequestUUID = _RequestedPurpose.ChmlCmplncRequestUUID  -- association [0..*]
LEFT OUTER JOIN I_ChmlCmplncReqSlsOrg AS _RequestedSlsOrg ON ChmlCmplncRequestUUID = _RequestedSlsOrg.ChmlCmplncRequestUUID  -- association [0..*]
LEFT OUTER JOIN I_ChmlCmplncReqPlnt AS _RequestedPlnt ON ChmlCmplncRequestUUID = _RequestedPlnt.ChmlCmplncRequestUUID  -- association [0..*]
LEFT OUTER JOIN I_ChmlCmplncReqRouteSegment AS _RouteSegment ON ChmlCmplncRequestUUID = _RouteSegment.ChmlCmplncRequestUUID  -- association [0..*]
LEFT OUTER JOIN I_ChmlCmplncReqStep AS _Step ON ChmlCmplncRequestUUID = _Step.ChmlCmplncRequestUUID  -- association [0..*]
LEFT OUTER JOIN I_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _Customer ON Customer = _Customer.Customer  -- association [0..1]
LEFT OUTER JOIN I_SDDocumentPartner AS _SDDocumentPartnerCustomer ON SalesDocument = _SDDocumentPartnerCustomer.SDDocument AND _SDDocumentPartnerCustomer.PartnerFunction = 'WE'  -- association [0..1]
LEFT OUTER JOIN I_DngrsGdsLogsPackgInstrn AS _PackingInstruction ON DngrsGdsLogsPackgInstrnUUID = _PackingInstruction.DngrsGdsLogsPackgInstrnUUID  -- association [0..1]
;