P_ProdCmplncTskAffcdObjDets

DDL: P_PRODCMPLNCTSKAFFCDOBJDETS Type: view CONSUMPTION Package: EHFND_BO_PCEP
25 Fields 1 Data Sources 11 Associations

P view for Prod Cmplnc Tasks

P_ProdCmplncTskAffcdObjDets is a Consumption CDS View that provides data about "P view for Prod Cmplnc Tasks" in SAP S/4HANA. It reads from 1 data source (P_ProdCmplncTaskCast) and exposes 25 fields with key field ProdCmplncTaskUUID. It has 11 associations to related views. Part of development package EHFND_BO_PCEP.

Data Sources (1)

SourceAliasJoin Type
P_ProdCmplncTaskCast ProdCmplncTask from

Associations (11)

CardinalityTargetAliasCondition
[0..1] I_SubstanceEnhanced _Substance $projection.ProdCmplncTaskAffcdObj = _Substance.SubstanceUUID
[0..1] C_ChmlCmplncPrimMatl _ChmlCmplncPrimMatl $projection.ProdCmplncTaskAffcdObj = _ChmlCmplncPrimMatl.ChmlCmplncInfoUUID
[0..1] C_ChmlCmplncPrimMatl _ChmlCmpstnChmlCmplncPrimMatl $projection.ChmlCmpstnChmlCmplncInfoUUID = _ChmlCmpstnChmlCmplncPrimMatl.ChmlCmplncInfoUUID
[0..1] C_ChmlCmplncPrimMatl _CmplRqRsltChmlCmplncPrimMatl $projection.CmplRqRsltChmlCmplncInfoUUID = _CmplRqRsltChmlCmplncPrimMatl.ChmlCmplncInfoUUID
[0..1] I_ChmlCmplncInfo _ChmlCmplncInfo $projection.ProdCmplncTaskAffcdObj = _ChmlCmplncInfo.ChmlCmplncInfoUUID
[0..1] P_ChmlSuplrMatlData _ChmlSuplrMatlData $projection.ProdCmplncTaskAffcdObj = _ChmlSuplrMatlData.ChmlSuplrMatlUUID
[0..1] I_SubstanceLstdSubst _SubstanceLstdSubst $projection.ProdCmplncTaskAffcdObj = _SubstanceLstdSubst.SubstanceUUID
[0..1] I_SubstanceText _SubstanceText $projection.ProdCmplncTaskAffcdObj = _SubstanceText.SubstanceUUID and _SubstanceText.Language = $session.system_language
[0..1] I_BusinessPartner _SuplrMatlBusinessPartner $projection.BusinessPartnerSupplier = _SuplrMatlBusinessPartner.BusinessPartner
[0..1] C_ProdCmplncServiceRequest _ProdCmplncServiceRq $projection.ProdCmplncTaskAffcdObj = _ProdCmplncServiceRq.ProdCmplncServiceRequestUUID
[1..1] P_CChmlCmplConstants _Constants _Constants.Dummy = _Constants.Dummy

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName PPCTSKAFFOBJDET 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
EndUserText.label P view for Prod Cmplnc Tasks view

Fields (25)

KeyFieldSource TableSource FieldDescription
KEY ProdCmplncTaskUUID ProdCmplncTaskUUID Product Compliance Task
ProdCmplncTaskAffcdObj ProdCmplncTaskAffcdObj Task-Affected Object
ChmlSuplrMatlUUID ChmlSuplrMatl ChmlSuplrMatlUUID Supplier Raw Material
BusinessPartnerSupplier ChmlSuplrMatl BusinessPartnerSupplier Supplier
ChmlCmpstnChmlCmplncInfoUUID ChmlComposition ChmlCmplncInfoUUID Chemical Compliance Information PP
CmplRqRsltChmlCmplncInfoUUID CmplRqRslt ChmlCmplncInfoUUID Chemical Compliance Information PP
CmplRqRsltChmlSuplrMatlUUID CmplRqRslt ChmlSuplrMatlUUID Supplier Raw Material
ChmlCmplncInternalName _ChmlCmplncInfo ChmlCmplncInternalName Internal Name
ProductName _ChmlCmplncPrimMatl MaterialName Material Description
ChmlCmpstnProductName _ChmlCmpstnChmlCmplncPrimMatl MaterialName Material Description
CmplRqRsltProductName _CmplRqRsltChmlCmplncPrimMatl MaterialName Material Description
Material _ChmlCmplncPrimMatl Material Vehicle Model
ChmlCmpstnMaterial _ChmlCmpstnChmlCmplncPrimMatl Material Vehicle Model
CmplRqRsltMaterial _CmplRqRsltChmlCmplncPrimMatl Material Vehicle Model
SubstanceInternalName _Substance SubstanceInternalName Internal Name
CompanySubstanceName _SubstanceText SubstanceName Substance Name
CustListedSubstanceDfltName _SubstanceLstdSubst CustListedSubstanceDfltName
CntntListedSubstanceDfltName _SubstanceLstdSubst CntntListedSubstanceDfltName
SearchTerm1 _SuplrMatlBusinessPartner SearchTerm1 Search Term 1
SearchTerm2 _SuplrMatlBusinessPartner SearchTerm2 Search Term 2
OrganizationBPName1 _SuplrMatlBusinessPartner OrganizationBPName1 Name 1
OrganizationBPName2 _SuplrMatlBusinessPartner OrganizationBPName2 Name 2
OrganizationBPName3 _SuplrMatlBusinessPartner OrganizationBPName3 Name 3
OrganizationBPName4 _SuplrMatlBusinessPartner OrganizationBPName4 Name 4
ProdCmplncProductOrCompName _ProdCmplncServiceRq ProdCmplncProductOrCompName Product / Substance

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_ProdCmplncTskAffcdObjDets.
-- 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_ProdCmplncTskAffcdObjDets AS
SELECT
  ProdCmplncTaskUUID,
  ProdCmplncTaskAffcdObj,
  ChmlSuplrMatl.ChmlSuplrMatlUUID AS ChmlSuplrMatlUUID,
  ChmlSuplrMatl.BusinessPartnerSupplier AS BusinessPartnerSupplier,
  ChmlComposition.ChmlCmplncInfoUUID AS ChmlCmpstnChmlCmplncInfoUUID,
  CmplRqRslt.ChmlCmplncInfoUUID AS CmplRqRsltChmlCmplncInfoUUID,
  CmplRqRslt.ChmlSuplrMatlUUID AS CmplRqRsltChmlSuplrMatlUUID,
  _ChmlCmplncInfo.ChmlCmplncInternalName AS ChmlCmplncInternalName,
  _ChmlCmplncPrimMatl.MaterialName AS ProductName,
  _ChmlCmpstnChmlCmplncPrimMatl.MaterialName AS ChmlCmpstnProductName,
  _CmplRqRsltChmlCmplncPrimMatl.MaterialName AS CmplRqRsltProductName,
  _ChmlCmplncPrimMatl.Material AS Material,
  _ChmlCmpstnChmlCmplncPrimMatl.Material AS ChmlCmpstnMaterial,
  _CmplRqRsltChmlCmplncPrimMatl.Material AS CmplRqRsltMaterial,
  _Substance.SubstanceInternalName AS SubstanceInternalName,
  _SubstanceText.SubstanceName AS CompanySubstanceName,
  _SubstanceLstdSubst.CustListedSubstanceDfltName AS CustListedSubstanceDfltName,
  _SubstanceLstdSubst.CntntListedSubstanceDfltName AS CntntListedSubstanceDfltName,
  _SuplrMatlBusinessPartner.SearchTerm1 AS SearchTerm1,
  _SuplrMatlBusinessPartner.SearchTerm2 AS SearchTerm2,
  _SuplrMatlBusinessPartner.OrganizationBPName1 AS OrganizationBPName1,
  _SuplrMatlBusinessPartner.OrganizationBPName2 AS OrganizationBPName2,
  _SuplrMatlBusinessPartner.OrganizationBPName3 AS OrganizationBPName3,
  _SuplrMatlBusinessPartner.OrganizationBPName4 AS OrganizationBPName4,
  _ProdCmplncServiceRq.ProdCmplncProductOrCompName AS ProdCmplncProductOrCompName
FROM P_ProdCmplncTaskCast AS ProdCmplncTask
LEFT OUTER JOIN I_SubstanceEnhanced AS _Substance ON ProdCmplncTaskAffcdObj = _Substance.SubstanceUUID  -- association [0..1]
LEFT OUTER JOIN C_ChmlCmplncPrimMatl AS _ChmlCmplncPrimMatl ON ProdCmplncTaskAffcdObj = _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_ChmlCmplncInfo AS _ChmlCmplncInfo ON ProdCmplncTaskAffcdObj = _ChmlCmplncInfo.ChmlCmplncInfoUUID  -- association [0..1]
LEFT OUTER JOIN P_ChmlSuplrMatlData AS _ChmlSuplrMatlData ON ProdCmplncTaskAffcdObj = _ChmlSuplrMatlData.ChmlSuplrMatlUUID  -- association [0..1]
LEFT OUTER JOIN I_SubstanceLstdSubst AS _SubstanceLstdSubst ON ProdCmplncTaskAffcdObj = _SubstanceLstdSubst.SubstanceUUID  -- association [0..1]
LEFT OUTER JOIN I_SubstanceText AS _SubstanceText ON ProdCmplncTaskAffcdObj = _SubstanceText.SubstanceUUID AND _SubstanceText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _SuplrMatlBusinessPartner ON BusinessPartnerSupplier = _SuplrMatlBusinessPartner.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN C_ProdCmplncServiceRequest AS _ProdCmplncServiceRq ON ProdCmplncTaskAffcdObj = _ProdCmplncServiceRq.ProdCmplncServiceRequestUUID  -- association [0..1]
LEFT OUTER JOIN P_CChmlCmplConstants AS _Constants ON _Constants.Dummy = _Constants.Dummy  -- association [1..1]
;

Learn More