EABP

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.

-- Budget Billing Plan
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE EABP (
    MANDT,            -- Client [MANDT]
    OPBEL,            -- BB Plan [ABPLANNR]
    VERTRAG,          -- Contract [VERTRAG]
    GPART,            -- Bus. Partner [GPART_KK]
    VKONTO,           -- Contract Acct [VKONT_KK]
    BEGPERIODE,       -- Start BB period [ABPABDAT]
    ENDPERIODE,       -- End BB period [ABPBISDAT]
    ERCHZBELNR,       -- Bill. doc. no. [E_ABRBELNRA]
    INVOPBEL,         -- Print Doc. No. [OPBEL_INV]
    PORTION,          -- Portion [PORTION]
    SAMMELNR,         -- Coll. Bill Acct [ABWVK_KK]
    KZABSVER,         -- BB Procedure [KZABSVER]
    LETZTEFAKZ,       -- Last due date [LETZTEFAKZ]
    MANUELLVKZ,       -- Chgd Manually [MANVELLVKZ]
    MASCHNIANP,       -- No Autom.Adjust [MASCHNIANP]
    VORAUSZDAT,       -- Adv. pay. start [VORAUSZDAT]
    ABSCHLDAT,        -- BB pay. start [ABSCHLDAT]
    ABSTOPDAT,        -- Stop date [ABSTOPDAT]
    ABSPERDAT,        -- Block Date [ABSPERDAT]
    ABSZYK,           -- Bud.bill. cycle [ABSZYK]
    ANPDAT,           -- Adjustment date [ANPDAT]
    DEAKTIV,          -- Deactivated [DEAKTIV]
    SOLHAB_KZ,        -- D/C sub-trans. [E_SOLHABTV]
    WAERS,            -- Currency [WAERS]
    ART,              -- BBP crtn type [BBP_CREATE]
    ERDAT,            -- Created On [ERDAT]
    ERNAM,            -- Created By [ERNAM]
    AEDAT,            -- Changed On [AEDAT]
    AENAM,            -- Changed By [AENAM]
    EINZBETR,         -- Move-in amount [EINZBETR]
    TAGBETR,          -- BB Amount/day [TAGBETR]
    VTEILKZ,          -- Remaining Amt [VTEILKZ]
    VOR_OPBEL,        -- Adv. PP inv.no. [VOR_OPBEL]
    BBP_EXTEND,       -- BBP extended [EXTEND]
    PYPLT,            -- Pymt plan type [E_PYPLT]
    ARCHIVE,          -- Archive [ARCHIVE_OBJ]
    DEBID,            -- CC deactiv [DEBID]
    DELKZ,            -- Budget Billing Plan Deactivated Through Deletion [E_DELKZ]
    D_BETRAG,         -- Stand. BB amnt [D_BETRAG]
    ABSBETRW,         -- Bdgt Bill Amnt [ABSBETRW]
    COUNT_KZ,         -- Counter Active [COUNT_BBP_KZ]
    COUNTER,          -- No. StandBBAmts [COUNTER_BBP]
    USE_HKONT,        -- Summariz. HKONT [USE_HKONT]
    BBP_OLD,          -- Prev. PaymtPlan [BBP_OLD]
    ABP_TYP,          -- ABP_TYP [ABP_TYP]
    BS_DAT,           -- Notif. Date [BS_DAT]
    ANP_ERCHZ,        -- BillDocAdjustmt [ANP_ABR_BEL]
    VSPERRE,          -- Extension Block [VSPERRE]
    EXITS_USED,       -- exits_used [EXITS_USED]
    INVOICING_PARTY,  -- Inv. Serv. Prov [INVOICING_PARTY]
    PSSTATUS,         -- Status [E_PSSTATUS]
    PSACTIV,          -- PS Activation [E_PSACTIV]
    PSTERMDAT,        -- PS End Date [E_PSTERMDAT]
    TERMREASON,       -- PS Canc.Reason [E_TERMREASON]
    KUMBETRW,         -- Cumulated Budget Billing Amount [KUMBETRW]
    VTRBETRW,         -- Budget Billing Amount at Contract Level [ACTBETRW]
    INTANPDAT,        -- Last Internet Adjustment [INTANPDAT]
    INTANPNUM,        -- Counter for Internet Adjustments [INTANPNUM]
    CHGRSN,           -- Reason for Change [ECHGRSN]
    INCLCAITEMS,      -- Incl. CA Items [E_INCLCAITEMS]
    UNMSRD,           -- Unmeas. Cust. [PS_UNMSRD]
    PAYMTPERCAT,      -- Payment Period Cat. [PS_UM_PAYMT_PER_CAT]
    ISU2CI_CATEGORY,  -- CI Integr.Cat. [ISU2CI_CATEGORY]
    ANP_ERCHZ_EPB,    -- BillDocAdjRef [ANP_ABR_BEL_EPB]
    PRIMARY KEY (MANDT, OPBEL, VERTRAG)
);