SAP table SKOP (Historical Balance Audit Trail G/L Account Items)
SAP table SKOP has 13 primary key fields being MANDT,KOART,BUKRS,KONTO,GJAHR,GSBER,SAART,UMSKS,UMSAT,BUPER,BUDAT,BELNR,BUZEI.
If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.
Field
Description
Data Type
Length
Decimals
Checktable
Data Element
MANDT
Client
CLNT
3
0
MANDT
KOART
Account type
CHAR
1
0
KOART
A
Assets
D
Customers
K
Vendors
M
Material
S
G/L accounts
BUKRS
Company Code
CHAR
4
0
BUKRS
KONTO
G/L Account Number
CHAR
10
0
SAKNR
GJAHR
Fiscal Year
NUMC
4
0
GJAHR
GSBER
Business Area
CHAR
4
0
GSBER
SAART
Record Type for Accumulated Balance Audit Trail
CHAR
1
0
SAART
UMSKS
Special G/L Transaction Type
CHAR
1
0
UMSKS
UMSAT
Special G/L Indicator
CHAR
1
0
UMSKZ
BUPER
Posting period in the form YYYYMM
ACCP
6
0
BUPER
BUDAT
Posting Date in the Document
DATS
8
0
BUDAT
BELNR
Document Number of an Accounting Document
CHAR
10
0
BELNR_D
BUZEI
Number of Line Item Within Accounting Document
NUMC
3
0
BUZEI
ALTKZ
Full Audit Trail:ID: Altern.Acct No. Filled with Credit Acct
CHAR
1
0
ALTKZ
ALTKT
Account Number in Group
CHAR
10
0
ALTKT
BLART
Document Type
CHAR
2
0
BLART
BLDAT
Document Date in Document
DATS
8
0
BLDAT
UMSKZ
Special G/L Indicator
CHAR
1
0
UMSKZ
WAERS
Currency Key
CUKY
5
0
WAERS
XBLNR
Reference Document Number
CHAR
16
0
XBLNR1
CPUDT
Day On Which Accounting Document Was Entered
DATS
8
0
CPUDT
USNAM
User Name
CHAR
12
0
USNAM
STAKZ
Indicator. Object Is Statistical
CHAR
1
0
STAKZ
DBBLG
Recurring Entry Document Number
CHAR
10
0
DBBLG
BKTXT
Document Header Text
CHAR
25
0
BKTXT
XKRES
Indicator: Can Line Items Be Displayed by Account?
CHAR
1
0
XKRES
XOPVW
Indicator: Open Item Management?
CHAR
1
0
XOPVW
BSCHL
Posting Key
CHAR
2
0
BSCHL
SHKZG
Debit/Credit Indicator
CHAR
1
0
SHKZG
H
Credit
S
Debit
BUZID
Identification of the Line Item
CHAR
1
0
BUZID
MWSKZ
Tax on sales/purchases code
CHAR
2
0
MWSKZ
FIPLS
Financial Budget Item
NUMC
3
0
FIPLS
DMBTR
Amount in local currency
CURR
23
2
DMBTR
DMSOL
Debit Amount in Local Currency
CURR
23
2
DMSOL
DMHAB
Credit Amount in Local Currency
CURR
23
2
DMHAB
DMSHB
Amount in Local Currency with +/- Signs
CURR
23
2
DMSHB
GSBE1
Business Area
CHAR
4
0
GSBER
WRBTR
Amount in document currency
CURR
23
2
WRBTR
WRSOL
Debit Amount in Document Currency
CURR
23
2
WRSOL
WRHAB
Credit Amount in Document Currency
CURR
23
2
WRHAB
WRSHB
Foreign Currency Amount with Signs (+/-)
CURR
23
2
WRSHB
WSKTO
Cash Discount Amount in Document Currency
CURR
23
2
WSKTO
WMWST
Tax Amount in Document Currency
CURR
23
2
WMWST
MWSHB
Tax on Sales/Purchases Amount in Foreign Curr. with +/- Sign
CURR
23
2
MWSHB
ZUONR
Assignment number
CHAR
18
0
DZUONR
AUGBL
Document Number of the Clearing Document
CHAR
10
0
AUGBL
AUGDT
Clearing Date
DATS
8
0
AUGDT
AUGCP
Clearing Entry Date
DATS
8
0
AUGCP
NETDT
Net Due Date
DATS
8
0
NETDT
ZFBDT
Baseline Date for Due Date Calculation
DATS
8
0
DZFBDT
SKFBT
Amount Eligible for Cash Discount in Document Currency
CURR
23
2
SKFBT
MWSTS
Tax Amount in Local Currency
CURR
23
2
MWSTS
MDSHB
Tax on Sales/Purchases Amount in Local Curr. with +/- Sign
CURR
23
2
MDSHB
HWBAS
Tax Base Amount in Local Currency
CURR
23
2
HWBAS
ZINKZ
Exempted from Interest Calculation
CHAR
2
0
DZINKZ
VALUT
Value date
DATS
8
0
VALUT
FWBAS
Tax Base Amount in Document Currency
CURR
23
2
FWBAS
PERNR
Personnel Number
NUMC
8
0
PERNR_D
ABPER
Settlement Period
ACCP
6
0
ABPER_RF
KOSTL
Cost Center
CHAR
10
0
KOSTL
SGTXT
Item Text
CHAR
50
0
SGTXT
AUFNR
Order Number
CHAR
12
0
AUFNR
AUFPS
Order item number
CHAR
2
0
AUFPS
ARTNR
Product number
CHAR
40
0
ARTNR
WERKS
Plant
CHAR
4
0
WERKS_D
MENGE
Quantity
QUAN
13
3
MENGE_D
MEINS
Base Unit of Measure
UNIT
3
0
MEINS
EBELN
Purchasing Document Number
CHAR
10
0
EBELN
EBELP
Item Number of Purchasing Document
NUMC
5
0
EBELP
PROJN
Old: Project number : No longer used --> PS_POSNR
CHAR
16
0
PROJN
PRONR
Project Number
CHAR
16
0
PRONR
GKART
Offsetting Account Type
CHAR
1
0
GKART
GKONT
Offsetting Account Number
CHAR
10
0
GKONT
VBUND
Company ID of Trading Partner
CHAR
6
0
RASSC
EGMLD
Reporting Country/Region for Delivery of Goods Within the EU