AVL

7 Fields

AVL is an SAP database table in S/4HANA. It contains 7 fields.

Fields (7)

KeyField CDS FieldsUsed in Views
AssetRealDepreciationArea AssetRealDepreciationArea 1
DepreciationKey DepreciationKey 1
DepreciationStartDate DepreciationStartDate 1
PlannedUsefulLifeInPeriods PlannedUsefulLifeInPeriods 1
PlannedUsefulLifeInYears PlannedUsefulLifeInYears 1
ValidityEndDate ValidityEndDate 1
ValidityStartDate ValidityStartDate 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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE AVL (
    ASSETREALDEPRECIATIONAREA,
    DEPRECIATIONKEY,
    DEPRECIATIONSTARTDATE,
    PLANNEDUSEFULLIFEINPERIODS,
    PLANNEDUSEFULLIFEINYEARS,
    VALIDITYENDDATE,
    VALIDITYSTARTDATE
);

Learn More