Which tables does P_ProdCmplncEvtInitObjDets read from?

P_ProdCmplncEvtInitObjDets reads data from: I_ProdCmplncEvent.

What VDM layer is P_ProdCmplncEvtInitObjDets?

P_ProdCmplncEvtInitObjDets is classified as a Consumption view optimized for specific business scenarios and reporting.

P_ProdCmplncEvtInitObjDets

Q: What is P_ProdCmplncEvtInitObjDets in SAP S/4HANA?

P_ProdCmplncEvtInitObjDets is a consumption CDS view in SAP S/4HANA. It contains 60 fields.

DDL: P_PRODCMPLNCEVTINITOBJDETS Type: view CONSUMPTION

60 Fields 1 Data Sources 17 Associations

P_ProdCmplncEvtInitObjDets is a Consumption CDS View in SAP S/4HANA. It reads from 1 data source (I_ProdCmplncEvent) and exposes 60 fields with key field ProdCmplncEventUUID. It has 17 associations to related views.

Data Sources (1)

Source	Alias	Join Type
I_ProdCmplncEvent	ProdCmplncEvent	from

Associations (17)

Cardinality	Target	Alias	Condition
[0..1]	I_CmplncPrps	_CmplncPrps	`$projection.ProdCmplncEventSourceUUID = _CmplncPrps.CmplncPrpsUUID`
[0..1]	I_CmplncPrpsText	_CmplncPrpsText	`$projection.ProdCmplncEventSourceUUID = _CmplncPrpsText.CmplncPrpsUUID and _CmplncPrpsText.Language = $session.system_language`
[0..1]	I_CmplRqVersEnhanced	_CmplRqVers	`$projection.ProdCmplncEventSourceUUID = _CmplRqVers.CmplRqVersUUID`
[0..1]	C_ChmlCmplncPrimMatl	_ChmlCmplncPrimMatl	`$projection.ProdCmplncEventSourceUUID = _ChmlCmplncPrimMatl.ChmlCmplncInfoUUID`
[0..1]	C_ChmlCmplncPrimMatl	_ChmlCmpstnChmlCmplncPrimMatl	`$projection.ChmlCmpstnChmlCmplncInfoUUID = _ChmlCmpstnChmlCmplncPrimMatl.ChmlCmplncInfoUUID --CCI`
[0..1]	C_ChmlCmplncPrimMatl	_CmplRqRsltChmlCmplncPrimMatl	`$projection.CmplRqRsltChmlCmplncInfoUUID = _CmplRqRsltChmlCmplncPrimMatl.ChmlCmplncInfoUUID --CSM`
[0..1]	I_BusinessPartner	_CrrSuplrMatlBusinessPartner	`$projection.CrrChmlSuplrMatlBPSupplier = _CrrSuplrMatlBusinessPartner.BusinessPartner`
[0..1]	C_ChmlCmplncPrimMatl	_CrrCsmCmplncPrimMatl	`$projection.CrrCsmCciAssgmtCciUUID = _CrrCsmCmplncPrimMatl.ChmlCmplncInfoUUID --Substance`
[0..1]	I_SubstanceEnhanced	_SubstanceByCmplRqRslt	`$projection.CmplRqRsltSubstanceUUID = _SubstanceByCmplRqRslt.SubstanceUUID`
[0..1]	I_SubstanceLstdSubst	_SubstLstdSubstByCmplRqRslt	`$projection.CmplRqRsltSubstanceUUID = _SubstLstdSubstByCmplRqRslt.SubstanceUUID`
[0..1]	I_SubstanceText	_SubstanceTextByCmplRqRslt	`$projection.CmplRqRsltSubstanceUUID = _SubstanceTextByCmplRqRslt.SubstanceUUID and _SubstanceTextByCmplRqRslt.Language = $session.system_language`
[0..1]	I_CmplRqVersEnhanced	_CmplRqRsltCmplRqVers	`CmplRqRslt.CmplRqVersUUID = _CmplRqRsltCmplRqVers.CmplRqVersUUID`
[0..1]	I_SubstanceEnhanced	_Substance	`$projection.ProdCmplncEventSourceUUID = _Substance.SubstanceUUID`
[0..1]	I_SubstanceLstdSubst	_SubstanceLstdSubst	`$projection.ProdCmplncEventSourceUUID = _SubstanceLstdSubst.SubstanceUUID`
[0..1]	I_SubstanceText	_SubstanceText	`$projection.ProdCmplncEventSourceUUID = _SubstanceText.SubstanceUUID and _SubstanceText.Language = $session.system_language`
[0..1]	I_BusinessPartner	_SuplrMatlBusinessPartner	`$projection.ChmlSuplrMatlBPSupplier = _SuplrMatlBusinessPartner.BusinessPartner`
[0..1]	C_ChmlCmplncPrimMatl	_ChmlSuplrMatlCmplncPrimMatl	`$projection.SuplrMatlAssgmtCciUUID = _ChmlSuplrMatlCmplncPrimMatl.ChmlCmplncInfoUUID`

Annotations (8)

Name	Value	Level
AbapCatalog.sqlViewName	PPCEIODET	view
AbapCatalog.compiler.compareFilter	true	view
AbapCatalog.preserveKey	true	view
AccessControl.authorizationCheck	#NOT_REQUIRED	view
AccessControl.personalData.blocking	#NOT_REQUIRED	view
VDM.private	true	view
VDM.viewType	#CONSUMPTION	view
ClientHandling.algorithm	#SESSION_VARIABLE	view

Fields (60)

Key	Field	Source Table	Source Field	Description
KEY	ProdCmplncEventUUID		ProdCmplncEventUUID	Product Compliance Event
	ProdCmplncEventSourceUUID		ProdCmplncEventSourceUUID	Event Source UUID
	ChmlCmpstnChmlCmplncInfoUUID	ChmlComposition	ChmlCmplncInfoUUID	Chemical Compliance Information PP
	CmplRqRsltChmlCmplncInfoUUID	CmplRqRslt	ChmlCmplncInfoUUID	Chemical Compliance Information PP
	CmplRqRsltChmlSuplrMatlUUID	CmplRqRslt	ChmlSuplrMatlUUID	Supplier Raw Material
	CmplRqRsltSubstanceUUID	CmplRqRslt	SubstanceUUID	Substance
	SuplrMatlAssgmtCciUUID	ChmlCmplncSuplrMatlAssgmt	ChmlCmplncInfoUUID	Chemical Compliance Information PP
	CrrCsmCciAssgmtCciUUID	CrrCsmCciAssgmt	ChmlCmplncInfoUUID	Chemical Compliance Information PP
	ChmlSuplrMatlBPSupplier	ChmlSuplrMatl	BusinessPartnerSupplier	Supplier
	CrrChmlSuplrMatlBPSupplier	CrrChmlSuplrMatl	BusinessPartnerSupplier	Supplier
	CmplncPrpsName	_CmplncPrpsText	CmplncPrpsName	Compliance Purpose Name
	CmplncPrps	_CmplncPrps	CmplncPrps	Purpose ID
	CmplRqVers
	CmplRqVersID	_CmplRqVers	CmplRqVers	Compliance Requirement
	CmplRqVersEnglishName	_CmplRqVers	CmplRqVersEnglishName
	ComplianceRequirement	_CmplRqVers	ComplianceRequirement	Compliance Requirement
	ChmlCmplncInternalName
	ProductName	_ChmlCmplncPrimMatl	MaterialName	Material Description
	Material	_ChmlCmplncPrimMatl	Material	Vehicle Model
	Specification
	ChmlCmpstnCmplncInternalName
	ChmlCmpstnProductName	_ChmlCmpstnChmlCmplncPrimMatl	MaterialName	Material Description
	ChmlCmpstnMaterial	_ChmlCmpstnChmlCmplncPrimMatl	Material	Vehicle Model
	ChmlCmpstnChmlCmplncInfoSpec
	CmplRqRsltProductName	_CmplRqRsltChmlCmplncPrimMatl	MaterialName	Material Description
	CmplRqRsltMaterial	_CmplRqRsltChmlCmplncPrimMatl	Material	Vehicle Model
	CmplRqRsltChmlCmplncInfoSpec
	CmplRqRsltSuplrMatlProdName	_CrrCsmCmplncPrimMatl	MaterialName	Material Description
	CmplRqRsltSuplrMatlMaterial	_CrrCsmCmplncPrimMatl	Material	Vehicle Model
	CmplRqRsltFirstName	_CrrSuplrMatlBusinessPartner	FirstName	First Name
	CmplRqRsltLastName	_CrrSuplrMatlBusinessPartner	LastName	Last Name
	CmplRqRsltOrgBPName1	_CrrSuplrMatlBusinessPartner	OrganizationBPName1	Name 1
	CmplRqRsltOrgBPName2	_CrrSuplrMatlBusinessPartner	OrganizationBPName2	Name 2
	CmplRqRsltGroupBPName1	_CrrSuplrMatlBusinessPartner	GroupBusinessPartnerName1	Name 1
	CmplRqRsltGroupBPName2	_CrrSuplrMatlBusinessPartner	GroupBusinessPartnerName2	Name 2
	CmplRqRsltChmlSuplrMatlSpec
	SubstanceNameasCmplRqRsltSubstanceName
	CmplRqRsltCustLstdSubstName	_SubstLstdSubstByCmplRqRslt	CustListedSubstanceDfltName
	CmplRqRsltCntntLstdSubstName	_SubstLstdSubstByCmplRqRslt	CntntListedSubstanceDfltName
	CmplRqRsltSubstanceSpec	_SubstanceByCmplRqRslt	Specification	Specification
	CmplRqRsltCustLstdSubst	_SubstLstdSubstByCmplRqRslt	CustListedSubstance
	CmplRqRsltCntntLstdSubst	_SubstLstdSubstByCmplRqRslt	CntntListedSubstance
	CmplRqRsltVersName
	CmplRqRsltCmplRq	_CmplRqRsltCmplRqVers	ComplianceRequirement	Compliance Requirement
	CompanySubstanceName	_SubstanceText	SubstanceName	Substance Name
	CustListedSubstanceDfltName	_SubstanceLstdSubst	CustListedSubstanceDfltName
	CntntListedSubstanceDfltName	_SubstanceLstdSubst	CntntListedSubstanceDfltName
	SubstanceSpecification	_Substance	Specification	Specification
	CustListedSubstance	_SubstanceLstdSubst	CustListedSubstance
	CntntListedSubstance	_SubstanceLstdSubst	CntntListedSubstance
	ChmlSuplrMatlChmCmInIntName
	ChmlSuplrMatlChmCmInProdName	_ChmlSuplrMatlCmplncPrimMatl	MaterialName	Material Description
	ChmlSuplrMatlMaterial	_ChmlSuplrMatlCmplncPrimMatl	Material	Vehicle Model
	FirstName	_SuplrMatlBusinessPartner	FirstName	First Name
	LastName	_SuplrMatlBusinessPartner	LastName	Last Name
	OrganizationBPName1	_SuplrMatlBusinessPartner	OrganizationBPName1	Name 1
	OrganizationBPName2	_SuplrMatlBusinessPartner	OrganizationBPName2	Name 2
	GroupBusinessPartnerName1	_SuplrMatlBusinessPartner	GroupBusinessPartnerName1	Name 1
	GroupBusinessPartnerName2	_SuplrMatlBusinessPartner	GroupBusinessPartnerName2	Name 2
	ChmlSuplrMatlChmCmInSpec

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 P_ProdCmplncEvtInitObjDets.
-- 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 P_ProdCmplncEvtInitObjDets AS
SELECT
  ProdCmplncEventUUID,
  ProdCmplncEventSourceUUID,
  ChmlComposition.ChmlCmplncInfoUUID AS ChmlCmpstnChmlCmplncInfoUUID,
  CmplRqRslt.ChmlCmplncInfoUUID AS CmplRqRsltChmlCmplncInfoUUID,
  CmplRqRslt.ChmlSuplrMatlUUID AS CmplRqRsltChmlSuplrMatlUUID,
  CmplRqRslt.SubstanceUUID AS CmplRqRsltSubstanceUUID,
  ChmlCmplncSuplrMatlAssgmt.ChmlCmplncInfoUUID AS SuplrMatlAssgmtCciUUID,
  CrrCsmCciAssgmt.ChmlCmplncInfoUUID AS CrrCsmCciAssgmtCciUUID,
  ChmlSuplrMatl.BusinessPartnerSupplier AS ChmlSuplrMatlBPSupplier,
  CrrChmlSuplrMatl.BusinessPartnerSupplier AS CrrChmlSuplrMatlBPSupplier,
  _CmplncPrpsText.CmplncPrpsName AS CmplncPrpsName,
  _CmplncPrps.CmplncPrps AS CmplncPrps,
  _CmplRqVers._CmplRqVersTextInCurrentLang.CmplRqVersName AS CmplRqVers,
  _CmplRqVers.CmplRqVers AS CmplRqVersID,
  _CmplRqVers.CmplRqVersEnglishName AS CmplRqVersEnglishName,
  _CmplRqVers.ComplianceRequirement AS ComplianceRequirement,
  _ChmlCmplncPrimMatl._ChmlCmplncInfo.ChmlCmplncInternalName AS ChmlCmplncInternalName,
  _ChmlCmplncPrimMatl.MaterialName AS ProductName,
  _ChmlCmplncPrimMatl.Material AS Material,
  _ChmlCmplncPrimMatl._ChmlCmplncInfo.Specification AS Specification,
  _ChmlCmpstnChmlCmplncPrimMatl._ChmlCmplncInfo.ChmlCmplncInternalName AS ChmlCmpstnCmplncInternalName,
  _ChmlCmpstnChmlCmplncPrimMatl.MaterialName AS ChmlCmpstnProductName,
  _ChmlCmpstnChmlCmplncPrimMatl.Material AS ChmlCmpstnMaterial,
  _ChmlCmpstnChmlCmplncPrimMatl._ChmlCmplncInfo.Specification AS ChmlCmpstnChmlCmplncInfoSpec,
  _CmplRqRsltChmlCmplncPrimMatl.MaterialName AS CmplRqRsltProductName,
  _CmplRqRsltChmlCmplncPrimMatl.Material AS CmplRqRsltMaterial,
  _CmplRqRsltChmlCmplncPrimMatl._ChmlCmplncInfo.Specification AS CmplRqRsltChmlCmplncInfoSpec,
  _CrrCsmCmplncPrimMatl.MaterialName AS CmplRqRsltSuplrMatlProdName,
  _CrrCsmCmplncPrimMatl.Material AS CmplRqRsltSuplrMatlMaterial,
  _CrrSuplrMatlBusinessPartner.FirstName AS CmplRqRsltFirstName,
  _CrrSuplrMatlBusinessPartner.LastName AS CmplRqRsltLastName,
  _CrrSuplrMatlBusinessPartner.OrganizationBPName1 AS CmplRqRsltOrgBPName1,
  _CrrSuplrMatlBusinessPartner.OrganizationBPName2 AS CmplRqRsltOrgBPName2,
  _CrrSuplrMatlBusinessPartner.GroupBusinessPartnerName1 AS CmplRqRsltGroupBPName1,
  _CrrSuplrMatlBusinessPartner.GroupBusinessPartnerName2 AS CmplRqRsltGroupBPName2,
  _CrrCsmCmplncPrimMatl._ChmlCmplncInfo.Specification AS CmplRqRsltChmlSuplrMatlSpec,
  _SubstLstdSubstByCmplRqRslt.CustListedSubstanceDfltName AS CmplRqRsltCustLstdSubstName,
  _SubstLstdSubstByCmplRqRslt.CntntListedSubstanceDfltName AS CmplRqRsltCntntLstdSubstName,
  _SubstanceByCmplRqRslt.Specification AS CmplRqRsltSubstanceSpec,
  _SubstLstdSubstByCmplRqRslt.CustListedSubstance AS CmplRqRsltCustLstdSubst,
  _SubstLstdSubstByCmplRqRslt.CntntListedSubstance AS CmplRqRsltCntntLstdSubst,
  _CmplRqRsltCmplRqVers._CmplRqVersTextInCurrentLang.CmplRqVersName AS CmplRqRsltVersName,
  _CmplRqRsltCmplRqVers.ComplianceRequirement AS CmplRqRsltCmplRq,
  _SubstanceText.SubstanceName AS CompanySubstanceName,
  _SubstanceLstdSubst.CustListedSubstanceDfltName AS CustListedSubstanceDfltName,
  _SubstanceLstdSubst.CntntListedSubstanceDfltName AS CntntListedSubstanceDfltName,
  _Substance.Specification AS SubstanceSpecification,
  _SubstanceLstdSubst.CustListedSubstance AS CustListedSubstance,
  _SubstanceLstdSubst.CntntListedSubstance AS CntntListedSubstance,
  _ChmlSuplrMatlCmplncPrimMatl._ChmlCmplncInfo.ChmlCmplncInternalName AS ChmlSuplrMatlChmCmInIntName,
  _ChmlSuplrMatlCmplncPrimMatl.MaterialName AS ChmlSuplrMatlChmCmInProdName,
  _ChmlSuplrMatlCmplncPrimMatl.Material AS ChmlSuplrMatlMaterial,
  _SuplrMatlBusinessPartner.FirstName AS FirstName,
  _SuplrMatlBusinessPartner.LastName AS LastName,
  _SuplrMatlBusinessPartner.OrganizationBPName1 AS OrganizationBPName1,
  _SuplrMatlBusinessPartner.OrganizationBPName2 AS OrganizationBPName2,
  _SuplrMatlBusinessPartner.GroupBusinessPartnerName1 AS GroupBusinessPartnerName1,
  _SuplrMatlBusinessPartner.GroupBusinessPartnerName2 AS GroupBusinessPartnerName2,
  _ChmlSuplrMatlCmplncPrimMatl._ChmlCmplncInfo.Specification AS ChmlSuplrMatlChmCmInSpec
FROM I_ProdCmplncEvent AS ProdCmplncEvent
LEFT OUTER JOIN I_CmplncPrps AS _CmplncPrps ON ProdCmplncEventSourceUUID = _CmplncPrps.CmplncPrpsUUID  -- association [0..1]
LEFT OUTER JOIN I_CmplncPrpsText AS _CmplncPrpsText ON ProdCmplncEventSourceUUID = _CmplncPrpsText.CmplncPrpsUUID AND _CmplncPrpsText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_CmplRqVersEnhanced AS _CmplRqVers ON ProdCmplncEventSourceUUID = _CmplRqVers.CmplRqVersUUID  -- association [0..1]
LEFT OUTER JOIN C_ChmlCmplncPrimMatl AS _ChmlCmplncPrimMatl ON ProdCmplncEventSourceUUID = _ChmlCmplncPrimMatl.ChmlCmplncInfoUUID  -- association [0..1]
LEFT OUTER JOIN C_ChmlCmplncPrimMatl AS _ChmlCmpstnChmlCmplncPrimMatl ON ChmlCmpstnChmlCmplncInfoUUID = _ChmlCmpstnChmlCmplncPrimMatl.ChmlCmplncInfoUUID  -- association [0..1]
LEFT OUTER JOIN C_ChmlCmplncPrimMatl AS _CmplRqRsltChmlCmplncPrimMatl ON CmplRqRsltChmlCmplncInfoUUID = _CmplRqRsltChmlCmplncPrimMatl.ChmlCmplncInfoUUID  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _CrrSuplrMatlBusinessPartner ON CrrChmlSuplrMatlBPSupplier = _CrrSuplrMatlBusinessPartner.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN C_ChmlCmplncPrimMatl AS _CrrCsmCmplncPrimMatl ON CrrCsmCciAssgmtCciUUID = _CrrCsmCmplncPrimMatl.ChmlCmplncInfoUUID  -- association [0..1]
LEFT OUTER JOIN I_SubstanceEnhanced AS _SubstanceByCmplRqRslt ON CmplRqRsltSubstanceUUID = _SubstanceByCmplRqRslt.SubstanceUUID  -- association [0..1]
LEFT OUTER JOIN I_SubstanceLstdSubst AS _SubstLstdSubstByCmplRqRslt ON CmplRqRsltSubstanceUUID = _SubstLstdSubstByCmplRqRslt.SubstanceUUID  -- association [0..1]
LEFT OUTER JOIN I_SubstanceText AS _SubstanceTextByCmplRqRslt ON CmplRqRsltSubstanceUUID = _SubstanceTextByCmplRqRslt.SubstanceUUID AND _SubstanceTextByCmplRqRslt.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_CmplRqVersEnhanced AS _CmplRqRsltCmplRqVers ON CmplRqRslt.CmplRqVersUUID = _CmplRqRsltCmplRqVers.CmplRqVersUUID  -- association [0..1]
LEFT OUTER JOIN I_SubstanceEnhanced AS _Substance ON ProdCmplncEventSourceUUID = _Substance.SubstanceUUID  -- association [0..1]
LEFT OUTER JOIN I_SubstanceLstdSubst AS _SubstanceLstdSubst ON ProdCmplncEventSourceUUID = _SubstanceLstdSubst.SubstanceUUID  -- association [0..1]
LEFT OUTER JOIN I_SubstanceText AS _SubstanceText ON ProdCmplncEventSourceUUID = _SubstanceText.SubstanceUUID AND _SubstanceText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _SuplrMatlBusinessPartner ON ChmlSuplrMatlBPSupplier = _SuplrMatlBusinessPartner.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN C_ChmlCmplncPrimMatl AS _ChmlSuplrMatlCmplncPrimMatl ON SuplrMatlAssgmtCciUUID = _ChmlSuplrMatlCmplncPrimMatl.ChmlCmplncInfoUUID  -- association [0..1]
;

Depth:

P_ProdCmplncEvtInitObjDets view

I_ProdCmplncEvent view