I_ChmlCmplncReqTP

DDL: I_CHMLCMPLNCREQTP Type: view TRANSACTIONAL
55 Fields 1 Data Sources 7 Associations

Chemical Compliance Request

I_ChmlCmplncReqTP is a Transactional CDS View that provides data about "Chemical Compliance Request" in SAP S/4HANA. It reads from 1 data source (I_ChmlCmplncReq) and exposes 55 fields with key field ChmlCmplncRequestUUID. It has 7 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_ChmlCmplncReq I_ChmlCmplncReq from

Associations (7)

CardinalityTargetAliasCondition
[0..1] I_ChmlCmplncReqNewCmplncInfoTP _NewComplInfo $projection.ChmlCmplncRequestUUID = _NewComplInfo.ChmlCmplncRequestUUID
[0..*] I_ChmlCmplncReqMktTP _RequestedMarket $projection.ChmlCmplncRequestUUID = _RequestedMarket.ChmlCmplncRequestUUID
[0..*] I_ChmlCmplncReqApplicationTP _RequestedApplication $projection.ChmlCmplncRequestUUID = _RequestedApplication.ChmlCmplncRequestUUID
[0..*] I_ChmlCmplncReqPrpsAssgmtTP _RequestedPurpose $projection.ChmlCmplncRequestUUID = _RequestedPurpose.ChmlCmplncRequestUUID
[0..*] I_ChmlCmplncReqSlsOrgTP _RequestedSlsOrg $projection.ChmlCmplncRequestUUID = _RequestedSlsOrg.ChmlCmplncRequestUUID
[0..*] I_ChmlCmplncReqPlntTP _RequestedPlnt $projection.ChmlCmplncRequestUUID = _RequestedPlnt.ChmlCmplncRequestUUID
[0..*] I_ChmlCmplncReqRouteSegmentTP _RouteSegment $projection.ChmlCmplncRequestUUID = _RouteSegment.ChmlCmplncRequestUUID

Annotations (20)

NameValueLevelField
EndUserText.label Chemical Compliance Request view
AbapCatalog.sqlViewName ICRQTP view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.transactionalProcessingEnabled true view
ObjectModel.modelCategory #BUSINESS_OBJECT view
ObjectModel.compositionRoot true view
ObjectModel.writeActivePersistence EHFNDV_CRQ view
ObjectModel.createEnabled EXTERNAL_CALCULATION view
ObjectModel.updateEnabled EXTERNAL_CALCULATION view
ObjectModel.deleteEnabled EXTERNAL_CALCULATION view
ObjectModel.entityChangeStateId LastChangeUTCDateTime view
ObjectModel.sapObjectNodeType.name ProdCmplncLogisticsRequest view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #B view

Fields (55)

KeyFieldSource TableSource FieldDescription
KEY ChmlCmplncRequestUUID ChmlCmplncRequestUUID Chemical Compliance Request
CreationUTCDateTime CreationUTCDateTime Time Stamp
CreatedByUser CreatedByUser User Name
LastChangeUTCDateTime LastChangeUTCDateTime Time Stamp
LastChangedByUser LastChangedByUser User Name
ChmlCmplncRequestDueDate ChmlCmplncRequestDueDate Due Date
ChmlCmplncReqCmplncProc ChmlCmplncReqCmplncProc Solution Area
ChmlCmplncRequestOriginType ChmlCmplncRequestOriginType Origin
ChmlCmplncReqOriginProc ChmlCmplncReqOriginProc Reason for Request
ChmlCmplncRequestPrgrsStatus ChmlCmplncRequestPrgrsStatus Status
ChmlCmplncBusinessProcess ChmlCmplncBusinessProcess Business Process
ChmlCmplncReqRequester ChmlCmplncReqRequester Requester
ChmlCmplncReqBPRequester ChmlCmplncReqBPRequester Requester
ChmlCmplncReqBPProcessor ChmlCmplncReqBPProcessor Processor
ChmlCmplncInfoUUID ChmlCmplncInfoUUID Chemical Compliance Information PP
ChmlCmplncProdUUID ChmlCmplncProdUUID Product Assignment
ChemicalCustomerMaterialUUID ChemicalCustomerMaterialUUID Customer Material
Material Material Vehicle Model
SalesDocument SalesDocument SD Document
SalesDocumentItem SalesDocumentItem Sales Document Item
ChmlCmplncReqLogisticDocCat ChmlCmplncReqLogisticDocCat Document Category
MultiComponentProduct MultiComponentProduct
ChmlCmplncRequestRemark ChmlCmplncRequestRemark Remark for Chemical Compliance Request
ChmlCmplncReqDetails ChmlCmplncReqDetails Request Details
ProdCmplncLogsDocument ProdCmplncLogsDocument Logistics Document
ProdCmplncLogsDocumentUUID ProdCmplncLogsDocumentUUID Logistics Doc. UUID
ProdCmplncLogsDocumentItem ProdCmplncLogsDocumentItem Item
BusinessSystemName BusinessSystemName Business System
DngrsGoodsModeOfTransport DngrsGoodsModeOfTransport Mode of Transport
Supplier Supplier Supplier
Customer Customer Sold-to Party
ProductComplianceRequest ProductComplianceRequest
_NewComplInfo _NewComplInfo
_RequestedMarket _RequestedMarket
_RequestedApplication _RequestedApplication
_RequestedPurpose _RequestedPurpose
_RequestedSlsOrg _RequestedSlsOrg
_RequestedPlnt _RequestedPlnt
_RouteSegment _RouteSegment
_CreatedByUser _CreatedByUser
_LastChangedByUser _LastChangedByUser
_Product _Product
_ChmlCmplncInfo _ChmlCmplncInfo
_ChemicalCustomerMaterial _ChemicalCustomerMaterial
_BusinessUserProcessor _BusinessUserProcessor
_BusinessUserRequester _BusinessUserRequester
_RequesterUser _RequesterUser
_ChmlCmplncReqCmplncProc _ChmlCmplncReqCmplncProc
_BusinessProcess _BusinessProcess
_OriginType _OriginType
_OriginProcess _OriginProcess
_Supplier _Supplier
_Customer _Customer
_RequestStatus _RequestStatus
_MultiComponentProduct _MultiComponentProduct

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_ChmlCmplncReqTP.
-- 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 I_ChmlCmplncReqTP AS
SELECT
  ChmlCmplncRequestUUID,
  CreationUTCDateTime,
  CreatedByUser,
  LastChangeUTCDateTime,
  LastChangedByUser,
  ChmlCmplncRequestDueDate,
  ChmlCmplncReqCmplncProc,
  ChmlCmplncRequestOriginType,
  ChmlCmplncReqOriginProc,
  ChmlCmplncRequestPrgrsStatus,
  ChmlCmplncBusinessProcess,
  ChmlCmplncReqRequester,
  ChmlCmplncReqBPRequester,
  ChmlCmplncReqBPProcessor,
  ChmlCmplncInfoUUID,
  ChmlCmplncProdUUID,
  ChemicalCustomerMaterialUUID,
  Material,
  SalesDocument,
  SalesDocumentItem,
  ChmlCmplncReqLogisticDocCat,
  MultiComponentProduct,
  ChmlCmplncRequestRemark,
  ChmlCmplncReqDetails,
  ProdCmplncLogsDocument,
  ProdCmplncLogsDocumentUUID,
  ProdCmplncLogsDocumentItem,
  BusinessSystemName,
  DngrsGoodsModeOfTransport,
  Supplier,
  Customer,
  ProductComplianceRequest
FROM I_ChmlCmplncReq
LEFT OUTER JOIN I_ChmlCmplncReqNewCmplncInfoTP AS _NewComplInfo ON ChmlCmplncRequestUUID = _NewComplInfo.ChmlCmplncRequestUUID  -- association [0..1]
LEFT OUTER JOIN I_ChmlCmplncReqMktTP AS _RequestedMarket ON ChmlCmplncRequestUUID = _RequestedMarket.ChmlCmplncRequestUUID  -- association [0..*]
LEFT OUTER JOIN I_ChmlCmplncReqApplicationTP AS _RequestedApplication ON ChmlCmplncRequestUUID = _RequestedApplication.ChmlCmplncRequestUUID  -- association [0..*]
LEFT OUTER JOIN I_ChmlCmplncReqPrpsAssgmtTP AS _RequestedPurpose ON ChmlCmplncRequestUUID = _RequestedPurpose.ChmlCmplncRequestUUID  -- association [0..*]
LEFT OUTER JOIN I_ChmlCmplncReqSlsOrgTP AS _RequestedSlsOrg ON ChmlCmplncRequestUUID = _RequestedSlsOrg.ChmlCmplncRequestUUID  -- association [0..*]
LEFT OUTER JOIN I_ChmlCmplncReqPlntTP AS _RequestedPlnt ON ChmlCmplncRequestUUID = _RequestedPlnt.ChmlCmplncRequestUUID  -- association [0..*]
LEFT OUTER JOIN I_ChmlCmplncReqRouteSegmentTP AS _RouteSegment ON ChmlCmplncRequestUUID = _RouteSegment.ChmlCmplncRequestUUID  -- association [0..*]
;

Learn More