V_Mmim_DDL_Om_Pi_Items

DDL: V_MMIM_DDL_OM_PI_ITEMS SQL: V_MMIM_OM_PI_IT Type: view
11 Fields 1 Data Sources

Goods Movement Parameters

V_Mmim_DDL_Om_Pi_Items is a CDS View that provides data about "Goods Movement Parameters" in SAP S/4HANA. It reads from 1 data source (apoc_d_or_item) and exposes 11 fields with key fields ao_id, iblnr, gjahr, zeili.

Data Sources (1)

SourceAliasJoin Type
apoc_d_or_item request from

Annotations (9)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.preserveKey true view
AbapCatalog.sqlViewName V_MMIM_OM_PI_IT view
AbapCatalog.compiler.compareFilter true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #XL view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Goods Movement Parameters view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY ao_id apoc_d_or_item appl_object_id Appl. Object ID
KEY iblnr
KEY gjahr
KEY zeili
guid
xprint
cpudt
cputm
status apoc_d_or_item status Workflow Status
channel apoc_d_or_item channel Memo Record Channel
db_key apoc_d_or_item db_key UUID

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 V_Mmim_DDL_Om_Pi_Items.
-- 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: V_MMIM_OM_PI_IT

CREATE VIEW V_Mmim_DDL_Om_Pi_Items AS
SELECT
  request.appl_object_id AS ao_id,
  substring(request.appl_object_id, 1, 10) AS iblnr,
  cast(substring(request.appl_object_id, 11, 4) as gjahr) AS gjahr,
  substring(request.appl_object_id, 15, 3) AS zeili,
  substring(request.appl_object_id, 22, 32) AS guid,
  substring(request.appl_object_id, 21, 1) AS xprint,
  cast (substring( cast( request.crea_date_time as abap.char(28) ), 1, 8 ) as abap.dats) AS cpudt,
  cast (substring( cast( request.crea_date_time as abap.char(28) ), 9, 6 ) as abap.tims) AS cputm,
  request.status AS status,
  request.channel AS channel,
  request.db_key AS db_key
FROM apoc_d_or_item AS request
;

Learn More