KOKS SAP (Historical balance audit trail: Subledger accts master rec.) Structure details

Dictionary Type: Structure
Description: Historical balance audit trail: Subledger accts master rec.




ABAP Code to SELECT data from KOKS
Related tables to KOKS
Access table KOKS




Structure field list including key, data, relationships and ABAP select examples

KOKS is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Historical balance audit trail: Subledger accts master rec." Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_KOKS TYPE KOKS.

The KOKS table consists of various fields, each holding specific information or linking keys about Historical balance audit trail: Subledger accts master rec. data available in SAP. These include KOART (Account Type), BUKRS (Company Code), KONTO (Customer Numbers), EMPFG (Payee code).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified


SAP KOKS structure fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3Assigned to domainMANDT
KOARTAccount Type KOARTCHAR1KOART
BUKRSCompany Code BUKRSCHAR4Assigned to domainBUKRSBUKC_T001
KONTOCustomer Numbers KUNNRCHAR10Assigned to domainALPHAKUNNRKUNC_KUNNR
EMPFGPayee code EMPFGCHAR16EMPFG
SAARTRecord Type for Accumulated Balance Audit Trail SAARTCHAR1CHAR1
ALTKZFull audit trail:ID:Altern.acct no. filled with credit acct ALTKZCHAR1XFELD
ALTKTAccount Number in Group ALTKTCHAR10ALPHAALTKT
ANREDTitle ANREDCHAR15TEXT15
NAME1Name NAME1CHAR30TEXT30
NAME2Name 2 NAME2CHAR30TEXT30
PSTLZPostal Code PSTLZCHAR10PSTLZ
ORT01City ORT01CHAR25TEXT25
LAND1Country Key LAND1CHAR3Assigned to domainLAND1LND
STRASHouse number and street STRASCHAR30TEXT30
PFACHPO Box PFACHCHAR10PFACH
PSTL2P.O. Box Postal Code PSTL2CHAR10PSTLZ
ORT02District ORT02CHAR25TEXT25
REGIOSTATE (State, Province, County) REGIOCHAR3Assigned to domainREGIO
COUNCCounty Code COUNCCHAR3Assigned to domainCOUNC
CITYCCity Code CITYCCHAR4Assigned to domainCITYC
XCPDKIndicator: Is the account a one-time account? XCPDKCHAR1XFELD
XZEMPIndicator: Alternative payee in document allowed ? XZEMPCHAR1XFELD
BLNKZSubsidy indicator for determining the reduction rates BLNKZCHAR2Assigned to domainBLNKZ
KTOKSG/L Account Group KTOKSCHAR4Assigned to domainKTOKS
KTOKKVendor account group KTOKKCHAR4Assigned to domainKTOKKKGK
KTOKDCustomer Account Group KTOKDCHAR4Assigned to domainKTOKDKGD
BANKNBank account number BANKNCHAR18BANKN
BANKLBank Keys BANKKCHAR15BANKKBNK
BANKSBank country key BANKSCHAR3Assigned to domainLAND1BKL
BANKAName of bank BANKACHAR60TEXT60
PSKTOAccount Number of Bank Account At Post Office PSKTOCHAR16PSKTO
BKONTBank Control Key BKONTCHAR2BKONT
BANKPCheck Digit for Bank No./Account BANKPCHAR2BANKP
SWIFTSWIFT/BIC for International Payments SWIFTCHAR11SWIFT
KNRZAAccount number of an alternative payer KNRZACHAR10Assigned to domainALPHAKUNNR
BRSCHIndustry key BRSCHCHAR4Assigned to domainBRSCH
KONZSGroup key KONZSCHAR10KONZS
KDNREHead office account number (in branch accounts) KNRZECHAR10Assigned to domainALPHAKUNNR
TELF1First telephone number TELF1CHAR16TEXT16
TELX1Telex number TELX1CHAR30TEXT30
TELFXFax Number TELFXCHAR31TEXT31
TELTXTeletex number TELTXCHAR30TEXT30
DATLTData communication line no. DATLTCHAR14TEXT14
TELBXTelebox number TELBXCHAR15TEXT15
SORTLSort field SORTLCHAR10CHAR10
WAERSCurrency Key WAERSCUKY5Assigned to domainWAERSFWS
SPRASLanguage Key SPRASLANG1Assigned to domainISOLASPRASSPRH_T002
LIFNRAccount Number of Vendor or Creditor LIFNRCHAR10Assigned to domainALPHALIFNRLIFKRED_C
KUNNRCustomer Numbers KUNNRCHAR10Assigned to domainALPHAKUNNRKUNC_KUNNR
KLIMGCredit limit: Total limit across all control areas KLIMGCURR15(2) WERT8
BBBNRInternational location number (part 1) BBBNRNUMC7NUM07
BBSNRInternational location number (Part 2) BBSNRNUMC5NUM05
BUBKZCheck digit for the international location number BUBKZNUMC1NUM01
STCD1Tax Number 1 STCD1CHAR16STCD1
STCD2Tax Number 2 STCD2CHAR11STCD2
FISKNAccount number of the master record with the fiscal address FISKN_DCHAR10Assigned to domainALPHAKUNNR
STKZULiable for VAT STKZUCHAR1XFELD
STKZAIndicator: Business Partner Subject to Equalization Tax? STKZACHAR1STKZA
ESRNRISR Subscriber Number ESRNRCHAR11ESRNR
AKONTReconciliation Account in General Ledger AKONTCHAR10Assigned to domainALPHASAKNR
BEGRUAuthorization Group BEGRUCHAR4BEGRU
EIKTOShipper's (Our) Account Number at the Customer or Vendor EIKTOCHAR12CHAR12
ERNAMName of Person who Created the Object ERNAMCHAR12USNAM
ZUAWAKey for sorting according to assignment numbers DZUAWACHAR3Assigned to domainZUAWA
ZWELSList of the Payment Methods to be Considered DZWELSCHAR10ZWELS
ZAMIMIndicator: Payment notice to customer (with cleared items)? DZAMIMCHAR1XFELD
ZTERMTerms of Payment Key DZTERMCHAR4ZTERM
ZAHLSBlock Key for Payment DZAHLSCHAR1Assigned to domainZAHLS
MAHNSDunning level MAHNS_DNUMC1MAHNS
KLIMKCustomer's credit limit KLIMKCURR15(2) WERT8
VZSKZInterest calculation indicator VZSKZCHAR2Assigned to domainVZSKZ
ZINDTKey date of the last interest calculation DZINDTDATS8DATUM
ZINRTInterest calculation frequency in months DZINRTNUMC2ZINRT
DATLZDate of the last interest calculation run DATLZDATS8DATUM
VBUNDCompany ID of trading partner RASSCCHAR6Assigned to domainALPHARCOMPPGS
BUSABAccounting clerk BUSABCHAR2Assigned to domainBUSAB
KNRZEHead office account number (in branch accounts) KNRZECHAR10Assigned to domainALPHAKUNNR
PERRNPeriod Indicator PERKZCHAR1PERKZPKZ
WAKONTerms of payment key for bill of exchange charges WAKONCHAR4ZTERM
MSCHLDunning key MSCHLCHAR1Assigned to domainMSCHL
WEBTRBill of exchange limit (in local currency) WEBTRCURR13(2) WERT7
REMITNext payee REMITCHAR10Assigned to domainALPHAKUNNR
FDGRVPlanning group FDGRVCHAR10Assigned to domainALPHAFDGRP
QSZNRCertificate Number of the Withholding Tax Exemption QSZNRCHAR10CHAR10
QSZDTValidity Date for Withholding Tax Exemption Certificate QSZDTDATS8DATUM
VRSNRInsurance number VRSNRCHAR10CHAR10
REPRFCheck Flag for Double Invoices or Credit Memos REPRFCHAR1XFELD
DTAWSInstruction key for data medium exchange DTAWSCHAR2Assigned to domainDTAWS
DTAMSIndicator for Data Medium Exchange DTAMSCHAR1DTAMS

Key field Non-key field



How do I retrieve data from SAP structure KOKS using ABAP code?

As KOKS is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on KOKS as there is no data to select.

How to access SAP table KOKS

Within an ECC or HANA version of SAP you can also view further information about KOKS and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!