SAP TABLES | Financial Accounting | Localization(FI-LOC) SAP FI

J_1I_SALREG SAP Structure for Sales Register Excise Details Structure and data







J_1I_SALREG is an SAP Structure so does not store data like a database table does but can be used to process "Structure for Sales Register Excise Details" Information within sap ABAP programs. This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_J_1I_SALREG TYPE J_1I_SALREG .

Below is the documentation avaialable and full details of the fields which make up this Structure.

You can view further information about this via relevant transactions such as SE11 or SE80. Also check out the Comments section below to view or add related contributions and example screen shots.



Display/Maintenance via SM30: Yes but with Restrictions

Enhancement category i: Can be enhanced (character-type or numeric)
See here for more information about this and other SAP enhancement categories


SAP J_1I_SALREG Structure fields within data Dictionary





Field
Component Type
Data Typelength (Decimals)Check tableDescriptionConversion Routine
BURKS_VFBUKRS_VFCHAR4
*
Company code to be billed
VKORGVKORGCHAR4
*
Sales Organization
VTWEGVTWEGCHAR2
*
Distribution Channel
SPARTSPARTCHAR2
*
Division
KUNNRKUNAGCHAR10
*
Sold-to partyALPHA
VBELNVBELN_VACHAR10
*
Sales DocumentALPHA
AUDATAUDATDATS8 Document Date (Date Received/Sent)
BSTNKBSTNKCHAR20 Customer purchase order number
NETWR_SONETWR_AKCURR15(2) Net Value of the Sales Order in Document Currency
WAERKWAERKCUKY5
*
SD Document Currency
VBTYPVBTYPCHAR1 SD document category
AUARTAUARTCHAR4
*
Sales Document TypeAUART
VBELN_VLVBELN_VLCHAR10
*
DeliveryALPHA
KUNNR_DELKUNWECHAR10
*
Ship-to partyALPHA
ERNAMERNAMCHAR12 Name of Person who Created the Object
ERDAT_DELERDATDATS8 Date on Which Record Was Created
VSTELVSTELCHAR4
*
Shipping Point/Receiving Point
LFARTLFARTCHAR4
*
Delivery Type
LFDATLFDAT_VDATS8 Delivery Date
BTGEWGSGEWQUAN15(3) Total Weight
NTGEWNTGEW_15QUAN15(3) Net weight
GEWEIGEWEIUNIT3
*
Weight UnitCUNIT
ERDAT_BILERDATDATS8 Date on Which Record Was Created
BUPLABUPLACHAR4
*
Business Place
VBELN_VFVBELN_VFCHAR10
*
Billing DocumentALPHA
FKARTFKARTCHAR4
*
Billing Type
FKTYPFKTYPCHAR1 Billing category
BELNRBELNR_DCHAR10 Accounting Document NumberALPHA
GJAHRGJAHRNUMC4 Fiscal YearGJAHR



FKDATFKDATDATS8 Billing date for billing index and printout
MWSBKMWSBPCURR13(2) Tax amount in document currency
NETWRNETWRCURR15(2) Net Value in Document Currency
ZLSCHSCHZW_BSEGCHAR1
*
Payment Method
EXGRPJ_1IEXCGRPCHAR2
*
Excise Group
TRNTYPJ_1ITRNTYPCHAR4
*
Excise Transaction Type
DOCYRJ_1IDOCUYRNUMC4 Year
DOCNOJ_1IDOCNONUMC10
*
Internal Excise Document Number
STRTYPJ_1ISTRTYPCHAR2 Sub Transaction Type
EXCURJ_1IEXCCURCUKY5
*
Currency
EXCCDJ_1IEXCDCHAR40 ECC Number
EXCRNJ_1IEXRNCHAR40 Excise Registration Number
EXNUMJ_1IEXCNUMCHAR10 Official Excise Document Number
EXDATJ_1IEXCDATDATS8 Excise Document Date
EXBEDJ_1IEXCBEDCURR13(2) Basic Excise Duty
EXSEDJ_1IEXCSEDCURR13(2) Special Excise Duty
EXAEDJ_1IEXCAEDCURR13(2) Additional Excise Duty
CESSJ_1IEXCESSCURR13(2) Cess amount
NCCDJ_1IEXNCCDCURR13(2) NCCD Value
ECSJ_1IEXECSCURR13(2) ECS Value
EXADDTAX1J_1IEXADDTAX1CURR13(2) Additional Tax1 value
EXADDTAX2J_1IEXADDTAX2CURR13(2) Additional Tax2 value
EXADDTAX3J_1IEXADDTAX3CURR13(2) Additional Tax3 value
EXPINDJ_1IINDEXPCHAR1 Export Type
CSTNOJ_1ICSTNOCHAR40 Central Sales Tax Number
LSTNOJ_1ILSTNOCHAR40 Local Sales Tax Number
PANNOJ_1IPANNOCHAR40 Permanent Account Number
STATUSJ_1ISTATUSCHAR1 Excise Document Status
USNAMJ_1IUSNAMCHAR12 Created By
CPUDTJ_1ICPUDTDATS8 Excise Document Entry Date
DEPEXNUMJ_1IEXCNUMCHAR10 Official Excise Document Number
DEPEXYEARJ_1IEXYEARNUMC4 Excise YearGJAHR
LIFNRJ_1ILIFNRCHAR10 Vendor
SHIPFROMLIFNRCHAR10
*
Account Number of Vendor or CreditorALPHA
EXBASJ_1IEXCBASCURR13(2) Excise Duty Base Amount
USNAM_DJ_1IUSNAMCHAR12 Created By
CPUDT_DJ_1ICPUDTDATS8 Excise Document Entry Date
EXGRP_DJ_1IEXCGRPCHAR2
*
Excise Group
EXBED_DJ_1IEXCBEDCURR13(2) Basic Excise Duty
EXSED_DJ_1IEXCSEDCURR13(2) Special Excise Duty
EXAED_DJ_1IEXCAEDCURR13(2) Additional Excise Duty
CESS_DJ_1IEXCESSCURR13(2) Cess amount
NCCD_DJ_1IEXNCCDCURR13(2) NCCD Value
ECS_DJ_1IEXECSCURR13(2) ECS Value
EXADDTAX1_DJ_1IEXADDTAX1CURR13(2) Additional Tax1 value
EXADDTAX2_DJ_1IEXADDTAX2CURR13(2) Additional Tax2 value
EXADDTAX3_DJ_1IEXADDTAX3CURR13(2) Additional Tax3 value



Key field
Non-key field