CRMS4_IU_C_ILNF

DDL: CRMS4_IU_C_ILNF Type: view_entity
24 Fields 1 Data Sources

Installation Fact

CRMS4_IU_C_ILNF is a CDS View that provides data about "Installation Fact" in SAP S/4HANA. It reads from 1 data source (CRMS4_IU_I_ILNF) and exposes 24 fields with key fields Anlage, Operand, Saison, Ab, Ablfdnr.

Data Sources (1)

SourceAliasJoin Type
CRMS4_IU_I_ILNF CRMS4_IU_I_ILNF from

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #NOT_ALLOWED view
EndUserText.label Installation Fact view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view

Fields (24)

KeyFieldSource TableSource FieldDescription
KEY Anlage Anlage Installation
KEY Operand Operand Operand
KEY Saison Saison Season
KEY Ab Ab Valid From
KEY Ablfdnr Ablfdnr Cons. No.
Bis Bis Value
Belnr Belnr SD Document
Mbelnr Mbelnr Billing Doc.No.
Mauszug Mauszug Fact was changed as a result of move-out
Altbis Altbis Valid to
Inaktiv Inaktiv Record inactive
Manaend Manaend Manual change
Tarifart Tarifart Rate Type
Kondigr Kondigr Rate fact group
Wert1 Wert1 Entry value
Wert2 Wert2 Val.to be billd
String1 String1 Key 1
String2 String2 Key 2
String3 String3 Key 3
String4 String4 Key 4
Ersatzwert Ersatzwert Replacemt value
Betrag Betrag Amount
Waers Waers Transaction Currency
Cologrp_Inst Cologrp_Inst Coloc. Grp Inst

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_ILNF.
-- 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.

CREATE VIEW CRMS4_IU_C_ILNF AS
SELECT
  Anlage,
  Operand,
  Saison,
  Ab,
  Ablfdnr,
  Bis,
  Belnr,
  Mbelnr,
  Mauszug,
  Altbis,
  Inaktiv,
  Manaend,
  Tarifart,
  Kondigr,
  Wert1,
  Wert2,
  String1,
  String2,
  String3,
  String4,
  Ersatzwert,
  Betrag,
  Waers,
  Cologrp_Inst
FROM CRMS4_IU_I_ILNF
;

Learn More