Skip to main content
insightsoftware Documentation insightsoftware Documentation
{%article.title%}
Published:
Was this article helpful?
0 out of 0 found this helpful

Import/Export Jobs


Table of contents


1 General

In addition to the "classic" import variant via files (txt files, ASCII files) and direct import via an application interface, the third way to transfer data to be imported to IDL Konsis is via special import database tables. This is particularly interesting for interfaces that are realized with the help of the IDL Importer, since this tool specializes in reading data from databases and writing them into databases. If the specifications described in more detail below are adhered to, these database tables can also be written using other tools.

Special notes:

The description is based on the table names, as the standard views are structured in the same way.

But acc. IDL Konsis Standard is only ever read and written via the corresponding VIEWs (table name plus Appendix '01') or (table name plus Appendix '02').

2 Description of Table Completion

2.1 General Structure Description

I000 - JOB ID
Managing the JOB numbers.
I001 - JOB Control
This table is used for information about the delivered data and for controlling the processing.
I003 - Import Protocol
This table is used to store/display import logs.
I005 - Importer Parameter Handover Table
This table is used to store the parameters for the UNLOAD routines via the IDL importer.
I1XX - Application Data
The application-specific data for each JOB ID is provided in the tables (see below).

2.2 Specificity of the Data Type Timestamp

The data type TIMESTAMP is implemented differently in the 3 supported database systems for conformity reasons. The database type TIMESTAMP is used only in DB2. It is stored in ORACLE and MS SQLServer using VARCHAR(26). The format for this is fixed and is 'YYYY-MM-DD-HH24.MI.SS.ff' in ORACLE syntax. It contains six-digit millisecond data, an example of which looks like this: ‘2011-03-01-15.35.32.00000'

The following SQL artifacts must be used to set the current date, for example:

DB2:
"Current timestamp"
ORACLE:
"TO_CHAR(SYSTIMESTAMP, 'YYYY-MM-DD-HH24.MI.SS.ff')"
MS SQL Server:
"(REPLACE(REPLACE((CONVERT(VARCHAR(23), CURRENT_TIMESTAMP, 121) + '000'),':','.'),' ','-'))"

2.3 Table I000 - JOB ID

To load data into the tables, the next JOB ID must be searched. Determining this unique number is the responsibility of the user. It is recommended to use the prepared Table I000 for this purpose. The sequence name "NEXT_JOBID" (I000_Oxide_NAME) and a value to be added (I000_ACT_VAL) must be entered once in this report.

This job ID must be used when writing the data to the other tables (I001 and I1xx).

2.4 Table I001 - JOB Steering

The overview "IE Job Control" (short word IEJBCN or via the action menu from the call application IMPT) shows all jobs contained in the special import tables. Before data can be written to the import table, a new job must be defined directly in the database. Table I001 shows this. The attributes must be documented as follows (the highlighted attributes must be completed):

Attribute Short Description Meaning
I001_JOBID lfd. Number of the job The next Job ID must be entered. Determining this unique number is the responsibility of the user. It is recommended to use the prepared Table I000 for this purpose. The sequence name "NEXT_JOBID" (I000_Oxide_NAME) and a value to be added (I000_ACT_VAL) must be entered once in this report.
I001_USERID USER ID User Id in IDL Konsis, under which this job is to be performed in IDL Konsis.
I001_ENABLED Release (Y/N) Allows you to control the job release for execution. Only if the value is 'Y', it is possible to complete this job.
I001_FOLLOW_JOBID lfd. Number of follow-on jobs Not yet implemented
I001_WITH_DELETE Import with previous delete (Y/N) License plate number whether existing data should be deleted beforehand
I001_START_FROM Earliest import date Time from when the import can be carried out as early as possible. To be entered as TIMESTAMP (date plus time) in accordance with the relevant DBMS.
I001_JOB_START Beginning Start time of the job. TIMESTAMP (date plus time) in accordance with the relevant DBMS.
I001_JOB_END End Job end time. TIMESTAMP (date plus time) in accordance with the relevant DBMS.
I001_JOB_SUCCESS Success status of the job (Y/N) Indicator of success or failure
I001_IEF_PROJID Project ID Job ID. The value 'KON' must be entered here for the import.
I001_IEF_OBJTYP Object Type Object type of the job. The value 'IEO' for the import has to be entered here.
I001_IEF_OBJID Object ID Job data type. The key according to the Import/Export Format Definition (IEFID) must be entered here for the import, e.g. 'ACBAL' for account balances.
I001_MODIFIER Used for the last change
I001_DATETIME Date of last change TIMESTAMP (date plus time) in accordance with the relevant DBMS.
I001_LOCKUSER LOCK user identification
I001_LOCKDATE LOCK time TIMESTAMP (date plus time) in accordance with the relevant DBMS.
I001_JOB_CREATOR Data supplier Text to indicate where the job data comes from, e.g. Importer.
I001_JOB_CREATED Time of data delivery When was the data imported into the import table? To be entered as TIMESTAMP (date plus time) in accordance with the relevant DBMS.
I001_HERKUNFT Data origin Special identification of the data origin to control special checks or implementation routines (e.g. in SAP, to eliminate the leading zeros in account number) in the import. Possible source: empty, 'KONSIS', 'WINKONS', 'SAP', 'VARIAL', 'AXAPTA', 'DCW', 'CONNECTOR' (and 'QUICK RECORDING').
I001_BEMERK1_UC Remark This comment field (as a UNIOCODE field) is available to the supplier, administrator or user to set optional text. For example, information about key fields for company, facts, etc. can be set here.

2.5 Table I005 - Importer Parameter Handover Table

This table is used when the entry "idlimporter.jar" is defined in the external menu call for "unloading from foreign system" (see Import). The attributes are assigned as follows:

Attribute Short Description Meaning
I005_I001_JOBID Job Identifier The generated Job Id must be entered.
I005_A015_PROJID Project ID Constant 'KON'
I005_A015_OBJTYP Object Type MNUITM constant
I005_A015_OBJID Menu ID Menu item of the executed function (e.g. ACBAL for unload account balances)
I005_KTK Group/Sub-Group
I005_GES Company
I005_ABR_MON_JAHR Period
I005_VGL_ABR Off-Period
I005_FAC Fact
I005_EX_FAC Ex-fact
I005_KTP Chart of accounts
I005_CNT Chart of controlling objects
I005_POP Chart of positions
I005_REPID Report ID
I005_IEFID Format ID e.g. #DSCTXT for standard formats
I005_UMS Transfer group
I005_UBR Business unit
I005_SPR Language
I005_VORTRAG_KENNZ License plate with/without carry forward
I005_SPIEGEL Transaction development
I005_DBNAME Database name
I005_A016_USERID User ID User ID of the application user

2.6 Table I1XX - Application Data

The following data sets (object types) are supported for handover by JOB:

Object Type Description Import Table With Previous Delete Target Table
ACBAL Account balances I100 Y K003
ICACBAL IC sub-account balances I101 Y K039
ICKONV IC P+L sub-account balances I101 N K039
CNTSAL Controlling balances I102 Y K041
KST Controlling objects I103 N K063
FATRN Fixed asset transactions I104 Y K042
ICFATRN IC Fixed asset transactions I104 Y K042
COADFN Accounts I105 N K010
POSDFN Positions I106 N K022
POSKTO Position+account assignments I107 Y K023
CAPTRN Capital transactions I108 Y K038
PRVTRN Reserve movements I108 Y K038
DEVTRN Individual development transactions I108 Y K038
CNTCDE Country indicator I109 N K009
CODT Companies I110 N K001
FXCDE Currency code I112 N K006
COADFN Charts of accounts I113 N K013
CNTCNT Controlling object hierarchy assignments I115 N K015
POSKTOP Position+account assignments - periodic I117 J K020
FXRTE Exchange rates I118 N K008
AGB Deadlines for submission I119 N K007
BUDT Business areas I120 N K005
UBRUBR Business unit hierarchy assignments I125 N K015
REPLNDFN Line Description report I127 Y K027
PERATH Period authorization I132 N A032
MNUATH Menu authorization I132 N A032
OBJATH Object authorization I132 N A032
ICFAOBJ IC Fixed Asset Objects I140 N K040
FAOBJ Fixed asset objects per account I140 N K040
GRPMNR Group/sub-group circle I144 N K044
SHRPAR Shareholding transactions I145 Y K045
CNSFNC Consolidation function I147 N K047
CNSVCH Consolidation vouchers I148 N K048
CNSPST Consolidation postings I149 Y K049
PRF Check rules I151 N K051
PRFPOS Check rules/positions I152 N K052
PRFGRP Check rule groups I154 N K054
PRFZUO Exclusion groups/check rules I155 N K055
PRDGRP Products/product groups I159 N K059
PRDMGN Product margins I161 Y K061
ICSTCK Stocks ICs I162 Y K062
VCH Vouchers I167 N K067
PST Postings I168 Y K068

For this purpose, a special import table in the database is defined in IDL Konsis for each database. In addition to the attributes for the data to be imported, this contains a header that contains a job number. This job number is used to identify the data that relates to each job. The attributes are sometimes longer than in the original table to allow for the conversion of external keys into internal keys. In addition to the attributes defined in #DB format, the following are included in the import tables (the highlighted attributes must be completed):

Attribute Short Description Meaning
I1XX_JOBID Number of the job Associated Job Id in I001
I1XX_RECORD_NR Order number lfd. Number of record related to job
I1XX_IMP_ERROR Error importing? (Y/N) Indicator whether this record has been imported
I1XX_MODIFIER Used for the last change
I1XX_DATETIME Date of last modification TIMESTAMP (date plus time) in accordance with the relevant DBMS.
I1XX_LOCKUSER LOCK user identification
I1XX_LOCKDATE LOCK time TIMESTAMP (date plus time) in accordance with the relevant DBMS.

The application-specific data will then follow. (See description of format types #DB in IEFEL)

When writing the data to the import table, the job number of the created job must be used.

3 Import of Data

3.1 IE Job Management Application (IEJBCN)

The actual import can then be started via the object menu via the application "IE Job-Steuerung" (IEJBCN). The start and exit of this process and a processing status are then recorded in the IE Job control.

Import/export format '#DB' is used for import, which is marked with the new format type 'TABLE' in the Import/Export Formats (IEFID) table. In this IEFID definition, the attribute 'Default filename table' contains the name of the import table.

The fields of the respective format are defined in the ALLCFLD application. The fields of the import tables are in ID "#DB" format and can be identified by the same prefix in the ID field. The attributes of the database tables are selected according to the field IDs in IEFLD, where for technical reasons "-" has been replaced by "_". For example, in the ACBAL format, the field for the FCT facts has the ID I100-FCT and accordingly the attribute in the database table I100_FAC is set.

Messages that are loaded into the temporary table and imported are also logged in a database table instead of a file. This error log can be viewed from the new "Import Error Log" overview, which is reached via the object menu of the IE job control. In this protocol, the "Job Step" parameter distinguishes between messages in the data delivery and messages in the import.

An import job can be deleted completely using the "delete" action in the IE Job control. In addition to the job control set, this delete also includes all data records in the associated import table and the associated error log.

The "IE Job-Data Copy" action in the IE Job-Controller allows you to copy the data of the import job. A new job is created. If available, you can select whether you want to copy only the incorrectly marked records or all of them.

3.2 Command Line

In addition to the option described above for managing jobs in the "IE Job Control" application, it is also possible to start jobs on the command line by invoking imports. This is described under: Start of import from command line

4 Description of Import Data Tables

The contents of certain fields must match the "key values" (object ID) and not the "external key" according to. Application KON/OTHOBJ - Other Objects - (Table A019). The relevant object type is saved in the description under "Remarks" for the affected fields.

4.1 I119 - SUBDTE - Income Tax Deadlines

Field Short Description May Be Type Remarks/Format/...
I119-JOBID JOBID M NUMERIC
I119-RECORD-NR RECNO M NUMERIC
I119-IMP-ERROR IMP-ERR K CHAR
I119-CLSDTE-MON-JAHR CLSDTE M PERIOD
I119-FCT FCT M CHAR
I119-CHECK-POINT CHKP K CHAR
I119-CODT CODT CHAR
I119-ABGABE ABGTERM M DATE
I119-WARNFRIST WARNFR K NUMERIC
I119-WARNFRIST-OBJTYP WARNTYPE K CHAR

4.2 I104 - FATRN - Fixed Asset Transactions

Field Short Description May Be Type Remarks/Format/...
I104-JOBID JOBID M NUMERIC
I104-RECORD-NR RECNO M NUMERIC
I104-IMP-ERROR IMP-ERR CHAR
I104-CODT CODT M CHAR
I104-ANL ANL M CHAR
I104-FCT FCT-I M CHAR
I104-CLSDTE-MON-JAHR CLSDTE-I M PERIOD
I104-BEWDAT BEWDAT M DATE
I104-WERT-LW WERT-LW M DECIMAL
I104-SOLL-HAB-KNZ SOLL-HAB K CHAR KON/OTHOBJ Object=S01
I104-UAW UAW K CHAR KON/OTHOBJ Object=UAW
I104-WK-DATEND DATEND K DATE
I104-WK-BETRAG WKURS K DECIMAL
I104-GEGEN-ANL GEGENANL K CHAR
I104-BELEG-GES1 VCH-GES1 K CHAR
I104-BELEG-GES2 VCH-GES2 K CHAR
I104-BELEG-CNSFNC VCH-CNSFNC K CHAR
I104-WERT-KW WERT-KW K DECIMAL
I104-WERT-PW WERT-PW K DECIMAL
I104-BUDT BUDT K CHAR
I104-CODT-AN CODT-AN K CHAR
I104-UAW-PW UAW-PW K CHAR KON/OTHOBJ Object=UAP
I104-WK-DATEND-PW DATENDPW K DATE
I104-WK-BETRAG-PW WKURS-PW K DECIMAL
I104-BUDT-AN BUDT-AN K CHAR
I104-COADFN COADFN K CHAR
I104-BEMERK1-UC BUTXT K UNICODE
I104-BSLKMPL BSLKMPL K CHAR
I104-KTOM COADFN K CHAR

4.3 I140 - FAOBJ - Fixed Asset Objects per Account

Field Short Description May Be Type Remarks/Format/...
I140-JOBID JOBID M NUMERIC
I140-RECORD-NR RECNO M NUMERIC
I140-IMP-ERROR IMP-ERR K CHAR
I140-CODT CODT M CHAR
I140-ANLM ANL M CHAR
I140-BEMERK1-UC BEMERK1 M UNICODE
I140-KTPM COADFN M CHAR
I140-KTOM COADFN M CHAR
I140-ANSCHAFF-DAT AN-DAT M DATE
I140-GESKON GESKON M CHAR KON/OTHOBJ Object=A12
I140-DPN-ART DPN-ART M CHAR KON/OTHOBJ Object=A03
I140-DPN-PROZ DPN-PROZ K CHAR
I140-DPN-KTOM DPN-COADFN K CHAR
I140-VERKAUF-DAT VK-DAT K DATE
I140-GUELTIG-AB GUE-AB K DATE
I140-GUELTIG-BIS GUE-BIS K DATE
I140-KTK KTK K CHAR
I140-KONZANLM KONZ-ANL K CHAR
I140-DPN-ZEIT DPN-DAU K CHAR
I140-DPN-BETRAG BETRAG K DECIMAL
I140-KSTKTP KST-COADFN K CHAR
I140-KSTM KST K CHAR
I140-FXCDE FXCDE K CHAR
I140-GESCH-WERT-LW LWSOLL K DECIMAL
I140-WB-KTOM WB-COADFN K CHAR
I140-UBR1 DPN-BUDT K CHAR

4.4 I167 - VCH - Vouchers

Field Short Description May Be Type Remarks/Format/...
I167-JOBID JOBID M NUMERIC
I167-RECORD-NR RECNO M NUMERIC
I167-IMP-ERROR IMP-ERR K CHAR
I167-CODT CODT M CHAR
I167-BUDT BUDT M CHAR
I167-CLSDTE-MON-JAHR CLSDTE-I M PERIOD
I167-FCT FCT M CHAR
I167-BELEG-NR BELEGNR M CHAR
I167-BELEGDAT BELDAT M DATE
I167-BUCHUNGSART BUCHART M CHAR KON/OTHOBJ Object=B03
I167-CMPCNT-KNZ VRBKNZ M CHAR
I167-BEMERK1-UC BEMERK1 K UNICODE
I167-MELDUNG MELDUNG K CHAR
I167-ZIEL-FCT Z-FCT K CHAR
I167-LS-STATUS LSSTATUS K CHAR KON/OTHOBJ Object=L01
I167-VCHCLA VCHCLA K CHAR

4.5 I132 - PERATH - Period Authorization

Field Short Description May Be Type Remarks/Format/...
I132-JOBID JOBID M NUMERIC
I132-RECORD-NR RECNO M NUMERIC
I132-IMP-ERROR IMP-ERR K CHAR
I132-OPROJID BENPRJ-I K CHAR Automatic filling
I132-OOBJTYP BENTYP-I K CHAR Automatic completion (USR)
I132-OOBJID OBJATH M CHAR User
I132-UPROJID OBJPRJ K CHAR Automatic filling
I132-UOBJTYP OBJTYP K CHAR Automatic filling (CLSDTE)
I132-UABR-MON-JAHR CLSDTE M PERIOD
I132-SEL BER1 M CHAR IAR/OTHOBJ Object=B01 See Application. NAME
I132-UPD BER2 K CHAR IAR/OTHOBJ Object=B01 s. Application. NAME
I132-INS BER3 K CHAR IAR/OTHOBJ Object=B01 s. Application. NAME
I132-DEL BER4 K CHAR IAR/OTHOBJ Object=B01 s. Application. NAME
I132-COP BER5 K CHAR IAR/OTHOBJ Object=B01 s. Application. NAME
I132-VAR BER6 K CHAR -blank
I132-BE7 BER7 K CHAR -blank
I132-BE8 BER8 K CHAR -blank
I132-BE9 BER9 K CHAR -blank
I132-BE0 BER0 K CHAR -blank

4.6 I132 - MNUATH - Menu Authorization

Field Short Description May Be Type Remarks/Format/...
I132-JOBID JOBID M NUMERIC
I132-RECORD-NR RECNO M NUMERIC
I132-IMP-ERROR IMP-ERR K CHAR
I132-OPROJID BENPRJ-I M CHAR Automatic filling
I132-OOBJTYP BENTYP-I M CHAR Automatic completion (USR)
I132-OOBJID OBJATH M CHAR User
I132-UPROJID OBJPRJ K CHAR IAR or KON
I132-UOBJTYP OBJTYP K CHAR Automatic filling (MNUITM)
I132-UOBJID OBJOBJ M CHAR
I132-SEL BER1 M CHAR IAR/OTHOBJ Object=B01 s. Application. NAME
I132-UPD BER2 K CHAR IAR/OTHOBJ Object=B01 s. Application. NAME
I132-INS BER3 K CHAR IAR/OTHOBJ Object=B01 s. Application. NAME
I132-DEL BER4 K CHAR IAR/OTHOBJ Object=B01 s. Application. NAME
I132-COP BER5 K CHAR IAR/OTHOBJ Object=B01 s. Application. NAME
I132-VAR BER6 K CHAR -blank
I132-BE7 BER7 K CHAR -blank
I132-BE8 BER8 K CHAR -blank
I132-BE9 BER9 K CHAR -blank
I132-BE0 BER0 K CHAR -blank

4.7 I132 - OBJATH - Object Authorization

Field Short Description May Be Type Remarks/Format/...
I132-JOBID JOBID M NUMERIC
I132-RECORD-NR RECNO M NUMERIC
I132-IMP-ERROR IMP-ERR K CHAR
I132-OPROJID BENPRJ-I M CHAR Automatic filling
I132-OOBJTYP BENTYP-I M CHAR Automatic completion (USR)
I132-OOBJID OBJATH M CHAR User
I132-UPROJID OBJPRJ K CHAR Automatic filling
I132-UOBJTYP OBJTYP K CHAR
I132-UOBJID OBJOBJ M CHAR
I132-SEL BER1 M CHAR IAR/OTHOBJ Object=B01 s. Application. NAME
I132-UPD BER2 K CHAR IAR/OTHOBJ Object=B01 s. Application. NAME
I132-INS BER3 K CHAR IAR/OTHOBJ Object=B01 s. Application. NAME
I132-DEL BER4 K CHAR IAR/OTHOBJ Object=B01 s. Application. NAME
I132-COP BER5 K CHAR IAR/OTHOBJ Object=B01 s. Application. NAME
I132-VAR BER6 K CHAR -blank
I132-BE7 BER7 K CHAR -blank
I132-BE8 BER8 K CHAR -blank
I132-BE9 BER9 K CHAR -blank
I132-BE0 BER0 K CHAR -blank

4.8 I168 - PST - Postings

Field Short Description May Be Type Remarks/Format/...
I168-JOBID JOBID M NUMERIC
I168-RECORD-NR RECNO M NUMERIC
I168-IMP-ERROR IMP-ERR K CHAR
I168-CODT CODT M CHAR
I168-BUDT BUDT K CHAR
I168-CLSDTE-MON-JAHR CLSDTE-I M PERIOD
I168-FCT FCT-I M CHAR
I168-BELEG-NR BELEGNR M CHAR
I168-PST-NR BUCHNR M CHAR
I168-CODT-AN IC-CODT K CHAR
I168-BUDT-AN IC-BUDT K CHAR
I168-COADFN COADFN K CHAR
I168-KTOM COADFN M CHAR
I168-KST1KTP KST1KTP K CHAR
I168-KST1 KST1 K CHAR
I168-ANLM FAOBJ K CHAR
I168-LW-SOLL SOLL-LW K DECIMAL
I168-LW-HABEN HABEN-LW K DECIMAL
I168-KW-SOLL SOLL-KW K DECIMAL
I168-KW-HABEN HABEN-KW K DECIMAL
I168-PW-SOLL SOLL-PW K DECIMAL
I168-PW-HABEN HABEN-PW K DECIMAL
I168-BSLKMPL BSLKMPL K CHAR
I168-UAW-PW UAP K CHAR KON/OTHOBJ Object=UAP
I168-WK-DATEND-PW DATENDPW K DATE
I168-WK-BETRAG-PW WKURS-PW K DECIMAL
I168-LT-KNZ LT-KNZ K CHAR KON/OTHOBJ Object=L08
I168-UAW-KW UAW K CHAR KON/OTHOBJ Object=UAW
I168-WK-DATEND-KW DATEND K DATE
I168-WK-BETRAG-KW WKURS K DECIMAL
I168-TW-SOLL SOLL-TW K DECIMAL
I168-TW-HABEN HABEN-TW K DECIMAL
I168-FXCDE-TW FXCDE-TW K CHAR
I168-BEMERK1-UC BEMERK1 K UNICODE
I168-KST2KTP KST2KTP K CHAR
I168-KST2 KST2 K CHAR
I168-KST3KTP KST3KTP K CHAR
I168-KST3 KST3 K CHAR
I168-KST4KTP KST4KTP K CHAR
I168-KST4 KST4 K CHAR
I168-KST5KTP KST5KTP K CHAR
I168-KST5 KST5 K CHAR
I168-KST6KTP KST6KTP K CHAR
I168-KST6 KST6 K CHAR
I168-KST7KTP KST7KTP K CHAR
I168-KST7 KST7 K CHAR
I168-KST8KTP KST8KTP K CHAR
I168-KST8 KST8 K CHAR
I168-KST9KTP KST9KTP K CHAR
I168-KST9 KST9 K CHAR
I168-KST0KTP KST0KTP K CHAR
I168-KST0 KST0 K CHAR
I168-PST-BUDT BU-BUDT K CHAR

4.9 I115 - CNTCNT - Controlling Object Hierarchy Assignments

Field Short Description May Be Type Remarks/Format/...
I115-JOBID JOBID M NUMERIC
I115-RECORD-NR RECNO M NUMERIC
I115-IMP-ERROR IMP-ERR K CHAR
I115-COADFN COADFN M CHAR
I115-KSTM KST M CHAR
I115-KSTU UKST M CHAR

4.10 I102 - CNTSAL - Controlling Balances

Field Short Description May Be Type Remarks/Format/...
I102-JOBID JOBID M NUMERIC
I102-RECORD-NR RECNO M NUMERIC
I102-IMP-ERROR IMP-ERR K CHAR
I102-CODT CODT M CHAR
I102-BUDT BUDT K CHAR
I102-COADFN COADFN K CHAR
I102-COADFN COADFN M CHAR
I102-CLSDTE-MON-JAHR CLSDTE-I M PERIOD
I102-FCT FCT-I M CHAR
I102-WERT-LW WERT-LW M DECIMAL
I102-SOLL-HAB-KNZ SOLL-HAB K CHAR KON/OTHOBJ Object=S01
I102-WERT-KW WERT-KW K DECIMAL
I102-WERT-PW WERT-PW K DECIMAL
I102-KST1KTP KST1KTP K CHAR
I102-KST1 KST1 K CHAR
I102-KST2KTP KST2KTP K CHAR
I102-KST2 KST2 K CHAR
I102-KST3KTP KST3KTP K CHAR
I102-KST3 KST3 K CHAR
I102-KST4KTP KST4KTP K CHAR
I102-KST4 KST4 K CHAR
I102-KST5KTP KST5KTP K CHAR
I102-KST5 KST5 K CHAR
I102-KST6KTP KST6KTP K CHAR
I102-KST6 KST6 K CHAR
I102-KST7KTP KST7KTP K CHAR
I102-KST7 KST7 K CHAR
I102-KST8KTP KST8KTP K CHAR
I102-KST8 KST8 K CHAR
I102-KST9KTP KST9KTP K CHAR
I102-KST9 KST9 K CHAR
I102-KST0KTP KST0KTP K CHAR
I102-KST0 KST0 K CHAR
I102-BEMERK1-UC BEMERK1 K UNICODE

4.11 I110 - CODT - Companies

Field Short Description May Be Type Remarks/Format/...
I110-JOBID JOBID M NUMERIC
I110-RECORD-NR RECNO M NUMERIC
I110-IMP-ERROR IMP-ERR K CHAR
I110-CODT CODT M CHAR
I110-BENE1-CODT-UC BENE1 M UNICODE
I110-KURZW-CODT-UC KURZW K UNICODE
I110-STRASSE STR K CHAR
I110-PLZ PLZ K CHAR
I110-ORT ORT K CHAR
I110-TELEFON TEL K CHAR
I110-TELEFAX TELFAX K CHAR
I110-EMAIL EMAIL K CHAR
I110-URL URL K CHAR
I110-ANSPR-PARTNER ANSPR K CHAR
I110-CNTCDE CNTCDE M CHAR
I110-FXCDE FXCDE M CHAR
I110-SPRID SPRID M CHAR
I110-ABW-GESCHJAHR ABWGJ K DATE
I110-GUELTIG-AB GUE-AB M DATE
I110-GUELTIG-BIS GUE-BIS K DATE
I110-COADFN COADFN M CHAR
I110-KST-COADFN KSTKTP K CHAR
I110-KST-KTP2 KSTKTP2 K CHAR
I110-KST-KTP3 KSTKTP3 K CHAR
I110-KST-KTP4 KSTKTP4 K CHAR
I110-KST-KTP5 KSTKTP5 K CHAR
I110-KST-KTP6 KSTKTP6 K CHAR
I110-KST-KTP7 KSTKTP7 K CHAR
I110-KST-KTP8 KSTKTP8 K CHAR
I110-KST-KTP9 KSTKTP9 K CHAR
I110-KST-KTP0 KSTKTP0 K CHAR
I110-PRFGRP PRFGRP K CHAR
I110-MERGE-DATE MG-DATE K DATE
I110-MERGE-CODT MG-CODT K CHAR
I110-LIC-TYPE-KON LICTKON K CHAR
I110-LIC-TYPE-FC LICTFC K CHAR
I110-LIC-TYPE-XLS LICTXLS K CHAR
I110-STEUERNR STEUERNR K CHAR
I110-CODT-ART GESART K CHAR
I110-RECHTSFORM-UC RECHTSF K UNICODE
I110-HANDELSREG-UC HANDREG K UNICODE
I110-HANDELSREG-NR HANDREGN K CHAR
I110-TIN TIN K CHAR
I110-GESCH-TAET-UC GESTAET K UNICODE
I110-ADDR-TYPE ADDRTYPE K CHAR
I110-BUILDING-ID BUILDID K CHAR
I110-POB POB K CHAR
I110-SUITE-ID SUITEID K CHAR
I110-FLOOR-ID FLOORID K CHAR
I110-SUBCOUNTRY-UC SUBCTRY K UNICODE
I110-DISTRICT-UC DISTRICT K UNICODE
I110-ADDRESS-UC ADDRESS K UNICODE

4.12 I145 - SHRPAR - Shareholding Transactions

Field Short Description May Be Type Remarks/Format/...
I145-JOBID JOBID M NUMERIC
I145-IMP-ERROR IMP-ERR K CHAR
I145-RECORD-NR RECNO M NUMERIC
I145-CODT CODT M CHAR
I145-COADFN COADFN K CHAR
I145-KTOM COADFN M CHAR
I145-FCT FCT-I M CHAR
I145-CLSDTE-MON-JAHR CLSDTE M PERIOD
I145-BEWDAT BEWDAT M DATE
I145-WERT-LW WERT-LW M DECIMAL
I145-SOLL-HAB-KNZ SOLL-HAB K CHAR KON/OTHOBJ Object=S01
I145-UAW UAW K CHAR KON/OTHOBJ Object=UAW
I145-WK-DATEND DATEND K DATE
I145-WK-BETRAG WKURS K DECIMAL
I145-WERT-KW WERT-KW K DECIMAL
I145-WERT-PW WERT-PW K DECIMAL
I145-WERT-TW WERT-TW K DECIMAL
I145-FXCDE FXCDE-TW K CHAR
I145-BET-PRDGRP-KAP PRDGRP-ERG K DECIMAL
I145-BET-PRDGRP-STIMM PRDGRP-STIM K DECIMAL
I145-BET-PRDGRP-ERG PRDGRP-KAP K DECIMAL
I145-KTK KTK K CHAR
I145-BUDT BUDT K CHAR
I145-CODT-AN IC-CODT M CHAR
I145-BSLKMPL BSLKMPL K CHAR
I145-UAW-PW UAW-PW K CHAR KON/OTHOBJ Object=UAP
I145-WK-DATEND-PW DATENDPW K DATE
I145-WK-BETRAG-PW WKURS-PW K DECIMAL
I145-BUDT-AN IC-BUDT K CHAR
I145-SUBDTE-KTOM AB-COADFN K CHAR
I145-SUBDTE-WERT-KW AB-W-KW K DECIMAL
I145-SUBDTE-S-H-KNZ AB-SH K CHAR
I145-BEMERK1-UC BUTXT K UNICODE
I145-BELEG-NR BELEG-NR K CHAR
I145-SUBDTE-WERT-LW AB-W-LW K DECIMAL
I145-SUBDTE-BSLKMPL AB-BSLKM K CHAR

4.13 I104 - ICFATRN - IC Fixed Asset Transactions

Field Short Description May Be Type Remarks/Format/...
I104-JOBID JOBID M NUMERIC
I104-RECORD-NR RECNO M NUMERIC
I104-IMP-ERROR IMP-ERR K CHAR
I104-CODT CODT M CHAR
I104-ANL ANL M CHAR
I104-FCT FCT-I M CHAR
I104-CLSDTE-MON-JAHR CLSDTE-I M PERIOD
I104-BEWDAT BEWDAT M DATE
I104-WERT-LW WERT-LW M DECIMAL
I104-SOLL-HAB-KNZ SOLL-HAB K CHAR KON/OTHOBJ Object=S01
I104-UAW UAW K CHAR KON/OTHOBJ Object=UAW
I104-WK-DATEND DATEND K DATE
I104-WK-BETRAG WKURS K DECIMAL
I104-GEGEN-ANL GEGENANL K CHAR
I104-BELEG-GES1 VCH-GES1 K CHAR
I104-BELEG-GES2 VCH-GES2 K CHAR
I104-BELEG-CNSFNC VCH-CNSFNC K CHAR
I104-WERT-KW WERT-KW K DECIMAL
I104-WERT-PW WERT-PW K DECIMAL
I104-BUDT BUDT K CHAR
I104-CODT-AN CODT-AN K CHAR
I104-UAW-PW UAW-PW K CHAR KON/OTHOBJ Object=UAP
I104-WK-DATEND-PW DATENDPW K DATE
I104-WK-BETRAG-PW WKURS-PW K DECIMAL
I104-BUDT-AN BUDT-AN K CHAR
I104-COADFN COADFN K CHAR
I104-BEMERK1-UC BUTXT K UNICODE
I104-BSLKMPL BSLKMPL K CHAR
I104-KTOM COADFN K CHAR

4.14 I140 - ICFAOBJ - IC Fixed Asset Objects

Field Short Description May Be Type Remarks/Format/...
I140-JOBID JOBID M NUMERIC
I140-RECORD-NR RECNO M NUMERIC
I140-IMP-ERROR IMP-ERR K CHAR
I140-CODT CODT M CHAR
I140-ANLM ANL M CHAR
I140-BEMERK1-UC BEMERK1 M UNICODE
I140-KTPM COADFN M CHAR
I140-KTOM COADFN M CHAR
I140-ANSCHAFF-DAT AN-DAT M DATE
I140-GESKON GESKON M CHAR KON/OTHOBJ Object=A03
I140-DPN-ART DPN-ART M CHAR KON/OTHOBJ Object=A12
I140-DPN-PROZ DPN-PROZ K CHAR
I140-DPN-KTOM DPN-COADFN K CHAR
I140-VERKAUF-DAT VK-DAT K DATE
I140-VK-CODT VK-CODT K CHAR
I140-VK-KTOM VK-COADFN K CHAR
I140-VK-ERLOES VK-WERT K DECIMAL
I140-SOLL-HAB-KNZ VK-SH K CHAR KON/OTHOBJ Object=S01
I140-UR-CODT UR-CODT K CHAR
I140-UR-ANLM UR-ANL K CHAR
I140-GUELTIG-AB GUE-AB K DATE
I140-GUELTIG-BIS GUE-BIS K DATE
I140-KTK KTK K CHAR
I140-KONZANLM KONZ-ANL K CHAR
I140-DPN-ZEIT DPN-DAU K CHAR
I140-DPN-BETRAG BETRAG K DECIMAL
I140-KSTKTP KST-COADFN K CHAR
I140-KSTM KST K CHAR
I140-WB-KTOM WB-COADFN K CHAR
I140-UBR1 DPN-BUDT K CHAR

4.15 I162 - ICSTCK - Stocks IC Stocks

Field Short Description May Be Type Remarks/Format/...
I162-JOBID JOBID M NUMERIC
I162-RECORD-NR RECNO M NUMERIC
I162-IMP-ERROR IMP-ERR K CHAR
I162-CODT CODT M CHAR
I162-BUDT BUDT K CHAR
I162-CLSDTE-MON-JAHR CLSDTE-I M PERIOD
I162-FCT FCT-I M CHAR
I162-PRDGRP PRDGRP M CHAR
I162-CODT-AN ICGES M CHAR
I162-BUDT-AN ICUBR K CHAR
I162-ZU-AB-SATZ ZUAB K DECIMAL
I162-WERT-LW WERT-LW M DECIMAL
I162-WERT-KW WERT-KW K DECIMAL
I162-WERT-PW WERT-PW K DECIMAL
I162-SOLL-HAB-KNZ SOLL-HAB K CHAR KON/OTHOBJ Object=S01
I162-COADFN COADFN K CHAR
I162-KTOM ELKTO M CHAR
I162-BEARB-KNZ BEAKNZ K CHAR KON/OTHOBJ Object=V04
I162-ZU-AB-WERT-KW ZUABKW K DECIMAL
I162-KSTKTP KSTKTP K CHAR
I162-KSTM KST K CHAR
I162-BEMERK1-UC BEMERK1 K UNICODE

4.16 I101 - ICKONV - IC P&L Sub-Account Balances

Field Short Description May Be Type Remarks/Format/...
I101-JOBID JOBID M NUMERIC
I101-RECORD-NR RECNO M NUMERIC
I101-IMP-ERROR IMP-ERR K CHAR
I101-CODT CODT M CHAR
I101-BUDT BUDT K CHAR
I101-COADFN COADFN K CHAR
I101-COADFN COADFN M CHAR
I101-CLSDTE-MON-JAHR CLSDTE-I M PERIOD
I101-FCT FCT-I M CHAR
I101-WERT-LW WERT-LW M DECIMAL
I101-SOLL-HAB-KNZ SOLL-HAB K CHAR KON/OTHOBJ Object=S01
I101-WERT-TW WERT-TW K DECIMAL
I101-FXCDE FXCDE-TW K CHAR
I101-CODT-AN ICGES M CHAR
I101-WERT-KW WERT-KW K DECIMAL
I101-WERT-PW WERT-PW K DECIMAL
I101-BUDT-AN ICUBR K CHAR
I101-KTK BELKTK K CHAR
I101-KST1KTP KST1KTP K CHAR
I101-KST1 KST1 K CHAR
I101-KST2KTP KST2KTP K CHAR
I101-KST2 KST2 K CHAR
I101-KST3KTP KST3KTP K CHAR
I101-KST3 KST3 K CHAR
I101-KST4KTP KST4KTP K CHAR
I101-KST4 KST4 K CHAR
I101-KST5KTP KST5KTP K CHAR
I101-KST5 KST5 K CHAR
I101-KST6KTP KST6KTP K CHAR
I101-KST6 KST6 K CHAR
I101-KST7KTP KST7KTP K CHAR
I101-KST7 KST7 K CHAR
I101-KST8KTP KST8KTP K CHAR
I101-KST8 KST8 K CHAR
I101-KST9KTP KST9KTP K CHAR
I101-KST9 KST9 K CHAR
I101-KST0KTP KST0KTP K CHAR
I101-KST0 KST0 K CHAR
I101-AUSZIFF-KNZ AUSZIF K NUMERIC
I101-REF-BELEG REFBEL K CHAR
I101-REF-DATUM REFDAT K DATE
I101-BEMERK1-UC BEMERK1 K UNICODE
I101-AUSZIFF-KNZ-2 AUSZIF-2 K DECIMAL

4.17 I101 - ICACBAL - IC Sub-Account Balances

Field Short Description May Be Type Remarks/Format/...
I101-JOBID JOBID M NUMERIC
I101-RECORD-NR RECNO M NUMERIC
I101-IMP-ERROR IMP-ERR K CHAR
I101-CODT CODT M CHAR
I101-BUDT BUDT K CHAR
I101-COADFN COADFN K CHAR
I101-COADFN COADFN M CHAR
I101-CLSDTE-MON-JAHR CLSDTE M PERIOD
I101-FCT FCT-I M CHAR
I101-WERT-LW WERT-LW M DECIMAL
I101-SOLL-HAB-KNZ SOLL-HAB K CHAR KON/OTHOBJ Object=S01
I101-WERT-TW WERT-TW K DECIMAL
I101-FXCDE FXCDE-TW K CHAR
I101-CODT-AN ICGES M CHAR
I101-WERT-KW WERT-KW K DECIMAL
I101-WERT-PW WERT-PW K DECIMAL
I101-BUDT-AN ICUBR K CHAR
I101-KTK BELKTK K CHAR
I101-KST1KTP KST1KTP K CHAR
I101-KST1 KST1 K CHAR
I101-KST2KTP KST2KTP K CHAR
I101-KST2 KST2 K CHAR
I101-KST3KTP KST3KTP K CHAR
I101-KST3 KST3 K CHAR
I101-KST4KTP KST4KTP K CHAR
I101-KST4 KST4 K CHAR
I101-KST5KTP KST5KTP K CHAR
I101-KST5 KST5 K CHAR
I101-KST6KTP KST6KTP K CHAR
I101-KST6 KST6 K CHAR
I101-KST7KTP KST7KTP K CHAR
I101-KST7 KST7 K CHAR
I101-KST8KTP KST8KTP K CHAR
I101-KST8 KST8 K CHAR
I101-KST9KTP KST9KTP K CHAR
I101-KST9 KST9 K CHAR
I101-KST0KTP KST0KTP K CHAR
I101-KST0 KST0 K CHAR
I101-AUSZIFF-KNZ-2 AUSZIF-2 K DECIMAL
I101-REF-BELEG REFBEL K CHAR
I101-REF-DATUM REFDAT K DATE
I101-BEMERK1-UC BEMERK1 K UNICODE
I101-AUSZIFF-KNZ AUSZIF K NUMERIC

4.18 I108 - CAPTRN - Capital Transactions

Field Short Description May Be Type Remarks/Format/...
I108-JOBID JOBID CHAR
I108-RECORD-NR RECNO CHAR
I108-IMP-ERROR IMP-ERR CHAR
I108-CLSDTE-MON-JAHR CLSDTE-I M PERIOD
I108-BELEG-GES1 VCH-GES1 K CHAR
I108-BELEG-GES2 VCH-GES2 K CHAR
I108-BELEG-CNSFNC VCH-CNSFNC K CHAR
I108-BEMERK1-UC BUTXT K UNICODE
I108-BEWDAT BEWDAT M DATE
I108-FCT FCT-I M CHAR
I108-CODT CODT M CHAR
I108-CODT-AN IC-CODT K CHAR
I108-KTK KTK K CHAR
I108-KTOM COADFN M CHAR
I108-COADFN COADFN K CHAR
I108-SOLL-HAB-KNZ SOLL-HAB K CHAR KON/OTHOBJ Object=S01
I108-UAW UAW K CHAR KON/OTHOBJ Object=UAW
I108-UAW-PW UAW-PW K CHAR KON/OTHOBJ Object=UAP
I108-BUDT BUDT K CHAR
I108-BUDT-AN IC-BUDT K CHAR
I108-WERT-KW WERT-KW K DECIMAL
I108-WERT-LW WERT-LW M DECIMAL
I108-WERT-PW WERT-PW K DECIMAL
I108-WK-BETRAG WKURS K DECIMAL
I108-WK-BETRAG-PW WKURS-PW K DECIMAL
I108-WK-DATEND DATEND K DATE
I108-WK-DATEND-PW DATENDPW K DATE
I108-BSLKMPL BSLKMPL K CHAR

4.19 I148 - CNSVCH - Consolidation Vouchers

Field Short Description May Be Type Remarks/Format/...
I148-JOBID JOBID M NUMERIC
I148-IMP-ERROR IMP-ERR K CHAR
I148-RECORD-NR RECNO M NUMERIC
I148-KTK KTK M CHAR
I148-CLSDTE-MON-JAHR CLSDTE-I M PERIOD
I148-FCT FCT M CHAR
I148-BELEG-GES1 VCH-GES1 M CHAR
I148-BELEG-GES2 VCH-GES2 M CHAR
I148-BELEG-CNSFNC VCH-CNSFNC M CHAR
I148-BELEG-DAT BELDAT M DATE
I148-BUCHUNGSART BUCHART M CHAR KON/OTHOBJ Object=B06
I148-CMPCNT-KNZ VRBKNZ K CHAR KON/OTHOBJ Object=V04
I148-BEMERK1-UC BEMERK1 K UNICODE
I148-MELDUNG MELDUNG K CHAR
I148-LS-STATUS LSSTATUS K CHAR KON/OTHOBJ Object=L01
I148-KA-STATUS KASTATUS K CHAR KON/OTHOBJ Object=L04
I148-BELKVA-BASIC VCH-KV M CHAR
I148-BELKVA-RECGRP VCH-NR K CHAR
I148-BELKVA-L VCH-L K CHAR
I148-BELKVA-V VCH-V K CHAR
I148-BELEG-LFD VCH-LFD K CHAR

4.20 I149 - CNSPST - Consolidation Postings

Field Short Description May Be Type Remarks/Format/...
I149-JOBID JOBID M NUMERIC
I149-RECORD-NR RECNO M NUMERIC
I149-IMP-ERROR IMP-ERR K CHAR
I149-KTK KTK K CHAR
I149-CODT CODT K CHAR
I149-CLSDTE-MON-JAHR CLSDTE-I K PERIOD
I149-FCT FCT-I M CHAR
I149-BUDT BUDT K CHAR
I149-BELEG-GES1 VCH-GES1 K CHAR
I149-BELEG-GES2 VCH-GES2 K CHAR
I149-BELEG-CNSFNC VCH-CNSFNC K CHAR
I149-PST-NR BUCHNR K CHAR
I149-STATUS BUCHSTAT K CHAR KON/OTHOBJ Object=S18
I149-COADFN COADFN K CHAR
I149-KTOM COADFN K CHAR
I149-ANLGES ANLGES K CHAR
I149-ANLM FAOBJ K CHAR
I149-BSLKMPL BSLKMPL K CHAR
I149-KW-SOLL SOLL-KW K DECIMAL
I149-KW-HABEN HABEN-KW K DECIMAL
I149-PW-SOLL SOLL-PW K DECIMAL
I149-PW-HABEN HABEN-PW K DECIMAL
I149-UAW-PW UAP K CHAR KON/OTHOBJ Object=UAP
I149-WK-DATEND-PW DATEND K DATE
I149-WK-BETRAG-PW WKURS K DECIMAL
I149-BEMERK1-UC BEMERK1 K UNICODE
I149-HERKKTK HERKKTK K CHAR
I149-LT-KNZ LT-KNZ K CHAR KON/OTHOBJ Object=L03
I149-KA-KNZ KA-KNZ K CHAR KON/OTHOBJ Object=L06
I149-KST1KTP KST1KTP K CHAR
I149-KST1 KST1 K CHAR
I149-KST2KTP KST2KTP K CHAR
I149-KST2 KST2 K CHAR
I149-KST3KTP KST3KTP K CHAR
I149-KST3 KST3 K CHAR
I149-KST4KTP KST4KTP K CHAR
I149-KST4 KST4 K CHAR
I149-KST5KTP KST5KTP K CHAR
I149-KST5 KST5 K CHAR
I149-KST6KTP KST6KTP K CHAR
I149-KST6 KST6 K CHAR
I149-KST7KTP KST7KTP K CHAR
I149-KST7 KST7 K CHAR
I149-KST8KTP KST8KTP K CHAR
I149-KST8 KST8 K CHAR
I149-KST9KTP KST9KTP K CHAR
I149-KST9 KST9 K CHAR
I149-KST0KTP KST0KTP K CHAR
I149-KST0 KST0 K CHAR
I149-UAW-KW UAW-KW K CHAR
I149-WK-DATEND-KW DATEN-KW K DATE
I149-WK-BETRAG-KW WKURS-KW K DECIMAL
I149-LW-SOLL SOLL-LW K DECIMAL
I149-LW-HABEN HABEN-LW K DECIMAL
I149-FXCDE-LW FXCDE-LW K CHAR
I149-BELKVA-BASIC VCH-KV M CHAR
I149-BELKVA-RECGRP VCH-NR K CHAR
I149-BELKVA-L VCH-L K CHAR
I149-BELKVA-V VCH-V K CHAR
I149-BELEG-LFD VCH-LFD K CHAR

4.21 I103 - KST - Controlling Objects

Field Short Description May Be Type Remarks/Format/...
I103-JOBID JOBID M NUMERIC
I103-RECORD-NR RECNO M NUMERIC
I103-IMP-ERROR IMP-ERR CHAR
I103-COADFN COADFN M CHAR
I103-KSTM KST M CHAR
I103-SPRID-KST LGNCDE K CHAR
I103-BENE1-KST-UC BENE1 M UNICODE
I103-KURZW-KST-UC KURZW K UNICODE
I103-KST-VERANTW VERANTW K CHAR
I103-KST-KNZ1 KSTKNZ1 K CHAR KON/OTHOBJ Object=K05
I103-KST-KNZ2 KSTKNZ2 K CHAR KON/OTHOBJ Object=K06
I103-VERDKST VKST K CHAR
I103-BUDT KUBR K CHAR
I103-GUELTIG-AB GUE-AB K DATE
I103-GUELTIG-BIS GUE-BIS K DATE
I103-KONZKTP KKTP K CHAR
I103-KONZKSTM KKST K CHAR
I103-AGG-KNZ AGGKNZ K CHAR KON/OTHOBJ Object=A14
I103-CODT CNTGES K CHAR

4.22 I144 - GRPMNR - Group/Sub-Group Circle

Field Short Description May Be Type Remarks/Format/...
I144-JOBID JOBID M NUMERIC
I144-RECORD-NR RECNO M NUMERIC
I144-IMP-ERROR IMP-ERR K CHAR
I144-KTK KTK M CHAR
I144-CLSDTE-MON-JAHR CLSDTE-I M PERIOD
I144-FCT FCT-I M CHAR
I144-CODT CODT M CHAR
I144-MUTTER MUTTER K CHAR KON/OTHOBJ Object=M07
I144-ZUGANG-KONS ZUGANG K DATE
I144-KONSART KONSART M CHAR KON/OTHOBJ Object=K03
I144-PST-AUS-TK PST-TK K CHAR
I144-BET-EBENE BETEBENE K CHAR
I144-BET-KAP BET-KAP K DECIMAL
I144-BET-PRDGRP-ADD PRDGRP-ADD K DECIMAL
I144-BET-PRDGRP-MULT PRDGRP-MULT K DECIMAL
I144-BET-PRDGRP-STIMM PRDGRP-STIM K DECIMAL
I144-BET-PRDGRP-ERG PRDGRP-ERG K DECIMAL
I144-BET-PRDGRP-QUOT PRDGRP-QUOT K DECIMAL
I144-OHNE-INDFREMD FREMDANT K CHAR
I144-NETTO-ANL NETTO K CHAR
I144-ABGANG-KONS ABGANG K DATE
I144-TRANSITION TRANS K CHAR
I144-BET-PRDGRP-M-MAN PRDGRP-MAN K DECIMAL

4.23 I105 - COADFN - Accounts

Field Short Description May Be Type Remarks/Format/...
I105-JOBID JOBID CHAR
I105-RECORD-NR RECNO CHAR
I105-IMP-ERROR IMP-ERR CHAR
I105-BENE1-COADFN-UC BENE M UNICODE
I105-BIL-RC-KNZ BG K CHAR KON/OTHOBJ Object=B01
I105-CDM-FLAG0 CDMFL0 K CHAR KON/OTHOBJ Object=C05
I105-CDM-FLAG1 CDMFL1 K CHAR KON/OTHOBJ Object=C05
I105-CDM-FLAG2 CDMFL2 K CHAR KON/OTHOBJ Object=C05
I105-CDM-FLAG3 CDMFL3 K CHAR KON/OTHOBJ Object=C05
I105-CDM-FLAG4 CDMFL4 K CHAR KON/OTHOBJ Object=C05
I105-CDM-FLAG5 CDMFL5 K CHAR KON/OTHOBJ Object=C05
I105-CDM-FLAG6 CDMFL6 K CHAR KON/OTHOBJ Object=C05
I105-CDM-FLAG7 CDMFL7 K CHAR KON/OTHOBJ Object=C05
I105-CDM-FLAG8 CDMFL8 K CHAR KON/OTHOBJ Object=C05
I105-CDM-FLAG9 CDMFL9 K CHAR KON/OTHOBJ Object=C05
I105-GUELTIG-AB GUE-AB K DATE
I105-GUELTIG-BIS GUE-BIS K DATE
I105-IC-CODT ICGES K CHAR
I105-IC-BUDT ICUBR K CHAR
I105-KNZ-MIT-E-COADFN EKTOGEN K CHAR
I105-KONS-CMPCNT KONSV K CHAR
I105-KONZKTOM KKTO K CHAR
I105-KONZKTP KKTP K CHAR
I105-COADFN-KNZ KNZ1 K CHAR KON/OTHOBJ Object=K01
I105-KTO1M VKTO K CHAR
I105-KTO2M WKTO K CHAR
I105-KTO3M SRFKTO K CHAR
I105-KTO4M EVKTO K CHAR
I105-KTO5M FAKTO K CHAR
I105-KTOM COADFN M CHAR
I105-KTOUBR BUDT K CHAR
I105-COADFN COADFN M CHAR
I105-KURZW-COADFN-UC KURZW K UNICODE
I105-RELART RELART K CHAR KON/OTHOBJ Object=R04
I105-SPI SPI K CHAR
I105-SPRID-COADFN LGNCDE M CHAR
I105-UB-KF UB-KF K CHAR KON/OTHOBJ Object=K16
I105-VORTRAG-RP VORUMB K CHAR KON/OTHOBJ Object=V30
I105-PER-KNZ-M PER-M K CHAR KON/OTHOBJ Object=P22
I105-PER-KNZ-Q PER-Q K CHAR KON/OTHOBJ Object=P22
I105-PER-KNZ-H PER-H K CHAR KON/OTHOBJ Object=P22
I105-PER-KNZ-J PER-J K CHAR KON/OTHOBJ Object=P22
I105-BSGM BSGM K CHAR
I105-SGA SGA K CHAR KON/OTHOBJ Object=K23
I105-COADFN-KNZ2 KNZ2 K CHAR KON/OTHOBJ Object=K22

4.24 I100 - ACBAL - Account Balances

Field Short Description May Be Type Remarks/Format/...
I100-JOBID JOBID M NUMERIC
I100-RECORD-NR RECNO M NUMERIC
I100-IMP-ERROR IMP-ERR K CHAR
I100-CODT CODT M CHAR
I100-BUDT BUDT K CHAR
I100-COADFN COADFN K CHAR
I100-COADFN COADFN M CHAR
I100-CLSDTE-MON-JAHR CLSDTE-I M PERIOD
I100-FCT FCT-I M CHAR
I100-WERT-LW WERT-LW M DECIMAL
I100-SOLL-HAB-KNZ SOLL-HAB K CHAR KON/OTHOBJ Object=S01
I100-WERT-KW WERT-KW K DECIMAL
I100-WERT-PW WERT-PW K DECIMAL
I100-BEMERK1-UC BEMERK1 K UNICODE
I100-CMPCNT-KNZ VRBKNZ K CHAR KON/OTHOBJ Object=V01

4.25 I113 - COADFN - Charts of Accounts

Field Short Description May Be Type Remarks/Format/...
I113-JOBID JOBID M NUMERIC
I113-RECORD-NR RECNO M NUMERIC
I113-IMP-ERROR IMP-ERR K CHAR
I113-COADFN COADFN M CHAR
I113-SPRID-COADFN LGNCDE K CHAR
I113-BENE1-COADFN-UC BENE1 M UNICODE
I113-KURZW-COADFN-UC KURZW K UNICODE
I113-GUELTIG-AB GUE-AB M DATE
I113-GUELTIG-BIS GUE-BIS K DATE
I113-COADFN-KNZ KTPKNZ M CHAR KON/OTHOBJ Object=K08
I113-OBJTYP KTPTYP M CHAR KON/OTHOBJ Object=P02
I113-KONZKTP KNZKTP K CHAR
I113-COADFN-LAENGE KTOLEN K NUMERIC
I113-KST-LAENGE KSTLEN K NUMERIC
I113-FAOBJ-PREFIX ANLPREF K CHAR
I113-KTOUBR KTOUBR K CHAR
I113-RELART RELART K CHAR KON/OTHOBJ Object=R04
I113-CDM CDM K CHAR KON/OTHOBJ Object=C04
I113-COADFN-BEZ-LNG KTOBEZL K NUMERIC

4.26 I147 - CNSFNC - Consolidation Function

Field Short Description May Be Type Remarks/Format/...
I147-JOBID JOBID M NUMERIC
I147-RECORD-NR RECNO M NUMERIC
I147-IMP-ERROR IMP-ERR K CHAR
I147-CNSFNC-BASIC KVABASIC M CHAR
I147-CNSFNC-RECGRP KVARECGR K CHAR
I147-CNSFNC-L CNSFNC-L K CHAR
I147-CNSFNC-V CNSFNC-V K CHAR
I147-SPRID-CNSFNC LGNCDE M CHAR
I147-BENE1-CNSFNC-UC BENE1 M UNICODE
I147-KURZW-CNSFNC-UC KURZW K UNICODE
I147-GUELTIG-AB GUE-AB M DATE
I147-GUELTIG-BIS GUE-BIS K DATE
I147-CNSFNC-REFERENZ CNSFNC-REFE M CHAR
I147-KVA1 KVA1 K CHAR
I147-KVA2 KVA2 K CHAR
I147-KVA4 KVA4 K CHAR
I147-KVA5 KVA5 K CHAR
I147-MIT-TW MIT-TW K CHAR KON/OTHOBJ Object=T03
I147-CNSFNC-COREP CNSFNC-COREP K CHAR
I147-COREP-SPALTE COREP-REPCLCDSC K CHAR
I147-CNSFNC-CF CNSFNC-CF K CHAR
I147-KNZ-CF KNZ-CF K CHAR KON/OTHOBJ Object=V31

4.27 I109 - CNTCDE - Country Code

Field Short Description May Be Type Remarks/Format/...
I109-JOBID JOBID M NUMERIC
I109-RECORD-NR RECNO M NUMERIC
I109-IMP-ERROR IMP-ERR K CHAR
I109-CNTCDE CNTCDE M CHAR
I109-SPRID-CNTCDE LGNCDE K CHAR
I109-BENE1-CNTCDE-UC BENE1 M UNICODE
I109-KURZW-CNTCDE-UC KURZW K UNICODE
I109-GUELTIG-AB GUE-AB M DATE
I109-GUELTIG-BIS GUE-BIS K DATE

4.28 I106 - POSDFN - Positions

Field Short Description May Be Type Remarks/Format/...
I106-JOBID JOBID CHAR
I106-RECORD-NR RECNO CHAR
I106-IMP-ERROR IMP-ERR CHAR
I106-AGB AGB M CHAR
I106-AGGM AGG M CHAR
I106-BENE1-AGG-UC BENE1 M UNICODE
I106-BIL-RC-KNZ BILGUV M CHAR KON/OTHOBJ Object=B01
I106-DAVON-POSDFN DAVONP K CHAR KON/OTHOBJ Object=D02
I106-DIMENSION DIMENS K CHAR KON/OTHOBJ Object=D01
I106-GUELTIG-AB GUE-AB M DATE
I106-GUELTIG-BIS GUE-BIS K DATE
I106-KURZW-AGG-UC KURZW K UNICODE
I106-SPRID-AGG LGNCDE K CHAR
I106-XBRL XBRL K CHAR
I106-HEADTEXT-UC HEADTEXT K UNICODE
I106-POSDFN-OBJTYP POSTYP K CHAR

4.29 I107 - POSKTO - Positions+Account Assignments

Field Short Description May Be Type Remarks/Format/...
I107-JOBID JOBID CHAR
I107-RECORD-NR RECNO CHAR
I107-IMP-ERROR IMP-ERR CHAR
I107-AGB AGB M CHAR
I107-AGGM AGG M CHAR
I107-ENDE-KNZ ENDE-KNZ K CHAR
I107-COADFN-BISM BIS-COADFN K CHAR
I107-KTOM COADFN M CHAR
I107-COADFN COADFN M CHAR
I107-SOLL-HAB-KNZ S-H-KNZ K CHAR KON/OTHOBJ Object=S01

4.30 I117 - POSKTOP - Position+Account Assignments - Periodic

Field Short Description May Be Type Remarks/Format/...
I117-JOBID JOBID M CHAR
I117-RECORD-NR RECNO M CHAR
I117-IMP-ERROR IMP-ERR K CHAR
I117-POSDFN POSDFN M CHAR
I117-POSM POSDFN M CHAR
I117-COADFN COADFN M CHAR
I117-KTOM COADFN M CHAR
I117-ORD-NR ORD-NR K NUMERIC
I117-GUELTIG-AB GUE-AB K DATE
I117-GUELTIG-BIS GUE-BIS K DATE
I117-SOLL-HAB-KNZ S-H-KNZ K CHAR
I117-COADFN-BISM BIS-COADFN K CHAR
I117-CK1 CK1 K CHAR

4.31 I151 - PRF - Check Rules

Field Short Description May Be Type Remarks/Format/...
I151-JOBID JOBID M NUMERIC
I151-RECORD-NR RECNO M NUMERIC
I151-IMP-ERROR IMP-ERR K CHAR
I151-PRF PRF M CHAR
I151-SPRID-PRF LGNCDE M CHAR
I151-LANGTEXT-UC LANGTEXT M UNICODE
I151-KURZTEXT-UC KURZTEXT K UNICODE
I151-GUELTIG-AB GUE-AB M PERIOD
I151-GUELTIG-BIS GUE-BIS K PERIOD
I151-OPERATOR OPERATOR M CHAR KON/OTHOBJ Object=P09
I151-L-DATEN L-DATEN M CHAR KON/OTHOBJ Object=P10
I151-R-DATEN R-DATEN K CHAR KON/OTHOBJ Object=P10
I151-L-WERT L-WERT M CHAR KON/OTHOBJ Object=P11
I151-R-WERT R-WERT K CHAR KON/OTHOBJ Object=P11
I151-L-FL-VABR L-FLVABR K CHAR KON/OTHOBJ Object=P12
I151-R-FL-VABR R-FLVABR K CHAR KON/OTHOBJ Object=P12
I151-L-FL-VFAC L-FLVFAC K CHAR KON/OTHOBJ Object=P13
I151-R-FL-VFAC R-FLVFAC K CHAR KON/OTHOBJ Object=P13
I151-EBENE EBENE K CHAR KON/OTHOBJ Object=P16
I151-TOLERANZ-KW TOLER-KW K DECIMAL
I151-TOLERANZ-LW TOLER-LW K DECIMAL
I151-TOLERANZ-PW TOLER-PW K DECIMAL
I151-PROZENT PROZENT K DECIMAL
I151-PRF-GRP GRP K CHAR
I151-FL-JE-COADFN JE-COADFN K CHAR KON/OTHOBJ Object=P29
I151-FL-JE-BUDT JE-BUDT K CHAR KON/OTHOBJ Object=P28
I151-FL-JE-IC-CODT JE-ICGES K CHAR KON/OTHOBJ Object=P31
I151-FL-JE-CNTOBJ JE-CNTOB K CHAR KON/OTHOBJ Object=P30
I151-FL-JE-CODT JE-CODT K CHAR KON/OTHOBJ Object=P36
I151-KONSTANTE KONSTANT K DECIMAL
I151-PRF-KLASSE PRFREGKL M CHAR

4.32 I154 - PRFGRP - Check Rule Groups

Field Short Description May Be Type Remarks/Format/...
I154-JOBID JOBID M NUMERIC
I154-RECORD-NR RECNO M NUMERIC
I154-IMP-ERROR IMP-ERR K CHAR
I154-GRP GRP M CHAR
I154-SPRID-PRFGRP LGNCDE M CHAR
I154-LANGTEXT-UC LANGTEXT M UNICODE
I154-KURZTEXT-UC KURZTEXT K UNICODE
I154-GRP-OBJTYP GRPTYP M CHAR KON/OTHOBJ Object=P26
I154-OGRP OGRP K CHAR

4.33 I152 - PRFPOS - Check Rules/Positions

Field Short Description May Be Type Remarks/Format/...
I152-JOBID JOBID M NUMERIC
I152-RECORD-NR RECNO M NUMERIC
I152-IMP-ERROR IMP-ERR K CHAR
I152-PRF PRF M CHAR
I152-SEITE SEITE M CHAR KON/OTHOBJ Object=P14
I152-AGB AGB K CHAR
I152-AGGM AGG K CHAR
I152-COADFN COADFN K CHAR
I152-KTOM COADFN K CHAR
I152-BIL-RC-KNZ BG K CHAR KON/OTHOBJ Object=B01
I152-COADFN-KNZ KNZ1 K CHAR KON/OTHOBJ Object=K01
I152-SPI SPI K CHAR
I152-BSLKMPL BSLKMPL K CHAR
I152-SSPA SSPA K CHAR
I152-SSPM SSPM K CHAR
I152-SBEA SBEA K CHAR
I152-SBEM SBEM K CHAR
I152-OPERATOR OPERATOR K CHAR KON/OTHOBJ Object=P25
I152-COADFN-KNZ2 KNZ2 K CHAR KON/OTHOBJ Object=K22
I152-SGA SGA K CHAR KON/OTHOBJ Object=K23
I152-CK1 CK1 K CHAR
I152-KSTKTP CNTKTP K CHAR
I152-KSTM CNTOBJ K CHAR
I152-BUDT BUDT K CHAR
I152-REPID RID K CHAR
I152-IC-VERPROB ICVERP K CHAR

4.34 I155 - PRFZUO - Exclusion Groups/Check Rules

Field Short Description May Be Type Remarks/Format/...
I155-JOBID JOBID M NUMERIC
I155-RECORD-NR RECNO M NUMERIC
I155-IMP-ERROR IMP-ERR K CHAR
I155-GRP GRP M CHAR
I155-PRF PRF M CHAR

4.35 I159 - PRDGRP - Products/Product Groups

Field Short Description May Be Type Remarks/Format/...
I159-JOBID JOBID M NUMERIC
I159-RECORD-NR RECNO M NUMERIC
I159-IMP-ERROR IMP-ERR K CHAR
I159-PRDGRP PRDGRP M CHAR
I159-SPRID-PRDGRP LGNCDE-I M CHAR
I159-BEMERK1-UC BEMERK1 M UNICODE
I159-KURZW-PRDGRP-UC KURZW K UNICODE
I159-COADFN COADFN M CHAR
I159-KTOM COADFN M CHAR
I159-KTO2M KTO2 K CHAR
I159-KSTKTP CNT-COADFN K CHAR
I159-KSTM CNT-ELIM K CHAR
I159-GUELTIG-AB GUE-AB M DATE
I159-GUELTIG-BIS GUE-BIS K DATE

4.36 I161 - PRDMGN - Product Margins

Field Short Description May Be Type Remarks/Format/...
I161-JOBID JOBID M NUMERIC
I161-RECORD-NR RECNO M NUMERIC
I161-IMP-ERROR IMP-ERR K CHAR
I161-CODT CODT M CHAR
I161-BUDT BUDT K CHAR
I161-CLSDTE-MON-JAHR CLSDTE-I M PERIOD
I161-FCT FCT-I M CHAR
I161-PRDGRP PRDGRP M CHAR
I161-CODT-AN ICGES M CHAR
I161-BUDT-AN ICUBR K CHAR
I161-ZU-AB-SATZ ZUAB K DECIMAL
I161-BEMERKUNG-UC BEMERK K UNICODE

4.37 I127 - REPLNDFN - Report Line Descriptions

Field Short Description May Be Type Remarks/Format/...
I127-JOBID JOBID M NUMERIC
I127-RECORD-NR RECNO M NUMERIC
I127-IMP-ERROR IMP-ERR K CHAR
I127-REPAGB REPAGB M CHAR
I127-LFDNR LFDNR M NUMERIC
I127-AGBM AGB M CHAR
I127-AGGM AGG M CHAR
I127-ZEILENTYP ZEITYP M CHAR KON/OTHOBJ Object=Z02
I127-WERT-KNZ WERTKZ M CHAR KON/OTHOBJ Object=W01
I127-SUMME-EX EX K NUMERIC
I127-SUMME-IN IN K NUMERIC
I127-VORSCHUB-CF CF K CHAR KON/OTHOBJ Object=V02
I127-VORSCHUB-NACH NACH K CHAR KON/OTHOBJ Object=V03
I127-UNTERSTRICH UNT K CHAR KON/OTHOBJ Object=U02
I127-BEDINGUNG BEDING K NUMERIC
I127-UEB-AGBM UEBAGB K CHAR
I127-UEB-AGGM UEBAGG K CHAR
I127-CNSFNC CNSFNC K CHAR
I127-KLEINER-NULL WERT-KL K CHAR KON/OTHOBJ Object=W10
I127-GLEICH-NULL WERT-GL K CHAR KON/OTHOBJ Object=W10
I127-GROESSER-NULL WERT-GR K CHAR KON/OTHOBJ Object=W10
I127-OLAP-AGBM OLAAGB K CHAR
I127-OLAP-AGGM OLAAGG K CHAR
I127-FARBE-VO VOFA K COLOUR
I127-FARBE-HI HIFA K COLOUR
I127-SCHR-SCHNITT SSCH K CHAR KON/OTHOBJ Object=FO1
I127-SCHR-GRAD SGRD K NUMERIC
I127-BSLKMPL BSLKMPL K CHAR
I127-SSPKMPL SSPKMPL K CHAR

4.38 I108 - PRVTRN - Reserve Movements

Field Short Description May Be Type Remarks/Format/...
I108-JOBID JOBID CHAR
I108-RECORD-NR RECNO CHAR
I108-IMP-ERROR IMP-ERR CHAR
I108-CLSDTE-MON-JAHR CLSDTE-I M PERIOD
I108-BELEG-GES1 VCH-GES1 K CHAR
I108-BELEG-GES2 VCH-GES2 K CHAR
I108-BELEG-CNSFNC VCH-CNSFNC K CHAR
I108-BEMERK1-UC BUTXT K UNICODE
I108-BEWDAT BEWDAT M DATE
I108-FCT FCT-I M CHAR
I108-CODT CODT M CHAR
I108-CODT-AN IC-CODT K CHAR
I108-KTOM COADFN M CHAR
I108-COADFN COADFN K CHAR
I108-SOLL-HAB-KNZ SOLL-HAB K CHAR KON/OTHOBJ Object=S01
I108-UAW UAW K CHAR KON/OTHOBJ Object=UAW
I108-UAW-PW UAW-PW K CHAR KON/OTHOBJ Object=UAP
I108-BUDT BUDT K CHAR
I108-BUDT-AN IC-BUDT K CHAR
I108-WERT-KW WERT-KW K DECIMAL
I108-WERT-LW WERT-LW M DECIMAL
I108-WERT-PW WERT-PW K DECIMAL
I108-WK-BETRAG WKURS K DECIMAL
I108-WK-BETRAG-PW WKURS-PW K DECIMAL
I108-WK-DATEND-PW DATENDPW K DATE
I108-WK-DATEND DATEND K DATE
I108-KTK KTK K CHAR
I108-BSLKMPL BSLKMPL K CHAR

4.39 I108 - DEVTRN - Individual Development Transactions

Field Short Description May Be Type Remarks/Format/...
I108-JOBID JOBID CHAR
I108-RECORD-NR RECNO CHAR
I108-IMP-ERROR IMP-ERR CHAR
I108-CLSDTE-MON-JAHR CLSDTE-I M PERIOD
I108-BELEG-GES1 VCH-GES1 K CHAR
I108-BELEG-GES2 VCH-GES2 K CHAR
I108-BELEG-CNSFNC VCH-CNSFNC K CHAR
I108-BEMERK1-UC BUTXT K UNICODE
I108-FCT FCT-I M CHAR
I108-CODT CODT M CHAR
I108-CODT-AN IC-CODT K CHAR
I108-KTOM COADFN M CHAR
I108-COADFN COADFN K CHAR
I108-KTK KTK K CHAR
I108-SOLL-HAB-KNZ SOLL-HAB K CHAR KON/OTHOBJ Object=S01
I108-UAW UAW K CHAR KON/OTHOBJ Object=UAW
I108-BUDT BUDT K CHAR
I108-UAW-PW UAW-PW K CHAR KON/OTHOBJ Object=UAP
I108-BUDT-AN IC-BUDT K CHAR
I108-WERT-KW WERT-KW K DECIMAL
I108-WERT-LW WERT-LW M DECIMAL
I108-WERT-PW WERT-PW K DECIMAL
I108-WK-BETRAG WKURS K DECIMAL
I108-WK-BETRAG-PW WKURS-PW K DECIMAL
I108-WK-DATEND DATEND K DATE
I108-WK-DATEND-PW DATENDPW K DATE
I108-BEWDAT BEWDAT M DATE
I108-BSLKMPL BSLKMPL K CHAR

4.40 I120 - BUDT - Business Areas

Field Short Description May Be Type Remarks/Format/...
I120-JOBID JOBID M NUMERIC
I120-RECORD-NR RECNO M NUMERIC
I120-IMP-ERROR IMP-ERR K CHAR
I120-BUDT BUDT M CHAR
I120-SPRID-BUDT LGNCDE-I K CHAR
I120-BENE1-BUDT-UC BENE1 M UNICODE
I120-KURZW-BUDT-UC KURZW K UNICODE
I120-GUELTIG-AB GUE-AB M DATE
I120-GUELTIG-BIS GUE-BIS K DATE
I120-AGG-KNZ AGGKNZ K CHAR KON/OTHOBJ Object=A13

4.41 I125 - UBRUBR - Business Unit Hierarchy Assignments

Field Short Description May Be Type Remarks/Format/...
I125-JOBID JOBID M NUMERIC
I125-RECORD-NR RECNO M NUMERIC
I125-IMP-ERROR IMP-ERR K CHAR
I125-BUDT BUDT M CHAR
I125-UBRU UUBR M CHAR

4.42 I112 - FXCDE - Currency Codes

Field Short Description May Be Type Remarks/Format/...
I112-JOBID JOBID M NUMERIC
I112-RECORD-NR RECNO M NUMERIC
I112-IMP-ERROR IMP-ERR K CHAR
I112-FXCDE FXCDE M CHAR
I112-SPRID-FXCDE LGNCDE K CHAR
I112-BENE1-FXCDE-UC WKZBENE1 M UNICODE
I112-KURZW-FXCDE-UC KURZW M UNICODE
I112-FAKTOR FAKTOR M CHAR
I112-ANZ-NK ANZ-NK K CHAR
I112-GUELTIG-AB GUE-AB M DATE
I112-GUELTIG-BIS GUE-BIS K DATE

4.43 I118 - FXRTE - Exchange Rates

Field Short Description May Be Type Remarks/Format/...
I118-JOBID JOBID M NUMERIC
I118-RECORD-NR RECNO M NUMERIC
I118-IMP-ERROR IMP-ERR K CHAR
I118-FXCDE FXCDE M CHAR
I118-FCT FCT M CHAR
I118-WKA WKA M CHAR KON/OTHOBJ Object=WKA
I118-DATEND STICHTWK M DATE
I118-ZEITBEZUG ZEITBEZ M CHAR KON/OTHOBJ Object=Z03
I118-BETRAG WKURS M DECIMAL

Published:

Import/Export Jobs


Table of contents


1 General

In addition to the "classic" import variant via files (txt files, ASCII files) and direct import via an application interface, the third way to transfer data to be imported to IDL Konsis is via special import database tables. This is particularly interesting for interfaces that are realized with the help of the IDL Importer, since this tool specializes in reading data from databases and writing them into databases. If the specifications described in more detail below are adhered to, these database tables can also be written using other tools.

Special notes:

The description is based on the table names, as the standard views are structured in the same way.

But acc. IDL Konsis Standard is only ever read and written via the corresponding VIEWs (table name plus Appendix '01') or (table name plus Appendix '02').

2 Description of Table Completion

2.1 General Structure Description

I000 - JOB ID
Managing the JOB numbers.
I001 - JOB Control
This table is used for information about the delivered data and for controlling the processing.
I003 - Import Protocol
This table is used to store/display import logs.
I005 - Importer Parameter Handover Table
This table is used to store the parameters for the UNLOAD routines via the IDL importer.
I1XX - Application Data
The application-specific data for each JOB ID is provided in the tables (see below).

2.2 Specificity of the Data Type Timestamp

The data type TIMESTAMP is implemented differently in the 3 supported database systems for conformity reasons. The database type TIMESTAMP is used only in DB2. It is stored in ORACLE and MS SQLServer using VARCHAR(26). The format for this is fixed and is 'YYYY-MM-DD-HH24.MI.SS.ff' in ORACLE syntax. It contains six-digit millisecond data, an example of which looks like this: ‘2011-03-01-15.35.32.00000'

The following SQL artifacts must be used to set the current date, for example:

DB2:
"Current timestamp"
ORACLE:
"TO_CHAR(SYSTIMESTAMP, 'YYYY-MM-DD-HH24.MI.SS.ff')"
MS SQL Server:
"(REPLACE(REPLACE((CONVERT(VARCHAR(23), CURRENT_TIMESTAMP, 121) + '000'),':','.'),' ','-'))"

2.3 Table I000 - JOB ID

To load data into the tables, the next JOB ID must be searched. Determining this unique number is the responsibility of the user. It is recommended to use the prepared Table I000 for this purpose. The sequence name "NEXT_JOBID" (I000_Oxide_NAME) and a value to be added (I000_ACT_VAL) must be entered once in this report.

This job ID must be used when writing the data to the other tables (I001 and I1xx).

2.4 Table I001 - JOB Steering

The overview "IE Job Control" (short word IEJBCN or via the action menu from the call application IMPT) shows all jobs contained in the special import tables. Before data can be written to the import table, a new job must be defined directly in the database. Table I001 shows this. The attributes must be documented as follows (the highlighted attributes must be completed):

Attribute Short Description Meaning
I001_JOBID lfd. Number of the job The next Job ID must be entered. Determining this unique number is the responsibility of the user. It is recommended to use the prepared Table I000 for this purpose. The sequence name "NEXT_JOBID" (I000_Oxide_NAME) and a value to be added (I000_ACT_VAL) must be entered once in this report.
I001_USERID USER ID User Id in IDL Konsis, under which this job is to be performed in IDL Konsis.
I001_ENABLED Release (Y/N) Allows you to control the job release for execution. Only if the value is 'Y', it is possible to complete this job.
I001_FOLLOW_JOBID lfd. Number of follow-on jobs Not yet implemented
I001_WITH_DELETE Import with previous delete (Y/N) License plate number whether existing data should be deleted beforehand
I001_START_FROM Earliest import date Time from when the import can be carried out as early as possible. To be entered as TIMESTAMP (date plus time) in accordance with the relevant DBMS.
I001_JOB_START Beginning Start time of the job. TIMESTAMP (date plus time) in accordance with the relevant DBMS.
I001_JOB_END End Job end time. TIMESTAMP (date plus time) in accordance with the relevant DBMS.
I001_JOB_SUCCESS Success status of the job (Y/N) Indicator of success or failure
I001_IEF_PROJID Project ID Job ID. The value 'KON' must be entered here for the import.
I001_IEF_OBJTYP Object Type Object type of the job. The value 'IEO' for the import has to be entered here.
I001_IEF_OBJID Object ID Job data type. The key according to the Import/Export Format Definition (IEFID) must be entered here for the import, e.g. 'ACBAL' for account balances.
I001_MODIFIER Used for the last change
I001_DATETIME Date of last change TIMESTAMP (date plus time) in accordance with the relevant DBMS.
I001_LOCKUSER LOCK user identification
I001_LOCKDATE LOCK time TIMESTAMP (date plus time) in accordance with the relevant DBMS.
I001_JOB_CREATOR Data supplier Text to indicate where the job data comes from, e.g. Importer.
I001_JOB_CREATED Time of data delivery When was the data imported into the import table? To be entered as TIMESTAMP (date plus time) in accordance with the relevant DBMS.
I001_HERKUNFT Data origin Special identification of the data origin to control special checks or implementation routines (e.g. in SAP, to eliminate the leading zeros in account number) in the import. Possible source: empty, 'KONSIS', 'WINKONS', 'SAP', 'VARIAL', 'AXAPTA', 'DCW', 'CONNECTOR' (and 'QUICK RECORDING').
I001_BEMERK1_UC Remark This comment field (as a UNIOCODE field) is available to the supplier, administrator or user to set optional text. For example, information about key fields for company, facts, etc. can be set here.

2.5 Table I005 - Importer Parameter Handover Table

This table is used when the entry "idlimporter.jar" is defined in the external menu call for "unloading from foreign system" (see Import). The attributes are assigned as follows:

Attribute Short Description Meaning
I005_I001_JOBID Job Identifier The generated Job Id must be entered.
I005_A015_PROJID Project ID Constant 'KON'
I005_A015_OBJTYP Object Type MNUITM constant
I005_A015_OBJID Menu ID Menu item of the executed function (e.g. ACBAL for unload account balances)
I005_KTK Group/Sub-Group
I005_GES Company
I005_ABR_MON_JAHR Period
I005_VGL_ABR Off-Period
I005_FAC Fact
I005_EX_FAC Ex-fact
I005_KTP Chart of accounts
I005_CNT Chart of controlling objects
I005_POP Chart of positions
I005_REPID Report ID
I005_IEFID Format ID e.g. #DSCTXT for standard formats
I005_UMS Transfer group
I005_UBR Business unit
I005_SPR Language
I005_VORTRAG_KENNZ License plate with/without carry forward
I005_SPIEGEL Transaction development
I005_DBNAME Database name
I005_A016_USERID User ID User ID of the application user

2.6 Table I1XX - Application Data

The following data sets (object types) are supported for handover by JOB:

Object Type Description Import Table With Previous Delete Target Table
ACBAL Account balances I100 Y K003
ICACBAL IC sub-account balances I101 Y K039
ICKONV IC P+L sub-account balances I101 N K039
CNTSAL Controlling balances I102 Y K041
KST Controlling objects I103 N K063
FATRN Fixed asset transactions I104 Y K042
ICFATRN IC Fixed asset transactions I104 Y K042
COADFN Accounts I105 N K010
POSDFN Positions I106 N K022
POSKTO Position+account assignments I107 Y K023
CAPTRN Capital transactions I108 Y K038
PRVTRN Reserve movements I108 Y K038
DEVTRN Individual development transactions I108 Y K038
CNTCDE Country indicator I109 N K009
CODT Companies I110 N K001
FXCDE Currency code I112 N K006
COADFN Charts of accounts I113 N K013
CNTCNT Controlling object hierarchy assignments I115 N K015
POSKTOP Position+account assignments - periodic I117 J K020
FXRTE Exchange rates I118 N K008
AGB Deadlines for submission I119 N K007
BUDT Business areas I120 N K005
UBRUBR Business unit hierarchy assignments I125 N K015
REPLNDFN Line Description report I127 Y K027
PERATH Period authorization I132 N A032
MNUATH Menu authorization I132 N A032
OBJATH Object authorization I132 N A032
ICFAOBJ IC Fixed Asset Objects I140 N K040
FAOBJ Fixed asset objects per account I140 N K040
GRPMNR Group/sub-group circle I144 N K044
SHRPAR Shareholding transactions I145 Y K045
CNSFNC Consolidation function I147 N K047
CNSVCH Consolidation vouchers I148 N K048
CNSPST Consolidation postings I149 Y K049
PRF Check rules I151 N K051
PRFPOS Check rules/positions I152 N K052
PRFGRP Check rule groups I154 N K054
PRFZUO Exclusion groups/check rules I155 N K055
PRDGRP Products/product groups I159 N K059
PRDMGN Product margins I161 Y K061
ICSTCK Stocks ICs I162 Y K062
VCH Vouchers I167 N K067
PST Postings I168 Y K068

For this purpose, a special import table in the database is defined in IDL Konsis for each database. In addition to the attributes for the data to be imported, this contains a header that contains a job number. This job number is used to identify the data that relates to each job. The attributes are sometimes longer than in the original table to allow for the conversion of external keys into internal keys. In addition to the attributes defined in #DB format, the following are included in the import tables (the highlighted attributes must be completed):

Attribute Short Description Meaning
I1XX_JOBID Number of the job Associated Job Id in I001
I1XX_RECORD_NR Order number lfd. Number of record related to job
I1XX_IMP_ERROR Error importing? (Y/N) Indicator whether this record has been imported
I1XX_MODIFIER Used for the last change
I1XX_DATETIME Date of last modification TIMESTAMP (date plus time) in accordance with the relevant DBMS.
I1XX_LOCKUSER LOCK user identification
I1XX_LOCKDATE LOCK time TIMESTAMP (date plus time) in accordance with the relevant DBMS.

The application-specific data will then follow. (See description of format types #DB in IEFEL)

When writing the data to the import table, the job number of the created job must be used.

3 Import of Data

3.1 IE Job Management Application (IEJBCN)

The actual import can then be started via the object menu via the application "IE Job-Steuerung" (IEJBCN). The start and exit of this process and a processing status are then recorded in the IE Job control.

Import/export format '#DB' is used for import, which is marked with the new format type 'TABLE' in the Import/Export Formats (IEFID) table. In this IEFID definition, the attribute 'Default filename table' contains the name of the import table.

The fields of the respective format are defined in the ALLCFLD application. The fields of the import tables are in ID "#DB" format and can be identified by the same prefix in the ID field. The attributes of the database tables are selected according to the field IDs in IEFLD, where for technical reasons "-" has been replaced by "_". For example, in the ACBAL format, the field for the FCT facts has the ID I100-FCT and accordingly the attribute in the database table I100_FAC is set.

Messages that are loaded into the temporary table and imported are also logged in a database table instead of a file. This error log can be viewed from the new "Import Error Log" overview, which is reached via the object menu of the IE job control. In this protocol, the "Job Step" parameter distinguishes between messages in the data delivery and messages in the import.

An import job can be deleted completely using the "delete" action in the IE Job control. In addition to the job control set, this delete also includes all data records in the associated import table and the associated error log.

The "IE Job-Data Copy" action in the IE Job-Controller allows you to copy the data of the import job. A new job is created. If available, you can select whether you want to copy only the incorrectly marked records or all of them.

3.2 Command Line

In addition to the option described above for managing jobs in the "IE Job Control" application, it is also possible to start jobs on the command line by invoking imports. This is described under: Start of import from command line

4 Description of Import Data Tables

The contents of certain fields must match the "key values" (object ID) and not the "external key" according to. Application KON/OTHOBJ - Other Objects - (Table A019). The relevant object type is saved in the description under "Remarks" for the affected fields.

4.1 I119 - SUBDTE - Income Tax Deadlines

Field Short Description May Be Type Remarks/Format/...
I119-JOBID JOBID M NUMERIC
I119-RECORD-NR RECNO M NUMERIC
I119-IMP-ERROR IMP-ERR K CHAR
I119-CLSDTE-MON-JAHR CLSDTE M PERIOD
I119-FCT FCT M CHAR
I119-CHECK-POINT CHKP K CHAR
I119-CODT CODT CHAR
I119-ABGABE ABGTERM M DATE
I119-WARNFRIST WARNFR K NUMERIC
I119-WARNFRIST-OBJTYP WARNTYPE K CHAR

4.2 I104 - FATRN - Fixed Asset Transactions

Field Short Description May Be Type Remarks/Format/...
I104-JOBID JOBID M NUMERIC
I104-RECORD-NR RECNO M NUMERIC
I104-IMP-ERROR IMP-ERR CHAR
I104-CODT CODT M CHAR
I104-ANL ANL M CHAR
I104-FCT FCT-I M CHAR
I104-CLSDTE-MON-JAHR CLSDTE-I M PERIOD
I104-BEWDAT BEWDAT M DATE
I104-WERT-LW WERT-LW M DECIMAL
I104-SOLL-HAB-KNZ SOLL-HAB K CHAR KON/OTHOBJ Object=S01
I104-UAW UAW K CHAR KON/OTHOBJ Object=UAW
I104-WK-DATEND DATEND K DATE
I104-WK-BETRAG WKURS K DECIMAL
I104-GEGEN-ANL GEGENANL K CHAR
I104-BELEG-GES1 VCH-GES1 K CHAR
I104-BELEG-GES2 VCH-GES2 K CHAR
I104-BELEG-CNSFNC VCH-CNSFNC K CHAR
I104-WERT-KW WERT-KW K DECIMAL
I104-WERT-PW WERT-PW K DECIMAL
I104-BUDT BUDT K CHAR
I104-CODT-AN CODT-AN K CHAR
I104-UAW-PW UAW-PW K CHAR KON/OTHOBJ Object=UAP
I104-WK-DATEND-PW DATENDPW K DATE
I104-WK-BETRAG-PW WKURS-PW K DECIMAL
I104-BUDT-AN BUDT-AN K CHAR
I104-COADFN COADFN K CHAR
I104-BEMERK1-UC BUTXT K UNICODE
I104-BSLKMPL BSLKMPL K CHAR
I104-KTOM COADFN K CHAR

4.3 I140 - FAOBJ - Fixed Asset Objects per Account

Field Short Description May Be Type Remarks/Format/...
I140-JOBID JOBID M NUMERIC
I140-RECORD-NR RECNO M NUMERIC
I140-IMP-ERROR IMP-ERR K CHAR
I140-CODT CODT M CHAR
I140-ANLM ANL M CHAR
I140-BEMERK1-UC BEMERK1 M UNICODE
I140-KTPM COADFN M CHAR
I140-KTOM COADFN M CHAR
I140-ANSCHAFF-DAT AN-DAT M DATE
I140-GESKON GESKON M CHAR KON/OTHOBJ Object=A12
I140-DPN-ART DPN-ART M CHAR KON/OTHOBJ Object=A03
I140-DPN-PROZ DPN-PROZ K CHAR
I140-DPN-KTOM DPN-COADFN K CHAR
I140-VERKAUF-DAT VK-DAT K DATE
I140-GUELTIG-AB GUE-AB K DATE
I140-GUELTIG-BIS GUE-BIS K DATE
I140-KTK KTK K CHAR
I140-KONZANLM KONZ-ANL K CHAR
I140-DPN-ZEIT DPN-DAU K CHAR
I140-DPN-BETRAG BETRAG K DECIMAL
I140-KSTKTP KST-COADFN K CHAR
I140-KSTM KST K CHAR
I140-FXCDE FXCDE K CHAR
I140-GESCH-WERT-LW LWSOLL K DECIMAL
I140-WB-KTOM WB-COADFN K CHAR
I140-UBR1 DPN-BUDT K CHAR

4.4 I167 - VCH - Vouchers

Field Short Description May Be Type Remarks/Format/...
I167-JOBID JOBID M NUMERIC
I167-RECORD-NR RECNO M NUMERIC
I167-IMP-ERROR IMP-ERR K CHAR
I167-CODT CODT M CHAR
I167-BUDT BUDT M CHAR
I167-CLSDTE-MON-JAHR CLSDTE-I M PERIOD
I167-FCT FCT M CHAR
I167-BELEG-NR BELEGNR M CHAR
I167-BELEGDAT BELDAT M DATE
I167-BUCHUNGSART BUCHART M CHAR KON/OTHOBJ Object=B03
I167-CMPCNT-KNZ VRBKNZ M CHAR
I167-BEMERK1-UC BEMERK1 K UNICODE
I167-MELDUNG MELDUNG K CHAR
I167-ZIEL-FCT Z-FCT K CHAR
I167-LS-STATUS LSSTATUS K CHAR KON/OTHOBJ Object=L01
I167-VCHCLA VCHCLA K CHAR

4.5 I132 - PERATH - Period Authorization

Field Short Description May Be Type Remarks/Format/...
I132-JOBID JOBID M NUMERIC
I132-RECORD-NR RECNO M NUMERIC
I132-IMP-ERROR IMP-ERR K CHAR
I132-OPROJID BENPRJ-I K CHAR Automatic filling
I132-OOBJTYP BENTYP-I K CHAR Automatic completion (USR)
I132-OOBJID OBJATH M CHAR User
I132-UPROJID OBJPRJ K CHAR Automatic filling
I132-UOBJTYP OBJTYP K CHAR Automatic filling (CLSDTE)
I132-UABR-MON-JAHR CLSDTE M PERIOD
I132-SEL BER1 M CHAR IAR/OTHOBJ Object=B01 See Application. NAME
I132-UPD BER2 K CHAR IAR/OTHOBJ Object=B01 s. Application. NAME
I132-INS BER3 K CHAR IAR/OTHOBJ Object=B01 s. Application. NAME
I132-DEL BER4 K CHAR IAR/OTHOBJ Object=B01 s. Application. NAME
I132-COP BER5 K CHAR IAR/OTHOBJ Object=B01 s. Application. NAME
I132-VAR BER6 K CHAR -blank
I132-BE7 BER7 K CHAR -blank
I132-BE8 BER8 K CHAR -blank
I132-BE9 BER9 K CHAR -blank
I132-BE0 BER0 K CHAR -blank

4.6 I132 - MNUATH - Menu Authorization

Field Short Description May Be Type Remarks/Format/...
I132-JOBID JOBID M NUMERIC
I132-RECORD-NR RECNO M NUMERIC
I132-IMP-ERROR IMP-ERR K CHAR
I132-OPROJID BENPRJ-I M CHAR Automatic filling
I132-OOBJTYP BENTYP-I M CHAR Automatic completion (USR)
I132-OOBJID OBJATH M CHAR User
I132-UPROJID OBJPRJ K CHAR IAR or KON
I132-UOBJTYP OBJTYP K CHAR Automatic filling (MNUITM)
I132-UOBJID OBJOBJ M CHAR
I132-SEL BER1 M CHAR IAR/OTHOBJ Object=B01 s. Application. NAME
I132-UPD BER2 K CHAR IAR/OTHOBJ Object=B01 s. Application. NAME
I132-INS BER3 K CHAR IAR/OTHOBJ Object=B01 s. Application. NAME
I132-DEL BER4 K CHAR IAR/OTHOBJ Object=B01 s. Application. NAME
I132-COP BER5 K CHAR IAR/OTHOBJ Object=B01 s. Application. NAME
I132-VAR BER6 K CHAR -blank
I132-BE7 BER7 K CHAR -blank
I132-BE8 BER8 K CHAR -blank
I132-BE9 BER9 K CHAR -blank
I132-BE0 BER0 K CHAR -blank

4.7 I132 - OBJATH - Object Authorization

Field Short Description May Be Type Remarks/Format/...
I132-JOBID JOBID M NUMERIC
I132-RECORD-NR RECNO M NUMERIC
I132-IMP-ERROR IMP-ERR K CHAR
I132-OPROJID BENPRJ-I M CHAR Automatic filling
I132-OOBJTYP BENTYP-I M CHAR Automatic completion (USR)
I132-OOBJID OBJATH M CHAR User
I132-UPROJID OBJPRJ K CHAR Automatic filling
I132-UOBJTYP OBJTYP K CHAR
I132-UOBJID OBJOBJ M CHAR
I132-SEL BER1 M CHAR IAR/OTHOBJ Object=B01 s. Application. NAME
I132-UPD BER2 K CHAR IAR/OTHOBJ Object=B01 s. Application. NAME
I132-INS BER3 K CHAR IAR/OTHOBJ Object=B01 s. Application. NAME
I132-DEL BER4 K CHAR IAR/OTHOBJ Object=B01 s. Application. NAME
I132-COP BER5 K CHAR IAR/OTHOBJ Object=B01 s. Application. NAME
I132-VAR BER6 K CHAR -blank
I132-BE7 BER7 K CHAR -blank
I132-BE8 BER8 K CHAR -blank
I132-BE9 BER9 K CHAR -blank
I132-BE0 BER0 K CHAR -blank

4.8 I168 - PST - Postings

Field Short Description May Be Type Remarks/Format/...
I168-JOBID JOBID M NUMERIC
I168-RECORD-NR RECNO M NUMERIC
I168-IMP-ERROR IMP-ERR K CHAR
I168-CODT CODT M CHAR
I168-BUDT BUDT K CHAR
I168-CLSDTE-MON-JAHR CLSDTE-I M PERIOD
I168-FCT FCT-I M CHAR
I168-BELEG-NR BELEGNR M CHAR
I168-PST-NR BUCHNR M CHAR
I168-CODT-AN IC-CODT K CHAR
I168-BUDT-AN IC-BUDT K CHAR
I168-COADFN COADFN K CHAR
I168-KTOM COADFN M CHAR
I168-KST1KTP KST1KTP K CHAR
I168-KST1 KST1 K CHAR
I168-ANLM FAOBJ K CHAR
I168-LW-SOLL SOLL-LW K DECIMAL
I168-LW-HABEN HABEN-LW K DECIMAL
I168-KW-SOLL SOLL-KW K DECIMAL
I168-KW-HABEN HABEN-KW K DECIMAL
I168-PW-SOLL SOLL-PW K DECIMAL
I168-PW-HABEN HABEN-PW K DECIMAL
I168-BSLKMPL BSLKMPL K CHAR
I168-UAW-PW UAP K CHAR KON/OTHOBJ Object=UAP
I168-WK-DATEND-PW DATENDPW K DATE
I168-WK-BETRAG-PW WKURS-PW K DECIMAL
I168-LT-KNZ LT-KNZ K CHAR KON/OTHOBJ Object=L08
I168-UAW-KW UAW K CHAR KON/OTHOBJ Object=UAW
I168-WK-DATEND-KW DATEND K DATE
I168-WK-BETRAG-KW WKURS K DECIMAL
I168-TW-SOLL SOLL-TW K DECIMAL
I168-TW-HABEN HABEN-TW K DECIMAL
I168-FXCDE-TW FXCDE-TW K CHAR
I168-BEMERK1-UC BEMERK1 K UNICODE
I168-KST2KTP KST2KTP K CHAR
I168-KST2 KST2 K CHAR
I168-KST3KTP KST3KTP K CHAR
I168-KST3 KST3 K CHAR
I168-KST4KTP KST4KTP K CHAR
I168-KST4 KST4 K CHAR
I168-KST5KTP KST5KTP K CHAR
I168-KST5 KST5 K CHAR
I168-KST6KTP KST6KTP K CHAR
I168-KST6 KST6 K CHAR
I168-KST7KTP KST7KTP K CHAR
I168-KST7 KST7 K CHAR
I168-KST8KTP KST8KTP K CHAR
I168-KST8 KST8 K CHAR
I168-KST9KTP KST9KTP K CHAR
I168-KST9 KST9 K CHAR
I168-KST0KTP KST0KTP K CHAR
I168-KST0 KST0 K CHAR
I168-PST-BUDT BU-BUDT K CHAR

4.9 I115 - CNTCNT - Controlling Object Hierarchy Assignments

Field Short Description May Be Type Remarks/Format/...
I115-JOBID JOBID M NUMERIC
I115-RECORD-NR RECNO M NUMERIC
I115-IMP-ERROR IMP-ERR K CHAR
I115-COADFN COADFN M CHAR
I115-KSTM KST M CHAR
I115-KSTU UKST M CHAR

4.10 I102 - CNTSAL - Controlling Balances

Field Short Description May Be Type Remarks/Format/...
I102-JOBID JOBID M NUMERIC
I102-RECORD-NR RECNO M NUMERIC
I102-IMP-ERROR IMP-ERR K CHAR
I102-CODT CODT M CHAR
I102-BUDT BUDT K CHAR
I102-COADFN COADFN K CHAR
I102-COADFN COADFN M CHAR
I102-CLSDTE-MON-JAHR CLSDTE-I M PERIOD
I102-FCT FCT-I M CHAR
I102-WERT-LW WERT-LW M DECIMAL
I102-SOLL-HAB-KNZ SOLL-HAB K CHAR KON/OTHOBJ Object=S01
I102-WERT-KW WERT-KW K DECIMAL
I102-WERT-PW WERT-PW K DECIMAL
I102-KST1KTP KST1KTP K CHAR
I102-KST1 KST1 K CHAR
I102-KST2KTP KST2KTP K CHAR
I102-KST2 KST2 K CHAR
I102-KST3KTP KST3KTP K CHAR
I102-KST3 KST3 K CHAR
I102-KST4KTP KST4KTP K CHAR
I102-KST4 KST4 K CHAR
I102-KST5KTP KST5KTP K CHAR
I102-KST5 KST5 K CHAR
I102-KST6KTP KST6KTP K CHAR
I102-KST6 KST6 K CHAR
I102-KST7KTP KST7KTP K CHAR
I102-KST7 KST7 K CHAR
I102-KST8KTP KST8KTP K CHAR
I102-KST8 KST8 K CHAR
I102-KST9KTP KST9KTP K CHAR
I102-KST9 KST9 K CHAR
I102-KST0KTP KST0KTP K CHAR
I102-KST0 KST0 K CHAR
I102-BEMERK1-UC BEMERK1 K UNICODE

4.11 I110 - CODT - Companies

Field Short Description May Be Type Remarks/Format/...
I110-JOBID JOBID M NUMERIC
I110-RECORD-NR RECNO M NUMERIC
I110-IMP-ERROR IMP-ERR K CHAR
I110-CODT CODT M CHAR
I110-BENE1-CODT-UC BENE1 M UNICODE
I110-KURZW-CODT-UC KURZW K UNICODE
I110-STRASSE STR K CHAR
I110-PLZ PLZ K CHAR
I110-ORT ORT K CHAR
I110-TELEFON TEL K CHAR
I110-TELEFAX TELFAX K CHAR
I110-EMAIL EMAIL K CHAR
I110-URL URL K CHAR
I110-ANSPR-PARTNER ANSPR K CHAR
I110-CNTCDE CNTCDE M CHAR
I110-FXCDE FXCDE M CHAR
I110-SPRID SPRID M CHAR
I110-ABW-GESCHJAHR ABWGJ K DATE
I110-GUELTIG-AB GUE-AB M DATE
I110-GUELTIG-BIS GUE-BIS K DATE
I110-COADFN COADFN M CHAR
I110-KST-COADFN KSTKTP K CHAR
I110-KST-KTP2 KSTKTP2 K CHAR
I110-KST-KTP3 KSTKTP3 K CHAR
I110-KST-KTP4 KSTKTP4 K CHAR
I110-KST-KTP5 KSTKTP5 K CHAR
I110-KST-KTP6 KSTKTP6 K CHAR
I110-KST-KTP7 KSTKTP7 K CHAR
I110-KST-KTP8 KSTKTP8 K CHAR
I110-KST-KTP9 KSTKTP9 K CHAR
I110-KST-KTP0 KSTKTP0 K CHAR
I110-PRFGRP PRFGRP K CHAR
I110-MERGE-DATE MG-DATE K DATE
I110-MERGE-CODT MG-CODT K CHAR
I110-LIC-TYPE-KON LICTKON K CHAR
I110-LIC-TYPE-FC LICTFC K CHAR
I110-LIC-TYPE-XLS LICTXLS K CHAR
I110-STEUERNR STEUERNR K CHAR
I110-CODT-ART GESART K CHAR
I110-RECHTSFORM-UC RECHTSF K UNICODE
I110-HANDELSREG-UC HANDREG K UNICODE
I110-HANDELSREG-NR HANDREGN K CHAR
I110-TIN TIN K CHAR
I110-GESCH-TAET-UC GESTAET K UNICODE
I110-ADDR-TYPE ADDRTYPE K CHAR
I110-BUILDING-ID BUILDID K CHAR
I110-POB POB K CHAR
I110-SUITE-ID SUITEID K CHAR
I110-FLOOR-ID FLOORID K CHAR
I110-SUBCOUNTRY-UC SUBCTRY K UNICODE
I110-DISTRICT-UC DISTRICT K UNICODE
I110-ADDRESS-UC ADDRESS K UNICODE

4.12 I145 - SHRPAR - Shareholding Transactions

Field Short Description May Be Type Remarks/Format/...
I145-JOBID JOBID M NUMERIC
I145-IMP-ERROR IMP-ERR K CHAR
I145-RECORD-NR RECNO M NUMERIC
I145-CODT CODT M CHAR
I145-COADFN COADFN K CHAR
I145-KTOM COADFN M CHAR
I145-FCT FCT-I M CHAR
I145-CLSDTE-MON-JAHR CLSDTE M PERIOD
I145-BEWDAT BEWDAT M DATE
I145-WERT-LW WERT-LW M DECIMAL
I145-SOLL-HAB-KNZ SOLL-HAB K CHAR KON/OTHOBJ Object=S01
I145-UAW UAW K CHAR KON/OTHOBJ Object=UAW
I145-WK-DATEND DATEND K DATE
I145-WK-BETRAG WKURS K DECIMAL
I145-WERT-KW WERT-KW K DECIMAL
I145-WERT-PW WERT-PW K DECIMAL
I145-WERT-TW WERT-TW K DECIMAL
I145-FXCDE FXCDE-TW K CHAR
I145-BET-PRDGRP-KAP PRDGRP-ERG K DECIMAL
I145-BET-PRDGRP-STIMM PRDGRP-STIM K DECIMAL
I145-BET-PRDGRP-ERG PRDGRP-KAP K DECIMAL
I145-KTK KTK K CHAR
I145-BUDT BUDT K CHAR
I145-CODT-AN IC-CODT M CHAR
I145-BSLKMPL BSLKMPL K CHAR
I145-UAW-PW UAW-PW K CHAR KON/OTHOBJ Object=UAP
I145-WK-DATEND-PW DATENDPW K DATE
I145-WK-BETRAG-PW WKURS-PW K DECIMAL
I145-BUDT-AN IC-BUDT K CHAR
I145-SUBDTE-KTOM AB-COADFN K CHAR
I145-SUBDTE-WERT-KW AB-W-KW K DECIMAL
I145-SUBDTE-S-H-KNZ AB-SH K CHAR
I145-BEMERK1-UC BUTXT K UNICODE
I145-BELEG-NR BELEG-NR K CHAR
I145-SUBDTE-WERT-LW AB-W-LW K DECIMAL
I145-SUBDTE-BSLKMPL AB-BSLKM K CHAR

4.13 I104 - ICFATRN - IC Fixed Asset Transactions

Field Short Description May Be Type Remarks/Format/...
I104-JOBID JOBID M NUMERIC
I104-RECORD-NR RECNO M NUMERIC
I104-IMP-ERROR IMP-ERR K CHAR
I104-CODT CODT M CHAR
I104-ANL ANL M CHAR
I104-FCT FCT-I M CHAR
I104-CLSDTE-MON-JAHR CLSDTE-I M PERIOD
I104-BEWDAT BEWDAT M DATE
I104-WERT-LW WERT-LW M DECIMAL
I104-SOLL-HAB-KNZ SOLL-HAB K CHAR KON/OTHOBJ Object=S01
I104-UAW UAW K CHAR KON/OTHOBJ Object=UAW
I104-WK-DATEND DATEND K DATE
I104-WK-BETRAG WKURS K DECIMAL
I104-GEGEN-ANL GEGENANL K CHAR
I104-BELEG-GES1 VCH-GES1 K CHAR
I104-BELEG-GES2 VCH-GES2 K CHAR
I104-BELEG-CNSFNC VCH-CNSFNC K CHAR
I104-WERT-KW WERT-KW K DECIMAL
I104-WERT-PW WERT-PW K DECIMAL
I104-BUDT BUDT K CHAR
I104-CODT-AN CODT-AN K CHAR
I104-UAW-PW UAW-PW K CHAR KON/OTHOBJ Object=UAP
I104-WK-DATEND-PW DATENDPW K DATE
I104-WK-BETRAG-PW WKURS-PW K DECIMAL
I104-BUDT-AN BUDT-AN K CHAR
I104-COADFN COADFN K CHAR
I104-BEMERK1-UC BUTXT K UNICODE
I104-BSLKMPL BSLKMPL K CHAR
I104-KTOM COADFN K CHAR

4.14 I140 - ICFAOBJ - IC Fixed Asset Objects

Field Short Description May Be Type Remarks/Format/...
I140-JOBID JOBID M NUMERIC
I140-RECORD-NR RECNO M NUMERIC
I140-IMP-ERROR IMP-ERR K CHAR
I140-CODT CODT M CHAR
I140-ANLM ANL M CHAR
I140-BEMERK1-UC BEMERK1 M UNICODE
I140-KTPM COADFN M CHAR
I140-KTOM COADFN M CHAR
I140-ANSCHAFF-DAT AN-DAT M DATE
I140-GESKON GESKON M CHAR KON/OTHOBJ Object=A03
I140-DPN-ART DPN-ART M CHAR KON/OTHOBJ Object=A12
I140-DPN-PROZ DPN-PROZ K CHAR
I140-DPN-KTOM DPN-COADFN K CHAR
I140-VERKAUF-DAT VK-DAT K DATE
I140-VK-CODT VK-CODT K CHAR
I140-VK-KTOM VK-COADFN K CHAR
I140-VK-ERLOES VK-WERT K DECIMAL
I140-SOLL-HAB-KNZ VK-SH K CHAR KON/OTHOBJ Object=S01
I140-UR-CODT UR-CODT K CHAR
I140-UR-ANLM UR-ANL K CHAR
I140-GUELTIG-AB GUE-AB K DATE
I140-GUELTIG-BIS GUE-BIS K DATE
I140-KTK KTK K CHAR
I140-KONZANLM KONZ-ANL K CHAR
I140-DPN-ZEIT DPN-DAU K CHAR
I140-DPN-BETRAG BETRAG K DECIMAL
I140-KSTKTP KST-COADFN K CHAR
I140-KSTM KST K CHAR
I140-WB-KTOM WB-COADFN K CHAR
I140-UBR1 DPN-BUDT K CHAR

4.15 I162 - ICSTCK - Stocks IC Stocks

Field Short Description May Be Type Remarks/Format/...
I162-JOBID JOBID M NUMERIC
I162-RECORD-NR RECNO M NUMERIC
I162-IMP-ERROR IMP-ERR K CHAR
I162-CODT CODT M CHAR
I162-BUDT BUDT K CHAR
I162-CLSDTE-MON-JAHR CLSDTE-I M PERIOD
I162-FCT FCT-I M CHAR
I162-PRDGRP PRDGRP M CHAR
I162-CODT-AN ICGES M CHAR
I162-BUDT-AN ICUBR K CHAR
I162-ZU-AB-SATZ ZUAB K DECIMAL
I162-WERT-LW WERT-LW M DECIMAL
I162-WERT-KW WERT-KW K DECIMAL
I162-WERT-PW WERT-PW K DECIMAL
I162-SOLL-HAB-KNZ SOLL-HAB K CHAR KON/OTHOBJ Object=S01
I162-COADFN COADFN K CHAR
I162-KTOM ELKTO M CHAR
I162-BEARB-KNZ BEAKNZ K CHAR KON/OTHOBJ Object=V04
I162-ZU-AB-WERT-KW ZUABKW K DECIMAL
I162-KSTKTP KSTKTP K CHAR
I162-KSTM KST K CHAR
I162-BEMERK1-UC BEMERK1 K UNICODE

4.16 I101 - ICKONV - IC P&L Sub-Account Balances

Field Short Description May Be Type Remarks/Format/...
I101-JOBID JOBID M NUMERIC
I101-RECORD-NR RECNO M NUMERIC
I101-IMP-ERROR IMP-ERR K CHAR
I101-CODT CODT M CHAR
I101-BUDT BUDT K CHAR
I101-COADFN COADFN K CHAR
I101-COADFN COADFN M CHAR
I101-CLSDTE-MON-JAHR CLSDTE-I M PERIOD
I101-FCT FCT-I M CHAR
I101-WERT-LW WERT-LW M DECIMAL
I101-SOLL-HAB-KNZ SOLL-HAB K CHAR KON/OTHOBJ Object=S01
I101-WERT-TW WERT-TW K DECIMAL
I101-FXCDE FXCDE-TW K CHAR
I101-CODT-AN ICGES M CHAR
I101-WERT-KW WERT-KW K DECIMAL
I101-WERT-PW WERT-PW K DECIMAL
I101-BUDT-AN ICUBR K CHAR
I101-KTK BELKTK K CHAR
I101-KST1KTP KST1KTP K CHAR
I101-KST1 KST1 K CHAR
I101-KST2KTP KST2KTP K CHAR
I101-KST2 KST2 K CHAR
I101-KST3KTP KST3KTP K CHAR
I101-KST3 KST3 K CHAR
I101-KST4KTP KST4KTP K CHAR
I101-KST4 KST4 K CHAR
I101-KST5KTP KST5KTP K CHAR
I101-KST5 KST5 K CHAR
I101-KST6KTP KST6KTP K CHAR
I101-KST6 KST6 K CHAR
I101-KST7KTP KST7KTP K CHAR
I101-KST7 KST7 K CHAR
I101-KST8KTP KST8KTP K CHAR
I101-KST8 KST8 K CHAR
I101-KST9KTP KST9KTP K CHAR
I101-KST9 KST9 K CHAR
I101-KST0KTP KST0KTP K CHAR
I101-KST0 KST0 K CHAR
I101-AUSZIFF-KNZ AUSZIF K NUMERIC
I101-REF-BELEG REFBEL K CHAR
I101-REF-DATUM REFDAT K DATE
I101-BEMERK1-UC BEMERK1 K UNICODE
I101-AUSZIFF-KNZ-2 AUSZIF-2 K DECIMAL

4.17 I101 - ICACBAL - IC Sub-Account Balances

Field Short Description May Be Type Remarks/Format/...
I101-JOBID JOBID M NUMERIC
I101-RECORD-NR RECNO M NUMERIC
I101-IMP-ERROR IMP-ERR K CHAR
I101-CODT CODT M CHAR
I101-BUDT BUDT K CHAR
I101-COADFN COADFN K CHAR
I101-COADFN COADFN M CHAR
I101-CLSDTE-MON-JAHR CLSDTE M PERIOD
I101-FCT FCT-I M CHAR
I101-WERT-LW WERT-LW M DECIMAL
I101-SOLL-HAB-KNZ SOLL-HAB K CHAR KON/OTHOBJ Object=S01
I101-WERT-TW WERT-TW K DECIMAL
I101-FXCDE FXCDE-TW K CHAR
I101-CODT-AN ICGES M CHAR
I101-WERT-KW WERT-KW K DECIMAL
I101-WERT-PW WERT-PW K DECIMAL
I101-BUDT-AN ICUBR K CHAR
I101-KTK BELKTK K CHAR
I101-KST1KTP KST1KTP K CHAR
I101-KST1 KST1 K CHAR
I101-KST2KTP KST2KTP K CHAR
I101-KST2 KST2 K CHAR
I101-KST3KTP KST3KTP K CHAR
I101-KST3 KST3 K CHAR
I101-KST4KTP KST4KTP K CHAR
I101-KST4 KST4 K CHAR
I101-KST5KTP KST5KTP K CHAR
I101-KST5 KST5 K CHAR
I101-KST6KTP KST6KTP K CHAR
I101-KST6 KST6 K CHAR
I101-KST7KTP KST7KTP K CHAR
I101-KST7 KST7 K CHAR
I101-KST8KTP KST8KTP K CHAR
I101-KST8 KST8 K CHAR
I101-KST9KTP KST9KTP K CHAR
I101-KST9 KST9 K CHAR
I101-KST0KTP KST0KTP K CHAR
I101-KST0 KST0 K CHAR
I101-AUSZIFF-KNZ-2 AUSZIF-2 K DECIMAL
I101-REF-BELEG REFBEL K CHAR
I101-REF-DATUM REFDAT K DATE
I101-BEMERK1-UC BEMERK1 K UNICODE
I101-AUSZIFF-KNZ AUSZIF K NUMERIC

4.18 I108 - CAPTRN - Capital Transactions

Field Short Description May Be Type Remarks/Format/...
I108-JOBID JOBID CHAR
I108-RECORD-NR RECNO CHAR
I108-IMP-ERROR IMP-ERR CHAR
I108-CLSDTE-MON-JAHR CLSDTE-I M PERIOD
I108-BELEG-GES1 VCH-GES1 K CHAR
I108-BELEG-GES2 VCH-GES2 K CHAR
I108-BELEG-CNSFNC VCH-CNSFNC K CHAR
I108-BEMERK1-UC BUTXT K UNICODE
I108-BEWDAT BEWDAT M DATE
I108-FCT FCT-I M CHAR
I108-CODT CODT M CHAR
I108-CODT-AN IC-CODT K CHAR
I108-KTK KTK K CHAR
I108-KTOM COADFN M CHAR
I108-COADFN COADFN K CHAR
I108-SOLL-HAB-KNZ SOLL-HAB K CHAR KON/OTHOBJ Object=S01
I108-UAW UAW K CHAR KON/OTHOBJ Object=UAW
I108-UAW-PW UAW-PW K CHAR KON/OTHOBJ Object=UAP
I108-BUDT BUDT K CHAR
I108-BUDT-AN IC-BUDT K CHAR
I108-WERT-KW WERT-KW K DECIMAL
I108-WERT-LW WERT-LW M DECIMAL
I108-WERT-PW WERT-PW K DECIMAL
I108-WK-BETRAG WKURS K DECIMAL
I108-WK-BETRAG-PW WKURS-PW K DECIMAL
I108-WK-DATEND DATEND K DATE
I108-WK-DATEND-PW DATENDPW K DATE
I108-BSLKMPL BSLKMPL K CHAR

4.19 I148 - CNSVCH - Consolidation Vouchers

Field Short Description May Be Type Remarks/Format/...
I148-JOBID JOBID M NUMERIC
I148-IMP-ERROR IMP-ERR K CHAR
I148-RECORD-NR RECNO M NUMERIC
I148-KTK KTK M CHAR
I148-CLSDTE-MON-JAHR CLSDTE-I M PERIOD
I148-FCT FCT M CHAR
I148-BELEG-GES1 VCH-GES1 M CHAR
I148-BELEG-GES2 VCH-GES2 M CHAR
I148-BELEG-CNSFNC VCH-CNSFNC M CHAR
I148-BELEG-DAT BELDAT M DATE
I148-BUCHUNGSART BUCHART M CHAR KON/OTHOBJ Object=B06
I148-CMPCNT-KNZ VRBKNZ K CHAR KON/OTHOBJ Object=V04
I148-BEMERK1-UC BEMERK1 K UNICODE
I148-MELDUNG MELDUNG K CHAR
I148-LS-STATUS LSSTATUS K CHAR KON/OTHOBJ Object=L01
I148-KA-STATUS KASTATUS K CHAR KON/OTHOBJ Object=L04
I148-BELKVA-BASIC VCH-KV M CHAR
I148-BELKVA-RECGRP VCH-NR K CHAR
I148-BELKVA-L VCH-L K CHAR
I148-BELKVA-V VCH-V K CHAR
I148-BELEG-LFD VCH-LFD K CHAR

4.20 I149 - CNSPST - Consolidation Postings

Field Short Description May Be Type Remarks/Format/...
I149-JOBID JOBID M NUMERIC
I149-RECORD-NR RECNO M NUMERIC
I149-IMP-ERROR IMP-ERR K CHAR
I149-KTK KTK K CHAR
I149-CODT CODT K CHAR
I149-CLSDTE-MON-JAHR CLSDTE-I K PERIOD
I149-FCT FCT-I M CHAR
I149-BUDT BUDT K CHAR
I149-BELEG-GES1 VCH-GES1 K CHAR
I149-BELEG-GES2 VCH-GES2 K CHAR
I149-BELEG-CNSFNC VCH-CNSFNC K CHAR
I149-PST-NR BUCHNR K CHAR
I149-STATUS BUCHSTAT K CHAR KON/OTHOBJ Object=S18
I149-COADFN COADFN K CHAR
I149-KTOM COADFN K CHAR
I149-ANLGES ANLGES K CHAR
I149-ANLM FAOBJ K CHAR
I149-BSLKMPL BSLKMPL K CHAR
I149-KW-SOLL SOLL-KW K DECIMAL
I149-KW-HABEN HABEN-KW K DECIMAL
I149-PW-SOLL SOLL-PW K DECIMAL
I149-PW-HABEN HABEN-PW K DECIMAL
I149-UAW-PW UAP K CHAR KON/OTHOBJ Object=UAP
I149-WK-DATEND-PW DATEND K DATE
I149-WK-BETRAG-PW WKURS K DECIMAL
I149-BEMERK1-UC BEMERK1 K UNICODE
I149-HERKKTK HERKKTK K CHAR
I149-LT-KNZ LT-KNZ K CHAR KON/OTHOBJ Object=L03
I149-KA-KNZ KA-KNZ K CHAR KON/OTHOBJ Object=L06
I149-KST1KTP KST1KTP K CHAR
I149-KST1 KST1 K CHAR
I149-KST2KTP KST2KTP K CHAR
I149-KST2 KST2 K CHAR
I149-KST3KTP KST3KTP K CHAR
I149-KST3 KST3 K CHAR
I149-KST4KTP KST4KTP K CHAR
I149-KST4 KST4 K CHAR
I149-KST5KTP KST5KTP K CHAR
I149-KST5 KST5 K CHAR
I149-KST6KTP KST6KTP K CHAR
I149-KST6 KST6 K CHAR
I149-KST7KTP KST7KTP K CHAR
I149-KST7 KST7 K CHAR
I149-KST8KTP KST8KTP K CHAR
I149-KST8 KST8 K CHAR
I149-KST9KTP KST9KTP K CHAR
I149-KST9 KST9 K CHAR
I149-KST0KTP KST0KTP K CHAR
I149-KST0 KST0 K CHAR
I149-UAW-KW UAW-KW K CHAR
I149-WK-DATEND-KW DATEN-KW K DATE
I149-WK-BETRAG-KW WKURS-KW K DECIMAL
I149-LW-SOLL SOLL-LW K DECIMAL
I149-LW-HABEN HABEN-LW K DECIMAL
I149-FXCDE-LW FXCDE-LW K CHAR
I149-BELKVA-BASIC VCH-KV M CHAR
I149-BELKVA-RECGRP VCH-NR K CHAR
I149-BELKVA-L VCH-L K CHAR
I149-BELKVA-V VCH-V K CHAR
I149-BELEG-LFD VCH-LFD K CHAR

4.21 I103 - KST - Controlling Objects

Field Short Description May Be Type Remarks/Format/...
I103-JOBID JOBID M NUMERIC
I103-RECORD-NR RECNO M NUMERIC
I103-IMP-ERROR IMP-ERR CHAR
I103-COADFN COADFN M CHAR
I103-KSTM KST M CHAR
I103-SPRID-KST LGNCDE K CHAR
I103-BENE1-KST-UC BENE1 M UNICODE
I103-KURZW-KST-UC KURZW K UNICODE
I103-KST-VERANTW VERANTW K CHAR
I103-KST-KNZ1 KSTKNZ1 K CHAR KON/OTHOBJ Object=K05
I103-KST-KNZ2 KSTKNZ2 K CHAR KON/OTHOBJ Object=K06
I103-VERDKST VKST K CHAR
I103-BUDT KUBR K CHAR
I103-GUELTIG-AB GUE-AB K DATE
I103-GUELTIG-BIS GUE-BIS K DATE
I103-KONZKTP KKTP K CHAR
I103-KONZKSTM KKST K CHAR
I103-AGG-KNZ AGGKNZ K CHAR KON/OTHOBJ Object=A14
I103-CODT CNTGES K CHAR

4.22 I144 - GRPMNR - Group/Sub-Group Circle

Field Short Description May Be Type Remarks/Format/...
I144-JOBID JOBID M NUMERIC
I144-RECORD-NR RECNO M NUMERIC
I144-IMP-ERROR IMP-ERR K CHAR
I144-KTK KTK M CHAR
I144-CLSDTE-MON-JAHR CLSDTE-I M PERIOD
I144-FCT FCT-I M CHAR
I144-CODT CODT M CHAR
I144-MUTTER MUTTER K CHAR KON/OTHOBJ Object=M07
I144-ZUGANG-KONS ZUGANG K DATE
I144-KONSART KONSART M CHAR KON/OTHOBJ Object=K03
I144-PST-AUS-TK PST-TK K CHAR
I144-BET-EBENE BETEBENE K CHAR
I144-BET-KAP BET-KAP K DECIMAL
I144-BET-PRDGRP-ADD PRDGRP-ADD K DECIMAL
I144-BET-PRDGRP-MULT PRDGRP-MULT K DECIMAL
I144-BET-PRDGRP-STIMM PRDGRP-STIM K DECIMAL
I144-BET-PRDGRP-ERG PRDGRP-ERG K DECIMAL
I144-BET-PRDGRP-QUOT PRDGRP-QUOT K DECIMAL
I144-OHNE-INDFREMD FREMDANT K CHAR
I144-NETTO-ANL NETTO K CHAR
I144-ABGANG-KONS ABGANG K DATE
I144-TRANSITION TRANS K CHAR
I144-BET-PRDGRP-M-MAN PRDGRP-MAN K DECIMAL

4.23 I105 - COADFN - Accounts

Field Short Description May Be Type Remarks/Format/...
I105-JOBID JOBID CHAR
I105-RECORD-NR RECNO CHAR
I105-IMP-ERROR IMP-ERR CHAR
I105-BENE1-COADFN-UC BENE M UNICODE
I105-BIL-RC-KNZ BG K CHAR KON/OTHOBJ Object=B01
I105-CDM-FLAG0 CDMFL0 K CHAR KON/OTHOBJ Object=C05
I105-CDM-FLAG1 CDMFL1 K CHAR KON/OTHOBJ Object=C05
I105-CDM-FLAG2 CDMFL2 K CHAR KON/OTHOBJ Object=C05
I105-CDM-FLAG3 CDMFL3 K CHAR KON/OTHOBJ Object=C05
I105-CDM-FLAG4 CDMFL4 K CHAR KON/OTHOBJ Object=C05
I105-CDM-FLAG5 CDMFL5 K CHAR KON/OTHOBJ Object=C05
I105-CDM-FLAG6 CDMFL6 K CHAR KON/OTHOBJ Object=C05
I105-CDM-FLAG7 CDMFL7 K CHAR KON/OTHOBJ Object=C05
I105-CDM-FLAG8 CDMFL8 K CHAR KON/OTHOBJ Object=C05
I105-CDM-FLAG9 CDMFL9 K CHAR KON/OTHOBJ Object=C05
I105-GUELTIG-AB GUE-AB K DATE
I105-GUELTIG-BIS GUE-BIS K DATE
I105-IC-CODT ICGES K CHAR
I105-IC-BUDT ICUBR K CHAR
I105-KNZ-MIT-E-COADFN EKTOGEN K CHAR
I105-KONS-CMPCNT KONSV K CHAR
I105-KONZKTOM KKTO K CHAR
I105-KONZKTP KKTP K CHAR
I105-COADFN-KNZ KNZ1 K CHAR KON/OTHOBJ Object=K01
I105-KTO1M VKTO K CHAR
I105-KTO2M WKTO K CHAR
I105-KTO3M SRFKTO K CHAR
I105-KTO4M EVKTO K CHAR
I105-KTO5M FAKTO K CHAR
I105-KTOM COADFN M CHAR
I105-KTOUBR BUDT K CHAR
I105-COADFN COADFN M CHAR
I105-KURZW-COADFN-UC KURZW K UNICODE
I105-RELART RELART K CHAR KON/OTHOBJ Object=R04
I105-SPI SPI K CHAR
I105-SPRID-COADFN LGNCDE M CHAR
I105-UB-KF UB-KF K CHAR KON/OTHOBJ Object=K16
I105-VORTRAG-RP VORUMB K CHAR KON/OTHOBJ Object=V30
I105-PER-KNZ-M PER-M K CHAR KON/OTHOBJ Object=P22
I105-PER-KNZ-Q PER-Q K CHAR KON/OTHOBJ Object=P22
I105-PER-KNZ-H PER-H K CHAR KON/OTHOBJ Object=P22
I105-PER-KNZ-J PER-J K CHAR KON/OTHOBJ Object=P22
I105-BSGM BSGM K CHAR
I105-SGA SGA K CHAR KON/OTHOBJ Object=K23
I105-COADFN-KNZ2 KNZ2 K CHAR KON/OTHOBJ Object=K22

4.24 I100 - ACBAL - Account Balances

Field Short Description May Be Type Remarks/Format/...
I100-JOBID JOBID M NUMERIC
I100-RECORD-NR RECNO M NUMERIC
I100-IMP-ERROR IMP-ERR K CHAR
I100-CODT CODT M CHAR
I100-BUDT BUDT K CHAR
I100-COADFN COADFN K CHAR
I100-COADFN COADFN M CHAR
I100-CLSDTE-MON-JAHR CLSDTE-I M PERIOD
I100-FCT FCT-I M CHAR
I100-WERT-LW WERT-LW M DECIMAL
I100-SOLL-HAB-KNZ SOLL-HAB K CHAR KON/OTHOBJ Object=S01
I100-WERT-KW WERT-KW K DECIMAL
I100-WERT-PW WERT-PW K DECIMAL
I100-BEMERK1-UC BEMERK1 K UNICODE
I100-CMPCNT-KNZ VRBKNZ K CHAR KON/OTHOBJ Object=V01

4.25 I113 - COADFN - Charts of Accounts

Field Short Description May Be Type Remarks/Format/...
I113-JOBID JOBID M NUMERIC
I113-RECORD-NR RECNO M NUMERIC
I113-IMP-ERROR IMP-ERR K CHAR
I113-COADFN COADFN M CHAR
I113-SPRID-COADFN LGNCDE K CHAR
I113-BENE1-COADFN-UC BENE1 M UNICODE
I113-KURZW-COADFN-UC KURZW K UNICODE
I113-GUELTIG-AB GUE-AB M DATE
I113-GUELTIG-BIS GUE-BIS K DATE
I113-COADFN-KNZ KTPKNZ M CHAR KON/OTHOBJ Object=K08
I113-OBJTYP KTPTYP M CHAR KON/OTHOBJ Object=P02
I113-KONZKTP KNZKTP K CHAR
I113-COADFN-LAENGE KTOLEN K NUMERIC
I113-KST-LAENGE KSTLEN K NUMERIC
I113-FAOBJ-PREFIX ANLPREF K CHAR
I113-KTOUBR KTOUBR K CHAR
I113-RELART RELART K CHAR KON/OTHOBJ Object=R04
I113-CDM CDM K CHAR KON/OTHOBJ Object=C04
I113-COADFN-BEZ-LNG KTOBEZL K NUMERIC

4.26 I147 - CNSFNC - Consolidation Function

Field Short Description May Be Type Remarks/Format/...
I147-JOBID JOBID M NUMERIC
I147-RECORD-NR RECNO M NUMERIC
I147-IMP-ERROR IMP-ERR K CHAR
I147-CNSFNC-BASIC KVABASIC M CHAR
I147-CNSFNC-RECGRP KVARECGR K CHAR
I147-CNSFNC-L CNSFNC-L K CHAR
I147-CNSFNC-V CNSFNC-V K CHAR
I147-SPRID-CNSFNC LGNCDE M CHAR
I147-BENE1-CNSFNC-UC BENE1 M UNICODE
I147-KURZW-CNSFNC-UC KURZW K UNICODE
I147-GUELTIG-AB GUE-AB M DATE
I147-GUELTIG-BIS GUE-BIS K DATE
I147-CNSFNC-REFERENZ CNSFNC-REFE M CHAR
I147-KVA1 KVA1 K CHAR
I147-KVA2 KVA2 K CHAR
I147-KVA4 KVA4 K CHAR
I147-KVA5 KVA5 K CHAR
I147-MIT-TW MIT-TW K CHAR KON/OTHOBJ Object=T03
I147-CNSFNC-COREP CNSFNC-COREP K CHAR
I147-COREP-SPALTE COREP-REPCLCDSC K CHAR
I147-CNSFNC-CF CNSFNC-CF K CHAR
I147-KNZ-CF KNZ-CF K CHAR KON/OTHOBJ Object=V31

4.27 I109 - CNTCDE - Country Code

Field Short Description May Be Type Remarks/Format/...
I109-JOBID JOBID M NUMERIC
I109-RECORD-NR RECNO M NUMERIC
I109-IMP-ERROR IMP-ERR K CHAR
I109-CNTCDE CNTCDE M CHAR
I109-SPRID-CNTCDE LGNCDE K CHAR
I109-BENE1-CNTCDE-UC BENE1 M UNICODE
I109-KURZW-CNTCDE-UC KURZW K UNICODE
I109-GUELTIG-AB GUE-AB M DATE
I109-GUELTIG-BIS GUE-BIS K DATE

4.28 I106 - POSDFN - Positions

Field Short Description May Be Type Remarks/Format/...
I106-JOBID JOBID CHAR
I106-RECORD-NR RECNO CHAR
I106-IMP-ERROR IMP-ERR CHAR
I106-AGB AGB M CHAR
I106-AGGM AGG M CHAR
I106-BENE1-AGG-UC BENE1 M UNICODE
I106-BIL-RC-KNZ BILGUV M CHAR KON/OTHOBJ Object=B01
I106-DAVON-POSDFN DAVONP K CHAR KON/OTHOBJ Object=D02
I106-DIMENSION DIMENS K CHAR KON/OTHOBJ Object=D01
I106-GUELTIG-AB GUE-AB M DATE
I106-GUELTIG-BIS GUE-BIS K DATE
I106-KURZW-AGG-UC KURZW K UNICODE
I106-SPRID-AGG LGNCDE K CHAR
I106-XBRL XBRL K CHAR
I106-HEADTEXT-UC HEADTEXT K UNICODE
I106-POSDFN-OBJTYP POSTYP K CHAR

4.29 I107 - POSKTO - Positions+Account Assignments

Field Short Description May Be Type Remarks/Format/...
I107-JOBID JOBID CHAR
I107-RECORD-NR RECNO CHAR
I107-IMP-ERROR IMP-ERR CHAR
I107-AGB AGB M CHAR
I107-AGGM AGG M CHAR
I107-ENDE-KNZ ENDE-KNZ K CHAR
I107-COADFN-BISM BIS-COADFN K CHAR
I107-KTOM COADFN M CHAR
I107-COADFN COADFN M CHAR
I107-SOLL-HAB-KNZ S-H-KNZ K CHAR KON/OTHOBJ Object=S01

4.30 I117 - POSKTOP - Position+Account Assignments - Periodic

Field Short Description May Be Type Remarks/Format/...
I117-JOBID JOBID M CHAR
I117-RECORD-NR RECNO M CHAR
I117-IMP-ERROR IMP-ERR K CHAR
I117-POSDFN POSDFN M CHAR
I117-POSM POSDFN M CHAR
I117-COADFN COADFN M CHAR
I117-KTOM COADFN M CHAR
I117-ORD-NR ORD-NR K NUMERIC
I117-GUELTIG-AB GUE-AB K DATE
I117-GUELTIG-BIS GUE-BIS K DATE
I117-SOLL-HAB-KNZ S-H-KNZ K CHAR
I117-COADFN-BISM BIS-COADFN K CHAR
I117-CK1 CK1 K CHAR

4.31 I151 - PRF - Check Rules

Field Short Description May Be Type Remarks/Format/...
I151-JOBID JOBID M NUMERIC
I151-RECORD-NR RECNO M NUMERIC
I151-IMP-ERROR IMP-ERR K CHAR
I151-PRF PRF M CHAR
I151-SPRID-PRF LGNCDE M CHAR
I151-LANGTEXT-UC LANGTEXT M UNICODE
I151-KURZTEXT-UC KURZTEXT K UNICODE
I151-GUELTIG-AB GUE-AB M PERIOD
I151-GUELTIG-BIS GUE-BIS K PERIOD
I151-OPERATOR OPERATOR M CHAR KON/OTHOBJ Object=P09
I151-L-DATEN L-DATEN M CHAR KON/OTHOBJ Object=P10
I151-R-DATEN R-DATEN K CHAR KON/OTHOBJ Object=P10
I151-L-WERT L-WERT M CHAR KON/OTHOBJ Object=P11
I151-R-WERT R-WERT K CHAR KON/OTHOBJ Object=P11
I151-L-FL-VABR L-FLVABR K CHAR KON/OTHOBJ Object=P12
I151-R-FL-VABR R-FLVABR K CHAR KON/OTHOBJ Object=P12
I151-L-FL-VFAC L-FLVFAC K CHAR KON/OTHOBJ Object=P13
I151-R-FL-VFAC R-FLVFAC K CHAR KON/OTHOBJ Object=P13
I151-EBENE EBENE K CHAR KON/OTHOBJ Object=P16
I151-TOLERANZ-KW TOLER-KW K DECIMAL
I151-TOLERANZ-LW TOLER-LW K DECIMAL
I151-TOLERANZ-PW TOLER-PW K DECIMAL
I151-PROZENT PROZENT K DECIMAL
I151-PRF-GRP GRP K CHAR
I151-FL-JE-COADFN JE-COADFN K CHAR KON/OTHOBJ Object=P29
I151-FL-JE-BUDT JE-BUDT K CHAR KON/OTHOBJ Object=P28
I151-FL-JE-IC-CODT JE-ICGES K CHAR KON/OTHOBJ Object=P31
I151-FL-JE-CNTOBJ JE-CNTOB K CHAR KON/OTHOBJ Object=P30
I151-FL-JE-CODT JE-CODT K CHAR KON/OTHOBJ Object=P36
I151-KONSTANTE KONSTANT K DECIMAL
I151-PRF-KLASSE PRFREGKL M CHAR

4.32 I154 - PRFGRP - Check Rule Groups

Field Short Description May Be Type Remarks/Format/...
I154-JOBID JOBID M NUMERIC
I154-RECORD-NR RECNO M NUMERIC
I154-IMP-ERROR IMP-ERR K CHAR
I154-GRP GRP M CHAR
I154-SPRID-PRFGRP LGNCDE M CHAR
I154-LANGTEXT-UC LANGTEXT M UNICODE
I154-KURZTEXT-UC KURZTEXT K UNICODE
I154-GRP-OBJTYP GRPTYP M CHAR KON/OTHOBJ Object=P26
I154-OGRP OGRP K CHAR

4.33 I152 - PRFPOS - Check Rules/Positions

Field Short Description May Be Type Remarks/Format/...
I152-JOBID JOBID M NUMERIC
I152-RECORD-NR RECNO M NUMERIC
I152-IMP-ERROR IMP-ERR K CHAR
I152-PRF PRF M CHAR
I152-SEITE SEITE M CHAR KON/OTHOBJ Object=P14
I152-AGB AGB K CHAR
I152-AGGM AGG K CHAR
I152-COADFN COADFN K CHAR
I152-KTOM COADFN K CHAR
I152-BIL-RC-KNZ BG K CHAR KON/OTHOBJ Object=B01
I152-COADFN-KNZ KNZ1 K CHAR KON/OTHOBJ Object=K01
I152-SPI SPI K CHAR
I152-BSLKMPL BSLKMPL K CHAR
I152-SSPA SSPA K CHAR
I152-SSPM SSPM K CHAR
I152-SBEA SBEA K CHAR
I152-SBEM SBEM K CHAR
I152-OPERATOR OPERATOR K CHAR KON/OTHOBJ Object=P25
I152-COADFN-KNZ2 KNZ2 K CHAR KON/OTHOBJ Object=K22
I152-SGA SGA K CHAR KON/OTHOBJ Object=K23
I152-CK1 CK1 K CHAR
I152-KSTKTP CNTKTP K CHAR
I152-KSTM CNTOBJ K CHAR
I152-BUDT BUDT K CHAR
I152-REPID RID K CHAR
I152-IC-VERPROB ICVERP K CHAR

4.34 I155 - PRFZUO - Exclusion Groups/Check Rules

Field Short Description May Be Type Remarks/Format/...
I155-JOBID JOBID M NUMERIC
I155-RECORD-NR RECNO M NUMERIC
I155-IMP-ERROR IMP-ERR K CHAR
I155-GRP GRP M CHAR
I155-PRF PRF M CHAR

4.35 I159 - PRDGRP - Products/Product Groups

Field Short Description May Be Type Remarks/Format/...
I159-JOBID JOBID M NUMERIC
I159-RECORD-NR RECNO M NUMERIC
I159-IMP-ERROR IMP-ERR K CHAR
I159-PRDGRP PRDGRP M CHAR
I159-SPRID-PRDGRP LGNCDE-I M CHAR
I159-BEMERK1-UC BEMERK1 M UNICODE
I159-KURZW-PRDGRP-UC KURZW K UNICODE
I159-COADFN COADFN M CHAR
I159-KTOM COADFN M CHAR
I159-KTO2M KTO2 K CHAR
I159-KSTKTP CNT-COADFN K CHAR
I159-KSTM CNT-ELIM K CHAR
I159-GUELTIG-AB GUE-AB M DATE
I159-GUELTIG-BIS GUE-BIS K DATE

4.36 I161 - PRDMGN - Product Margins

Field Short Description May Be Type Remarks/Format/...
I161-JOBID JOBID M NUMERIC
I161-RECORD-NR RECNO M NUMERIC
I161-IMP-ERROR IMP-ERR K CHAR
I161-CODT CODT M CHAR
I161-BUDT BUDT K CHAR
I161-CLSDTE-MON-JAHR CLSDTE-I M PERIOD
I161-FCT FCT-I M CHAR
I161-PRDGRP PRDGRP M CHAR
I161-CODT-AN ICGES M CHAR
I161-BUDT-AN ICUBR K CHAR
I161-ZU-AB-SATZ ZUAB K DECIMAL
I161-BEMERKUNG-UC BEMERK K UNICODE

4.37 I127 - REPLNDFN - Report Line Descriptions

Field Short Description May Be Type Remarks/Format/...
I127-JOBID JOBID M NUMERIC
I127-RECORD-NR RECNO M NUMERIC
I127-IMP-ERROR IMP-ERR K CHAR
I127-REPAGB REPAGB M CHAR
I127-LFDNR LFDNR M NUMERIC
I127-AGBM AGB M CHAR
I127-AGGM AGG M CHAR
I127-ZEILENTYP ZEITYP M CHAR KON/OTHOBJ Object=Z02
I127-WERT-KNZ WERTKZ M CHAR KON/OTHOBJ Object=W01
I127-SUMME-EX EX K NUMERIC
I127-SUMME-IN IN K NUMERIC
I127-VORSCHUB-CF CF K CHAR KON/OTHOBJ Object=V02
I127-VORSCHUB-NACH NACH K CHAR KON/OTHOBJ Object=V03
I127-UNTERSTRICH UNT K CHAR KON/OTHOBJ Object=U02
I127-BEDINGUNG BEDING K NUMERIC
I127-UEB-AGBM UEBAGB K CHAR
I127-UEB-AGGM UEBAGG K CHAR
I127-CNSFNC CNSFNC K CHAR
I127-KLEINER-NULL WERT-KL K CHAR KON/OTHOBJ Object=W10
I127-GLEICH-NULL WERT-GL K CHAR KON/OTHOBJ Object=W10
I127-GROESSER-NULL WERT-GR K CHAR KON/OTHOBJ Object=W10
I127-OLAP-AGBM OLAAGB K CHAR
I127-OLAP-AGGM OLAAGG K CHAR
I127-FARBE-VO VOFA K COLOUR
I127-FARBE-HI HIFA K COLOUR
I127-SCHR-SCHNITT SSCH K CHAR KON/OTHOBJ Object=FO1
I127-SCHR-GRAD SGRD K NUMERIC
I127-BSLKMPL BSLKMPL K CHAR
I127-SSPKMPL SSPKMPL K CHAR

4.38 I108 - PRVTRN - Reserve Movements

Field Short Description May Be Type Remarks/Format/...
I108-JOBID JOBID CHAR
I108-RECORD-NR RECNO CHAR
I108-IMP-ERROR IMP-ERR CHAR
I108-CLSDTE-MON-JAHR CLSDTE-I M PERIOD
I108-BELEG-GES1 VCH-GES1 K CHAR
I108-BELEG-GES2 VCH-GES2 K CHAR
I108-BELEG-CNSFNC VCH-CNSFNC K CHAR
I108-BEMERK1-UC BUTXT K UNICODE
I108-BEWDAT BEWDAT M DATE
I108-FCT FCT-I M CHAR
I108-CODT CODT M CHAR
I108-CODT-AN IC-CODT K CHAR
I108-KTOM COADFN M CHAR
I108-COADFN COADFN K CHAR
I108-SOLL-HAB-KNZ SOLL-HAB K CHAR KON/OTHOBJ Object=S01
I108-UAW UAW K CHAR KON/OTHOBJ Object=UAW
I108-UAW-PW UAW-PW K CHAR KON/OTHOBJ Object=UAP
I108-BUDT BUDT K CHAR
I108-BUDT-AN IC-BUDT K CHAR
I108-WERT-KW WERT-KW K DECIMAL
I108-WERT-LW WERT-LW M DECIMAL
I108-WERT-PW WERT-PW K DECIMAL
I108-WK-BETRAG WKURS K DECIMAL
I108-WK-BETRAG-PW WKURS-PW K DECIMAL
I108-WK-DATEND-PW DATENDPW K DATE
I108-WK-DATEND DATEND K DATE
I108-KTK KTK K CHAR
I108-BSLKMPL BSLKMPL K CHAR

4.39 I108 - DEVTRN - Individual Development Transactions

Field Short Description May Be Type Remarks/Format/...
I108-JOBID JOBID CHAR
I108-RECORD-NR RECNO CHAR
I108-IMP-ERROR IMP-ERR CHAR
I108-CLSDTE-MON-JAHR CLSDTE-I M PERIOD
I108-BELEG-GES1 VCH-GES1 K CHAR
I108-BELEG-GES2 VCH-GES2 K CHAR
I108-BELEG-CNSFNC VCH-CNSFNC K CHAR
I108-BEMERK1-UC BUTXT K UNICODE
I108-FCT FCT-I M CHAR
I108-CODT CODT M CHAR
I108-CODT-AN IC-CODT K CHAR
I108-KTOM COADFN M CHAR
I108-COADFN COADFN K CHAR
I108-KTK KTK K CHAR
I108-SOLL-HAB-KNZ SOLL-HAB K CHAR KON/OTHOBJ Object=S01
I108-UAW UAW K CHAR KON/OTHOBJ Object=UAW
I108-BUDT BUDT K CHAR
I108-UAW-PW UAW-PW K CHAR KON/OTHOBJ Object=UAP
I108-BUDT-AN IC-BUDT K CHAR
I108-WERT-KW WERT-KW K DECIMAL
I108-WERT-LW WERT-LW M DECIMAL
I108-WERT-PW WERT-PW K DECIMAL
I108-WK-BETRAG WKURS K DECIMAL
I108-WK-BETRAG-PW WKURS-PW K DECIMAL
I108-WK-DATEND DATEND K DATE
I108-WK-DATEND-PW DATENDPW K DATE
I108-BEWDAT BEWDAT M DATE
I108-BSLKMPL BSLKMPL K CHAR

4.40 I120 - BUDT - Business Areas

Field Short Description May Be Type Remarks/Format/...
I120-JOBID JOBID M NUMERIC
I120-RECORD-NR RECNO M NUMERIC
I120-IMP-ERROR IMP-ERR K CHAR
I120-BUDT BUDT M CHAR
I120-SPRID-BUDT LGNCDE-I K CHAR
I120-BENE1-BUDT-UC BENE1 M UNICODE
I120-KURZW-BUDT-UC KURZW K UNICODE
I120-GUELTIG-AB GUE-AB M DATE
I120-GUELTIG-BIS GUE-BIS K DATE
I120-AGG-KNZ AGGKNZ K CHAR KON/OTHOBJ Object=A13

4.41 I125 - UBRUBR - Business Unit Hierarchy Assignments

Field Short Description May Be Type Remarks/Format/...
I125-JOBID JOBID M NUMERIC
I125-RECORD-NR RECNO M NUMERIC
I125-IMP-ERROR IMP-ERR K CHAR
I125-BUDT BUDT M CHAR
I125-UBRU UUBR M CHAR

4.42 I112 - FXCDE - Currency Codes

Field Short Description May Be Type Remarks/Format/...
I112-JOBID JOBID M NUMERIC
I112-RECORD-NR RECNO M NUMERIC
I112-IMP-ERROR IMP-ERR K CHAR
I112-FXCDE FXCDE M CHAR
I112-SPRID-FXCDE LGNCDE K CHAR
I112-BENE1-FXCDE-UC WKZBENE1 M UNICODE
I112-KURZW-FXCDE-UC KURZW M UNICODE
I112-FAKTOR FAKTOR M CHAR
I112-ANZ-NK ANZ-NK K CHAR
I112-GUELTIG-AB GUE-AB M DATE
I112-GUELTIG-BIS GUE-BIS K DATE

4.43 I118 - FXRTE - Exchange Rates

Field Short Description May Be Type Remarks/Format/...
I118-JOBID JOBID M NUMERIC
I118-RECORD-NR RECNO M NUMERIC
I118-IMP-ERROR IMP-ERR K CHAR
I118-FXCDE FXCDE M CHAR
I118-FCT FCT M CHAR
I118-WKA WKA M CHAR KON/OTHOBJ Object=WKA
I118-DATEND STICHTWK M DATE
I118-ZEITBEZUG ZEITBEZ M CHAR KON/OTHOBJ Object=Z03
I118-BETRAG WKURS M DECIMAL

For an optimal Community experience, Please view on Desktop
Powered by Zendesk