CRMS4_IU_I_MOCNTR

DDL: CRMS4_IU_I_MOCNTR SQL: CRMS4IUVIMOCNTR Type: view
9 Fields 1 Data Sources 3 Associations

Contract of Move-Out Document

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

Data Sources (1)

SourceAliasJoin Type
eausv eausv 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 CRMS4IUVIMOCNTR view
EndUserText.label Contract of Move-Out 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 UtilitiesMoveOutDocument eausv auszbeleg Move-out doc.
KEY UtilitiesContract eausv vertrag PoD service
UtilitiesInstallation eausv anlage Installation
UtilitiesPremise eausv vstelle Premise
MoveOutDate eausv auszdat Move-Out Date
IsReversed eausv storausz Move-out 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_MOCNTR.
-- 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: CRMS4IUVIMOCNTR

CREATE VIEW CRMS4_IU_I_MOCNTR AS
SELECT
  eausv.auszbeleg AS UtilitiesMoveOutDocument,
  eausv.vertrag AS UtilitiesContract,
  eausv.anlage AS UtilitiesInstallation,
  eausv.vstelle AS UtilitiesPremise,
  eausv.auszdat AS MoveOutDate,
  eausv.storausz AS IsReversed
FROM eausv
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