J_3RTSE

Transparent Table Application Table
46 Fields 1 CDS Views

Secondary index table for VAT

J_3RTSE is an SAP database table in S/4HANA. Secondary index table for VAT. It contains 46 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_RU_SecondaryEventBasic view from BASIC RU Secondary Events

Fields (46)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY bukrs bukrs Company Code
KEY initdoc belnr_d Document Number
KEY initdate budat Posting Date
KEY initbuzei buzei Item
KEY secbukrs bukrs Company Code
KEY secdoc belnr_d Document Number
KEY secdate bldat Document Date
KEY secbuzei buzei Item
KEY origin j_3rforigin Origin
type j_3rfsec_type Sec. Event Type
quant menge_d Quantity
summa j_3rdmbtr Sec. Evnt. Amount
percent j_3rpercent Percent
reference j_3rszuonr Allocation
withouttax j_3rwithouttax VAT Incl/Excl
taxdoc belnr_d Document Number
taxdate bldat Document Date
matnr matnr Material
charg charg_d Batch
objnr j_objnr Object number
kstar kstar Cost Element
initxblnr xblnr1 Reference
ndsposc j_3rndspos VATItemOfInvo
waers waers Currency
propl j_3rpropl PaymentPercent
vozmvat j_3rvozm VAT Compensated
meins meins Base Unit
secxblnr xblnr1 Reference
posend j_3rposend Item is processed
event j_3rnksevent Event Type
errcode j_3rperrcode Error Code
descript char50 c
statistic j_3rstop Processing attrib
rundate j_3rrundate Run date
runid j_3rrunid Run identificator
usnam usnam User Name
upddt upddt Last Update
taxyear gjahr Fiscal Year
taxcode dzmwsk Target Tax Code
ccd_beln j_3rs_ccd_beln Cus. Decl. No.
ccd_item j_3rs_ccditemid CDec Item No.
ccd_subitm j_3rs_ccdsubid Subitem Number
import_notification j_3rs_imnt_int_num Imp Notif Int Number
import_notification_item j_3rs_imnt_posnr Import Notif Item
rate_date j_3rexch_rate_date Exchange Rate Date

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.

-- Secondary index table for VAT
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE J_3RTSE (
    MANDT,                     -- Client [mandt]
    BUKRS,                     -- Company Code [bukrs]
    INITDOC,                   -- Document Number [belnr_d]
    INITDATE,                  -- Posting Date [budat]
    INITBUZEI,                 -- Item [buzei]
    SECBUKRS,                  -- Company Code [bukrs]
    SECDOC,                    -- Document Number [belnr_d]
    SECDATE,                   -- Document Date [bldat]
    SECBUZEI,                  -- Item [buzei]
    ORIGIN,                    -- Origin [j_3rforigin]
    TYPE,                      -- Sec. Event Type [j_3rfsec_type]
    QUANT,                     -- Quantity [menge_d]
    SUMMA,                     -- Sec. Evnt. Amount [j_3rdmbtr]
    PERCENT,                   -- Percent [j_3rpercent]
    REFERENCE,                 -- Allocation [j_3rszuonr]
    WITHOUTTAX,                -- VAT Incl/Excl [j_3rwithouttax]
    TAXDOC,                    -- Document Number [belnr_d]
    TAXDATE,                   -- Document Date [bldat]
    MATNR,                     -- Material [matnr]
    CHARG,                     -- Batch [charg_d]
    OBJNR,                     -- Object number [j_objnr]
    KSTAR,                     -- Cost Element [kstar]
    INITXBLNR,                 -- Reference [xblnr1]
    NDSPOSC,                   -- VATItemOfInvo [j_3rndspos]
    WAERS,                     -- Currency [waers]
    PROPL,                     -- PaymentPercent [j_3rpropl]
    VOZMVAT,                   -- VAT Compensated [j_3rvozm]
    MEINS,                     -- Base Unit [meins]
    SECXBLNR,                  -- Reference [xblnr1]
    POSEND,                    -- Item is processed [j_3rposend]
    EVENT,                     -- Event Type [j_3rnksevent]
    ERRCODE,                   -- Error Code [j_3rperrcode]
    DESCRIPT,                  -- c [char50]
    STATISTIC,                 -- Processing attrib [j_3rstop]
    RUNDATE,                   -- Run date [j_3rrundate]
    RUNID,                     -- Run identificator [j_3rrunid]
    USNAM,                     -- User Name [usnam]
    UPDDT,                     -- Last Update [upddt]
    TAXYEAR,                   -- Fiscal Year [gjahr]
    TAXCODE,                   -- Target Tax Code [dzmwsk]
    CCD_BELN,                  -- Cus. Decl. No. [j_3rs_ccd_beln]
    CCD_ITEM,                  -- CDec Item No. [j_3rs_ccditemid]
    CCD_SUBITM,                -- Subitem Number [j_3rs_ccdsubid]
    IMPORT_NOTIFICATION,       -- Imp Notif Int Number [j_3rs_imnt_int_num]
    IMPORT_NOTIFICATION_ITEM,  -- Import Notif Item [j_3rs_imnt_posnr]
    RATE_DATE,                 -- Exchange Rate Date [j_3rexch_rate_date]
    PRIMARY KEY (MANDT, BUKRS, INITDOC, INITDATE, INITBUZEI, SECBUKRS, SECDOC, SECDATE, SECBUZEI, ORIGIN)
);

Learn More