AGKO

Transparent Table Application Table
8 Fields 1 CDS Views

Cleared Accounts

AGKO is an SAP database table in S/4HANA. Cleared Accounts. It contains 8 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_ClearedAccount1 view union_all CONSUMPTION

Fields (8)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY bukrs BUKRS Company Code
KEY belnr BELNR_D Document Number
KEY gjahr GJAHR Fiscal Year
KEY koart KOART Account type
KEY agkto AGKTO Clearing Acct
augdt AUGDT Clearing
_dataaging DATA_TEMPERATURE Data Aging

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.

-- Cleared Accounts
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE AGKO (
    MANDT,       -- Client [MANDT]
    BUKRS,       -- Company Code [BUKRS]
    BELNR,       -- Document Number [BELNR_D]
    GJAHR,       -- Fiscal Year [GJAHR]
    KOART,       -- Account type [KOART]
    AGKTO,       -- Clearing Acct [AGKTO]
    AUGDT,       -- Clearing [AUGDT]
    _DATAAGING,  -- Data Aging [DATA_TEMPERATURE]
    PRIMARY KEY (MANDT, BUKRS, BELNR, GJAHR, KOART, AGKTO)
);

Learn More