ANKA

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.

-- Anlagenklassen: Allgemeine Daten
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE ANKA (
    MANDT,   -- Client [mandt]
    ANLKL,   -- Asset Class [anlkl]
    ERNAM,   -- Created By [ernam]
    ERDAT,   -- Created On [erdat]
    AENAM,   -- Changed By [aenam]
    AEDAT,   -- Changed On [aedat_anla]
    XLOEV,   -- Centrally [xloev_anka]
    XSPEA,   -- Centrally [xspea_anka]
    XOPVW,   -- LineItem settl. [opvwa]
    NUMKR,   -- Number Range [numkr]
    KTOGR,   -- Account Determ. [ktogr]
    ANKAR,   -- Layout set history [ankar]
    FELEI,   -- Screen Layout [felei]
    BEGRU,   -- AuthorizGroup [begru]
    ZUAWA,   -- Sort key [dzuawa]
    GSBER,   -- Business Area [gsber]
    WERKS,   -- Plant [werks_d]
    KOSTL,   -- Cost Center [kostl]
    LSTAR,   -- Activity Type [lstar]
    ANEQK,   -- Manage Historically [aneqk]
    ANEQS,   -- Complete. [aneqs]
    MACKZ,   -- Matchcode ind. [mackz]
    LAND1,   -- Origin C/R [am_land1]
    LIFNR,   -- Vendor [am_lifnr]
    LIEFE,   -- Supplier Name [liefe]
    ANLUE,   -- Asset Super No. [anlue]
    EIGKZ,   -- Property Indic. [eigkz]
    VMGLI,   -- Prop.classif. [vmgli]
    XVRMW,   -- Man.net wrth vl [xvrmw]
    INVSL,   -- Invest.Support [invsl]
    ORD41,   -- Eval.group 1 [ord41]
    ORD42,   -- Eval. Group 2 [ord42]
    ORD43,   -- Eval. Group 3 [ord43]
    ORD44,   -- Eval.group 4 [ord44]
    IZWEK,   -- Invest. Reason [izwek]
    HERST,   -- Manufacturer [herst]
    MEINS,   -- Base Unit [meins]
    FEINS,   -- Area Unit [feins]
    INKEN,   -- Inventory Ind. [inken]
    FIAMT,   -- Tax Office [fiamt]
    STADT,   -- Municipality [ort01_anla]
    ANLTP,   -- Asset Category [anltp]
    XUNTV,   -- External sub-no [xuntv]
    XAKTIV,  -- Set Capit. Date [xaktiv]
    LEAFI,   -- Lessor [leafi]
    LEJAR,   -- Lease Length [lejar]
    LEPER,   -- Periods [leper]
    LRYTH,   -- Cycle [lryth]
    LMZIN,   -- Mnthly int.rate [lmzin]
    LEANZ,   -- No.leas.paymnts [leanz]
    LETXT,   -- Suppl. text [letxt]
    AIMMO,   -- Connection to SAP Real Estate Management [aimmo]
    GDLGRP,  -- Eval. Group 5 [gdlgrp]
    XERWRT,  -- Do not take memo value into account [xerwrt]
    XANLGR,  -- Group Asset [xanlgr]
    XINVM,   -- Inv. Measure [im_xinvm]
    LEART,   -- Type [leart]
    ABGSL,   -- Capit. key [im_abgr_sl]
    PRIMARY KEY (MANDT, ANLKL)
);