Fisvd_Ld_Cmp_Rep

DDL: FISVD_LD_CMP_REP SQL: fisv_ld_cmp_rep Type: view

ledger company customizing with reporting ledger

Fisvd_Ld_Cmp_Rep is a CDS View that provides data about "ledger company customizing with reporting ledger" in SAP S/4HANA. It reads from 1 data source (finsc_ld_cmp) and exposes 18 fields.

Data Sources (1)

SourceAliasJoin Type
finsc_ld_cmp ld from

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName fisv_ld_cmp_rep view
AbapCatalog.buffering.status #ACTIVE view
AbapCatalog.buffering.type #FULL view
EndUserText.label ledger company customizing with reporting ledger view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view

Fields (18)

KeyFieldSource TableSource FieldDescription
rldnr finsc_ld_cmp rldnr Ledger (Compat.)
rldnr_rep rep rldnr Ledger (Compat.)
bukrs bukrs Value
curtph curtph Field Name
mlrelindh mlrelindh ML Relevant (H)
curtpk curtpk Field Name
curposk curposk Curr Pos K
mlrelindk mlrelindk ML Relevant (K)
curtpo curtpo FreeDef Crcy 1
curposo curposo Curr Pos O
mlrelindo mlrelindo ML Relevant (O)
curtpv curtpv FreeDef Crcy 2
curposv curposv Curr Pos V
mlrelindv mlrelindv ML Relevant (V)
periv periv FYear Variant
parglaccts parglaccts Parallel GL Accts
opvar opvar Pstg Per.Var.
toyear toyear To Year

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 Fisvd_Ld_Cmp_Rep.
-- 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: fisv_ld_cmp_rep

CREATE VIEW Fisvd_Ld_Cmp_Rep AS
SELECT
  ld.rldnr AS rldnr,
  rep.rldnr AS rldnr_rep,
  bukrs,
  curtph,
  mlrelindh,
  curtpk,
  curposk,
  mlrelindk,
  curtpo,
  curposo,
  mlrelindo,
  curtpv,
  curposv,
  mlrelindv,
  periv,
  parglaccts,
  opvar,
  toyear
FROM finsc_ld_cmp AS ld
;