T001B

Transparent Table Customizing Table
19 Fields 6 CDS Views

Erlaubte Buchungsperioden

T001B is an SAP database table in S/4HANA. Erlaubte Buchungsperioden. It contains 19 fields. 6 CDS views read from this table.

CDS Views using this table (6)

ViewTypeJoinVDMDescription
Fac_Bcf_Posting_Period view left_outer CDS View for posting period
Fac_Opp_Cds_Ppv view inner CDS View For PPV value help on Overview page
Fac_Opp_Cds_T001b view from CDS View For T001B
Fac_Opp_Cds_T001b_In_Cocd view from CDS View For T001B
Fac_Opp_Cds_Valid_Ppv_Item view from CDS View For PPV Item Overview page
Fac_Ppv_Cds_T001b view from CDS View For PPV Item Overview page

Fields (19)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY rrcty rrcty Record Type
KEY bukrs opvar Pstg Per.Var.
KEY mkoar mkoar Account Type
KEY bkont bkont_001b To Account
vkont vkont_001b From Account
frye1 fryer Fiscal Year
frpe1 frper From Period
toye1 toyer Fiscal Year
tope1 toper To Period
frye2 frye2 Fiscal Year
frpe2 frpe2 From Period
toye2 toye2 Fiscal Year
tope2 tope2 To Period
brgru brgru Authorization
frye3 fagl_frye3 Fiscal Year
frpe3 fagl_frpe3 From Period 3
toye3 fagl_toye3 Fiscal Year
tope3 fagl_tope3 To Period 3

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.

-- Erlaubte Buchungsperioden
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE T001B (
    MANDT,  -- Client [mandt]
    RRCTY,  -- Record Type [rrcty]
    BUKRS,  -- Pstg Per.Var. [opvar]
    MKOAR,  -- Account Type [mkoar]
    BKONT,  -- To Account [bkont_001b]
    VKONT,  -- From Account [vkont_001b]
    FRYE1,  -- Fiscal Year [fryer]
    FRPE1,  -- From Period [frper]
    TOYE1,  -- Fiscal Year [toyer]
    TOPE1,  -- To Period [toper]
    FRYE2,  -- Fiscal Year [frye2]
    FRPE2,  -- From Period [frpe2]
    TOYE2,  -- Fiscal Year [toye2]
    TOPE2,  -- To Period [tope2]
    BRGRU,  -- Authorization [brgru]
    FRYE3,  -- Fiscal Year [fagl_frye3]
    FRPE3,  -- From Period 3 [fagl_frpe3]
    TOYE3,  -- Fiscal Year [fagl_toye3]
    TOPE3,  -- To Period 3 [fagl_tope3]
    PRIMARY KEY (MANDT, RRCTY, BUKRS, MKOAR, BKONT)
);

Learn More