BSAK — 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 LFB1
    3 LIFNR Vendor LIFNR X CHAR 10 LFA1
    4 UMSKS Transact.type UMSKS X CHAR 1
    5 UMSKZ Special G/L ind UMSKZ X CHAR 1
    6 AUGDT Clearing AUGDT X DATS 8
    7 AUGBL Clrng doc. AUGBL X CHAR 10
    8 ZUONR Assignment DZUONR X CHAR 18
    9 GJAHR Fiscal Year GJAHR X NUMC 4
    10 BELNR Document Number BELNR_D X CHAR 10
    11 BUZEI Posting row BUZEI X NUMC 3
    12 BUDAT Posting Date BUDAT DATS 8
    13 BLDAT Document Date BLDAT DATS 8
    14 CPUDT Entered on CPUDT DATS 8
    15 WAERS Currency WAERS CUKY 5
    16 XBLNR Reference XBLNR1 CHAR 16
    17 BLART Document Type BLART CHAR 2
    18 MONAT Period MONAT NUMC 2
    19 BSCHL Posting key BSCHL CHAR 2
    20 ZUMSK Target Special G/L Indicator DZUMSK CHAR 1
    21 SHKZG Debit/Credit SHKZG CHAR 1
    22 GSBER Business Area GSBER CHAR 4
    23 MWSKZ Tax code MWSKZ CHAR 2
    24 DMBTR Amount in LC DMBTR CURR 23
    25 WRBTR Amount WRBTR CURR 23
    26 MWSTS Tax Amount in Local Currency MWSTS CURR 23
    27 WMWST Tax Amount in Document Currency WMWST CURR 23
    28 BDIFF Valuation diff. BDIFF CURR 23
    29 BDIF2 Valuation diff. 2 BDIF2 CURR 23
    30 SGTXT Name SGTXT CHAR 50
    31 PROJN Old: Project number : No longer used --> PS_POSNR PROJN CHAR 16
    32 AUFNR Order AUFNR CHAR 12
    33 ANLN1 Asset ANLN1 CHAR 12
    34 ANLN2 Asset Subnumber ANLN2 CHAR 4
    35 EBELN Purchasing Doc. EBELN CHAR 10
    36 EBELP ARIBA item number EBELP NUMC 5
    37 SAKNR G/L Account SAKNR CHAR 10
    38 HKONT G/L HKONT CHAR 10
    39 FKONT Financial Budget Item FIPLS NUMC 3
    40 FILKD Branch FILKD CHAR 10
    41 ZFBDT Baseline date DZFBDT DATS 8
    42 ZTERM Payt terms DZTERM CHAR 4
    43 ZBD1T Days DZBD1T DEC 3
    44 ZBD2T Days DZBD2T DEC 3
    45 ZBD3T Days net DZBD3T DEC 3
    46 ZBD1P Cash discount 1 DZBD1P DEC 5
    47 ZBD2P Cash discount 2 DZBD2P DEC 5
    48 SKFBT Disc. base SKFBT CURR 23
    49 SKNTO Discount amt SKNTO CURR 23
    50 WSKTO Disc. amount WSKTO CURR 23
    51 ZLSCH Pymt method DZLSCH CHAR 1
    52 ZLSPR Pmnt block DZLSPR CHAR 1
    53 ZBFIX Fixed DZBFIX CHAR 1
    54 HBKID Short key for a house bank HBKID CHAR 5
    55 BVTYP Partner bank type BVTYP CHAR 4
    56 REBZG Invoice ref. REBZG CHAR 10
    57 REBZJ Fiscal year REBZJ NUMC 4
    58 REBZZ Line item REBZZ NUMC 3
    59 SAMNR Collect.inv. SAMNR NUMC 8
    60 ZOLLT Customs Tariff Number DZOLLT CHAR 8
    61 ZOLLD Customs Date DZOLLD DATS 8
    62 LZBKZ State central bank indicator LZBKZ CHAR 3
    63 LANDL Supplying Country LANDL CHAR 3
    64 DIEKZ Service indicator (foreign payment) DIEKZ CHAR 1
    65 MANSP Dunn. block MANSP CHAR 1
    66 MSCHL Dunning key MSCHL CHAR 1
    67 MADAT Last dunned MADAT DATS 8
    68 MANST Dunning level MAHNS_D NUMC 1
    69 MABER Dunning Area MABER CHAR 2
    70 XNETB Indicator: Document Posted Net ? XNETB CHAR 1
    71 XANET Indicator: Down payment in net procedure ? XANET CHAR 1
    72 XCPDD Indicator: Address and Bank Data Set Individually XCPDD CHAR 1
    73 XESRD Indicator: Must POR Subscriber Number Be Set? XESRD CHAR 1
    74 XZAHL Pymt tran. XZAHL CHAR 1
    75 MWSK1 Tax Code for Distribution MWSKX CHAR 2
    76 DMBT1 Amount in Local Currency for Tax Distribution DMBTX CURR 23
    77 WRBT1 Amount in Foreign Currency for Tax Breakdown WRBTX CURR 23
    78 MWSK2 Tax Code for Distribution MWSKX CHAR 2
    79 DMBT2 Amount in Local Currency for Tax Distribution DMBTX CURR 23
    80 WRBT2 Amount in Foreign Currency for Tax Breakdown WRBTX CURR 23
    81 MWSK3 Tax Code for Distribution MWSKX CHAR 2
    82 DMBT3 Amount in Local Currency for Tax Distribution DMBTX CURR 23
    83 WRBT3 Amount in Foreign Currency for Tax Breakdown WRBTX CURR 23
    84 QSSKZ Withholding Tax Code QSSKZ CHAR 2
    85 QSSHB W/tax base amount QSSHB CURR 23
    86 QBSHB Wit./tax amount QBSHB CURR 23
    87 BSTAT Doc.status BSTAT_D CHAR 1
    88 ANFBN Document Number of the Bill of Exchange Payment Request ANFBN CHAR 10
    89 ANFBJ Fiscal Year of the Bill of Exchange Payment Request Document ANFBJ NUMC 4
    90 ANFBU Company Code in Which Bill of Exch.Payment Request Is Posted ANFBU CHAR 4
    91 VBUND Trading Partner RASSC CHAR 6
    92 REBZT Following Document Type REBZT CHAR 1
    93 STCEG VAT registration number STCEG CHAR 20
    94 EGBLD Country of Destination for Delivery of Goods EGBLD CHAR 3
    95 EGLLD Supplying Country for Delivery of Goods EGLLD CHAR 3
    96 QSZNR Certificate Number of Withholding Tax Exemption QSZNR CHAR 10
    97 QSFBT W/tax exempt amt QSFBT CURR 23
    98 XINVE Indicator: Capital Goods Affected? XINVE CHAR 1
    99 PROJK WBS element PS_PSP_PNR NUMC 8
    100 FIPOS Commitment Item FIPOS CHAR 14
    101 NPLNR Network Number for Account Assignment NPLNR CHAR 12
    102 AUFPL Routing number of operations in the order CO_AUFPL NUMC 10
    103 APLZL General counter for order CIM_COUNT NUMC 8
    104 XEGDR Indicator: Triangular deal within the EU ? XEGDR CHAR 1
    105 DMBE2 Amt loc.curr.2 DMBE2 CURR 23
    106 DMBE3 Amt loc. curr.3 DMBE3 CURR 23
    107 DMB21 Amount in Second Local Currency for Tax Breakdown DMB2X CURR 23
    108 DMB22 Amount in Second Local Currency for Tax Breakdown DMB2X CURR 23
    109 DMB23 Amount in Second Local Currency for Tax Breakdown DMB2X CURR 23
    110 DMB31 Amount in Third Local Currency for Tax Breakdown DMB3X CURR 23
    111 DMB32 Amount in Third Local Currency for Tax Breakdown DMB3X CURR 23
    112 DMB33 Amount in Third Local Currency for Tax Breakdown DMB3X CURR 23
    113 MWST2 Tax Amount in Second Local Currency MWST2 CURR 23
    114 MWST3 Tax Amount in Third Local Currency MWST3 CURR 23
    115 SKNT2 Cash Discount Amount in Second Local Currency SKNT2 CURR 23
    116 SKNT3 Cash Discount Amount in Third Local Currency SKNT3 CURR 23
    117 BDIF3 Valuation diff. 3 BDIF3 CURR 23
    118 XRAGL Indicator: Clearing Was Reversed XRAGL CHAR 1
    119 RSTGR Reason code RSTGR CHAR 3
    120 UZAWE Pmt meth.supl. UZAWE CHAR 2 T042F
    121 KOSTL Cost Center KOSTL CHAR 10
    122 LNRAN Sequence number of asset line items in fiscal year LNRAN NUMC 5 ANEK
    123 XSTOV Indicator: Document Is Flagged for Reversal XSTOV CHAR 1
    124 KZBTR Original Reduction Amount in Local Currency KZBTR_FI CURR 23
    125 XREF1 Reference key 1 XREF1 CHAR 12
    126 XREF2 Reference key 2 XREF2 CHAR 12
    127 XARCH Character Field of Length 1 XARCH CHAR 1
    128 PSWSL G/L currency PSWSL CUKY 5 TCURC
    129 PSWBT General ledger amt PSWBT CURR 23
    130 IMKEY Real Estate Key IMKEY CHAR 8
    131 ZEKKN Sequential Number of Account Assignment DZEKKN NUMC 2
    132 FISTL Funds Center FISTL CHAR 16
    133 GEBER Fund BP_GEBER CHAR 10
    134 DABRZ Reference Date DABRBEZ DATS 8
    135 XNEGP Negative pstng XNEGP CHAR 1
    136 EMPFB Payee/Payer EMPFB CHAR 10
    137 PRCTR Profit Center PRCTR CHAR 10
    138 XREF3 Reference key 3 XREF3 CHAR 20
    139 DTWS1 Instruct.key 1 DTAT16 NUMC 2
    140 DTWS2 Instruct. key 2 DTAT17 NUMC 2
    141 DTWS3 Instruct. key 3 DTAT18 NUMC 2
    142 DTWS4 Instruct. key 4 DTAT19 NUMC 2
    143 XPYPR Payment sent XPYPR CHAR 1
    144 KIDNO Payment Ref. KIDNO CHAR 30
    145 PYCUR Payment cur. PYCUR CUKY 5
    146 PYAMT Amt in pyt cur. PYAMT CURR 23
    147 BUPLA Business Place BUPLA CHAR 4
    148 SECCO Section Code SECCO CHAR 4
    149 PPDIFF Realized Exchange Rate Gain/Loss 1.Loc.Curr.(Part Payments) PPDIFF CURR 23
    150 PPDIF2 Realized Exchange Rate Gain/Loss 2.Loc. Curr.(Part Payments) PPDIF2 CURR 23
    151 PPDIF3 Realized Exchange Rate Gain/Loss 3.Loc.Curr.(Part Payments) PPDIF3 CURR 23
    152 PENLC1 Penalty Charge Amount in First Local Currency PENALTY1 CURR 23
    153 PENLC2 Penalty Charge Amount in Second Local Currency PENALTY2 CURR 23
    154 PENLC3 Penalty Charge Amount in Third Local Currency PENALTY3 CURR 23
    155 PENFC Penalty Charge Amount in Document Currency PENALTY CURR 23
    156 PENDAYS Number of Days for Penalty Charge Calculation PDAYS INT4 10
    157 PENRC Reason for Late Payment PENRC CHAR 2
    158 VERTT Contract Type RANTYP CHAR 1
    159 VERTN Contract Number RANL CHAR 13
    160 VBEWA Flow Type SBEWART CHAR 4
    161 KBLNR Document number for earmarked funds KBLNR_FI CHAR 10
    162 KBLPOS Earmarked Funds: Document Item KBLPOS NUMC 3
    163 GRANT_NBR Grant GM_GRANT_NBR CHAR 20
    164 GMVKZ Item is in Execution FM_GMVKZ CHAR 1
    165 SRTYPE Type of Additional Receivable FM_SRTYPE CHAR 2
    166 LOTKZ Lot Number for Documents PSO_LOTKZ CHAR 10
    167 ZINKZ Exempted from Interest Calculation DZINKZ CHAR 2
    168 FKBER Functional Area FKBER CHAR 16
    169 INTRENO Internal Key of Real Estate Object VVINTRENO CHAR 13
    170 PPRCT Partner PC PPRCTR CHAR 10
    171 BUZID Line item ID BUZID CHAR 1
    172 AUGGJ Clrg Fiscal Yr AUGGJ NUMC 4
    173 HKTID ID for Account Details HKTID CHAR 5
    174 BUDGET_PD Budget Period FM_BUDGET_PERIOD CHAR 10
    175 _DATAAGING Data Filter Value for Data Aging DATA_TEMPERATURE DATS 8
    176 KONTT Account Assignment Category for Industry Solution CHAR 2
    177 KONTL Acct Assignment String for Industry-Specific Acct Assignmnts CHAR 50
    178 UEBGDAT DATS Field Type DATS 8
    179 VNAME Joint venture JV_NAME CHAR 6 T8JV
    180 EGRUP Equity Group JV_EGROUP CHAR 3 T8JF
    181 BTYPE Billing Category JV_BILIND CHAR 2 T8JA
    182 PROPMANO Real Estate Management Mandate REHORECNNRM CHAR 13
    183 GKONT Offsetting acct GKONT CHAR 10
    184 GKART Offst.acct type GKOAR CHAR 1
    185 GHKON GHKONT CHAR 10