R_ChmlCustMatlImprtRespyTP

DDL: R_CHMLCUSTMATLIMPRTRESPYTP Type: view_entity TRANSACTIONAL Package: EHFND_RAP_CCM
21 Fields 1 Data Sources

CCM Import Responsibility - TP

R_ChmlCustMatlImprtRespyTP is a Transactional CDS View that provides data about "CCM Import Responsibility - TP" in SAP S/4HANA. It reads from 1 data source (I_ChmlCustMatlImprtRespy) and exposes 21 fields with key field ChmlCustMatlImprtRespyUUID. Part of development package EHFND_RAP_CCM.

Data Sources (1)

SourceAliasJoin Type
I_ChmlCustMatlImprtRespy I_ChmlCustMatlImprtRespy from

Annotations (10)

NameValueLevelField
EndUserText.label CCM Import Responsibility - TP view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.representativeKey ChmlCustMatlImprtRespyUUID view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
Metadata.allowExtensions true view

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY ChmlCustMatlImprtRespyUUID ChmlCustMatlImprtRespyUUID
CreationUTCDateTime CreationUTCDateTime Time Stamp
CreatedByUser CreatedByUser User Name
LastChangeUTCDateTime LastChangeUTCDateTime Time Stamp
LastChangedByUser LastChangedByUser User Name
ChemicalCustomerMaterialUUID ChemicalCustomerMaterialUUID Customer Material
ImprtRespySellingCompanyCode ImprtRespySellingCompanyCode
ImprtRespyDlvgPlant ImprtRespyDlvgPlant
ImprtRespyRespImporter ImprtRespyRespImporter Responsible Importer
ValidityStartDate ValidityStartDate Validity Start Date
ValidityEndDate ValidityEndDate ValidTo
ImprtRespyRemarkText ImprtRespyRemarkText Import Responsibility Remark
ImprtRespyDlvgPlantName
Associations_ChemicalCustomerMaterial
_ResponsibleImporter _ResponsibleImporter
_ResponsibleImporterTxt _ResponsibleImporterTxt
_DeliveringPlant _DeliveringPlant
_SellingCompany _SellingCompany
_CreatedByUser _CreatedByUser
_LastChangedByUser _LastChangedByUser
Parent_ChemicalCustomerMaterialTP

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 R_ChmlCustMatlImprtRespyTP.
-- 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 R_ChmlCustMatlImprtRespyTP AS
SELECT
  ChmlCustMatlImprtRespyUUID,
  CreationUTCDateTime,
  CreatedByUser,
  LastChangeUTCDateTime,
  LastChangedByUser,
  ChemicalCustomerMaterialUUID,
  ImprtRespySellingCompanyCode,
  ImprtRespyDlvgPlant,
  ImprtRespyRespImporter,
  ValidityStartDate,
  ValidityEndDate,
  ImprtRespyRemarkText,
  cast( coalesce(_DeliveringPlant.PlantName, _PlantNameAny.Text ) as sotr_txt ) AS ImprtRespyDlvgPlantName
FROM I_ChmlCustMatlImprtRespy
;

Learn More