BSIS — Table Structure, Fields(Columns) and Definitions

    Position Column Name Description Data Element Primary Key Data Type Length Check Table
    1 MANDT Client MANDT X CLNT 3
    2 BUKRS Company Code BUKRS X CHAR 4
    3 HKONT G/L HKONT X CHAR 10
    4 AUGDT Clearing AUGDT X DATS 8
    5 AUGBL Clrng doc. AUGBL X CHAR 10
    6 ZUONR Assignment DZUONR X CHAR 18
    7 GJAHR Fiscal Year GJAHR X NUMC 4
    8 BELNR Document Number BELNR_D X CHAR 10
    9 BUZEI Posting row BUZEI X NUMC 3
    10 BUDAT Posting Date BUDAT DATS 8
    11 BLDAT Document Date BLDAT DATS 8
    12 WAERS Currency WAERS CUKY 5 TCURC
    13 XBLNR Reference XBLNR1 CHAR 16
    14 BLART Document Type BLART CHAR 2 T003
    15 MONAT Period MONAT NUMC 2
    16 BSCHL Posting key BSCHL CHAR 2 TBSL
    17 SHKZG Debit/Credit SHKZG CHAR 1
    18 GSBER Business Area GSBER CHAR 4 TGSB
    19 MWSKZ Tax code MWSKZ CHAR 2 T007A
    20 FKONT Financial Budget Item FIPLS NUMC 3
    21 DMBTR Amount in LC DMBTR CURR 23
    22 WRBTR Amount WRBTR CURR 23
    23 MWSTS Tax Amount in Local Currency MWSTS CURR 23
    24 WMWST Tax Amount in Document Currency WMWST CURR 23
    25 SGTXT Name SGTXT CHAR 50
    26 PROJN Old: Project number : No longer used --> PS_POSNR PROJN CHAR 16
    27 AUFNR Order AUFNR_NEU CHAR 12 AUFK
    28 WERKS Plant WERKS_D CHAR 4 T001W
    29 KOSTL Cost Center KOSTL CHAR 10
    30 ZFBDT Baseline date DZFBDT DATS 8
    31 XOPVW OI management XOPVW CHAR 1
    32 VALUT Value date VALUT DATS 8
    33 BSTAT Doc.status BSTAT_D CHAR 1
    34 BDIFF Valuation diff. BDIFF CURR 23
    35 BDIF2 Valuation diff. 2 BDIF2 CURR 23
    36 VBUND Trading Partner RASSC CHAR 6 T880
    37 PSWSL G/L currency PSWSL CUKY 5 TCURC
    38 WVERW Usage WVERW CHAR 1
    39 DMBE2 Amt loc.curr.2 DMBE2 CURR 23
    40 DMBE3 Amt loc. curr.3 DMBE3 CURR 23
    41 MWST2 Tax Amount in Second Local Currency MWST2 CURR 23
    42 MWST3 Tax Amount in Third Local Currency MWST3 CURR 23
    43 BDIF3 Valuation diff. 3 BDIF3 CURR 23
    44 RDIF3 Exchange Rate Difference Realized for Third Local Currency RDIF3 CURR 23
    45 XRAGL Indicator: Clearing Was Reversed XRAGL CHAR 1
    46 PROJK WBS element PS_PSP_PNR NUMC 8 PRPS
    47 PRCTR Profit Center PRCTR CHAR 10
    48 XSTOV Indicator: Document Is Flagged for Reversal XSTOV CHAR 1
    49 XARCH Character Field of Length 1 XARCH CHAR 1
    50 PSWBT General ledger amt PSWBT CURR 23
    51 XNEGP Negative pstng XNEGP CHAR 1
    52 RFZEI Pmnt card item RFZEI_CC NUMC 3
    53 CCBTC Settlement CCBTC CHAR 10
    54 XREF3 Reference key 3 XREF3 CHAR 20
    55 BUPLA Business Place BUPLA CHAR 4 J_1BBRANCH
    56 PPDIFF Realized Exchange Rate Gain/Loss 1.Loc.Curr.(Part Payments) PPDIFF CURR 23
    57 PPDIF2 Realized Exchange Rate Gain/Loss 2.Loc. Curr.(Part Payments) PPDIF2 CURR 23
    58 PPDIF3 Realized Exchange Rate Gain/Loss 3.Loc.Curr.(Part Payments) PPDIF3 CURR 23
    59 BEWAR Transactn Type RMVCT CHAR 3 T856
    60 IMKEY Real Estate Key IMKEY CHAR 8
    61 DABRZ Reference Date DABRBEZ DATS 8
    62 INTRENO Internal Key of Real Estate Object VVINTRENO CHAR 13
    63 GRANT_NBR Grant GM_GRANT_NBR CHAR 20
    64 FKBER Functional Area FKBER CHAR 16
    65 FIPOS Commitment Item FIPOS CHAR 14
    66 FISTL Funds Center FISTL CHAR 16
    67 GEBER Fund BP_GEBER CHAR 10
    68 PPRCT Partner PC PPRCTR CHAR 10
    69 BUZID Line item ID BUZID CHAR 1
    70 AUGGJ Clrg Fiscal Yr AUGGJ NUMC 4
    71 UZAWE Pmt meth.supl. UZAWE CHAR 2
    72 SEGMENT Segment FB_SEGMENT CHAR 10
    73 PSEGMENT Partner Segment FB_PSEGMENT CHAR 10
    74 PGEBER Partner Fund FM_PFUND CHAR 10
    75 PGRANT_NBR Partner Grant GM_GRANT_PARTNER CHAR 20
    76 MEASURE Funded Program FM_MEASURE CHAR 24
    77 BUDGET_PD Budget Period FM_BUDGET_PERIOD CHAR 10
    78 PBUDGET_PD Par. BudPer FM_PBUDGET_PERIOD CHAR 10
    79 FIPEX Commitment Item CHAR 1
    80 _DATAAGING Data Filter Value for Data Aging DATA_TEMPERATURE DATS 8
    81 KIDNO Payment Ref. KIDNO CHAR 30
    82 PRODPER Joint Venture Production Date JVA_PROD_MONTH ACCP 6
    83 QSSKZ Withholding Tax Code QSSKZ CHAR 2
    84 PROPMANO Real Estate Management Mandate REHORECNNRM CHAR 13
    85 GKONT Offsetting acct GKONT CHAR 10
    86 GKART Offst.acct type GKOAR CHAR 1
    87 GHKON GHKONT CHAR 10
    88 LOGSYSTEM_SENDER Logical destination (specified in function call) CHAR 10
    89 BUKRS_SENDER Company Code CHAR 4
    90 BELNR_SENDER Accounting Document Number CHAR 10
    91 GJAHR_SENDER Fiscal Year of Document in Sender System NUMC 4
    92 BUZEI_SENDER Number of Line Item Within Accounting Document NUMC 3