BPJA

Transparent Table Application Table
22 Fields 1 CDS Views

Totals Record for Annual Total Controlling Obj.

BPJA is an SAP database table in S/4HANA. Totals Record for Annual Total Controlling Obj.. It contains 22 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_ProjectBudgetAnnualData view_entity from BASIC Annual Budget data for Project

Fields (22)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY lednr BP_LEDNR Ledger
KEY objnr BP_OBJEKT Obj.No.
KEY posit BP_POSIT Int. CI (8)
KEY trgkz BP_TRGKZ Object ind.
KEY wrttp CO_WRTTP Value Type
KEY gjahr GJAHR Fiscal Year
KEY geber BP_GEBER Fund
KEY versn BP_VERSION Version
KEY vorga BP_VORGANG Budget Type
KEY twaer TWAER Trans. Currency
KEY subvo BP_SUBVO Budget Subtype
KEY gnjhr GNJHR YCE
KEY farea FM_FAREA Functional Area
wtjhr BP_WJT Year
wljhr BP_WJL Year
wtjhv BP_WJTV Year
wljhv BP_WJLV Year
kalnr CK_KALNR Cost EstimateNo
klvar CK_KLVAR Costing Variant
spred SPRED Distribution Key
beltp BP_INOUT Debit Type

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.

-- Totals Record for Annual Total Controlling Obj.
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE BPJA (
    MANDT,  -- Client [MANDT]
    LEDNR,  -- Ledger [BP_LEDNR]
    OBJNR,  -- Obj.No. [BP_OBJEKT]
    POSIT,  -- Int. CI (8) [BP_POSIT]
    TRGKZ,  -- Object ind. [BP_TRGKZ]
    WRTTP,  -- Value Type [CO_WRTTP]
    GJAHR,  -- Fiscal Year [GJAHR]
    GEBER,  -- Fund [BP_GEBER]
    VERSN,  -- Version [BP_VERSION]
    VORGA,  -- Budget Type [BP_VORGANG]
    TWAER,  -- Trans. Currency [TWAER]
    SUBVO,  -- Budget Subtype [BP_SUBVO]
    GNJHR,  -- YCE [GNJHR]
    FAREA,  -- Functional Area [FM_FAREA]
    WTJHR,  -- Year [BP_WJT]
    WLJHR,  -- Year [BP_WJL]
    WTJHV,  -- Year [BP_WJTV]
    WLJHV,  -- Year [BP_WJLV]
    KALNR,  -- Cost EstimateNo [CK_KALNR]
    KLVAR,  -- Costing Variant [CK_KLVAR]
    SPRED,  -- Distribution Key [SPRED]
    BELTP,  -- Debit Type [BP_INOUT]
    PRIMARY KEY (MANDT, LEDNR, OBJNR, POSIT, TRGKZ, WRTTP, GJAHR, GEBER, VERSN, VORGA, TWAER, SUBVO, GNJHR, FAREA)
);

Learn More