1. Home
  2. Resources
  3. SAP Tables
  4. SKOP - Historical Balance Audit Trail G/L Account Items

SAP Table SKOP

Historical Balance Audit Trail G/L Account Items

SKOP (Historical Balance Audit Trail G/L Account Items) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link SKOP to other SAP tables.

SKOP table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT CLNT 3 0
KOART Account Type KOART CHAR 1 0
A Assets
D Customers
K Vendors
M Material
S G/L accounts
BUKRS Company Code BUKRS CHAR 4 0
KONTO G/L Account Number SAKNR CHAR 10 0
GJAHR Fiscal Year GJAHR NUMC 4 0
GSBER Business Area GSBER CHAR 4 0
SAART Record Type for Accumulated Balance Audit Trail SAART CHAR 1 0
UMSKS Special G/L Transaction Type UMSKS CHAR 1 0
UMSAT Special G/L Indicator UMSKZ CHAR 1 0
BUPER Posting period in the form YYYYMM BUPER ACCP 6 0
BUDAT Posting Date in the Document BUDAT DATS 8 0
BELNR Accounting Document Number BELNR_D CHAR 10 0
BUZEI Number of Line Item Within Accounting Document BUZEI NUMC 3 0
ALTKZ Full audit trail:ID:Altern.acct no. filled with credit acct ALTKZ CHAR 1 0
X Yes
NULL No
ALTKT Account Number in Group ALTKT CHAR 10 0
BLART Document Type BLART CHAR 2 0
BLDAT Document Date in Document BLDAT DATS 8 0
UMSKZ Special G/L Indicator UMSKZ CHAR 1 0
WAERS Currency Key WAERS CUKY 5 0
XBLNR Reference Document Number XBLNR1 CHAR 16 0
CPUDT Day On Which Accounting Document Was Entered CPUDT DATS 8 0
USNAM User name USNAM CHAR 12 0
STAKZ Indicator. object is statistical STAKZ CHAR 1 0
DBBLG Recurring Entry Document Number DBBLG CHAR 10 0
BKTXT Document Header Text BKTXT CHAR 25 0
XKRES Indicator: Can Line Items Be Displayed by Account? XKRES CHAR 1 0
X Yes
NULL No
XOPVW Indicator: Open item management? XOPVW CHAR 1 0
X Yes
NULL No
BSCHL Posting Key BSCHL CHAR 2 0
SHKZG Debit/Credit Indicator SHKZG CHAR 1 0
H Credit
S Debit
BUZID Identification of the Line Item BUZID CHAR 1 0
MWSKZ Tax on sales/purchases code MWSKZ CHAR 2 0
FIPLS Financial Budget Item FIPLS NUMC 3 0
DMBTR Amount in Local Currency DMBTR CURR 13 2
DMSOL Debit Amount in Local Currency DMSOL CURR 13 2
DMHAB Credit Amount in Local Currency DMHAB CURR 13 2
DMSHB Amount in Local Currency with +/- Signs DMSHB CURR 13 2
GSBE1 Business Area GSBER CHAR 4 0
WRBTR Amount in document currency WRBTR CURR 13 2
WRSOL Debit Amount in Document Currency WRSOL CURR 13 2
WRHAB Credit Amount in Document Currency WRHAB CURR 13 2
WRSHB Foreign Currency Amount with Signs (+/-) WRSHB CURR 13 2
WSKTO Cash discount amount in document currency WSKTO CURR 13 2
WMWST Tax amount in document currency WMWST CURR 13 2
MWSHB Tax on Sales/Purchases Amount in Foreign Curr. with +/- Sign MWSHB CURR 13 2
ZUONR Assignment Number DZUONR CHAR 18 0
AUGBL Document Number of the Clearing Document AUGBL CHAR 10 0
AUGDT Clearing Date AUGDT DATS 8 0
AUGCP Clearing Entry Date AUGCP DATS 8 0
NETDT Due Date for Net Payment NETDT DATS 8 0
ZFBDT Baseline Date for Due Date Calculation DZFBDT DATS 8 0
SKFBT Amount Eligible for Cash Discount in Document Currency SKFBT CURR 13 2
MWSTS Tax Amount in Local Currency MWSTS CURR 13 2
MDSHB Tax on Sales/Purchases amount in Local Curr. with +/- Sign MDSHB CURR 13 2
HWBAS Tax Base Amount in Local Currency HWBAS CURR 13 2
ZINKZ Exempted from interest calculation DZINKZ CHAR 2 0
A Reasons for block
VALUT Value date VALUT DATS 8 0
FWBAS Tax Base Amount in Document Currency FWBAS CURR 13 2
PERNR Personnel Number PERNR_D NUMC 8 0
ABPER Settlement period ABPER_RF ACCP 6 0
KOSTL Cost Center KOSTL CHAR 10 0
SGTXT Item Text SGTXT CHAR 50 0
AUFNR Order Number AUFNR CHAR 12 0
AUFPS Order item number AUFPS CHAR 2 0
ARTNR Product number ARTNR CHAR 18 0
WERKS Plant WERKS_D CHAR 4 0
MENGE Quantity MENGE_D QUAN 13 3
MEINS Base Unit of Measure MEINS UNIT 3 0
EBELN Purchasing Document Number EBELN CHAR 10 0
EBELP Item Number of Purchasing Document EBELP NUMC 5 0
PROJN Old: Project number : No longer used --> PS_POSNR PROJN CHAR 16 0
PRONR Project Number PRONR CHAR 16 0
GKART Offsetting Account Type GKART CHAR 1 0
GKONT Offsetting Account Number GKONT CHAR 10 0
VBUND Company ID of trading partner RASSC CHAR 6 0
EGMLD Reporting Country for Delivery of Goods within the EU EGMLD_BSEZ CHAR 3 0
STCEG VAT Registration Number STCEG CHAR 20 0
BVORG Number of Cross-Company Code Posting Transaction BVORG CHAR 16 0
XNEGP Indicator: Negative posting XNEGP CHAR 1 0
X Yes
NULL No