OIB_USERDEF_VMR_CDS

DDL: OIB_USERDEF_VMR_CDS SQL: OIBUSERDEF_V Type: view
16 Fields 1 Data Sources

Conversion parameters for user defaults VMR

OIB_USERDEF_VMR_CDS is a CDS View that provides data about "Conversion parameters for user defaults VMR" in SAP S/4HANA. It reads from 1 data source (oib_userdef_vmr) and exposes 16 fields with key fields Plant, Material, ExternalPlant, ExternalMaterial, OilPhysParamName.

Data Sources (1)

SourceAliasJoin Type
oib_userdef_vmr oib_userdef_vmr from

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName OIBUSERDEF_V view
AbapCatalog.compiler.compareFilter true view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view
EndUserText.label Conversion parameters for user defaults VMR view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY Plant werks Receiving Plant
KEY Material matnr Vehicle Model
KEY ExternalPlant
KEY ExternalMaterial
KEY OilPhysParamName
OilPhysParamFieldName
OilPhysParamUoMFieldName
IsOilPhysParamReadOnly
OilPhysParamDescStyle
OilPhysParamCheckStyle
OilPhysParamValueStyle
OilPhysParamUnitStyle
OilPhysParamDesc
IsOilPhysParam
OilPhysParamValue
OilPhysParamUoM

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 OIB_USERDEF_VMR_CDS.
-- 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: OIBUSERDEF_V

CREATE VIEW OIB_USERDEF_VMR_CDS AS
SELECT
  werks AS Plant,
  matnr AS Material,
  cast('' as werks_d) AS ExternalPlant,
  cast('' as matnr) AS ExternalMaterial,
  cast('' as oib_par_name ) AS OilPhysParamName,
  cast('' as oib_par_fieldname ) AS OilPhysParamFieldName,
  cast('' as oib_unit_fieldname ) AS OilPhysParamUoMFieldName,
  cast('' as abap.char(1)) AS IsOilPhysParamReadOnly,
  cast('' as abap.char(1)) AS OilPhysParamDescStyle,
  cast('' as abap.char(1)) AS OilPhysParamCheckStyle,
  cast('' as abap.char(1)) AS OilPhysParamValueStyle,
  cast('' as abap.char(1)) AS OilPhysParamUnitStyle,
  cast('' as oib_par_text ) AS OilPhysParamDesc,
  cast('' as oib_par_charflag ) AS IsOilPhysParam,
  cast('' as oib_par_char ) AS OilPhysParamValue,
  cast('' as meinh ) AS OilPhysParamUoM
FROM oib_userdef_vmr
;

Learn More