C_LgsPaInsnRglnUpdtRegulation

DDL: C_LGSPAINSNRGLNUPDTREGULATION Type: view_entity CONSUMPTION
49 Fields 1 Data Sources

DG Assessment of Packing Instruction

C_LgsPaInsnRglnUpdtRegulation is a Consumption CDS View that provides data about "DG Assessment of Packing Instruction" in SAP S/4HANA. It reads from 1 data source (P_DaGdsLgsPaInsnRglnUpdtRgln) and exposes 49 fields with key field RglnUpdtHierNodeID.

Data Sources (1)

SourceAliasJoin Type
P_DaGdsLgsPaInsnRglnUpdtRgln P_DaGdsLgsPaInsnRglnUpdtRgln from

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
VDM.viewType #CONSUMPTION view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions true view
EndUserText.label DG Assessment of Packing Instruction view
Feature FTGL_PSSPROD_9227 view

Fields (49)

KeyFieldSource TableSource FieldDescription
KEY RglnUpdtHierNodeID RglnUpdtHierNodeID
RglnUpdtHierNodeName RglnUpdtHierNodeName
RglnUpdtHierLevel RglnUpdtHierLevel
RglnUpdtHierParentNodeID RglnUpdtHierParentNodeID
CmplRqRsltUUID CmplRqRsltUUID SDS Assessment
CmplRqRsltReferencedObjectUUID _Cube CmplRqRsltReferencedObjectUUID UUID of Ref. Object
CmplRqRsltReferencedObjectType _Cube CmplRqRsltReferencedObjectType Reference Type
CmplRqRsltProcessingStatus _Cube CmplRqRsltProcessingStatus Processing Status
ProcessingStatusText
CmplRqRsltCalculatedStatus _Cube CmplRqRsltCalculatedStatus Calculated Compliance Status
CmplRqRsltCmplncStsTxt
CmplRqRsltHasReldVersLtstRevsn _Cube CmplRqRsltHasReldVersLtstRevsn
DngrsGoodsModeOfTransport _Cube DngrsGoodsModeOfTransport Mode of Transport
DngrsGoodsModeOfTransportName
CmplRqRsltDngrsGdsModeOfTrUUID _Cube CmplRqRsltDngrsGdsModeOfTrUUID NodeID
DangerousGoodDescForDocuments
TransportPermission _Cube TransportPermission Transport Permission
TransportPermissionName
TransportPermissionCriticality _Cube TransportPermissionCriticality
CmplRqVersUUID _Cube CmplRqVersUUID NodeID
CmplRqVersName
CmplRqVersIsLatest _Cube CmplRqVersIsLatest
CmplRqUUID _Cube CmplRqUUID Compl Req.
ComplianceRequirement ComplianceRequirement Compliance Requirement
EffectiveDate _Cube EffectiveDate Effective Date
CmplRqVers _Cube CmplRqVers Compliance Requirement
CmplRqApplicationComponent _Cube CmplRqApplicationComponent Solution Area
CmplRqPattern _Cube CmplRqPattern Compliance Pattern
CmplRqPatternName _Cube CmplRqPatternName Pattern Name
DngrsGdsLogsPackgInstrnUUID _Cube DngrsGdsLogsPackgInstrnUUID
PackingInstructionSystemUUID _Cube PackingInstructionSystemUUID Packing Instructi Nr
PackingInstructionText
PackingInstructionNumber _Cube PackingInstructionNumber
DngrsGoodIsPartiallyPackaged _Cube DngrsGoodIsPartiallyPackaged
ClassifiedAsDangerousGood _Cube ClassifiedAsDangerousGood Classified As
ClassifiedAsDangerousGoodName
ProdCmplncDngrsGdsIdnNmbr _Cube ProdCmplncDngrsGdsIdnNmbr Number
ProdCmplncDngrsGdsIdnNmbrType _Cube ProdCmplncDngrsGdsIdnNmbrType Number (Prefix)
DangerousGoodsIdnNumberCnctntd _Cube DangerousGoodsIdnNumberCnctntd DG IDNo ConCat
DangerousGoodsClass _Cube DangerousGoodsClass Class/Division
DangerousGoodsClassName
DangerousGoodsPackingGroup _Cube DangerousGoodsPackingGroup Packing Group
EnclosureVariant _Cube EnclosureVariant Enclosure Variant
EnclosureVariantName
ChmlCmplncInfoUUID _Cube ChmlCmplncInfoUUID Chemical Compliance Information PP
DngrsGdsRespUnit DngrsGdsRespUnit Responsible Unit for Dangerous Goods
ChmlCmplncInfoType _Cube ChmlCmplncInfoType Type of Chemical Compliance Information
Product _Cube Product Product Sold
_Parent _Parent

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.CmplRqRsltCalculatedStatus AS CmplRqRsltCalculatedStatus,
  _Cube._CmplRqRsltCalcdCmplncStsTxt[1:Language=$session.system_language].CmplRqRsltCmplncStsTxt AS CmplRqRsltCmplncStsTxt,
  _Cube.CmplRqRsltHasReldVersLtstRevsn AS CmplRqRsltHasReldVersLtstRevsn,
  _Cube.DngrsGoodsModeOfTransport AS DngrsGoodsModeOfTransport,
  _Cube._DngrsGoodsModeOfTransportTxt[1:Language=$session.system_language].DngrsGoodsModeOfTransportName AS DngrsGoodsModeOfTransportName,
  _Cube.CmplRqRsltDngrsGdsModeOfTrUUID AS CmplRqRsltDngrsGdsModeOfTrUUID,
  _Cube._CmplRqRsltDaGdsMoOfTrDesc[1:Language=$session.system_language].DangerousGoodDescForDocuments AS DangerousGoodDescForDocuments,
  _Cube.TransportPermission AS TransportPermission,
  _Cube._TransportPermissionText[1:Language=$session.system_language].TransportPermissionName AS TransportPermissionName,
  _Cube.TransportPermissionCriticality 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,
  _Cube.PackingInstructionNumber AS PackingInstructionNumber,
  _Cube.DngrsGoodIsPartiallyPackaged AS DngrsGoodIsPartiallyPackaged,
  _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.EnclosureVariant AS EnclosureVariant,
  _Cube._EnclosureVariantText[1:Language=$session.system_language].EnclosureVariantName AS EnclosureVariantName,
  _Cube.ChmlCmplncInfoUUID AS ChmlCmplncInfoUUID,
  DngrsGdsRespUnit,
  _Cube.ChmlCmplncInfoType AS ChmlCmplncInfoType,
  _Cube.Product AS Product
FROM P_DaGdsLgsPaInsnRglnUpdtRgln
;

Learn More