ent12164_view

DDL: ENT_2164 SQL: ENT_2164 Type: view
55 Fields 1 Data Sources

Accounts Payable Account - Transaction Figure

ent12164_view is a CDS View that provides data about "Accounts Payable Account - Transaction Figure" in SAP S/4HANA. It reads from 1 data source (lfc1) and exposes 55 fields with key fields mandt, lifnr, bukrs, gjahr.

Data Sources (1)

SourceAliasJoin Type
lfc1 lfc1 from

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName ENT_2164 view
EndUserText.label Accounts Payable Account - Transaction Figure view
Metadata.ignorePropagatedAnnotations true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #P view

Fields (55)

KeyFieldSource TableSource FieldDescription
KEY mandt mandt Editing Client
KEY lifnr lifnr Vendor no.
KEY bukrs bukrs Value
KEY gjahr gjahr Settlement Year
umsav umsav Bal.Carried Fwd
um01s um01s Debit
um01h um01h Credit
um01u um01u Sales
um02s um02s Debit
um02h um02h Credit
um02u um02u Sales
um03s um03s Debit
um03h um03h Credit
um03u um03u Sales
um04s um04s Debit
um04h um04h Credit
um04u um04u Sales
um05s um05s Debit
um05h um05h Credit
um05u um05u Sales
um06s um06s Debit
um06h um06h Credit
um06u um06u Sales
um07s um07s Debit
um07h um07h Credit
um07u um07u Sales
um08s um08s Debit
um08h um08h Credit
um08u um08u Sales
um09s um09s Debit
um09h um09h Credit
um09u um09u Sales
um10s um10s Debit
um10h um10h Credit
um10u um10u Sales
um11s um11s Debit
um11h um11h Credit
um11u um11u Sales
um12s um12s Debit
um12h um12h Credit
um12u um12u Sales
um13s um13s Debit
um13h um13h Credit
um13u um13u Sales
um14s um14s Debit
um14h um14h Credit
um14u um14u Sales
um15s um15s Debit
um15h um15h Credit
um15u um15u Sales
um16s um16s Debit
um16h um16h Credit
um16u um16u Sales
erdat erdat Entered On
usnam usnam User Name

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 ent12164_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_2164

CREATE VIEW ent12164_view AS
SELECT
  mandt,
  lifnr,
  bukrs,
  gjahr,
  umsav,
  um01s,
  um01h,
  um01u,
  um02s,
  um02h,
  um02u,
  um03s,
  um03h,
  um03u,
  um04s,
  um04h,
  um04u,
  um05s,
  um05h,
  um05u,
  um06s,
  um06h,
  um06u,
  um07s,
  um07h,
  um07u,
  um08s,
  um08h,
  um08u,
  um09s,
  um09h,
  um09u,
  um10s,
  um10h,
  um10u,
  um11s,
  um11h,
  um11u,
  um12s,
  um12h,
  um12u,
  um13s,
  um13h,
  um13u,
  um14s,
  um14h,
  um14u,
  um15s,
  um15h,
  um15u,
  um16s,
  um16h,
  um16u,
  erdat,
  usnam
FROM lfc1
;

Learn More