GLE_ADB_KFC_AVG_SL_GEN

CDS View

Generated View: All Average Ledgers

GLE_ADB_KFC_AVG_SL_GEN is a CDS View in S/4HANA. Generated View: All Average Ledgers. It contains 12 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
gle_adb_kfc_calculation view union_all Average Daily Balances - Calculation
I_FinSGLAvgDailyBalSpclLdgr view_entity from COMPOSITE Average Daily Balances Daily Adjustment
P_AvgDailyBalKeyFig view union_all COMPOSITE

Fields (12)

KeyField CDS FieldsUsed in Views
KEY CompanyCode CompanyCode 1
KEY FiscalYear FiscalYear 1
KEY Ledger Ledger 1
branch_id FinancialServicesBranch 1
datasource_id FinancialDataSource 1
FinancialDataSource FinancialDataSource 1
FinancialServicesBranch FinancialServicesBranch 1
FinancialServicesProductGroup FinancialServicesProductGroup 1
FiscalPeriod FiscalPeriod 1
FiscalYearPeriod FiscalYearPeriod 1
FiscalYearVariant FiscalYearVariant 1
fs_product_group FinancialServicesProductGroup 1

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Generated View: All Average Ledgers
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE GLE_ADB_KFC_AVG_SL_GEN (
    COMPANYCODE,
    FISCALYEAR,
    LEDGER,
    BRANCH_ID,
    DATASOURCE_ID,
    FINANCIALDATASOURCE,
    FINANCIALSERVICESBRANCH,
    FINANCIALSERVICESPRODUCTGROUP,
    FISCALPERIOD,
    FISCALYEARPERIOD,
    FISCALYEARVARIANT,
    FS_PRODUCT_GROUP,
    PRIMARY KEY (COMPANYCODE, FISCALYEAR, LEDGER)
);