BSAK is a standard Financial Accounting Transparent Table in SAP FI application, which stores Accounting: Secondary Index for Vendors (Cleared Items) data. On this page, you can view the Table Structure, Columns(Fields), links to SAP Documentation, Wiki & Help Pages, Q&A, similar/related TCodes, Tables, FMs, ABAP Reports, BW Datasources, and Authorization Objects for BSAK. You can use the transaction code SE16 to view the data in this table, and SE11 TCode for the table structure and definition.

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

SAP Help, Wiki, Q&A and other resources for BSAK

Click the above link for the full list of resources and help pages, only the first few are posted below

  • Nachlaufprogramm (FI) - SAP Help Portal

     Table of Contents Menu 

    "Das Programm lscht die Sekundrindizes aus den Tabellen BSIS, BSAS, BSAD, BSAK und BSIP. Die Sekundrindexeintrge in der Tabelle BSIM werden nicht vom Nachlaufprogramm gelscht. Stattdessen werden sie vom Lschprogramm direkt zusammen mit den Belegdaten gelscht."

    https://help.sap.com/viewer/a193f2ae056e41b38356402f8e12bb50/6.06.22/de-DE/6c764a5305fcf563e10000000a4450e5.html

  • %FUNC% Nachlaufprogramm (FI) - SAP Help Portal

     Table of Contents Menu 

    "Das Programm lscht die Sekundrindizes aus den Tabellen BSIS, BSAS, BSAD, BSAK und BSIP. Die Sekundrindexeintrge in der Tabelle BSIM werden nicht vom Nachlaufprogramm gelscht. Stattdessen werden sie vom Lschprogramm direkt zusammen mit den Belegdaten gelscht."

    https://help.sap.com/viewer/92fcba4b877842928f841e778cd7aa37/6.06.19/de-DE/8e55d7531a4d424de10000000a174cb4.html

  • %FUNC% Postprocessing Program (FI) - SAP Help Portal

     Table of Contents Menu 

    "The program deletes the secondary indexes from tables BSIS, BSAS, BASAD BSAK and BSIP. The secondary index entries in table BSIM are not deleted by the postprocessing program. Instead they are deleted directly together with the document data by the delete program."

    https://help.sap.com/viewer/92fcba4b877842928f841e778cd7aa37/6.06.20/en-US/8e55d7531a4d424de10000000a174cb4.html

  • Postprocessing Program (FI) - SAP Help Portal

     Table of Contents Menu 

    "The program deletes the secondary indexes from tables BSIS, BSAS, BASAD BSAK and BSIP. The secondary index entries in table BSIM are not deleted by the postprocessing program. Instead they are deleted directly together with the document data by the delete program."

    https://help.sap.com/viewer/92fcba4b877842928f841e778cd7aa37/6.06.20/en-US/6c764a5305fcf563e10000000a4450e5.html

  • Configuration of Accounts Payable and Accounts Receivable | SAP Help Portal

    This datasource extracts Accounts Payable Accounting line items from tables BSIK (open items) and BSAK (cleared items) in the R/3 source system.

    https://help.sap.com/docs/SAP_BUSINESSOBJECTS_FINANCIAL_INFORMATION_MANAGEMENT/42177c639aea4f559027e8a25064bf3b/f9ccc1056faf1014878bae8cb0e91070.html

  • Fields of Origin in the Extraction Structure - Accounts Payable: Line Items | SAP Help Portal

    Thank you. Please enter any additional feedback you would like to leave, then press submit.

    https://help.sap.com/docs/SAP_BUSINESSOBJECTS_FINANCIAL_INFORMATION_MANAGEMENT/42177c639aea4f559027e8a25064bf3b/f9ce2e4e6faf1014878bae8cb0e91070.html

  • TransientProviders - SAP Help Portal

     Table of Contents Menu 

    https://help.sap.com/viewer/44d76b07aa8e45899a2e83923c3d11ba/6.17.18/en-US/9c4cdebb-bad1-48a3-83d4-d6dfbe419d9d.html

  • Placement and Processing of Research Requests - SAP Help Portal

     Table of Contents Menu 

    "This query returns vendor line items (tables BSIK (open items) and BSAK (cleared items)) of subledger accounting. This query is based on operational data provisioning technology."

    https://help.sap.com/viewer/44d76b07aa8e45899a2e83923c3d11ba/6.18.08/en-US/a5b668b3d24a49cabeddbb157a0232e5.html

  • Vendor Line Items - SAP Help Portal

     Table of Contents Menu 

    https://help.sap.com/viewer/44d76b07aa8e45899a2e83923c3d11ba/6.18.08/en-US/2fe299a861d14dd4ad13380d271749e2.html

  • Accounts Payable: Line Items - SAP Help Portal

     Table of Contents Menu 

    "This DataSource extracts Accounts Payable Accounting line items from tables BSIK (open items) and BSAK (cleared items) in the R/3 source system."

    https://help.sap.com/viewer/8283ab99b2f540c18afbe5cbb34501e3/7.57.14/en-US/53c88953d7363d58e10000000a174cb4.html

  • View the full list of resources, SAP Help/Wiki pages and Q&A for BSAK


Related Tables

TABLE Description Functional Area
BSIK Accounting: Secondary Index for Vendors FI - Financial Accounting
BSEG Accounting Document Segment FI - Financial Accounting
BKPF Accounting Document Header FI - Financial Accounting
BSAD Accounting: Secondary Index for Customers (Cleared Items) FI - Financial Accounting
BSIS Accounting: Secondary Index for G/L Accounts FI - Financial Accounting

Transaction Codes for SAP Table BSAK

TCODE Description Functional Area
FBL1N Vendor Line Items FI - Information System
SE11 ABAP Dictionary Maintenance Basis - Dictionary Maintenance
MIRO Enter Incoming Invoice MM - Invoice Verification
SE16 Data Browser Basis - Workbench Utilities
FBL3N G/L Account Line Items FI - Information System
FB03 Display Document FI - Financial Accounting

FMs for SAP Table BSAK

FM Description Functional Area
REUSE_ALV_GRID_DISPLAY Output of a simple list (single-line) Basis - SAP List Viewer
REUSE_ALV_COMMENTARY_WRITE List body comment block output BC - SAP List Viewer
REUSE_ALV_EVENTS_GET Returns table of possible events for a list type BC - SAP List Viewer
REUSE_ALV_LIST_DISPLAY Output a simple list (single line or several lines) BC - SAP List Viewer
CONVERSION_EXIT_ALPHA_INPUT Conversion exit ALPHA, external->internal Basis - Syntax, Compiler, Runtime
GUI_DOWNLOAD Download an Internal Table to the PC Basis - Graphical User Interface

ABAP Reports for SAP Table BSAK

ABAP REPORT Description Functional Area
BUILD_FIELDCAT Include ZHPM_STOCK_CHECK
BWOM2_TIMEST BWOM2_TIMEST: Time-stamp Maintenance CO - Information System, iViews
RSECADMIN Administration Program for Secure Storage BW - OLAP Technology
SAP_RSADMIN_MAINTAIN RSADMIN Administration BW - OLAP Technology
RSTMPLWIDTP Template f BW - Data Basis
SAPMS38T Runtime Analysis Basis - Runtime Analysis

BW Datasources for SAP Table BSAK

BW DATASOURCE Description Functional Area
0FI_AP_4 Vendors: Line Items with Delta Extrcation FI - Accounts Payable
0FI_GL_4 General Ledger: Line Items with Delta Extraction FI - General Ledger Accounting
0FI_AR_4 Customers: Line Items with Delta Extraction FI - Accounts Receivable
0FI_AP_3 Vendors: Line Items FI - Accounts Payable
0FI_AR_3 Customers: Line Items FI - Accounts Receivable
0FI_AP_6 Vendor Sales Figures via Delta Extraction FI - Accounts Payable

Authorization Objects for SAP Table BSAK

AUTHORIZATION OBJECT Description Functional Area
CMS_CAG Authorization object for CAG
F_BKPF_KOA Accounting Document: Authorization for Account Types
S_RFC Authorization Check for RFC Access
F_BKPF_BUK Accounting Document: Authorization for Company Codes
ECM_VAL Change Management: Validity
ECM_CTXT Engineering Change Management: Context

Most searched SAP Financial Accounting Tables