CRMS4_IU_I_MICNTR

DDL: CRMS4_IU_I_MICNTR SQL: CRMS4IUVIMICNTR Type: view
9 Fields 1 Data Sources 3 Associations

Contract of Move-In Document

CRMS4_IU_I_MICNTR is a CDS View that provides data about "Contract of Move-In Document" in SAP S/4HANA. It reads from 1 data source (eeinv) and exposes 9 fields with key fields UtilitiesMoveInDocument, UtilitiesContract. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
eeinv eeinv from

Associations (3)

CardinalityTargetAliasCondition
[1..1] I_UtilitiesContract _UtilitiesContract _UtilitiesContract.UtilitiesContract = $projection.UtilitiesContract
[0..1] I_UtilitiesInstallation _UtilitiesInstallation _UtilitiesInstallation.UtilitiesInstallation = $projection.UtilitiesInstallation
[0..1] I_UtilitiesPremise _UtilitiesPremise _UtilitiesPremise.UtilitiesPremise = $projection.UtilitiesPremise

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName CRMS4IUVIMICNTR view
EndUserText.label Contract of Move-In Document view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY UtilitiesMoveInDocument eeinv einzbeleg Move-In Doc.
KEY UtilitiesContract eeinv vertrag PoD service
UtilitiesInstallation eeinv anlage Installation
UtilitiesPremise eeinv vstelle Premise
MoveInDate eeinv einzdat Move-In Date
IsReversed eeinv stornokz Move-in revd
_UtilitiesContract _UtilitiesContract
_UtilitiesInstallation _UtilitiesInstallation
_UtilitiesPremise _UtilitiesPremise

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 CRMS4_IU_I_MICNTR.
-- 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: CRMS4IUVIMICNTR

CREATE VIEW CRMS4_IU_I_MICNTR AS
SELECT
  eeinv.einzbeleg AS UtilitiesMoveInDocument,
  eeinv.vertrag AS UtilitiesContract,
  eeinv.anlage AS UtilitiesInstallation,
  eeinv.vstelle AS UtilitiesPremise,
  eeinv.einzdat AS MoveInDate,
  eeinv.stornokz AS IsReversed
FROM eeinv
LEFT OUTER JOIN I_UtilitiesContract AS _UtilitiesContract ON _UtilitiesContract.UtilitiesContract = UtilitiesContract  -- association [1..1]
LEFT OUTER JOIN I_UtilitiesInstallation AS _UtilitiesInstallation ON _UtilitiesInstallation.UtilitiesInstallation = UtilitiesInstallation  -- association [0..1]
LEFT OUTER JOIN I_UtilitiesPremise AS _UtilitiesPremise ON _UtilitiesPremise.UtilitiesPremise = UtilitiesPremise  -- association [0..1]
;

Learn More