CRMS4_IU_C_MICNTR

DDL: CRMS4_IU_C_MICNTR SQL: CRMS4IUVCMICNTR Type: view
16 Fields 2 Data Sources

Move-In Document with assigned Contract

CRMS4_IU_C_MICNTR is a CDS View that provides data about "Move-In Document with assigned Contract" in SAP S/4HANA. It reads from 2 data sources (CRMS4_IU_I_MIHEAD, CRMS4_IU_I_MICNTR) and exposes 16 fields with key fields einzbeleg, vertrag.

Data Sources (2)

SourceAliasJoin Type
CRMS4_IU_I_MIHEAD VA from
CRMS4_IU_I_MICNTR VB inner

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName CRMS4IUVCMICNTR view
EndUserText.label Move-In Document with assigned Contract view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY einzbeleg CRMS4_IU_I_MIHEAD UtilitiesMoveInDocument Move-In Doc.
KEY vertrag CRMS4_IU_I_MICNTR UtilitiesContract PoD service
vkont CRMS4_IU_I_MIHEAD ContractAccount Contract Acct
kunde CRMS4_IU_I_MIHEAD BusinessPartner Issuing Authority
bezugsdat CRMS4_IU_I_MIHEAD ActualMoveInDate Actual MI date
stornokz CRMS4_IU_I_MIHEAD IsReversed Reversed?
erdat CRMS4_IU_I_MIHEAD CreationDate Time Stamp
ernam CRMS4_IU_I_MIHEAD CreatedByUser User Name
aedat CRMS4_IU_I_MIHEAD LastChangeDate Time Stamp
aenam CRMS4_IU_I_MIHEAD LastChangedByUser User Name
begru CRMS4_IU_I_MIHEAD AuthorizationGroup AuthorizGroup
loevm CRMS4_IU_I_MIHEAD DeletionIndicator Deletion Ind.
anlage CRMS4_IU_I_MICNTR UtilitiesInstallation Installation
vstelle CRMS4_IU_I_MICNTR UtilitiesPremise Premise
einzdat CRMS4_IU_I_MICNTR MoveInDate Move-In Date
_BusinessPartner CRMS4_IU_I_MIHEAD _BusinessPartner

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_C_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: CRMS4IUVCMICNTR

CREATE VIEW CRMS4_IU_C_MICNTR AS
SELECT
  VA.UtilitiesMoveInDocument AS einzbeleg,
  VB.UtilitiesContract AS vertrag,
  VA.ContractAccount AS vkont,
  VA.BusinessPartner AS kunde,
  VA.ActualMoveInDate AS bezugsdat,
  VA.IsReversed AS stornokz,
  VA.CreationDate AS erdat,
  VA.CreatedByUser AS ernam,
  VA.LastChangeDate AS aedat,
  VA.LastChangedByUser AS aenam,
  VA.AuthorizationGroup AS begru,
  VA.DeletionIndicator AS loevm,
  VB.UtilitiesInstallation AS anlage,
  VB.UtilitiesPremise AS vstelle,
  VB.MoveInDate AS einzdat,
  VA._BusinessPartner AS _BusinessPartner
FROM CRMS4_IU_I_MIHEAD AS VA
INNER JOIN CRMS4_IU_I_MICNTR AS VB ON /* join condition not captured in parsed metadata */
;

Learn More