J_1IEXCDTL

Transparent Table Application Table
104 Fields 1 CDS Views

Excise invoice line item details

J_1IEXCDTL is an SAP database table in S/4HANA. Excise invoice line item details. It contains 104 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_ExciseDocumentItem view from BASIC Excise Document Item

Fields (104)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY trntyp j_1itrntyp Excise TT
KEY docyr j_1idocuyr Year
KEY docno j_1idocno Internal No.
KEY zeile j_1izeile Item
werks werks_d Plant
exnum j_1iexcnum Official No.
exdat j_1iexcdat Exc. doc. date
exyear j_1iexyear Excise year
exgrp j_1iexcgrp Excise Group
lifnr j_1ilifnr Vendor
shipfrom lifnr Supplier
rcwrk umwrk Receiving plant
gsber gsber Business Area
lgort lgort_d Location
matnr matnr Material
maktx maktx Description
charg charg_d Batch
chapid j_1ichid Chapter ID
menge j_1imenge Qty in exc inv
menga j_1imenga GR quantity
credit_qty j_1imengc Credit Qty
mengr j_1imengr Qty remaining
scpgn j_1iscpgn Quantity of Scrap ge
meins j_1imeins Unit of measure
mengr_uom meins Base Unit
excur j_1iexccur Currency
exbas j_1iexcbas Excise base amt
exbed j_1iexcbed BED
exsed j_1iexcsed SED
exaed j_1iexcaed AED
cess j_1iexcess CESS
bedinv j_1ibedinv Inv. BED
aedinv j_1iaedinv Inv. AED
sedinv j_1isedinv Inv. SED
addbed j_1iaddbed Add. BED
addsed j_1iaddsed Add. SED
addaed j_1iaddaed Add. AED
indtax j_1indtax Non Dedu. Tax
part2yr j_1iyear Year
rg23aser j_1i23aser RG23A ser. no.
rg23cser j_1i23cser RG23C ser. no.
rgplaser j_1iplaser PLA ser. no.
part1yr j_1iyear Year
part1ser j_1isrlno1 Serial no.
rdoc1 j_1irdoc1 Ref. doc. 1
ryear1 j_1iryear1 Ref. Year1
ritem1 j_1iritem1 Ref. Item1
rind1 j_1irind1 Ref doc typ 1
rdoc2 j_1irdoc2 Ref. doc. 2
ryear2 j_1iryear2 Ref. Year2
ritem2 j_1iritem2 Ref. Item2
rind2 j_1irind2 Ref doc typ 2
rdoc3 j_1irdoc3 Ref doc 3
rind3 j_1irind3 Ref doc typ 3
status j_1istatus Status
bedrate j_1ibedrat BED percentage
aedrate j_1iaedrat Addl Excise Duty %
sedrate j_1isedrat Special Excise Duty
cessrate j_1icess Cess Rate
capind j_1icapind Material type
mrpind char1 Single-Character Flag
rej_code j_1irejcode Rejection code
usnam j_1iusnam Entered by
cpudt j_1icpudt Entry Date
cputm cputm Entered at
aenam j_1iusnamc Changed By
aedat j_1iaedat Changed on date
addldata1 j_1iaddata Additional data
addldata2 j_1iaddata Additional data
addldata3 j_1iaddata Additional data
addldata4 j_1iaddata Additional data
addlval1 j_1iaddval Addnl value
addlval2 j_1iaddval Addnl value
num_of_pkgs j_1inum_of_pkg No. Packages
desc_pkg j_1idesc_pkg Description
ntgew ntgew_15 Net Weight
brgew brgew_15 Gross Weight
gewei gewei Unit of Weight
mrk_pkg j_1imrk_pkg Marks
nos_on_pkg j_1inos_on_pkg Numbers
licyr j_1ilicyr License Year
licno j_1ilicno Internal No.
liczeile j_1izeile Item
nccd j_1iexnccd NCCD Value
nccdinv j_1inccdinv NCCD Inventory Comp
nccdrate j_1inccdrat NCCD Rate in %
addnccd j_1iaddnccd Additional NCCD
ecs j_1iexecs ECS
ecsinv j_1iecsinv ECS Inventory Comp
ecsrate j_1iecsrat ECS Rate in %
exaddtax1 j_1iexaddtax1 Additional tax1
exaddinv1 j_1iexaddinv1 Inv. AT1
exaddrate1 j_1iexaddrat1 AT1 percentage
addat1 j_1iaddat1 Additional AT1
exaddtax2 j_1iexaddtax2 Additional tax2
exaddinv2 j_1iexaddinv2 Inv. AT2
exaddrate2 j_1iexaddrat2 AT2 percentage
addat2 j_1iaddat2 Additional AT2
exaddtax3 j_1iexaddtax3 Additional tax3
exaddinv3 j_1iexaddinv3 Inv. AT3
exaddrate3 j_1iexaddrat3 AT3 percentage
addat3 j_1iaddat3 Additional AT3
sertaxserno j_1isertaxno Ser Tax Serial No

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.

-- Excise invoice line item details
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE J_1IEXCDTL (
    MANDT,        -- Client [mandt]
    TRNTYP,       -- Excise TT [j_1itrntyp]
    DOCYR,        -- Year [j_1idocuyr]
    DOCNO,        -- Internal No. [j_1idocno]
    ZEILE,        -- Item [j_1izeile]
    WERKS,        -- Plant [werks_d]
    EXNUM,        -- Official No. [j_1iexcnum]
    EXDAT,        -- Exc. doc. date [j_1iexcdat]
    EXYEAR,       -- Excise year [j_1iexyear]
    EXGRP,        -- Excise Group [j_1iexcgrp]
    LIFNR,        -- Vendor [j_1ilifnr]
    SHIPFROM,     -- Supplier [lifnr]
    RCWRK,        -- Receiving plant [umwrk]
    GSBER,        -- Business Area [gsber]
    LGORT,        -- Location [lgort_d]
    MATNR,        -- Material [matnr]
    MAKTX,        -- Description [maktx]
    CHARG,        -- Batch [charg_d]
    CHAPID,       -- Chapter ID [j_1ichid]
    MENGE,        -- Qty in exc inv [j_1imenge]
    MENGA,        -- GR quantity [j_1imenga]
    CREDIT_QTY,   -- Credit Qty [j_1imengc]
    MENGR,        -- Qty remaining [j_1imengr]
    SCPGN,        -- Quantity of Scrap ge [j_1iscpgn]
    MEINS,        -- Unit of measure [j_1imeins]
    MENGR_UOM,    -- Base Unit [meins]
    EXCUR,        -- Currency [j_1iexccur]
    EXBAS,        -- Excise base amt [j_1iexcbas]
    EXBED,        -- BED [j_1iexcbed]
    EXSED,        -- SED [j_1iexcsed]
    EXAED,        -- AED [j_1iexcaed]
    CESS,         -- CESS [j_1iexcess]
    BEDINV,       -- Inv. BED [j_1ibedinv]
    AEDINV,       -- Inv. AED [j_1iaedinv]
    SEDINV,       -- Inv. SED [j_1isedinv]
    ADDBED,       -- Add. BED [j_1iaddbed]
    ADDSED,       -- Add. SED [j_1iaddsed]
    ADDAED,       -- Add. AED [j_1iaddaed]
    INDTAX,       -- Non Dedu. Tax [j_1indtax]
    PART2YR,      -- Year [j_1iyear]
    RG23ASER,     -- RG23A ser. no. [j_1i23aser]
    RG23CSER,     -- RG23C ser. no. [j_1i23cser]
    RGPLASER,     -- PLA ser. no. [j_1iplaser]
    PART1YR,      -- Year [j_1iyear]
    PART1SER,     -- Serial no. [j_1isrlno1]
    RDOC1,        -- Ref. doc. 1 [j_1irdoc1]
    RYEAR1,       -- Ref. Year1 [j_1iryear1]
    RITEM1,       -- Ref. Item1 [j_1iritem1]
    RIND1,        -- Ref doc typ 1 [j_1irind1]
    RDOC2,        -- Ref. doc. 2 [j_1irdoc2]
    RYEAR2,       -- Ref. Year2 [j_1iryear2]
    RITEM2,       -- Ref. Item2 [j_1iritem2]
    RIND2,        -- Ref doc typ 2 [j_1irind2]
    RDOC3,        -- Ref doc 3 [j_1irdoc3]
    RIND3,        -- Ref doc typ 3 [j_1irind3]
    STATUS,       -- Status [j_1istatus]
    BEDRATE,      -- BED percentage [j_1ibedrat]
    AEDRATE,      -- Addl Excise Duty % [j_1iaedrat]
    SEDRATE,      -- Special Excise Duty [j_1isedrat]
    CESSRATE,     -- Cess Rate [j_1icess]
    CAPIND,       -- Material type [j_1icapind]
    MRPIND,       -- Single-Character Flag [char1]
    REJ_CODE,     -- Rejection code [j_1irejcode]
    USNAM,        -- Entered by [j_1iusnam]
    CPUDT,        -- Entry Date [j_1icpudt]
    CPUTM,        -- Entered at [cputm]
    AENAM,        -- Changed By [j_1iusnamc]
    AEDAT,        -- Changed on date [j_1iaedat]
    ADDLDATA1,    -- Additional data [j_1iaddata]
    ADDLDATA2,    -- Additional data [j_1iaddata]
    ADDLDATA3,    -- Additional data [j_1iaddata]
    ADDLDATA4,    -- Additional data [j_1iaddata]
    ADDLVAL1,     -- Addnl value [j_1iaddval]
    ADDLVAL2,     -- Addnl value [j_1iaddval]
    NUM_OF_PKGS,  -- No. Packages [j_1inum_of_pkg]
    DESC_PKG,     -- Description [j_1idesc_pkg]
    NTGEW,        -- Net Weight [ntgew_15]
    BRGEW,        -- Gross Weight [brgew_15]
    GEWEI,        -- Unit of Weight [gewei]
    MRK_PKG,      -- Marks [j_1imrk_pkg]
    NOS_ON_PKG,   -- Numbers [j_1inos_on_pkg]
    LICYR,        -- License Year [j_1ilicyr]
    LICNO,        -- Internal No. [j_1ilicno]
    LICZEILE,     -- Item [j_1izeile]
    NCCD,         -- NCCD Value [j_1iexnccd]
    NCCDINV,      -- NCCD Inventory Comp [j_1inccdinv]
    NCCDRATE,     -- NCCD Rate in % [j_1inccdrat]
    ADDNCCD,      -- Additional NCCD [j_1iaddnccd]
    ECS,          -- ECS [j_1iexecs]
    ECSINV,       -- ECS Inventory Comp [j_1iecsinv]
    ECSRATE,      -- ECS Rate in % [j_1iecsrat]
    EXADDTAX1,    -- Additional tax1 [j_1iexaddtax1]
    EXADDINV1,    -- Inv. AT1 [j_1iexaddinv1]
    EXADDRATE1,   -- AT1 percentage [j_1iexaddrat1]
    ADDAT1,       -- Additional AT1 [j_1iaddat1]
    EXADDTAX2,    -- Additional tax2 [j_1iexaddtax2]
    EXADDINV2,    -- Inv. AT2 [j_1iexaddinv2]
    EXADDRATE2,   -- AT2 percentage [j_1iexaddrat2]
    ADDAT2,       -- Additional AT2 [j_1iaddat2]
    EXADDTAX3,    -- Additional tax3 [j_1iexaddtax3]
    EXADDINV3,    -- Inv. AT3 [j_1iexaddinv3]
    EXADDRATE3,   -- AT3 percentage [j_1iexaddrat3]
    ADDAT3,       -- Additional AT3 [j_1iaddat3]
    SERTAXSERNO,  -- Ser Tax Serial No [j_1isertaxno]
    PRIMARY KEY (MANDT, TRNTYP, DOCYR, DOCNO, ZEILE)
);

Learn More