C_LgsPaInsnRglnUpdtRegulation

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_LgsPaInsnRglnUpdtRegulation.
-- 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.

CREATE VIEW C_LgsPaInsnRglnUpdtRegulation AS
SELECT
  RglnUpdtHierNodeID,
  RglnUpdtHierNodeName,
  RglnUpdtHierLevel,
  RglnUpdtHierParentNodeID,
  CmplRqRsltUUID,
  _Cube.CmplRqRsltReferencedObjectUUID AS CmplRqRsltReferencedObjectUUID,
  _Cube.CmplRqRsltReferencedObjectType AS CmplRqRsltReferencedObjectType,
  _Cube.CmplRqRsltProcessingStatus AS CmplRqRsltProcessingStatus,
  _Cube._CmplRqRsltProcgStsTxt[1:Language=$session.system_language].ProcessingStatusText AS ProcessingStatusText,
  _Cube.CmplRqRsltHasReldVersLtstRevsn AS CmplRqRsltHasReldVersLtstRevsn,
  cast('' as ehfnd_req_mot_nd) AS DngrsGoodsModeOfTransport,
  cast('' as val_text) AS DngrsGoodsModeOfTransportName,
  cast(hextobin('00000000000000000000000000000000') as cmplrqrsltdngrsgdsmodeoftruuid) AS CmplRqRsltDngrsGdsModeOfTrUUID,
  cast( '' as ehdgm_reg_upd_lpi_dg_desc) AS DngrsGoodsDescription,
  cast('' as ehdgm_final_description) AS DangerousGoodDescForDocuments,
  cast('' as ehdgm_final_descrmarkingtxt) AS DngrsGoodMarkingLabelText,
  cast('' as ehdgm_transport_permission_nd) AS TransportPermission,
  cast('' as val_text) AS TransportPermissionName,
  cast('0' as int1) AS TransportPermissionCriticality,
  _Cube.CmplRqVersUUID AS CmplRqVersUUID,
  _Cube._CmplRqVersText[1:Language=$session.system_language].CmplRqVersName AS CmplRqVersName,
  _Cube.CmplRqVersIsLatest AS CmplRqVersIsLatest,
  _Cube.CmplRqUUID AS CmplRqUUID,
  ComplianceRequirement,
  _Cube.EffectiveDate AS EffectiveDate,
  _Cube.CmplRqVers AS CmplRqVers,
  _Cube.CmplRqApplicationComponent AS CmplRqApplicationComponent,
  _Cube.CmplRqPattern AS CmplRqPattern,
  _Cube.CmplRqPatternName AS CmplRqPatternName,
  _Cube.DngrsGdsLogsPackgInstrnUUID AS DngrsGdsLogsPackgInstrnUUID,
  _Cube.PackingInstructionSystemUUID AS PackingInstructionSystemUUID,
  _Cube._PackingInstructionText[1:Language=$session.system_language].PackingInstructionText AS PackingInstructionText,
  cast ( _Cube.PackingInstructionNumber as pl_piid preserving type ) AS PackingInstructionNumber,
  _Cube.ClassifiedAsDangerousGood AS ClassifiedAsDangerousGood,
  _Cube._ClassifiedAsDangerousGoodTxt[1:Language=$session.system_language].ClassifiedAsDangerousGoodName AS ClassifiedAsDangerousGoodName,
  _Cube.ProdCmplncDngrsGdsIdnNmbr AS ProdCmplncDngrsGdsIdnNmbr,
  _Cube.ProdCmplncDngrsGdsIdnNmbrType AS ProdCmplncDngrsGdsIdnNmbrType,
  _Cube.DangerousGoodsIdnNumberCnctntd AS DangerousGoodsIdnNumberCnctntd,
  _Cube.DangerousGoodsClass AS DangerousGoodsClass,
  _Cube._DngrsGdsClassOrDivisionText[1:Language=$session.system_language].DangerousGoodsClassName AS DangerousGoodsClassName,
  _Cube.DangerousGoodsPackingGroup AS DangerousGoodsPackingGroup,
  _Cube._DngrsGdsPackingGroupText[1:Language=$session.system_language].DangerousGoodsPackingGroupName AS DangerousGoodsPackingGroupName,
  _Cube.EnclosureVariant AS EnclosureVariant,
  _Cube._EnclosureVariantText[1:Language=$session.system_language].EnclosureVariantName AS EnclosureVariantName,
  _Cube.SpecialProvisionOrExemptionTxt AS SpecialProvisionOrExemptionTxt,
  _Cube.ChmlCmplncInfoUUID AS ChmlCmplncInfoUUID,
  DngrsGdsRespUnit,
  _Cube.ChmlCmplncInfoType AS ChmlCmplncInfoType,
  _Cube.Product AS Product,
  _Cube.ProductName AS ProductName
FROM P_DaGdsLgsPaInsnRglnUpdtRgln
;