I_CmplRqRsltWasteCodeNoteTP

DDL: I_CMPLRQRSLTWASTECODENOTETP SQL: ICRRWSTCDNOTETP Type: view TRANSACTIONAL Package: EHSDS_CRPAT_WASTE_CODE
7 Fields 1 Data Sources 1 Associations 1 OData Services

Waste Code Note - TP

I_CmplRqRsltWasteCodeNoteTP is a Transactional CDS View that provides data about "Waste Code Note - TP" in SAP S/4HANA. It reads from 1 data source (I_CmplRqRsltWasteCodeNote) and exposes 7 fields with key field PCPrptyNoteUUID. It has 1 association to related views. It is exposed through 1 OData service (ASQL_F6278). Part of development package EHSDS_CRPAT_WASTE_CODE.

Data Sources (1)

SourceAliasJoin Type
I_CmplRqRsltWasteCodeNote I_CmplRqRsltWasteCodeNote from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_CmplRqRsltWasteCodeTP _CmplRqRsltWasteCode $projection.PCPrptyRootUUID = _CmplRqRsltWasteCode.CmplRqRsltUUID

Annotations (19)

NameValueLevelField
AbapCatalog.sqlViewName ICRRWSTCDNOTETP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.representativeKey PCPrptyNoteUUID view
ObjectModel.semanticKey PCPrptyNoteUUID view
ObjectModel.transactionalProcessingUnitRoot true view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled true view
ObjectModel.writeActivePersistence EHFNDV_NOTES view
ObjectModel.writeDraftPersistence EHFNDW_WST_NOTE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
EndUserText.label Waste Code Note - TP view

OData Services (1)

ServiceBindingVersionContractRelease
ASQL_F6278 ASQL_F6278 C2 NOT_RELEASED

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY PCPrptyNoteUUID PCPrptyNoteUUID UUID of Note
PCPrptyParentType PCPrptyParentType Parent object type
PCPrptyParentUUID PCPrptyParentUUID Parent Object
PCPrptyRootType PCPrptyRootType Root object type
PCPrptyRootUUID PCPrptyRootUUID Root object
PCPrptyNoteText PCPrptyNoteText Comments
_CmplRqRsltWasteCode _CmplRqRsltWasteCode

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_CmplRqRsltWasteCodeNoteTP.
-- 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.
-- SQL view name: ICRRWSTCDNOTETP

CREATE VIEW I_CmplRqRsltWasteCodeNoteTP AS
SELECT
  PCPrptyNoteUUID,
  PCPrptyParentType,
  PCPrptyParentUUID,
  PCPrptyRootType,
  PCPrptyRootUUID,
  PCPrptyNoteText
FROM I_CmplRqRsltWasteCodeNote
LEFT OUTER JOIN I_CmplRqRsltWasteCodeTP AS _CmplRqRsltWasteCode ON PCPrptyRootUUID = _CmplRqRsltWasteCode.CmplRqRsltUUID  -- association [1..1]
;

Learn More