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.

-- Abschlagsplan
-- 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)
);