ETRG

Transparent Table Application Table
37 Fields 2 CDS Views

Billing Order

ETRG is an SAP database table in S/4HANA. Billing Order. It contains 37 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_UtilitiesBillingOrder view from BASIC Billing Order
SHSM_ISU_F4_EA24 view inner Document with Adjustment Reversal Search Help

Fields (37)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY anlage ANLAGE Installation
KEY abrdats ABRDATS Sch. Bill. Date
KEY abrvorg ABRVORG Billing Trans.
bukrs BUKRS Company Code
sparte SPARTE Division
portion PORTION Portion
abrvorg2 ABRVORG Billing Trans.
trigstat TRIGSTAT Order status
ableinh ABLEINH MR unit
adatsoll ADATSOLL Scheduled MRD
abrdatsu ABRDATSU Sch.BD supp.BOs
abrvorgu ABRVORGU Suppress BT
begend BEGEND Start PE bil.pd
sc_belnr SC_BELNR Doc.no.adj.rev.
erdat ERDAT Created On
ernam ERNAM Created By
aedat AEDAT Changed On
aenam AENAM Changed By
endprio ENDPRIO PEB priority
abschlpan ABSCHLPAN Adjust BB plan
zuorddat E_ZUORDDATABR All. date billg
mem_opbel MEM_OPBEL Rev.doc.newInv.
mem_budat MEM_BUDAT PDate new inv.
adatsollu ADATSOLLU SMRD for SO
estinbill ESTINBILL Estim. in Bill.
estinbillu ESTINBILLU Suppr. Est.Bill
estinbill_sav ESTINBILL_SAV Orig.Est.Bill.
estinbill_usav ESTINBILL_USAV SupprBillingOrder
osb_group E_OSB_GROUP OSB Group
maindocno MAINDOCNO PrimInstDoc.No.
wait_bi WAIT_BI Bill. Sequence
vkonto VKONT_KK Contract Acct
mdusrequestid E_MDUSREQUESTID MDUS Request
mdusrqstat E_MDUSRQSTAT MDUS Status
cologrp_inst E_COLOGRP_INST Coloc. Grp Inst
billg_err E_BILLING_ERROR Billing Error

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.

-- Billing Order
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE ETRG (
    MANDT,           -- Client [MANDT]
    ANLAGE,          -- Installation [ANLAGE]
    ABRDATS,         -- Sch. Bill. Date [ABRDATS]
    ABRVORG,         -- Billing Trans. [ABRVORG]
    BUKRS,           -- Company Code [BUKRS]
    SPARTE,          -- Division [SPARTE]
    PORTION,         -- Portion [PORTION]
    ABRVORG2,        -- Billing Trans. [ABRVORG]
    TRIGSTAT,        -- Order status [TRIGSTAT]
    ABLEINH,         -- MR unit [ABLEINH]
    ADATSOLL,        -- Scheduled MRD [ADATSOLL]
    ABRDATSU,        -- Sch.BD supp.BOs [ABRDATSU]
    ABRVORGU,        -- Suppress BT [ABRVORGU]
    BEGEND,          -- Start PE bil.pd [BEGEND]
    SC_BELNR,        -- Doc.no.adj.rev. [SC_BELNR]
    ERDAT,           -- Created On [ERDAT]
    ERNAM,           -- Created By [ERNAM]
    AEDAT,           -- Changed On [AEDAT]
    AENAM,           -- Changed By [AENAM]
    ENDPRIO,         -- PEB priority [ENDPRIO]
    ABSCHLPAN,       -- Adjust BB plan [ABSCHLPAN]
    ZUORDDAT,        -- All. date billg [E_ZUORDDATABR]
    MEM_OPBEL,       -- Rev.doc.newInv. [MEM_OPBEL]
    MEM_BUDAT,       -- PDate new inv. [MEM_BUDAT]
    ADATSOLLU,       -- SMRD for SO [ADATSOLLU]
    ESTINBILL,       -- Estim. in Bill. [ESTINBILL]
    ESTINBILLU,      -- Suppr. Est.Bill [ESTINBILLU]
    ESTINBILL_SAV,   -- Orig.Est.Bill. [ESTINBILL_SAV]
    ESTINBILL_USAV,  -- SupprBillingOrder [ESTINBILL_USAV]
    OSB_GROUP,       -- OSB Group [E_OSB_GROUP]
    MAINDOCNO,       -- PrimInstDoc.No. [MAINDOCNO]
    WAIT_BI,         -- Bill. Sequence [WAIT_BI]
    VKONTO,          -- Contract Acct [VKONT_KK]
    MDUSREQUESTID,   -- MDUS Request [E_MDUSREQUESTID]
    MDUSRQSTAT,      -- MDUS Status [E_MDUSRQSTAT]
    COLOGRP_INST,    -- Coloc. Grp Inst [E_COLOGRP_INST]
    BILLG_ERR,       -- Billing Error [E_BILLING_ERROR]
    PRIMARY KEY (MANDT, ANLAGE, ABRDATS, ABRVORG)
);

Learn More