ent12006_view

DDL: ENT12006 SQL: ENT_2006 Type: view
62 Fields 1 Data Sources

General Ledger - G/L Account - Transaction Figure

ent12006_view is a CDS View that provides data about "General Ledger - G/L Account - Transaction Figure" in SAP S/4HANA. It reads from 1 data source (glt0) and exposes 62 fields with key fields rclnt, rldnr, rrcty, rvers, bukrs.

Data Sources (1)

SourceAliasJoin Type
glt0 glt0 from

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName ENT_2006 view
EndUserText.label General Ledger - G/L Account - Transaction Figure view
Metadata.ignorePropagatedAnnotations true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #P view

Fields (62)

KeyFieldSource TableSource FieldDescription
KEY rclnt rclnt Client
KEY rldnr rldnr Ledger (Compat.)
KEY rrcty rrcty Record Type
KEY rvers rvers Version: Tax rt
KEY bukrs bukrs Value
KEY ryear ryear Ref. Year1
KEY racct racct GL Account From
KEY rbusa rbusa Business Area
KEY rtcur rtcur Currency
KEY drcrk drcrk Debit/Credit
KEY rpmax rpmax Period
tslvt tslvt Transactn curr.
tsl01 tsl01 Transactn curr.
tsl02 tsl02 Transactn curr.
tsl03 tsl03 Transactn curr.
tsl04 tsl04 Transactn curr.
tsl05 tsl05 Transactn curr.
tsl06 tsl06 Transactn curr.
tsl07 tsl07 Transactn curr.
tsl08 tsl08 Transactn curr.
tsl09 tsl09 Transactn curr.
tsl10 tsl10 Transactn curr.
tsl11 tsl11 Transactn curr.
tsl12 tsl12 Transactn curr.
tsl13 tsl13 Transactn curr.
tsl14 tsl14 Transactn curr.
tsl15 tsl15 Transactn curr.
tsl16 tsl16 Transactn curr.
hslvt hslvt Local Currency
hsl01 hsl01 Total transactions in the period in local currency (curr 2)
hsl02 hsl02 Total transactions in the period in local currency (curr 2)
hsl03 hsl03 Total transactions in the period in local currency (curr 2)
hsl04 hsl04 Total transactions in the period in local currency (curr 2)
hsl05 hsl05 Total transactions in the period in local currency (curr 2)
hsl06 hsl06 Total transactions in the period in local currency (curr 2)
hsl07 hsl07 Total transactions in the period in local currency (curr 2)
hsl08 hsl08 Total transactions in the period in local currency (curr 2)
hsl09 hsl09 Total transactions in the period in local currency (curr 2)
hsl10 hsl10 Total transactions in the period in local currency (curr 2)
hsl11 hsl11 Total transactions in the period in local currency (curr 2)
hsl12 hsl12 Total transactions in the period in local currency (curr 2)
hsl13 hsl13 Total transactions in the period in local currency (curr 2)
hsl14 hsl14 Total transactions in the period in local currency (curr 2)
hsl15 hsl15 Total transactions in the period in local currency (curr 2)
hsl16 hsl16 Total transactions in the period in local currency (curr 2)
cspred cspred Distr. key currency
kslvt kslvt Total GC
ksl01 ksl01 Total GC
ksl02 ksl02 Total GC
ksl03 ksl03 Total GC
ksl04 ksl04 Total GC
ksl05 ksl05 Total GC
ksl06 ksl06 Total GC
ksl07 ksl07 Total GC
ksl08 ksl08 Total GC
ksl09 ksl09 Total GC
ksl10 ksl10 Total GC
ksl11 ksl11 Total GC
ksl12 ksl12 Total GC
ksl13 ksl13 Total GC
ksl14 ksl14 Total GC
ksl15 ksl15 Total GC

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 ent12006_view.
-- 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: ENT_2006

CREATE VIEW ent12006_view AS
SELECT
  rclnt,
  rldnr,
  rrcty,
  rvers,
  bukrs,
  ryear,
  racct,
  rbusa,
  rtcur,
  drcrk,
  rpmax,
  tslvt,
  tsl01,
  tsl02,
  tsl03,
  tsl04,
  tsl05,
  tsl06,
  tsl07,
  tsl08,
  tsl09,
  tsl10,
  tsl11,
  tsl12,
  tsl13,
  tsl14,
  tsl15,
  tsl16,
  hslvt,
  hsl01,
  hsl02,
  hsl03,
  hsl04,
  hsl05,
  hsl06,
  hsl07,
  hsl08,
  hsl09,
  hsl10,
  hsl11,
  hsl12,
  hsl13,
  hsl14,
  hsl15,
  hsl16,
  cspred,
  kslvt,
  ksl01,
  ksl02,
  ksl03,
  ksl04,
  ksl05,
  ksl06,
  ksl07,
  ksl08,
  ksl09,
  ksl10,
  ksl11,
  ksl12,
  ksl13,
  ksl14,
  ksl15
FROM glt0
;

Learn More