I_MDChgProcModCstmFldPrpty

DDL: I_MDCHGPROCMODCSTMFLDPRPTY SQL: IMDCHGPROCMCFP Type: view BASIC

MDC Model Custom Field Property

I_MDChgProcModCstmFldPrpty is a Basic CDS View that provides data about "MDC Model Custom Field Property" in SAP S/4HANA. It reads from 1 data source (mdc_modelcfields) and exposes 6 fields with key fields Client, MDChgProcessSrceObjectTypeCode, MDChgProcessModelTableName, MDChangeProcessModelFieldName.

Data Sources (1)

SourceAliasJoin Type
mdc_modelcfields mdc_modelcfields from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IMDCHGPROCMCFP view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #CUSTOMIZING view
VDM.viewType #BASIC view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label MDC Model Custom Field Property view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY Client client Workflow definition: Client
KEY MDChgProcessSrceObjectTypeCode bo_type SOT Name
KEY MDChgProcessModelTableName table_name Table Name
KEY MDChangeProcessModelFieldName field_name VAT Declaration Fld
MDChgProcModelFieldIsObscured obscured Hidden
MDChgProcModelFieldIsTechnical technical TRUE

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_MDChgProcModCstmFldPrpty.
-- 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: IMDCHGPROCMCFP

CREATE VIEW I_MDChgProcModCstmFldPrpty AS
SELECT
  Client,
  bo_type AS MDChgProcessSrceObjectTypeCode,
  table_name AS MDChgProcessModelTableName,
  field_name AS MDChangeProcessModelFieldName,
  obscured AS MDChgProcModelFieldIsObscured,
  technical AS MDChgProcModelFieldIsTechnical
FROM mdc_modelcfields
;