TEML_OUTBILCHAR

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.

-- Characteristics for Outsorted Billing Document
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TEML_OUTBILCHAR (
    MANDT,                      -- Client [mandt]
    BELNR,                      -- Billing Doc.No. [e_belnr]
    VERTRAG,                    -- Contract [vertrag]
    BILLGPERIODDURATION,        -- Billing Period Duration in Days [e_billgperdurtn_vdm]
    TRANSACTIONCRCY,            -- Trans. currency [twaers]
    TOTALNETAMOUNT,             -- Total Net Amount [e_billgdoctotnetamtml_vdm]
    ADJDTOTALNETAMT,            -- Adjusted Total Net Amount [e_billgdocadjdtotnetamt_vdm]
    PREVDOCNETAMT,              -- Total Net Amount of Previous Document [e_prevdocnetamt_vdm]
    PREVDOCADJDNETAMT,          -- Adjd Total Net Amount of Previous Doc [e_prevdocadjdnetamt_vdm]
    PREVDIFFNETAMT,             -- Prev Doc Net Amount Difference [e_prevdocdiff_vdm]
    PREVDIFFADJDNETAMT,         -- Adj.Net Amt Difference for Prev Doc [e_prevdocadjddiff_vdm]
    PREVDOCMINNETAMT,           -- Min Net Amt ovr Cur Prev Doc [e_prevdocminnetamt_vdm]
    PREVDOCMAXNETAMT,           -- Max Net Amt ovr Cur Prev Doc [e_prevdocmaxnetamt_vdm]
    PREVDOCAVGNETAMT,           -- Avg Net Amt ovr Cur Prev Doc [e_prevdocavgnetamt_vdm]
    PREVDOCMDNNETAMT,           -- Mdn Net Amt ovr Cur Prev Doc [e_prevdocmdnnetamt_vdm]
    PREVDOCSTDVNETAMT,          -- Stdv Net Amt ovr Cur Prev Doc [e_prevdocstdvnetamt_vdm]
    PREVDOCVARCNETAMT,          -- Varc Net Amt ovr Cur Prev Doc [e_prevdocvarcnetamt_vdm]
    PREVDOCMINADJDNETAMT,       -- Min Adjd Net Amt ovr Cur Prev Doc [e_prevdocminadjdnetamt_vdm]
    PREVDOCMAXADJDNETAMT,       -- Max Adjd Net Amt ovr Cur Prev Doc [e_prevdocmaxadjdnetamt_vdm]
    PREVDOCAVGADJDNETAMT,       -- Avg Adjd Net Amt ovr Cur Prev Doc [e_prevdocavgadjdnetamt_vdm]
    PREVDOCMDNADJDNETAMT,       -- Mdn Adjd Net Amt ovr Cur Prev Doc [e_prevdocmdnadjdnetamt_vdm]
    PREVDOCSTDVADJDNETAMT,      -- Stdv Adjd Net Amt ovr Cur Prev Doc [e_prevdocstdvadjdnetamt_vdm]
    PREVDOCVARCADJDNETAMT,      -- Varc Adjd Net Amt ovr Cur Prev Doc [e_prevdocvarcadjdnetamt_vdm]
    PREVDOCMINPREVNETAMT,       -- Min Prev Net Amt ovr Cur Prev Doc [e_prevdocprminnetamt_vdm]
    PREVDOCMAXPREVNETAMT,       -- Max Prev Net Amt ovr Cur Prev Doc [e_prevdocprmaxnetamt_vdm]
    PREVDOCAVGPREVNETAMT,       -- Avg Prev Net Amt ovr Cur Prev Doc [e_prevdocpravgnetamt_vdm]
    PREVDOCMDNPREVNETAMT,       -- Mdn Prev Net Amt ovr Cur Prev Doc [e_prevdocprmdnnetamt_vdm]
    PREVDOCSTDVPREVNETAMT,      -- Stdv Prev Net Amt ovr Cur Prev Doc [e_prevdocprstdvnetamt_vdm]
    PREVDOCVARCPREVNETAMT,      -- Varc Prev Net Amt ovr Cur Prev Doc [e_prevdocprvarcnetamt_vdm]
    PREVDOCMINPREVADJDNETAMT,   -- Min Prev Adjd Net Amt ovr Cur Prev Doc [e_prevdocprminadjdnetamt_vdm]
    PREVDOCMAXPREVADJDNETAMT,   -- Max Prev Adjd Net Amt ovr Cur Prev Doc [e_prevdocprmaxadjdnetamt_vdm]
    PREVDOCAVGPREVADJDNETAMT,   -- Avg Prev Adjd Net Amt ovr Cur Prev Doc [e_prevdocpravgadjdnetamt_vdm]
    PREVDOCMDNPREVADJDNETAMT,   -- Mdn Prev Adjd Net Amt ovr Cur Prev Doc [e_prevdocprmdnadjdnetamt_vdm]
    PREVDOCSTDVPREVADJDNETAMT,  -- Stdv Prev Adjd Net Amt ovr Cur Prev Doc [e_prevdocprstdvadjdnetamt_vdm]
    PREVDOCVARCPREVADJDNETAMT,  -- Varc Prev Adjd Net Amt ovr Cur Prev Doc [e_prevdocprvarcadjdnetamt_vdm]
    PREVDOCMINDIFFNETAMT,       -- Min Net Amt Diff ovr Cur Prev Doc [e_prevdocmindiff_vdm]
    PREVDOCMAXDIFFNETAMT,       -- Max Net Amt Diff ovr Cur Prev Doc [e_prevdocmaxdiff_vdm]
    PREVDOCAVGDIFFNETAMT,       -- Avg Net Amt Diff ovr Cur Prev Doc [e_prevdocavgdiff_vdm]
    PREVDOCMDNDIFFNETAMT,       -- Mdn Net Amt Diff ovr Cur Prev Doc [e_prevdocmdndiff_vdm]
    PREVDOCSTDVDIFFNETAMT,      -- Stdv Net Amt Diff ovr Cur Prev Doc [e_prevdocstdvdiff_vdm]
    PREVDOCVARCDIFFNETAMT,      -- Varc Net Amt Diff ovr Cur Prev Doc [e_prevdocvarcdiff_vdm]
    PREVDOCMINDIFFADJDNETAMT,   -- Min Adjd Net Amt Diff ovr Cur Prev Doc [e_prevdocminadjddiff_vdm]
    PREVDOCMAXDIFFADJDNETAMT,   -- Max Adjd Net Amt Diff ovr Cur Prev Doc [e_prevdocmaxadjddiff_vdm]
    PREVDOCAVGDIFFADJDNETAMT,   -- Avg Adjd Net Amt Diff ovr Cur Prev Doc [e_prevdocavgadjddiff_vdm]
    PREVDOCMDNDIFFADJDNETAMT,   -- Mdn Adjd Net Amt Diff ovr Cur Prev Doc [e_prevdocmdnadjddiff_vdm]
    PREVDOCSTDVDIFFADJDNETAMT,  -- Stdv Adjd Net Amt Diff ovr Cur Prev Doc [e_prevdocstdvadjddiff_vdm]
    PREVDOCVARCDIFFADJDNETAMT,  -- Varc Adjd Net Amt Diff ovr Cur Prev Doc [e_prevdocvarcadjddiff_vdm]
    PREVYRBILLGDOCNETAMT,       -- Total Net Amount of Prev Year Doc [e_prevyrdocnetamt_vdm]
    PREVYRBILLGDOCADJDNETAMT,   -- Adjd Total Net Amount of Prev Year Doc [e_prevyrdocadjdnetamt_vdm]
    PREVYRBILLGDIFFNETAMT,      -- Difference Prev Year Doc Net Amounts [e_prevyrdocdiff_vdm]
    PREVYRBILLGDIFFADJDNETAMT,  -- Diff Prev Year Doc Adjd Net Amounts [e_prevyrdocadjddiff_vdm]
    CURYRMINNETAMT,             -- Min.Net Amt in Current Year [e_curyrminnetamt_vdm]
    CURYRMAXNETAMT,             -- Max Net Amt in Current Year [e_curyrmaxnetamt_vdm]
    CURYRAVGNETAMT,             -- Avg Net Amt in Current Year [e_curyravgnetamt_vdm]
    CURYRMDNNETAMT,             -- Mdn Net Amt in Current Year [e_curyrmdnnetamt_vdm]
    CURYRSTDVNETAMT,            -- Stdv Net Amt in Current Year [e_curyrstdvnetamt_vdm]
    CURYRVARCNETAMT,            -- Varc Net Amt in Current Year [e_curyrvarcnetamt_vdm]
    CURYRMINADJDTOTNETAMT,      -- Min Adjd Net Amt in Current Year [e_curyrminadjdnetamt_vdm]
    CURYRMAXADJDTOTNETAMT,      -- Max Adjd Net Amt in Current Year [e_curyrmaxadjdnetamt_vdm]
    CURYRAVGADJDTOTNETAMT,      -- Avg Adj.Net Amt in Current Year [e_curyravgadjdnetamt_vdm]
    CURYRMDNADJDTOTNETAMT,      -- Mdn Adjd Net Amt in Current Year [e_curyrmdnadjdnetamt_vdm]
    CURYRSTDVADJDTOTNETAMT,     -- Stdv Adjd Net Amt in Current Year [e_curyrstdvadjdnetamt_vdm]
    CURYRVARCADJDTOTNETAMT,     -- Varc Adjd Net Amt in Current Year [e_curyrvarcadjdnetamt_vdm]
    THREEYRMINNETAMT,           -- Min Net Amt ovr 3 docs [e_threedocminnetamt_vdm]
    THREEYRMAXNETAMT,           -- Max Net Amt ovr 3 docs [e_threedocmaxnetamt_vdm]
    THREEYRAVGNETAMT,           -- Avg Net Amt ovr 3 docs [e_threedocavgnetamt_vdm]
    THREEYRMDNNETAMT,           -- Mdn Net Amt ovr 3 docs [e_threedocmdnnetamt_vdm]
    THREEYRSTDVNETAMT,          -- Stdv Net Amt ovr 3 docs [e_threedocstdvnetamt_vdm]
    THREEYRVARCNETAMT,          -- Varc Net Amt ovr 3 docs [e_threedocvarcnetamt_vdm]
    THREEYRMINADJDNETAMT,       -- Min Adjd Net Amt ovr 3 docs [e_threedocminadjdnetamt_vdm]
    THREEYRMAXADJDNETAMT,       -- Max Adjd Net Amt ovr 3 docs [e_threedocmaxadjdnetamt_vdm]
    THREEYRAVGADJDNETAMT,       -- Avg Adjd Net Amt ovr 3 docs [e_threedocavgadjdnetamt_vdm]
    THREEYRMDNADJDNETAMT,       -- Mdn Adjd Net Amt ovr 3 docs [e_threedocmdnadjdnetamt_vdm]
    THREEYRSTDVADJDNETAMT,      -- Stdv Adjd Net Amt ovr 3 docs [e_threedocstdvadjdnetamt_vdm]
    THREEYRVARCADJDNETAMT,      -- Stdv Adjd Net Amt ovr 3 docs [e_threedocstdvadjdnetamt_vdm]
    THREEYRMINPREVYRNETAMT,     -- Min Prev Net Amt ovr 3 docs [e_threedocprminnetamt_vdm]
    THREEYRMAXPREVYRNETAMT,     -- Max Prev Net Amt ovr 3 docs [e_threedocprmaxnetamt_vdm]
    THREEYRAVGPREVYRNETAMT,     -- Avg Prev Net Amt ovr 3 docs [e_threedocpravgnetamt_vdm]
    THREEYRMDNPREVYRNETAMT,     -- Mdn Prev Net Amt ovr 3 docs [e_threedocprmdnnetamt_vdm]
    THREEYRSTDVPREVYRNETAMT,    -- Stdv Prev Net Amt ovr 3 docs [e_threedocprstdvnetamt_vdm]
    THREEYRVARCPREVYRNETAMT,    -- Varc Prev Net Amt ovr 3 docs [e_threedocprvarcnetamt_vdm]
    THREEYRMINPREVADJDNETAMT,   -- Min Prev Adjd Net Amt ovr 3 docs [e_threedocprminadjdnetamt_vdm]
    THREEYRMAXPREVADJDNETAMT,   -- Max Prev Adjd Net Amt ovr 3 docs [e_threedocprmaxadjdnetamt_vdm]
    THREEYRAVGPREVADJDNETAMT,   -- Avg Prev Adjd Net Amt ovr 3 docs [e_threedocpravgadjdnetamt_vdm]
    THREEYRMDNPREVADJDNETAMT,   -- Mdn Prev Adjd Net Amt ovr 3 docs [e_threedocprmdnadjdnetamt_vdm]
    THREEYRSTDVPREVADJDNETAMT,  -- Stdv Prev Adjd Net Amt ovr 3 docs [e_threedocprstdvadjdnetamt_vdm]
    THREEYRVARCPREVADJDNETAMT,  -- Varc Prev Adjd Net Amt ovr 3 docs [e_threedocprvarcadjdnetamt_vdm]
    THREEYRMINDIFFNETAMT,       -- Min Net Amt Diff ovr 3 docs [e_threedocmindiff_vdm]
    THREEYRMAXDIFFNETAMT,       -- Max Net Amt Diff ovr 3 docs [e_threedocmaxdiff_vdm]
    THREEYRAVGDIFFNETAMT,       -- Avg Net Amt Diff ovr 3 docs [e_threedocavgdiff_vdm]
    THREEYRMDNDIFFNETAMT,       -- Mdn Net Amt Diff ovr 3 docs [e_threedocmdndiff_vdm]
    THREEYRSTDVDIFFNETAMT,      -- Stdv Net Amt Diff ovr 3 docs [e_threedocstdvdiff_vdm]
    THREEYRVARCDIFFNETAMT,      -- Varc Net Amt Diff ovr 3 docs [e_threedocvarcdiff_vdm]
    THREEYRMINDIFFADJDNETAMT,   -- Min Adjd Net Amt Diff ovr 3 docs [e_threedocminadjddiff_vdm]
    THREEYRMAXDIFFADJDNETAMT,   -- Max Adjd Net Amt Diff ovr 3 docs [e_threedocmaxadjddiff_vdm]
    THREEYRAVGDIFFADJDNETAMT,   -- Avg Adjd Net Amt Diff ovr 3 docs [e_threedocavgadjddiff_vdm]
    THREEYRMDNDIFFADJDNETAMT,   -- Mdn Adjd Net Amt Diff ovr 3 docs [e_threedocmdnadjddiff_vdm]
    THREEYRSTDVDIFFADJDNETAMT,  -- Stdv Adjd Net Amt Diff ovr 3 docs [e_threedocstdvadjddiff_vdm]
    THREEYRVARCDIFFADJDNETAMT,  -- Varc Adjd Net Amt Diff ovr 3 docs [e_threedocvarcadjddiff_vdm]
    PREVBILLGDOCEXISTS,         -- Previous Document Exists [e_prevbillgdocexist_vdm]
    FIRSTBILLGDOCOUTSRTD,       -- First Billing Document is Outsorted [e_firstbidocoutmovein_vdm]
    OUTSRTGCHECKGRPFORBILLG,    -- Outsort.chk grp [ausgrup]
    RATECATEGORY,               -- Rate category [tariftyp]
    BILLINGCLASS,               -- Billing Class [aklasse]
    INDUSTRYSECTOR,             -- Industry [bu_ind_sector]
    LINEITMCNVRSNRSN,           -- Convers. reason [umwgrund]
    HASCNVRSNRSN,               -- Conversion Reason Exists [e_cnvrsnrsnexist_vdm]
    BILLINGCHECK,               -- Bill.validation [validation]
    OUTSORTINGREASON,           -- Man. OS billing [manoutsort]
    PRIMARY KEY (MANDT, BELNR)
);