SAP /1BCDWB/IQ000000000001 Table in S/4 HANA - Query SKA1SKB1/SYSTQV000002(100)
/1BCDWB/IQ000000000001 is a standard SAP Table which is used to store Query SKA1SKB1/SYSTQV000002(100) data and is available within SAP S/4 HANA systems and previous ECC R/3 systems. Below is the technical details and the field list relevant for an SAP S/4 HANA system, see here for details and fields available within the SAP R/3 version of the /1BCDWB/IQ000000000001 table(ECC)
Delivery Class:
Display/Maintenance via SM30: Display/Maintenance Allowed but with Restrictions
Enhancement category: Not classified
Dictionary Type: Structure
Database Table: /1BCDWB/IQ000000000001
/1BCDWB/IQ000000000001 table structure field list
Below is the full /1BCDWB/IQ000000000001 field list that makes up the SAP database table structure, including key fields, description, data type and other technical details of each field
| Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP | SHLP Field |
| BUKRS | Company Code | BUKRS | CHAR | 4(0) | T001 | BUKRS | BUK | C_T001 | BUKRS | |
| SAKNR | G/L Account Number | SAKNR | CHAR | 10(0) | SKA1 | ALPHA | SAKNR | SAK | C_SAKNR | SAKNR |
| BEGRU | Authorization Group | BRGRU | CHAR | 4(0) | BRGRU | |||||
| BUSAB | Accounting Clerk Abbreviation | BUSAB | CHAR | 2(0) | T001S | BUSAB | ||||
| DATLZ | Date of Last Interest Calculation Run | DATLZ | DATS | 8(0) | DATUM | |||||
| ERDAT | Date on which the Record Was Created | ERDAT_RF | DATS | 8(0) | DATUM | |||||
| ERNAM | Name of Person who Created the Object | ERNAM_RF | CHAR | 12(0) | USNAM | |||||
| FDGRV | Planning Group | FDGRV | CHAR | 10(0) | T035 | ALPHA | FDGRP | |||
| FDLEV | Planning Level | FDLEV | CHAR | 2(0) | T036 | FDLEV | FFE | |||
| FIPLS | Financial Budget Item | FIPLS | NUMC | 3(0) | FIPLS | |||||
| FSTAG | Field status group | FSTAG | CHAR | 4(0) | T004F | FSTAG | ||||
| HBKID | Short key for a house bank | HBKID | CHAR | 5(0) | T012 | HBKID | ||||
| HKTID | ID for account details | HKTID | CHAR | 5(0) | T012K | HKTID | ||||
| KDFSL | Key for Exchange Rate Differences in Foreign Currency Accts | KDFSL | CHAR | 4(0) | T030S | KDFSL | ||||
| MITKZ | Account is Reconciliation Account | MITKZ | CHAR | 1(0) | MITKZ | |||||
| MWSKZ | Tax Category in Account Master Record | SMWSK | CHAR | 2(0) | SMWSK | |||||
| STEXT | G/L Account Additional Text | STEXT_SKB1 | CHAR | 50(0) | TEXT50 | |||||
| VZSKZ | Interest calculation indicator | VZSKZ | CHAR | 2(0) | T056 | VZSKZ | ||||
| WAERS | Account currency | WAERS_SKB1 | CUKY | 5(0) | TCURC | WAERS | FWS | |||
| WMETH | Indicator: Account Managed in External System | WMETH | CHAR | 2(0) | WMETH | |||||
| XGKON | Cash Receipt Account / Cash Disbursement Account | XGKON | CHAR | 1(0) | XFELD | |||||
| XINTB | Indicator: Is Account only Posted to Automatically? | XINTB | CHAR | 1(0) | XFELD | |||||
| XKRES | Indicator: Can Line Items Be Displayed by Account? | XKRES | CHAR | 1(0) | XFELD | |||||
| XLOEB | Indicator: Account Marked for Deletion? | XLOEV | CHAR | 1(0) | XFELD | |||||
| XNKON | Indicator: Supplement for Automatic Postings ? | XNKON | CHAR | 1(0) | XFELD | |||||
| XOPVW | Indicator: Open Item Management? | XOPVW | CHAR | 1(0) | XFELD | |||||
| XSPEB | Indicator: Is Account Blocked for Posting? | XSPEB | CHAR | 1(0) | XFELD | |||||
| ZINDT | Key Date of Last Interest Calculation | DZINDT | DATS | 8(0) | DATUM | |||||
| ZINRT | Interest Calculation Frequency in Months | DZINRT | NUMC | 2(0) | ZINRT | |||||
| ZUAWA | Key for sorting according to assignment numbers | DZUAWA | CHAR | 3(0) | TZUN | ZUAWA | ||||
| ALTKT | Alternative Account Number in Company Code | ALTKT_SKB1 | CHAR | 10(0) | ALPHA | SAKNR | ||||
| XMITK | Indicator: Reconcil.Acct Ready for Input at Time of Posting? | XMITK | CHAR | 1(0) | XFELD | |||||
| RECID | Recovery Indicator | JV_RECIND | CHAR | 2(0) | T8JJ | ALPHA | JV_RECIND | |||
| FIPOS | Commitment Item | FIPOS | CHAR | 14(0) | FMCIS | FIPOS | FIP | |||
| XMWNO | Indicator: Tax code is not a required field | XMWNO | CHAR | 1(0) | XFELD | |||||
| XSALH | Manage Balances in Local Currency Only (Indicator) | XSALH | CHAR | 1(0) | XFELD | |||||
| BEWGP | Valuation Group | BEWGP | CHAR | 10(0) | CHAR10 | |||||
| INFKY | Inflation Key | J_1AIFSKS | CHAR | 8(0) | J_1AINFSKS | J_1AIFSKS | ||||
| TOGRU | Tolerance Group for G/L Accounts | TOGRU_S | CHAR | 4(0) | T043S | TOGRU | ||||
| XLGCLR | Clearing Specific to Ledger Groups | XLGCLR | CHAR | 1(0) | XFELD | |||||
| MCAKEY | MCA Key | GLE_DTE_MCA_MCAKEY | CHAR | 5(0) | GLE_MCA_TMCAKEY | GLE_MCA_MCAKEY | ||||
| COCHANGED | Controlling area data changed | FINS_SKB1_COCHANGED | CHAR | 1(0) | CHAR1 | |||||
| LAST_CHANGED_TS | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | TIMESTAMP | DEC | 15(0) | TZNTSTMPS | |||||
| KTOPL | Chart of Accounts | KTOPL | CHAR | 4(0) | T004 | KTOPL | KPL | C_KTOPL | KTOPL | |
| SAKNR001 | G/L Account Number | SAKNR | CHAR | 10(0) | ALPHA | SAKNR | SAK | C_SAKNR | SAKNR | |
| XBILK | Indicator: Account is a balance sheet account? | XBILK | CHAR | 1(0) | XFELD | |||||
| SAKAN | G/L Account Number, Significant Length | SAKAN | CHAR | 10(0) | CHAR10 | |||||
| BILKT | Group Account Number | BILKT | CHAR | 10(0) | SKA1 | ALPHA | SAKNR | |||
| ERDAT001 | Date on which the Record Was Created | ERDAT_RF | DATS | 8(0) | DATUM | |||||
| ERNAM001 | Name of Person who Created the Object | ERNAM_RF | CHAR | 12(0) | USNAM | |||||
| GVTYP | P&L statement account type | GVTYP | CHAR | 2(0) | CHAR2 | |||||
| KTOKS | G/L Account Group | KTOKS | CHAR | 4(0) | T077S | KTOKS | ||||
| MUSTR | Number of the Sample Account | MUSTR | CHAR | 10(0) | SKM1 | ALPHA | MUSTR | MST | ||
| VBUND | Company ID of Trading Partner | RASSC | CHAR | 6(0) | T880 | ALPHA | RCOMP | PGS | ||
| XLOEV | Indicator: Account Marked for Deletion? | XLOEV | CHAR | 1(0) | XFELD | |||||
| XSPEA | Indicator: Account Is Blocked for Creation ? | XSPEA | CHAR | 1(0) | XFELD | |||||
| XSPEB001 | Indicator: Is Account Blocked for Posting? | XSPEB | CHAR | 1(0) | XFELD | |||||
| XSPEP | Indicator: Account Blocked for Planning ? | XSPEP | CHAR | 1(0) | XFELD | |||||
| MCOD1 | Search Term for Using Matchcode | MCODF | CHAR | 25(0) | CHAR25 | |||||
| FUNC_AREA | Functional Area | FKBER | CHAR | 16(0) | TFKB | FKBER | FBE | |||
| GLACCOUNT_TYPE | Type of a General Ledger Account | GLACCOUNT_TYPE | CHAR | 1(0) | GLACCOUNT_TYPE | |||||
| GLACCOUNT_SUBTYPE | Subtype of a GL Account | GLACCOUNT_SUBTYPE | CHAR | 1(0) | GLACCOUNT_SUBTYPE | |||||
| SPECNAME00000001 | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | TIMESTAMP | DEC | 15(0) | TZNTSTMPS | |||||
| SPRAS | Language Key | SPRAS | LANG | 1(0) | T002 | ISOLA | SPRAS | SPR | H_T002 | SPRAS |
| KTOPL001 | Chart of Accounts | KTOPL | CHAR | 4(0) | T004 | KTOPL | KPL | C_KTOPL | KTOPL | |
| SAKNR002 | G/L Account Number | SAKNR | CHAR | 10(0) | SKA1 | ALPHA | SAKNR | SAK | C_SAKNR | SAKNR |
| TXT20 | G/L account short text | TXT20_SKAT | CHAR | 20(0) | TEXT20 | |||||
| TXT50 | G/L Account Long Text | TXT50_SKAT | CHAR | 50(0) | TEXT50 | |||||
| MCOD1001 | Search Term for Matchcode Search | MCDS1 | CHAR | 25(0) | CHAR25 | |||||
| SPECNAME00000002 | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | TIMESTAMP | DEC | 15(0) | TZNTSTMPS |
Search for further information about these or an SAP related objects