SAP Table J_1ISER_BSEG

Transaction table having the Invoices with Service Category

J_1ISER_BSEG (Transaction table having the Invoices with Service Category) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link J_1ISER_BSEG to other SAP tables.

J_1ISER_BSEG table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
BUKRS Company Code BUKRS T001 CHAR 4 0
BELNR Accounting Document Number BELNR_D CHAR 10 0
GJAHR Fiscal Year GJAHR NUMC 4 0
BUZEI Number of Line Item Within Accounting Document BUZEI NUMC 3 0
CONDNAME Condition name for Indian tax conditions J_1ICONDNAME CHAR 10 0
ECSARTOT A/R ECS total
BEDSETOFFQ BED Set Off condition Quantity based
BEDINVENTQ BED Inventory Quantity Based
AEDSETOFFQ AED Set Off condition Quantity Based
AEDINVENTQ AED Inventory Quantity Based
SEDSETOFFQ SED Set Off Condition Quantity Based
SEDINVENTQ SED Inventory Quantity Based
BEDSETOFFT BED Set Off condition Total
AEDSETOFFT AED Set Off condition Total
SEDSETOFFT SED Set Off Condition Total
BEDINVENTT BED Inventory Total
AEDINVENTT AED Inventory Total
SEDINVENTT SED Inventory Total
BEDSETOFFP BED Set Off condition Percentage
BEDINVENTP BED Inventory Percentage
AEDSETOFFP AED Set Off condition Percentage
AEDINVENTP AED Inventory Percentage
SEDSETOFFP SED Set Off ConditionPercentage
SEDINVENTP SED Inventory Percentage
BEDARPERC A/R BED Percentage
BEDARQTY A/R BED Quantity based
AEDARPERC A/R AED Percentage
AEDARQTY A/R AED Quantity based
SEDARPERC A/R SED Percentage
SEDARQTY A/R SED Quantity based
CESARPERC A/R Cess Percentage
CESARQTY A/R Cess Quantity Based
APCST A/P Central Sales tax
APLST A/P Local Sales tax
APSUR A/P ST Surcharge
APSETOFF A/P ST setoff
BEDARTOT A/R BED total
AEDARTOT A/R AED total
SEDARTOT A/R SED total
CESARTOT A/R Cess total
NCDSETOFFQ NCCD Set Off condition Quantity Based
NCDSETOFFT NCCD Set Off condition Total
NCDINVENTQ NCCD Inventory Quantity Based
NCDINVENTT NCCD Inventory Total
NCDSETOFFP NCCD Set Off condition Percentage
NCDINVENTP NCCD Inventory Percentage
NCDARPERC A/R NCCD Percentage
NCDARQTY A/R NCCD Quantity based
NCDARTOT A/R NCCD total
ECSSETOFFQ ECS Set Off condition Quantity Based
ECSSETOFFT ECS Set Off condition Total
ECSINVENTQ ECS Inventory Quantity Based
ECSINVENTT ECS Inventory Total
ECSSETOFFP ECS Set Off condition Percentage
ECSINVENTP ECS Inventory Percentage
ECSARPERC A/R ECS Percentage
ECSARQTY A/R ECS Quantity based
CSTAPND A/P CST Non Deductible under VAT
RMDAPVAT A/P VAT RM Deductible
RMNDAPVAT A/P VAT RM Non Deductible
CGDAPVAT A/P VAT CG Deductible
CGNDAPVAT A/P VAT CG Non Deductible
PARVAT A/R VAT Payable
CSTARVAT A/R CST Payable under VAT
AT1SETOFFQ AT1 Set Off condition Quantity Based
AT1SETOFFT AT1 Set Off condition Total
AT1INVENTQ AT1 Inventory Quantity Based
AT1INVENTT AT1 Inventory Total
AT1SETOFFP AT1 Set Off condition Percentage
AT1INVENTP AT1 Inventory Percentage
AT1ARPERC A/R AT1 Percentage
AT1ARQTY A/R AT1 Quantity based
AT1ARTOT A/R AT1 total
AT2SETOFFQ AT2 Set Off condition Quantity Based
AT2SETOFFT AT2 Set Off condition Total
AT2INVENTQ AT2 Inventory Quantity Based
AT2INVENTT AT2 Inventory Total
AT2SETOFFP AT2 Set Off condition Percentage
AT2INVENTP AT2 Inventory Percentage
AT2ARPERC A/R AT2 Percentage
AT2ARQTY A/R AT2 Quantity based
AT2ARTOT A/R AT2 total
AT3SETOFFQ AT3 Set Off condition Quantity Based
AT3SETOFFT AT3 Set Off condition Total
AT3INVENTQ AT3 Inventory Quantity Based
AT3INVENTT AT3 Inventory Total
AT3SETOFFP AT3 Set Off condition Percentage
AT3INVENTP AT3 Inventory Percentage
AT3ARPERC A/R AT3 Percentage
AT3ARQTY A/R AT3 Quantity based
AT3ARTOT A/R AT3 total
SEROFFT A/P Service Tax Set Off
SERECSOFFT A/P Service ECS Set Off
SERAT1OFFT A/P Service SHCess Set Off
SERART A/R Service Tax
SERECSART A/R Service ECS
SERAT1ART A/R Service SHCess
GTASERT GTA Service Tax
BLART Document Type BLART CHAR 2 0
KSCHL Condition Type KSCHL CHAR 4 0
BUDAT Posting Date in the Document BUDAT DATS 8 0
STBLG Reverse Document Number STBLG CHAR 10 0
STJAH Reverse document fiscal year STJAH NUMC 4 0
WERKS Plant WERKS_D CHAR 4 0
KUNNR Customer Number KUNNR CHAR 10 0
LIFNR Account Number of Vendor or Creditor LIFNR CHAR 10 0
SHKZG Debit/Credit Indicator SHKZG CHAR 1 0
H Credit
S Debit
HKONT General Ledger Account HKONT CHAR 10 0
MWSKZ Tax on sales/purchases code MWSKZ CHAR 2 0
TXGRP Group Indicator for Tax Line Items TXGRP NUMC 3 0
KBETR Tax Rate KBETR_TAX CURR 11 2
WAERS Currency Key WAERS CUKY 5 0
HWBAS Tax Base Amount in Local Currency HWBAS CURR 13 2
HWSTE Tax Amount in Local Currency HWSTE CURR 13 2
FWBAS Tax Base Amount in Document Currency FWBAS CURR 13 2
FWSTE Tax Amount in Document Currency FWSTE CURR 13 2
J_1ISERCAT Service category J_1ISER_CAT CHAR 10 0
DOCTYPE Service Document Type J_1ISERDOCTYP CHAR 1 0
F FI Document
V SD Document
M MM Document
O Other Documents
USNAM User name USNAM CHAR 12 0
CPUDT Day On Which Accounting Document Was Entered CPUDT DATS 8 0
CPUTM Time of Entry CPUTM TIMS 6 0
BUPLA Business Place BUPLA CHAR 4 0
SECCO Section Code SECCO CHAR 4 0

J_1ISER_BSEG foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
J_1ISER_BSEG BUKRS J_1ISER_BSEG BUKRS T001 Company Codes BUKRS
J_1ISER_BSEG BUKRS J_1ISER_BSEG MANDT T001 Company Codes MANDT
J_1ISER_BSEG MANDT J_1ISER_BSEG MANDT T000 Clients MANDT