HA ABAP System copy Target Installation - ABAP Import Error

[Former Member]

Hello All,

We are running on HA ABAP System copy Target Installation (Oracle) - DB Instance in ABAP import

phase i.e (Phase 17 of 20). There is an inconsistency occurs in Loading of 'BSIS-pre' and 'KOCLU-post' import package: ERROR, where 13 processes are failes for 2 tables i.e BSIS and KOCLU.

-

---

Below is the error log for BSIS__DPI.log:

DbSl Trace: Error 922 in exec_immediate() from oci_execute_stmt(), orpc=0

DbSl Trace: ORA-922 occurred when executing SQL stmt (parse error offset=5435)

(DB) ERROR: DDL statement failed

( CREATE TABLE "BSIS" ("MANDT" VARCHAR2 (000009) DEFAULT '000' NOT NULL, "BUKRS" VARCHAR2 (000012) DEFAULT ' ' NOT NULL, "HKONT" VARCHAR2 (000030) DEFAULT ' ' NOT NULL, "AUGDT" VARCHAR2 (000024) DEFAULT '00000000' NOT NULL, "AUGBL" VARCHAR2 (000030) DEFAULT ' ' NOT NULL, "ZUONR" VARCHAR2 (000054) DEFAULT ' ' NOT NULL, "GJAHR" VARCHAR2 (000012) DEFAULT '0000' NOT NULL, "BELNR" VARCHAR2 (000030) DEFAULT ' ' NOT NULL, "BUZEI" VARCHAR2 (000009) DEFAULT '000' NOT NULL, "BUDAT" VARCHAR2 (000024) DEFAULT '00000000' NOT NULL, "BLDAT" VARCHAR2 (000024) DEFAULT '00000000' NOT NULL, "WAERS" VARCHAR2 (000015) DEFAULT ' ' NOT NULL, "XBLNR" VARCHAR2 (000048) DEFAULT ' ' NOT NULL, "BLART" VARCHAR2 (000006) DEFAULT ' ' NOT NULL, "MONAT" VARCHAR2 (000006) DEFAULT '00' NOT NULL, "BSCHL" VARCHAR2 (000006) DEFAULT ' ' NOT NULL, "SHKZG" VARCHAR2 (000003) DEFAULT ' ' NOT NULL, "GSBER" VARCHAR2 (000012) DEFAULT ' ' NOT NULL, "MWSKZ" VARCHAR2 (000006) DEFAULT ' ' NOT NULL, "FKONT" VARCHAR2 (000009) DEFAULT '000' NOT NULL, "DMBTR" NUMBER (000013, 000002) DEFAULT 0 NOT NULL, "WRBTR" NUMBER (000013, 000002) DEFAULT 0 NOT NULL, "MWSTS" NUMBER (000013, 000002) DEFAULT 0 NOT NULL, "WMWST" NUMBER (000013, 000002) DEFAULT 0 NOT NULL, "SGTXT" VARCHAR2 (000150) DEFAULT ' ' NOT NULL, "PROJN" VARCHAR2 (000048) DEFAULT ' ' NOT NULL, "AUFNR" VARCHAR2 (000036) DEFAULT ' ' NOT NULL, "WERKS" VARCHAR2 (000012) DEFAULT ' ' NOT NULL, "KOSTL" VARCHAR2 (000030) DEFAULT ' ' NOT NULL, "ZFBDT" VARCHAR2 (000024) DEFAULT '00000000' NOT NULL, "XOPVW" VARCHAR2 (000003) DEFAULT ' ' NOT NULL, "VALUT" VARCHAR2 (000024) DEFAULT '00000000' NOT NULL, "BSTAT" VARCHAR2 (000003) DEFAULT ' ' NOT NULL, "BDIFF" NUMBER (000013, 000002) DEFAULT 0 NOT NULL, "BDIF2" NUMBER (000013, 000002) DEFAULT 0 NOT NULL, "VBUND" VARCHAR2 (000018) DEFAULT ' ' NOT NULL, "PSWSL" VARCHAR2 (000015) DEFAULT ' ' NOT NULL, "WVERW" VARCHAR2 (000003) DEFAULT ' ' NOT NULL, "DMBE2" NUMBER (000013, 000002) DEFAULT 0 NOT NULL, "DMBE3" NUMBER (000013, 000002) DEFAULT 0 NOT NULL, "MWST2" NUMBER (000013, 000002) DEFAULT 0 NOT NULL, "MWST3" NUMBER (000013, 000002) DEFAULT 0 NOT NULL, "BDIF3" NUMBER (000013, 000002) DEFAULT 0 NOT NULL, "RDIF3" NUMBER (000013, 000002) DEFAULT 0 NOT NULL, "XRAGL" VARCHAR2 (000003) DEFAULT ' ' NOT NULL, "PROJK" VARCHAR2 (000024) DEFAULT '00000000' NOT NULL, "PRCTR" VARCHAR2 (000030) DEFAULT ' ' NOT NULL, "XSTOV" VARCHAR2 (000003) DEFAULT ' ' NOT NULL, "XARCH" VARCHAR2 (000003) DEFAULT ' ' NOT NULL, "PSWBT" NUMBER (000013, 000002) DEFAULT 0 NOT NULL, "XNEGP" VARCHAR2 (000003) DEFAULT ' ' NOT NULL, "RFZEI" VARCHAR2 (000009) DEFAULT '000' NOT NULL, "CCBTC" VARCHAR2 (000030) DEFAULT ' ' NOT NULL, "XREF3" VARCHAR2 (000060) DEFAULT ' ' NOT NULL, "BUPLA" VARCHAR2 (000012) DEFAULT ' ' NOT NULL, "PPDIFF" NUMBER (000013, 000002) DEFAULT 0 NOT NULL, "PPDIF2" NUMBER (000013, 000002) DEFAULT 0 NOT NULL, "PPDIF3" NUMBER (000013, 000002) DEFAULT 0 NOT NULL, "BEWAR" VARCHAR2 (000009) DEFAULT ' ' NOT NULL, "IMKEY" VARCHAR2 (000024) DEFAULT ' ' NOT NULL, "DABRZ" VARCHAR2 (000024) DEFAULT '00000000' NOT NULL, "INTRENO" VARCHAR2 (000039) DEFAULT ' ' NOT NULL, "GRANT_NBR" VARCHAR2 (000060) DEFAULT ' ' NOT NULL, "FKBER" VARCHAR2 (000048) DEFAULT ' ' NOT NULL, "FIPOS" VARCHAR2 (000042) DEFAULT ' ' NOT NULL, "FISTL" VARCHAR2 (000048) DEFAULT ' ' NOT NULL, "GEBER" VARCHAR2 (000030) DEFAULT ' ' NOT NULL, "PPRCT" VARCHAR2 (000030) DEFAULT ' ' NOT NULL, "BUZID" VARCHAR2 (000003) DEFAULT ' ' NOT NULL, "AUGGJ" VARCHAR2 (000012) DEFAULT '0000' NOT NULL, "UZAWE" VARCHAR2 (000006) DEFAULT ' ' NOT NULL, "SEGMENT" VARCHAR2 (000030) DEFAULT ' ' NOT NULL, "PSEGMENT" VARCHAR2 (000030) DEFAULT ' ' NOT NULL, "PGEBER" VARCHAR2 (000030) DEFAULT ' ' NOT NULL, "PGRANT_NBR" VARCHAR2 (000060) DEFAULT ' ' NOT NULL, "MEASURE" VARCHAR2 (000072) DEFAULT ' ' NOT NULL, "BUDGET_PD" VARCHAR2 (000030) DEFAULT ' ' NOT NULL, "PBUDGET_PD" VARCHAR2 (000030) DEFAULT ' ' NOT NULL, "FIPEX" VARCHAR2 (000072) DEFAULT ' ' NOT NULL, "PRODPER" VARCHAR2 (000018) DEFAULT ' ' NOT NULL, "QSSKZ" VARCHAR2 (000006) DEFAULT ' ' NOT NULL, "PROPMANO" VARCHAR2 (000039) DEFAULT ' ' NOT NULL) PCTFREE 10 PCTUSED 40 INITRANS 001 TABLESPACE STORAGE (INITIAL 0000204784 K NEXT 0000100000 K MINEXTENTS 0000000001 MAXEXTENTS UNLIMITED PCTINCREASE 0000 FREELISTS 001 FREELIST GROUPS 01) )

DbSlExecute: rc = 99

(SQL error 922)

error message returned by DbSl:

ORA-00922: missing or invalid option

-

---

Below is the error log for KOCLU__DT.log:

DbSl Trace: Error 12801 in exec_immediate() from oci_execute_stmt(), orpc=0

DbSl Trace: ORA-12801 occurred when executing SQL stmt (parse error offset=0)

(DB) ERROR: DDL statement failed

(CREATE UNIQUE INDEX "KOCLU~0" ON "KOCLU" ( "MANDT", "KNUMV", "PAGENO" ) TABLESPACE PSAPSR3 STORAGE

(INITIAL 1782579200 NEXT 0000000640K MINEXTENTS 0000000001 MAXEXTENTS 2147483645 PCTINCREASE 0 ) NOLOGGING COMPUTE STATISTICS PARALLEL 4 )

DbSlExecute: rc = 99

(SQL error 12801)

error message returned by DbSl:

ORA-12801: error signaled in parallel query server P002

ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found

-

---

Please advise us.

Thanks & Regards

AK Mahapatra

Edited by: Ak Mahapatra on Sep 21, 2011 5:45 AM

[former_member182307]

Can you upload the oracle alter log ( /oracle/SID/saptrace/background/alert_SID.log ) ?

By the way, what's your Oracle release ?

About KOCLU and duplicate entries , you can run the following script against your target db to find out duplicate entries :

select alldata.rowid, alldata.*

from TBRGT alldata,

(SELECT <keycolumn 1>, ..., <keycolumn n>

FROM <table>

GROUP BY <keycolumn 1>, ..., <keycolumn n>

HAVING COUNT(*) > 1) keydata

where alldata.<keycolumn 1>=keydata.<keycolumn 1>

and ...

and alldata.<keycolumn n>=keydata.<keycolumn n>;

I your case it should be :

select alldata.rowid, alldata.*

from SAPSR3.KOCLU alldata,

(SELECT MANDT, KNUMV, PAGENO

FROM SAPSR3.KOCLU GROUP BY MANDT, KNUMV, PAGENO

HAVING COUNT(*) > 1) keydata

where alldata.MANDT=keydata.MANDT

and alldata.KNUMV=keydata.KNUMV

and alldata.PAGENO=keydata.PAGENO

;

If you really have duplicate entries there, I would drop the DB and start the overall import process again.

This means something went wrong during the import ( maybe the process ended and was restarted, in som case you run in this kind of troubles ) .

Sometimes it's faster than deep diving in these import issues.

Hope this helps.

Steve.

[Former Member]

Oracle release is 10.2.0.5

I think syntax statement is wrong

SQL> select alldata.rowid, alldata.*

from SAPSR3.KOCLU alldata,

(SELECT MANDT, KNUMV, PAGENO

FROM SAPSR3.KOCLU GROUP BY MANDT, KNUMV, PAGENO

HAVING COUNT(*) > 1) keydata

where alldata.MANDT=keydata.MANDT

and alldata.KNUMV=keydata.KNUMV

and alldata.PAGENO=keydata.PAGENO;

SP2-0678: Column or attribute type can not be displayed by SQL*Plus

Also what BSIS_pre import table error ?

drop the DB and start the overall import process again is not a solution.

[former_member269960]

This sometimes happens when import stopped and you restart the import.

What I would do is drop that table with the dup entries and restart the import of that package

[Former Member]

Import is not yet stopped, This error occurs due to R3load version bugs as per OSS Note # 1266637

[former_member182307]

Hi,

The sql syntax is correct . Here is what it gives on one of my systems :

SQL> select alldata.rowid, alldata.*

2 from SAPSR3.KOCLU alldata,

3 (SELECT MANDT, KNUMV, PAGENO

4 FROM SAPSR3.KOCLU GROUP BY MANDT, KNUMV, PAGENO

5 HAVING COUNT(*) > 1) keydata

6 where alldata.MANDT=keydata.MANDT

7 and alldata.KNUMV=keydata.KNUMV

8 and alldata.PAGENO=keydata.PAGENO

9 ;

no rows selected

No rows selected as i have no duplicates on this key in my table.

Maybe you're using a different schema from SAPSR3. Then you should adapt the statement with your schema.

Hope the note you found helps.

Steve.

[former_member182307]

Hello,

You should have a look at the Oracle alert log also. By the way, can you post it ?

ORA 00922 is usually a syntax error code which is strange in your case as the statements are triggerred by sapinst. The other error on KOCLU is due to duplicate entries in table KOCLU on the choosen fields used to build up the index, so the primary index, which is unique ( ie no duplicated values tolerated ), cannot be created.

Did you try to force any of the import steps ?

Regards,

Steve.

[Former Member]

Hello Steve,

No I didn't any force of the import steps.

I know ORA 00922 is usually a syntax error code which is already present in the TABART entries i.e which Created and defind as ZUTAB.SQL

These is strange for both the tables KOCLU. If you could find anything, please let us know.

See below DDLORA.TPL:

prikey: AFTER_LOAD ORDER_BY_PKEY

seckey: AFTER_LOAD

cretab: CREATE TABLE &tab_name&

( /{ &fld_name& &fld_desc& /-, /} )

TABLESPACE &tablespace&

&lob_cache&

STORAGE (INITIAL &init&

NEXT &next&

MINEXTENTS &minext&

MAXEXTENTS &maxext&

PCTINCREASE &pctinc& )

drptab: DROP TABLE &tab_name&

crepky: CREATE UNIQUE INDEX &pri_key&

ON &tab_name&

( &key_fld& /-, )

TABLESPACE &tablespace&

STORAGE (INITIAL &init&

NEXT &next&

MINEXTENTS &minext&

MAXEXTENTS &maxext&

PCTINCREASE &pctinc& )

NOLOGGING

COMPUTE STATISTICS ;

ALTER INDEX &pri_key& LOGGING

drppky: DROP INDEX &pri_key&

creind: CREATE &unique& INDEX &ind_name&

ON &tab_name&

( /{ &fld_name& /-, /} )

TABLESPACE &tablespace&

STORAGE (INITIAL &init&

NEXT &next&

MINEXTENTS &minext&

MAXEXTENTS &maxext&

PCTINCREASE &pctinc& )

NOLOGGING

COMPUTE STATISTICS ;

ALTER INDEX &ind_name& LOGGING

drpind: DROP INDEX &ind_name&

crevie: CREATE VIEW &view_name&

( /{ &fld_name& /-, /} )

AS &query&

drpvie: DROP VIEW &view_name&

trcdat: TRUNCATE TABLE &tab_name&

deldat: DELETE FROM &tab_name& &where&

negtab: LICHECK MLICHECK

negdat: LICHECK MLICHECK

negind: LICHECK_{0 MLICHECK}0 LICHECK^{0 MLICHECK}0

negvie:

1. table storage parameters

loc: APPL0 PSAPSR3 0000

APPL1 PSAPSR3 0000

APPL2 PSAPSR3 0000

CLUST PSAPSR3 0000

DDIM PSAPSR3 0000

DFACT PSAPSR3 0000

DODS PSAPSR3 0000

POOL PSAPSR3 0000

SDIC PSAPSR3 0000

SDOCU PSAPSR3 0000

SLDEF PSAPSR3701 0000

SLEXC PSAPSR3701 0000

SLOAD PSAPSR3USR 0000

SPROT PSAPSR3 0000

SSDEF PSAPSR3701 0000

SSEXC PSAPSR3701 0000

SSRC PSAPSR3USR 0000

TEMP PSAPSR3USR 0000

USER PSAPSR3 0000

USER1 PSAPSR3USR 0000

ZUTAB PSAPSR3 0000

USER2 PSAPSR3USR 0

USER3 PSAPSR3USR 0

USER6 PSAPSR3USR 0

USER8 PSAPSR3USR 0

USER9 PSAPSR3USR 0

USR00 PSAPSR3USR 0000

USR01 PSAPSR3USR 0000

USR02 PSAPSR3USR 0000

USR03 PSAPSR3USR 0000

USR04 PSAPSR3USR 0000

USR05 PSAPSR3USR 0000

USR06 PSAPSR3USR 0000

USR07 PSAPSR3USR 0000

USR08 PSAPSR3USR 0000

USR09 PSAPSR3USR 0000

sto: 0 0000000016K 0000000040K 0000000001 2147483645

1 0000000016K 0000000160K 0000000001 2147483645

10 0000000016K 0000655360K 0000000001 2147483645

11 0000000016K 0001310720K 0000000001 2147483645

12 0000000016K 0002621440K 0000000001 2147483645

13 0000000016K 0005242880K 0000000001 2147483645

14 0000000016K 0010485760K 0000000001 2147483645

2 0000000016K 0000000640K 0000000001 2147483645

3 0000000016K 0000002560K 0000000001 2147483645

4 0000000016K 0000010240K 0000000001 2147483645

5 0000000016K 0000020480K 0000000001 2147483645

6 0000000016K 0000040960K 0000000001 2147483645

7 0000000016K 0000081920K 0000000001 2147483645

8 0000000016K 0000163840K 0000000001 2147483645

9 0000000016K 0000327680K 0000000001 2147483645

1. index storage parameters

loc: APPL0 PSAPSR3 0000

APPL1 PSAPSR3 0000

APPL2 PSAPSR3 0000

CLUST PSAPSR3 0000

DDIM PSAPSR3 0000

DFACT PSAPSR3 0000

DODS PSAPSR3 0000

POOL PSAPSR3 0000

SDIC PSAPSR3USR 0000

SDOCU PSAPSR3USR 0000

SLDEF PSAPSR3701 0000

SLEXC PSAPSR3701 0000

SLOAD PSAPSR3USR 0000

SPROT PSAPSR3USR 0000

SSDEF PSAPSR3701 0000

SSEXC PSAPSR3701 0000

SSRC PSAPSR3USR 0000

TEMP PSAPSR3USR 0000

USER PSAPSR3 0000

USER1 PSAPSR3USR 0000

ZUTAB PSAPSR3 0000

USER2 PSAPSR3USR 0

USER3 PSAPSR3USR 0

USER6 PSAPSR3USR 0

USER8 PSAPSR3USR 0

USER9 PSAPSR3USR 0

USR00 PSAPSR3USR 0000

USR01 PSAPSR3USR 0000

USR02 PSAPSR3USR 0000

USR03 PSAPSR3USR 0000

USR04 PSAPSR3USR 0000

USR05 PSAPSR3USR 0000

USR06 PSAPSR3USR 0000

USR07 PSAPSR3USR 0000

USR08 PSAPSR3USR 0000

USR09 PSAPSR3USR 0000

sto: 0 0000000016K 0000000040K 0000000001 2147483645

1 0000000016K 0000000080K 0000000001 2147483645

10 0000000016K 0000163840K 0000000001 2147483645

11 0000000016K 0000327680K 0000000001 2147483645

12 0000000016K 0000655360K 0000000001 2147483645

13 0000000016K 0001310720K 0000000001 2147483645

14 0000000016K 0002621440K 0000000001 2147483645

2 0000000016K 0000000160K 0000000001 2147483645

3 0000000016K 0000000640K 0000000001 2147483645

4 0000000016K 0000002560K 0000000001 2147483645

5 0000000016K 0000005120K 0000000001 2147483645

6 0000000016K 0000010240K 0000000001 2147483645

7 0000000016K 0000020480K 0000000001 2147483645

8 0000000016K 0000040960K 0000000001 2147483645

9 0000000016K 0000081920K 0000000001 2147483645

[Former Member]

See ZUTAB.SQL :

#

1. ORACLE : NATIVE SQL EXPORT GENERATED AT 20110906023442

#

tab: BKPF

sql: CREATE TABLE "BKPF"

("MANDT" VARCHAR2 (000009)

DEFAULT '000' NOT NULL,

"BUKRS" VARCHAR2 (000012)

DEFAULT ' ' NOT NULL,

"BELNR" VARCHAR2 (000030)

DEFAULT ' ' NOT NULL,

"GJAHR" VARCHAR2 (000012)

DEFAULT '0000' NOT NULL,

"BLART" VARCHAR2 (000006)

DEFAULT ' ' NOT NULL,

"BLDAT" VARCHAR2 (000024)

DEFAULT '00000000' NOT NULL,

"BUDAT" VARCHAR2 (000024)

DEFAULT '00000000' NOT NULL,

"MONAT" VARCHAR2 (000006)

DEFAULT '00' NOT NULL,

"CPUDT" VARCHAR2 (000024)

DEFAULT '00000000' NOT NULL,

"CPUTM" VARCHAR2 (000018)

DEFAULT '000000' NOT NULL,

"AEDAT" VARCHAR2 (000024)

DEFAULT '00000000' NOT NULL,

"UPDDT" VARCHAR2 (000024)

DEFAULT '00000000' NOT NULL,

"WWERT" VARCHAR2 (000024)

DEFAULT '00000000' NOT NULL,

"USNAM" VARCHAR2 (000036)

DEFAULT ' ' NOT NULL,

"TCODE" VARCHAR2 (000060)

DEFAULT ' ' NOT NULL,

"BVORG" VARCHAR2 (000048)

DEFAULT ' ' NOT NULL,

"XBLNR" VARCHAR2 (000048)

DEFAULT ' ' NOT NULL,

"DBBLG" VARCHAR2 (000030)

DEFAULT ' ' NOT NULL,

"STBLG" VARCHAR2 (000030)

DEFAULT ' ' NOT NULL,

"STJAH" VARCHAR2 (000012)

DEFAULT '0000' NOT NULL,

"BKTXT" VARCHAR2 (000075)

DEFAULT ' ' NOT NULL,

"WAERS" VARCHAR2 (000015)

DEFAULT ' ' NOT NULL,

"KURSF" NUMBER (000009, 000005)

DEFAULT 0 NOT NULL,

"KZWRS" VARCHAR2 (000015)

DEFAULT ' ' NOT NULL,

"KZKRS" NUMBER (000009, 000005)

DEFAULT 0 NOT NULL,

"BSTAT" VARCHAR2 (000003)

DEFAULT ' ' NOT NULL,

"XNETB" VARCHAR2 (000003)

DEFAULT ' ' NOT NULL,

"FRATH" NUMBER (000013, 000002)

DEFAULT 0 NOT NULL,

"XRUEB" VARCHAR2 (000003)

DEFAULT ' ' NOT NULL,

"GLVOR" VARCHAR2 (000012)

DEFAULT ' ' NOT NULL,

"GRPID" VARCHAR2 (000036)

DEFAULT ' ' NOT NULL,

"DOKID" VARCHAR2 (000120)

DEFAULT ' ' NOT NULL,

"ARCID" VARCHAR2 (000030)

DEFAULT ' ' NOT NULL,

"IBLAR" VARCHAR2 (000006)

DEFAULT ' ' NOT NULL,

"AWTYP" VARCHAR2 (000015)

DEFAULT ' ' NOT NULL,

"AWKEY" VARCHAR2 (000060)

DEFAULT ' ' NOT NULL,

"FIKRS" VARCHAR2 (000012)

DEFAULT ' ' NOT NULL,

"HWAER" VARCHAR2 (000015)

DEFAULT ' ' NOT NULL,

"HWAE2" VARCHAR2 (000015)

DEFAULT ' ' NOT NULL,

"HWAE3" VARCHAR2 (000015)

DEFAULT ' ' NOT NULL,

"KURS2" NUMBER (000009, 000005)

DEFAULT 0 NOT NULL,

"KURS3" NUMBER (000009, 000005)

DEFAULT 0 NOT NULL,

"BASW2" VARCHAR2 (000003)

DEFAULT ' ' NOT NULL,

"BASW3" VARCHAR2 (000003)

DEFAULT ' ' NOT NULL,

"UMRD2" VARCHAR2 (000003)

DEFAULT ' ' NOT NULL,

"UMRD3" VARCHAR2 (000003)

DEFAULT ' ' NOT NULL,

"XSTOV" VARCHAR2 (000003)

DEFAULT ' ' NOT NULL,

"STODT" VARCHAR2 (000024)

DEFAULT '00000000' NOT NULL,

"XMWST" VARCHAR2 (000003)

DEFAULT ' ' NOT NULL,

"CURT2" VARCHAR2 (000006)

DEFAULT ' ' NOT NULL,

"CURT3" VARCHAR2 (000006)

DEFAULT ' ' NOT NULL,

"KUTY2" VARCHAR2 (000012)

DEFAULT ' ' NOT NULL,

"KUTY3" VARCHAR2 (000012)

DEFAULT ' ' NOT NULL,

"XSNET" VARCHAR2 (000003)

DEFAULT ' ' NOT NULL,

"AUSBK" VARCHAR2 (000012)

DEFAULT ' ' NOT NULL,

"XUSVR" VARCHAR2 (000003)

DEFAULT ' ' NOT NULL,

"DUEFL" VARCHAR2 (000003)

DEFAULT ' ' NOT NULL,

"AWSYS" VARCHAR2 (000030)

DEFAULT ' ' NOT NULL,

"TXKRS" NUMBER (000009, 000005)

DEFAULT 0 NOT NULL,

"LOTKZ" VARCHAR2 (000030)

DEFAULT ' ' NOT NULL,

"XWVOF" VARCHAR2 (000003)

DEFAULT ' ' NOT NULL,

"STGRD" VARCHAR2 (000006)

DEFAULT ' ' NOT NULL,

"PPNAM" VARCHAR2 (000036)

DEFAULT ' ' NOT NULL,

"BRNCH" VARCHAR2 (000012)

DEFAULT ' ' NOT NULL,

"NUMPG" VARCHAR2 (000009)

DEFAULT '000' NOT NULL,

"ADISC" VARCHAR2 (000003)

DEFAULT ' ' NOT NULL,

"XREF1_HD" VARCHAR2 (000060)

DEFAULT ' ' NOT NULL,

"XREF2_HD" VARCHAR2 (000060)

DEFAULT ' ' NOT NULL,

"XREVERSAL" VARCHAR2 (000003)

DEFAULT ' ' NOT NULL,

"REINDAT" VARCHAR2 (000024)

DEFAULT '00000000' NOT NULL,

"RLDNR" VARCHAR2 (000006)

DEFAULT ' ' NOT NULL,

"LDGRP" VARCHAR2 (000012)

DEFAULT ' ' NOT NULL,

"PROPMANO" VARCHAR2 (000039)

DEFAULT ' ' NOT NULL,

"XBLNR_ALT" VARCHAR2 (000078)

DEFAULT ' ' NOT NULL,

"VATDATE" VARCHAR2 (000024)

DEFAULT '00000000' NOT NULL,

"XSPLIT" VARCHAR2 (000003)

DEFAULT ' ' NOT NULL,

"PSOTY" VARCHAR2 (000006)

DEFAULT ' ' NOT NULL,

"PSOAK" VARCHAR2 (000030)

DEFAULT ' ' NOT NULL,

"PSOKS" VARCHAR2 (000030)

DEFAULT ' ' NOT NULL,

"PSOSG" VARCHAR2 (000003)

DEFAULT ' ' NOT NULL,

"PSOFN" VARCHAR2 (000090)

DEFAULT ' ' NOT NULL,

"INTFORM" VARCHAR2 (000012)

DEFAULT ' ' NOT NULL,

"INTDATE" VARCHAR2 (000024)

DEFAULT '00000000' NOT NULL,

"PSOBT" VARCHAR2 (000024)

DEFAULT '00000000' NOT NULL,

"PSOZL" VARCHAR2 (000003)

DEFAULT ' ' NOT NULL,

"PSODT" VARCHAR2 (000024)

DEFAULT '00000000' NOT NULL,

"PSOTM" VARCHAR2 (000018)

DEFAULT '000000' NOT NULL,

"FM_UMART" VARCHAR2 (000003)

DEFAULT ' ' NOT NULL,

"CCINS" VARCHAR2 (000012)

DEFAULT ' ' NOT NULL,

"CCNUM" VARCHAR2 (000075)

DEFAULT ' ' NOT NULL,

"SSBLK" VARCHAR2 (000003)

DEFAULT ' ' NOT NULL,

"BATCH" VARCHAR2 (000030)

DEFAULT ' ' NOT NULL,

"SNAME" VARCHAR2 (000036)

DEFAULT ' ' NOT NULL,

"SAMPLED" VARCHAR2 (000003)

DEFAULT ' ' NOT NULL,

"EXCLUDE_FLAG" VARCHAR2 (000003)

DEFAULT ' ' NOT NULL,

"BLIND" VARCHAR2 (000003)

DEFAULT ' ' NOT NULL,

"OFFSET_STATUS" VARCHAR2 (000006)

DEFAULT ' ' NOT NULL,

"OFFSET_REFER_DAT" VARCHAR2 (000024)

DEFAULT '00000000' NOT NULL,

"PENRC" VARCHAR2 (000006)

DEFAULT ' ' NOT NULL,

"KNUMV" VARCHAR2 (000030)

DEFAULT ' ' NOT NULL)

PCTFREE 20

PCTUSED 00

INITRANS 001

TABLESPACE &ZUTAB&

STORAGE (INITIAL 0000368656 K

NEXT 0000368656 K

MINEXTENTS 0000000001

MAXEXTENTS UNLIMITED

PCTINCREASE 0000

FREELISTS 001

FREELIST GROUPS 01) ;

[Former Member]

Contd..ZUTAB.SQL

ind: BKPF~0

sql: CREATE UNIQUE INDEX "BKPF~0" ON "BKPF"

("MANDT",

"BUKRS",

"BELNR",

"GJAHR")

PCTFREE 01

INITRANS 002

TABLESPACE &ZUTAB&

COMPRESS 3

STORAGE (INITIAL 0000070416 K

NEXT 0000070416 K

MINEXTENTS 0000000001

MAXEXTENTS UNLIMITED

PCTINCREASE 0000

FREELISTS 001) PARALLEL ;

ALTER INDEX "BKPF~0" NOPARALLEL ;

ind: BKPF~1

sql: CREATE

INDEX "BKPF~1" ON "BKPF"

("MANDT",

"BUKRS",

"BSTAT",

"XBLNR")

PCTFREE 01

INITRANS 002

TABLESPACE &ZUTAB&

COMPRESS 4

STORAGE (INITIAL 0000060176 K

NEXT 0000060176 K

MINEXTENTS 0000000001

MAXEXTENTS UNLIMITED

PCTINCREASE 0000

FREELISTS 001) PARALLEL ;

ALTER INDEX "BKPF~1" NOPARALLEL ;

ind: BKPF~2

sql: CREATE

INDEX "BKPF~2" ON "BKPF"

("MANDT",

"BUKRS",

"BSTAT",

"BUDAT")

PCTFREE 01

INITRANS 002

TABLESPACE &ZUTAB&

COMPRESS 4

STORAGE (INITIAL 0000075536 K

NEXT 0000075536 K

MINEXTENTS 0000000001

MAXEXTENTS UNLIMITED

PCTINCREASE 0000

FREELISTS 001) PARALLEL ;

ALTER INDEX "BKPF~2" NOPARALLEL ;

ind: BKPF~3

sql: CREATE

INDEX "BKPF~3" ON "BKPF"

("MANDT",

"BUKRS",

"BSTAT",

"BLART")

PCTFREE 01

INITRANS 002

TABLESPACE &ZUTAB&

COMPRESS 4

STORAGE (INITIAL 0000060816 K

NEXT 0000060816 K

MINEXTENTS 0000000001

MAXEXTENTS UNLIMITED

PCTINCREASE 0000

FREELISTS 001) PARALLEL ;

ALTER INDEX "BKPF~3" NOPARALLEL ;

ind: BKPF~4

sql: CREATE

INDEX "BKPF~4" ON "BKPF"

("MANDT",

"AWTYP",

"AWKEY",

"AWSYS")

PCTFREE 01

INITRANS 002

TABLESPACE &ZUTAB&

COMPRESS 2

STORAGE (INITIAL 0000095376 K

NEXT 0000095376 K

MINEXTENTS 0000000001

MAXEXTENTS UNLIMITED

PCTINCREASE 0000

FREELISTS 001) PARALLEL ;

ALTER INDEX "BKPF~4" NOPARALLEL ;

ind: BKPF~5

sql: CREATE

INDEX "BKPF~5" ON "BKPF"

("MANDT",

"BUKRS",

"CPUDT",

"BSTAT")

PCTFREE 01

INITRANS 002

TABLESPACE &ZUTAB&

COMPRESS 4

STORAGE (INITIAL 0000076816 K

NEXT 0000076816 K

MINEXTENTS 0000000001

MAXEXTENTS UNLIMITED

PCTINCREASE 0000

FREELISTS 001) PARALLEL ;

ALTER INDEX "BKPF~5" NOPARALLEL ;

ind: BKPF~6

sql: CREATE

INDEX "BKPF~6" ON "BKPF"

("MANDT",

"BUKRS",

"BLDAT",

"BSTAT")

PCTFREE 01

INITRANS 002

TABLESPACE &ZUTAB&

COMPRESS 4

STORAGE (INITIAL 0000071696 K

NEXT 0000071696 K

MINEXTENTS 0000000001

MAXEXTENTS UNLIMITED

PCTINCREASE 0000

FREELISTS 001) PARALLEL ;

ALTER INDEX "BKPF~6" NOPARALLEL ;

ind: BKPF~BUT

sql: CREATE

INDEX "BKPF~BUT" ON "BKPF"

("MANDT",

"PSOBT",

"PSOZL",

"BUKRS")

PCTFREE 01

INITRANS 002

TABLESPACE &ZUTAB&

NOCOMPRESS

STORAGE (INITIAL 0000070416 K

NEXT 0000070416 K

MINEXTENTS 0000000001

MAXEXTENTS UNLIMITED

PCTINCREASE 0000

FREELISTS 001) PARALLEL ;

ALTER INDEX "BKPF~BUT" NOPARALLEL ;

ind: BKPF~Z0

sql: CREATE

INDEX "BKPF~Z0" ON "BKPF"

("BLART",

"XBLNR",

"STGRD")

PCTFREE 01

INITRANS 002

TABLESPACE &ZUTAB&

COMPRESS 3

STORAGE (INITIAL 0000115200 K

NEXT 0000115200 K

MINEXTENTS 0000000001

MAXEXTENTS UNLIMITED

PCTINCREASE 0000

FREELISTS 001) PARALLEL ;

ALTER INDEX "BKPF~Z0" NOPARALLEL ;

ind: BKPF~Z1

sql: CREATE

INDEX "BKPF~Z1" ON "BKPF"

("MANDT",

"BUKRS",

"GJAHR",

"BUDAT",

"AWKEY")

PCTFREE 01

INITRANS 002

TABLESPACE &ZUTAB&

COMPRESS 4

STORAGE (INITIAL 0000070416 K

NEXT 0000070416 K

MINEXTENTS 0000000001

MAXEXTENTS UNLIMITED

PCTINCREASE 0000

FREELISTS 001) PARALLEL ;

ALTER INDEX "BKPF~Z1" NOPARALLEL ;

tab: BSIS

sql: CREATE TABLE "BSIS"

("MANDT" VARCHAR2 (000009)

DEFAULT '000' NOT NULL,

"BUKRS" VARCHAR2 (000012)

DEFAULT ' ' NOT NULL,

"HKONT" VARCHAR2 (000030)

DEFAULT ' ' NOT NULL,

"AUGDT" VARCHAR2 (000024)

DEFAULT '00000000' NOT NULL,

"AUGBL" VARCHAR2 (000030)

DEFAULT ' ' NOT NULL,

"ZUONR" VARCHAR2 (000054)

DEFAULT ' ' NOT NULL,

"GJAHR" VARCHAR2 (000012)

DEFAULT '0000' NOT NULL,

"BELNR" VARCHAR2 (000030)

DEFAULT ' ' NOT NULL,

"BUZEI" VARCHAR2 (000009)

DEFAULT '000' NOT NULL,

"BUDAT" VARCHAR2 (000024)

DEFAULT '00000000' NOT NULL,

"BLDAT" VARCHAR2 (000024)

DEFAULT '00000000' NOT NULL,

"WAERS" VARCHAR2 (000015)

DEFAULT ' ' NOT NULL,

"XBLNR" VARCHAR2 (000048)

DEFAULT ' ' NOT NULL,

"BLART" VARCHAR2 (000006)

DEFAULT ' ' NOT NULL,

"MONAT" VARCHAR2 (000006)

DEFAULT '00' NOT NULL,

"BSCHL" VARCHAR2 (000006)

DEFAULT ' ' NOT NULL,

"SHKZG" VARCHAR2 (000003)

DEFAULT ' ' NOT NULL,

"GSBER" VARCHAR2 (000012)

DEFAULT ' ' NOT NULL,

"MWSKZ" VARCHAR2 (000006)

DEFAULT ' ' NOT NULL,

"FKONT" VARCHAR2 (000009)

DEFAULT '000' NOT NULL,

"DMBTR" NUMBER (000013, 000002)

DEFAULT 0 NOT NULL,

"WRBTR" NUMBER (000013, 000002)

DEFAULT 0 NOT NULL,

"MWSTS" NUMBER (000013, 000002)

DEFAULT 0 NOT NULL,

"WMWST" NUMBER (000013, 000002)

DEFAULT 0 NOT NULL,

"SGTXT" VARCHAR2 (000150)

DEFAULT ' ' NOT NULL,

"PROJN" VARCHAR2 (000048)

DEFAULT ' ' NOT NULL,

"AUFNR" VARCHAR2 (000036)

DEFAULT ' ' NOT NULL,

"WERKS" VARCHAR2 (000012)

DEFAULT ' ' NOT NULL,

"KOSTL" VARCHAR2 (000030)

DEFAULT ' ' NOT NULL,

"ZFBDT" VARCHAR2 (000024)

DEFAULT '00000000' NOT NULL,

"XOPVW" VARCHAR2 (000003)

DEFAULT ' ' NOT NULL,

"VALUT" VARCHAR2 (000024)

DEFAULT '00000000' NOT NULL,

"BSTAT" VARCHAR2 (000003)

DEFAULT ' ' NOT NULL,

"BDIFF" NUMBER (000013, 000002)

DEFAULT 0 NOT NULL,

"BDIF2" NUMBER (000013, 000002)

DEFAULT 0 NOT NULL,

"VBUND" VARCHAR2 (000018)

DEFAULT ' ' NOT NULL,

"PSWSL" VARCHAR2 (000015)

DEFAULT ' ' NOT NULL,

"WVERW" VARCHAR2 (000003)

DEFAULT ' ' NOT NULL,

"DMBE2" NUMBER (000013, 000002)

DEFAULT 0 NOT NULL,

"DMBE3" NUMBER (000013, 000002)

DEFAULT 0 NOT NULL,

"MWST2" NUMBER (000013, 000002)

DEFAULT 0 NOT NULL,

"MWST3" NUMBER (000013, 000002)

DEFAULT 0 NOT NULL,

"BDIF3" NUMBER (000013, 000002)

DEFAULT 0 NOT NULL,

"RDIF3" NUMBER (000013, 000002)

DEFAULT 0 NOT NULL,

"XRAGL" VARCHAR2 (000003)

DEFAULT ' ' NOT NULL,

"PROJK" VARCHAR2 (000024)

DEFAULT '00000000' NOT NULL,

"PRCTR" VARCHAR2 (000030)

DEFAULT ' ' NOT NULL,

"XSTOV" VARCHAR2 (000003)

DEFAULT ' ' NOT NULL,

"XARCH" VARCHAR2 (000003)

DEFAULT ' ' NOT NULL,

"PSWBT" NUMBER (000013, 000002)

DEFAULT 0 NOT NULL,

"XNEGP" VARCHAR2 (000003)

DEFAULT ' ' NOT NULL,

"RFZEI" VARCHAR2 (000009)

DEFAULT '000' NOT NULL,

"CCBTC" VARCHAR2 (000030)

DEFAULT ' ' NOT NULL,

"XREF3" VARCHAR2 (000060)

DEFAULT ' ' NOT NULL,

"BUPLA" VARCHAR2 (000012)

DEFAULT ' ' NOT NULL,

"PPDIFF" NUMBER (000013, 000002)

DEFAULT 0 NOT NULL,

"PPDIF2" NUMBER (000013, 000002)

DEFAULT 0 NOT NULL,

"PPDIF3" NUMBER (000013, 000002)

DEFAULT 0 NOT NULL,

"BEWAR" VARCHAR2 (000009)

DEFAULT ' ' NOT NULL,

"IMKEY" VARCHAR2 (000024)

DEFAULT ' ' NOT NULL,

"DABRZ" VARCHAR2 (000024)

DEFAULT '00000000' NOT NULL,

"INTRENO" VARCHAR2 (000039)

DEFAULT ' ' NOT NULL,

"GRANT_NBR" VARCHAR2 (000060)

DEFAULT ' ' NOT NULL,

"FKBER" VARCHAR2 (000048)

DEFAULT ' ' NOT NULL,

"FIPOS" VARCHAR2 (000042)

DEFAULT ' ' NOT NULL,

"FISTL" VARCHAR2 (000048)

DEFAULT ' ' NOT NULL,

"GEBER" VARCHAR2 (000030)

DEFAULT ' ' NOT NULL,

"PPRCT" VARCHAR2 (000030)

DEFAULT ' ' NOT NULL,

"BUZID" VARCHAR2 (000003)

DEFAULT ' ' NOT NULL,

"AUGGJ" VARCHAR2 (000012)

DEFAULT '0000' NOT NULL,

"UZAWE" VARCHAR2 (000006)

DEFAULT ' ' NOT NULL,

"SEGMENT" VARCHAR2 (000030)

DEFAULT ' ' NOT NULL,

"PSEGMENT" VARCHAR2 (000030)

DEFAULT ' ' NOT NULL,

"PGEBER" VARCHAR2 (000030)

DEFAULT ' ' NOT NULL,

"PGRANT_NBR" VARCHAR2 (000060)

DEFAULT ' ' NOT NULL,

"MEASURE" VARCHAR2 (000072)

DEFAULT ' ' NOT NULL,

"BUDGET_PD" VARCHAR2 (000030)

DEFAULT ' ' NOT NULL,

"PBUDGET_PD" VARCHAR2 (000030)

DEFAULT ' ' NOT NULL,

"FIPEX" VARCHAR2 (000072)

DEFAULT ' ' NOT NULL,

"PRODPER" VARCHAR2 (000018)

DEFAULT ' ' NOT NULL,

"QSSKZ" VARCHAR2 (000006)

DEFAULT ' ' NOT NULL,

"PROPMANO" VARCHAR2 (000039)

DEFAULT ' ' NOT NULL)

PCTFREE 10

PCTUSED 40

INITRANS 001

TABLESPACE &&

STORAGE (INITIAL 0000204784 K

NEXT 0000100000 K

MINEXTENTS 0000000001

MAXEXTENTS UNLIMITED

PCTINCREASE 0000

FREELISTS 001

FREELIST GROUPS 01) ;

ind: BSIS~0

sql: CREATE UNIQUE INDEX "BSIS~0" ON "BSIS"

("MANDT",

"BUKRS",

"HKONT",

"AUGDT",

"AUGBL",

"ZUONR",

"GJAHR",

"BELNR",

"BUZEI")

PCTFREE 10

INITRANS 002

TABLESPACE &&

NOCOMPRESS

STORAGE (INITIAL 0000102384 K

NEXT 0000051200 K

MINEXTENTS 0000000001

MAXEXTENTS UNLIMITED

PCTINCREASE 0000

FREELISTS 001) PARALLEL ;

ALTER INDEX "BSIS~0" NOPARALLEL ;

ind: BSIS~1

sql: CREATE

INDEX "BSIS~1" ON "BSIS"

("MANDT",

"BUKRS",

"BELNR",

"GJAHR",

"BUZEI")

PCTFREE 10

INITRANS 002

TABLESPACE &&

NOCOMPRESS

STORAGE (INITIAL 0000102384 K

NEXT 0000051200 K

MINEXTENTS 0000000001

MAXEXTENTS UNLIMITED

PCTINCREASE 0000

FREELISTS 001) PARALLEL ;

ALTER INDEX "BSIS~1" NOPARALLEL ;

ind: BSIS~Z01

sql: CREATE

INDEX "BSIS~Z01" ON "BSIS"

("MANDT",

"BUKRS",

"HKONT",

"GJAHR",

"MONAT",

"VBUND")

PCTFREE 01

INITRANS 002

TABLESPACE &&

COMPRESS 6

STORAGE (INITIAL 0000102384 K

NEXT 0000081200 K

MINEXTENTS 0000000001

MAXEXTENTS UNLIMITED

PCTINCREASE 0000

FREELISTS 001) PARALLEL ;

ALTER INDEX "BSIS~Z01" NOPARALLEL ;

[Former Member]

ind: BSIS~Z03

sql: CREATE

INDEX "BSIS~Z03" ON "BSIS"

("MANDT",

"BUKRS",

"HKONT",

"BUDAT")

PCTFREE 01

INITRANS 002

TABLESPACE &&

COMPRESS 4

STORAGE (INITIAL 0000102384 K

NEXT 0000081200 K

MINEXTENTS 0000000001

MAXEXTENTS UNLIMITED

PCTINCREASE 0000

FREELISTS 001) PARALLEL ;

ALTER INDEX "BSIS~Z03" NOPARALLEL ;

tab: COEP

sql: CREATE TABLE "COEP"

("MANDT" VARCHAR2 (000009)

DEFAULT '000' NOT NULL,

"KOKRS" VARCHAR2 (000012)

DEFAULT ' ' NOT NULL,

"BELNR" VARCHAR2 (000030)

DEFAULT ' ' NOT NULL,

"BUZEI" VARCHAR2 (000009)

DEFAULT '000' NOT NULL,

"PERIO" VARCHAR2 (000009)

DEFAULT '000' NOT NULL,

"WTGBTR" NUMBER (000015, 000002)

DEFAULT 0 NOT NULL,

"WOGBTR" NUMBER (000015, 000002)

DEFAULT 0 NOT NULL,

"WKGBTR" NUMBER (000015, 000002)

DEFAULT 0 NOT NULL,

"WKFBTR" NUMBER (000015, 000002)

DEFAULT 0 NOT NULL,

"PAGBTR" NUMBER (000015, 000002)

DEFAULT 0 NOT NULL,

"PAFBTR" NUMBER (000015, 000002)

DEFAULT 0 NOT NULL,

"MEGBTR" NUMBER (000015, 000003)

DEFAULT 0 NOT NULL,

"MEFBTR" NUMBER (000015, 000003)

DEFAULT 0 NOT NULL,

"MBGBTR" NUMBER (000015, 000003)

DEFAULT 0 NOT NULL,

"MBFBTR" NUMBER (000015, 000003)

DEFAULT 0 NOT NULL,

"LEDNR" VARCHAR2 (000006)

DEFAULT ' ' NOT NULL,

"OBJNR" VARCHAR2 (000066)

DEFAULT ' ' NOT NULL,

"GJAHR" VARCHAR2 (000012)

DEFAULT '0000' NOT NULL,

"WRTTP" VARCHAR2 (000006)

DEFAULT ' ' NOT NULL,

"VERSN" VARCHAR2 (000009)

DEFAULT ' ' NOT NULL,

"KSTAR" VARCHAR2 (000030)

DEFAULT ' ' NOT NULL,

"HRKFT" VARCHAR2 (000042)

DEFAULT ' ' NOT NULL,

"VRGNG" VARCHAR2 (000012)

DEFAULT ' ' NOT NULL,

"PAROB" VARCHAR2 (000066)

DEFAULT ' ' NOT NULL,

"PAROB1" VARCHAR2 (000066)

DEFAULT ' ' NOT NULL,

"USPOB" VARCHAR2 (000066)

DEFAULT ' ' NOT NULL,

"VBUND" VARCHAR2 (000018)

DEFAULT ' ' NOT NULL,

"PARGB" VARCHAR2 (000012)

DEFAULT ' ' NOT NULL,

"BEKNZ" VARCHAR2 (000003)

DEFAULT ' ' NOT NULL,

"TWAER" VARCHAR2 (000015)

DEFAULT ' ' NOT NULL,

"OWAER" VARCHAR2 (000015)

DEFAULT ' ' NOT NULL,

"MEINH" VARCHAR2 (000009)

DEFAULT ' ' NOT NULL,

"MEINB" VARCHAR2 (000009)

DEFAULT ' ' NOT NULL,

"MVFLG" VARCHAR2 (000003)

DEFAULT ' ' NOT NULL,

"SGTXT" VARCHAR2 (000150)

DEFAULT ' ' NOT NULL,

"REFBZ" VARCHAR2 (000009)

DEFAULT '000' NOT NULL,

"ZLENR" VARCHAR2 (000009)

DEFAULT '000' NOT NULL,

"BW_REFBZ" VARCHAR2 (000009)

DEFAULT '000' NOT NULL,

"GKONT" VARCHAR2 (000030)

DEFAULT ' ' NOT NULL,

"GKOAR" VARCHAR2 (000003)

DEFAULT ' ' NOT NULL,

"WERKS" VARCHAR2 (000012)

DEFAULT ' ' NOT NULL,

"MATNR" VARCHAR2 (000054)

DEFAULT ' ' NOT NULL,

"RBEST" VARCHAR2 (000009)

DEFAULT '000' NOT NULL,

"EBELN" VARCHAR2 (000030)

DEFAULT ' ' NOT NULL,

"EBELP" VARCHAR2 (000015)

DEFAULT '00000' NOT NULL,

"ZEKKN" VARCHAR2 (000006)

DEFAULT '00' NOT NULL,

"ERLKZ" VARCHAR2 (000003)

DEFAULT ' ' NOT NULL,

"PERNR" VARCHAR2 (000024)

DEFAULT '00000000' NOT NULL,

"BTRKL" VARCHAR2 (000006)

DEFAULT '00' NOT NULL,

"OBJNR_N1" VARCHAR2 (000066)

DEFAULT ' ' NOT NULL,

"OBJNR_N2" VARCHAR2 (000066)

DEFAULT ' ' NOT NULL,

"OBJNR_N3" VARCHAR2 (000066)

DEFAULT ' ' NOT NULL,

"PAOBJNR" VARCHAR2 (000030)

DEFAULT '0000000000' NOT NULL,

"BELTP" VARCHAR2 (000003)

DEFAULT '0' NOT NULL,

"BUKRS" VARCHAR2 (000012)

DEFAULT ' ' NOT NULL,

"GSBER" VARCHAR2 (000012)

DEFAULT ' ' NOT NULL,

"FKBER" VARCHAR2 (000048)

DEFAULT ' ' NOT NULL,

"SCOPE" VARCHAR2 (000006)

DEFAULT ' ' NOT NULL,

"LOGSYSO" VARCHAR2 (000030)

DEFAULT ' ' NOT NULL,

"PKSTAR" VARCHAR2 (000030)

DEFAULT ' ' NOT NULL,

"PBUKRS" VARCHAR2 (000012)

DEFAULT ' ' NOT NULL,

"PFKBER" VARCHAR2 (000048)

DEFAULT ' ' NOT NULL,

"PSCOPE" VARCHAR2 (000006)

DEFAULT ' ' NOT NULL,

"LOGSYSP" VARCHAR2 (000030)

DEFAULT ' ' NOT NULL,

"DABRZ" VARCHAR2 (000024)

DEFAULT '00000000' NOT NULL,

"BWSTRAT" VARCHAR2 (000003)

DEFAULT ' ' NOT NULL,

"OBJNR_HK" VARCHAR2 (000066)

DEFAULT ' ' NOT NULL,

"TIMESTMP" NUMBER (000016, 000000)

DEFAULT 0 NOT NULL,

"QMNUM" VARCHAR2 (000036)

DEFAULT ' ' NOT NULL,

"GEBER" VARCHAR2 (000030)

DEFAULT ' ' NOT NULL,

"PGEBER" VARCHAR2 (000030)

DEFAULT ' ' NOT NULL,

"GRANT_NBR" VARCHAR2 (000060)

DEFAULT ' ' NOT NULL,

"PGRANT_NBR" VARCHAR2 (000060)

DEFAULT ' ' NOT NULL,

"REFBZ_FI" VARCHAR2 (000009)

DEFAULT '000' NOT NULL,

"SEGMENT" VARCHAR2 (000030)

DEFAULT ' ' NOT NULL,

"PSEGMENT" VARCHAR2 (000030)

DEFAULT ' ' NOT NULL,

"BUDGET_PD" VARCHAR2 (000030)

DEFAULT ' ' NOT NULL,

"PBUDGET_PD" VARCHAR2 (000030)

DEFAULT ' ' NOT NULL)

PCTFREE 10

PCTUSED 00

INITRANS 001

TABLESPACE &ZUTAB&

STORAGE (INITIAL 0000102384 K

NEXT 0000102384 K

MINEXTENTS 0000000001

MAXEXTENTS UNLIMITED

PCTINCREASE 0000

FREELISTS 001

FREELIST GROUPS 01) ;

ind: COEP~0

sql: CREATE UNIQUE INDEX "COEP~0" ON "COEP"

("MANDT",

"KOKRS",

"BELNR",

"BUZEI")

PCTFREE 01

INITRANS 002

TABLESPACE &ZUTAB&

COMPRESS 3

STORAGE (INITIAL 0000051184 K

NEXT 0000051184 K

MINEXTENTS 0000000001

MAXEXTENTS UNLIMITED

PCTINCREASE 0000

FREELISTS 001) PARALLEL ;

ALTER INDEX "COEP~0" NOPARALLEL ;

ind: COEP~1

sql: CREATE

INDEX "COEP~1" ON "COEP"

("MANDT",

"LEDNR",

"OBJNR",

"GJAHR",

"WRTTP",

"VERSN",

"KSTAR",

"HRKFT",

"PERIO",

"VRGNG",

"PAROB",

"USPOB",

"VBUND",

"PARGB",

"BEKNZ",

"TWAER")

PCTFREE 01

INITRANS 002

TABLESPACE &ZUTAB&

COMPRESS 16

STORAGE (INITIAL 0000051184 K

NEXT 0000051184 K

MINEXTENTS 0000000001

MAXEXTENTS UNLIMITED

PCTINCREASE 0000

FREELISTS 001) PARALLEL ;

ALTER INDEX "COEP~1" NOPARALLEL ;

ind: COEP~Z01

sql: CREATE

INDEX "COEP~Z01" ON "COEP"

("MANDT",

"KOKRS",

"OBJNR")

PCTFREE 01

INITRANS 002

TABLESPACE &ZUTAB&

COMPRESS 3

STORAGE (INITIAL 0000051184 K

NEXT 0000051184 K

MINEXTENTS 0000000001

MAXEXTENTS UNLIMITED

PCTINCREASE 0000

FREELISTS 001) PARALLEL ;

ALTER INDEX "COEP~Z01" NOPARALLEL ;

[Former Member]

tab: GLPCA

sql: CREATE TABLE "GLPCA"

("RCLNT" VARCHAR2 (000009)

DEFAULT '000' NOT NULL,

"GL_SIRID" VARCHAR2 (000054)

DEFAULT ' ' NOT NULL,

"RLDNR" VARCHAR2 (000006)

DEFAULT ' ' NOT NULL,

"RRCTY" VARCHAR2 (000003)

DEFAULT ' ' NOT NULL,

"RVERS" VARCHAR2 (000009)

DEFAULT ' ' NOT NULL,

"RYEAR" VARCHAR2 (000012)

DEFAULT '0000' NOT NULL,

"RTCUR" VARCHAR2 (000015)

DEFAULT ' ' NOT NULL,

"RUNIT" VARCHAR2 (000009)

DEFAULT ' ' NOT NULL,

"DRCRK" VARCHAR2 (000003)

DEFAULT ' ' NOT NULL,

"POPER" VARCHAR2 (000009)

DEFAULT '000' NOT NULL,

"DOCCT" VARCHAR2 (000003)

DEFAULT ' ' NOT NULL,

"DOCNR" VARCHAR2 (000030)

DEFAULT ' ' NOT NULL,

"DOCLN" VARCHAR2 (000009)

DEFAULT ' ' NOT NULL,

"RBUKRS" VARCHAR2 (000012)

DEFAULT ' ' NOT NULL,

"RPRCTR" VARCHAR2 (000030)

DEFAULT ' ' NOT NULL,

"RHOART" VARCHAR2 (000006)

DEFAULT '00' NOT NULL,

"RFAREA" VARCHAR2 (000048)

DEFAULT ' ' NOT NULL,

"KOKRS" VARCHAR2 (000012)

DEFAULT ' ' NOT NULL,

"RACCT" VARCHAR2 (000030)

DEFAULT ' ' NOT NULL,

"HRKFT" VARCHAR2 (000012)

DEFAULT ' ' NOT NULL,

"RASSC" VARCHAR2 (000018)

DEFAULT ' ' NOT NULL,

"EPRCTR" VARCHAR2 (000030)

DEFAULT ' ' NOT NULL,

"ACTIV" VARCHAR2 (000012)

DEFAULT ' ' NOT NULL,

"AFABE" VARCHAR2 (000006)

DEFAULT '00' NOT NULL,

"OCLNT" VARCHAR2 (000009)

DEFAULT '000' NOT NULL,

"SBUKRS" VARCHAR2 (000012)

DEFAULT ' ' NOT NULL,

"SPRCTR" VARCHAR2 (000030)

DEFAULT ' ' NOT NULL,

"SHOART" VARCHAR2 (000006)

DEFAULT '00' NOT NULL,

"SFAREA" VARCHAR2 (000048)

DEFAULT ' ' NOT NULL,

"TSL" NUMBER (000015, 000002)

DEFAULT 0 NOT NULL,

"HSL" NUMBER (000015, 000002)

DEFAULT 0 NOT NULL,

"KSL" NUMBER (000015, 000002)

DEFAULT 0 NOT NULL,

"MSL" NUMBER (000015, 000003)

DEFAULT 0 NOT NULL,

"CPUDT" VARCHAR2 (000024)

DEFAULT '00000000' NOT NULL,

"CPUTM" VARCHAR2 (000018)

DEFAULT '000000' NOT NULL,

"USNAM" VARCHAR2 (000036)

DEFAULT ' ' NOT NULL,

"SGTXT" VARCHAR2 (000150)

DEFAULT ' ' NOT NULL,

"AUTOM" VARCHAR2 (000003)

DEFAULT ' ' NOT NULL,

"DOCTY" VARCHAR2 (000006)

DEFAULT ' ' NOT NULL,

"BLDAT" VARCHAR2 (000024)

DEFAULT '00000000' NOT NULL,

"BUDAT" VARCHAR2 (000024)

DEFAULT '00000000' NOT NULL,

"WSDAT" VARCHAR2 (000024)

DEFAULT '00000000' NOT NULL,

"REFDOCNR" VARCHAR2 (000030)

DEFAULT ' ' NOT NULL,

"REFRYEAR" VARCHAR2 (000012)

DEFAULT '0000' NOT NULL,

"REFDOCLN" VARCHAR2 (000009)

DEFAULT '000' NOT NULL,

"REFDOCCT" VARCHAR2 (000003)

DEFAULT ' ' NOT NULL,

"REFACTIV" VARCHAR2 (000012)

DEFAULT ' ' NOT NULL,

"AWTYP" VARCHAR2 (000015)

DEFAULT ' ' NOT NULL,

"AWORG" VARCHAR2 (000030)

DEFAULT ' ' NOT NULL,

"WERKS" VARCHAR2 (000012)

DEFAULT ' ' NOT NULL,

"GSBER" VARCHAR2 (000012)

DEFAULT ' ' NOT NULL,

"KOSTL" VARCHAR2 (000030)

DEFAULT ' ' NOT NULL,

"LSTAR" VARCHAR2 (000018)

DEFAULT ' ' NOT NULL,

"AUFNR" VARCHAR2 (000036)

DEFAULT ' ' NOT NULL,

"AUFPL" VARCHAR2 (000030)

DEFAULT '0000000000' NOT NULL,

"ANLN1" VARCHAR2 (000036)

DEFAULT ' ' NOT NULL,

"ANLN2" VARCHAR2 (000012)

DEFAULT ' ' NOT NULL,

"MATNR" VARCHAR2 (000054)

DEFAULT ' ' NOT NULL,

"BWKEY" VARCHAR2 (000012)

DEFAULT ' ' NOT NULL,

"BWTAR" VARCHAR2 (000030)

DEFAULT ' ' NOT NULL,

"ANBWA" VARCHAR2 (000009)

DEFAULT ' ' NOT NULL,

"KUNNR" VARCHAR2 (000030)

DEFAULT ' ' NOT NULL,

"LIFNR" VARCHAR2 (000030)

DEFAULT ' ' NOT NULL,

"RMVCT" VARCHAR2 (000009)

DEFAULT ' ' NOT NULL,

"EBELN" VARCHAR2 (000030)

DEFAULT ' ' NOT NULL,

"EBELP" VARCHAR2 (000015)

DEFAULT '00000' NOT NULL,

"KSTRG" VARCHAR2 (000036)

DEFAULT ' ' NOT NULL,

"ERKRS" VARCHAR2 (000012)

DEFAULT ' ' NOT NULL,

"PAOBJNR" VARCHAR2 (000030)

DEFAULT '0000000000' NOT NULL,

"PASUBNR" VARCHAR2 (000012)

DEFAULT '0000' NOT NULL,

"PS_PSP_PNR" VARCHAR2 (000024)

DEFAULT '00000000' NOT NULL,

"KDAUF" VARCHAR2 (000030)

DEFAULT ' ' NOT NULL,

"KDPOS" VARCHAR2 (000018)

DEFAULT '000000' NOT NULL,

"FKART" VARCHAR2 (000012)

DEFAULT ' ' NOT NULL,

"VKORG" VARCHAR2 (000012)

DEFAULT ' ' NOT NULL,

"VTWEG" VARCHAR2 (000006)

DEFAULT ' ' NOT NULL,

"AUBEL" VARCHAR2 (000030)

DEFAULT ' ' NOT NULL,

"AUPOS" VARCHAR2 (000018)

DEFAULT '000000' NOT NULL,

"SPART" VARCHAR2 (000006)

DEFAULT ' ' NOT NULL,

"VBELN" VARCHAR2 (000030)

DEFAULT ' ' NOT NULL,

"POSNR" VARCHAR2 (000018)

DEFAULT '000000' NOT NULL,

"VKGRP" VARCHAR2 (000009)

DEFAULT ' ' NOT NULL,

"VKBUR" VARCHAR2 (000012)

DEFAULT ' ' NOT NULL,

"VBUND" VARCHAR2 (000018)

DEFAULT ' ' NOT NULL,

"LOGSYS" VARCHAR2 (000030)

DEFAULT ' ' NOT NULL,

"ALEBN" VARCHAR2 (000030)

DEFAULT ' ' NOT NULL,

"AWSYS" VARCHAR2 (000030)

DEFAULT ' ' NOT NULL,

"VERSA" VARCHAR2 (000009)

DEFAULT ' ' NOT NULL,

"STFLG" VARCHAR2 (000003)

DEFAULT ' ' NOT NULL,

"STOKZ" VARCHAR2 (000003)

DEFAULT ' ' NOT NULL,

"STAGR" VARCHAR2 (000018)

DEFAULT ' ' NOT NULL,

"GRTYP" VARCHAR2 (000003)

DEFAULT ' ' NOT NULL,

"REP_MATNR" VARCHAR2 (000054)

DEFAULT ' ' NOT NULL,

"CO_PRZNR" VARCHAR2 (000036)

DEFAULT ' ' NOT NULL,

"IMKEY" VARCHAR2 (000024)

DEFAULT ' ' NOT NULL,

"DABRZ" VARCHAR2 (000024)

DEFAULT '00000000' NOT NULL,

"VALUT" VARCHAR2 (000024)

DEFAULT '00000000' NOT NULL,

"RSCOPE" VARCHAR2 (000006)

DEFAULT ' ' NOT NULL,

"AWREF_REV" VARCHAR2 (000030)

DEFAULT ' ' NOT NULL,

"AWORG_REV" VARCHAR2 (000030)

DEFAULT ' ' NOT NULL,

"BWART" VARCHAR2 (000009)

DEFAULT ' ' NOT NULL,

"BLART" VARCHAR2 (000006)

DEFAULT ' ' NOT NULL)

PCTFREE 10

PCTUSED 00

INITRANS 001

TABLESPACE &ZUTAB&

STORAGE (INITIAL 0000204784 K

NEXT 0000204784 K

MINEXTENTS 0000000001

MAXEXTENTS UNLIMITED

PCTINCREASE 0000

FREELISTS 001

FREELIST GROUPS 01) ;

ind: GLPCA~0

sql: CREATE UNIQUE INDEX "GLPCA~0" ON "GLPCA"

("RCLNT",

"GL_SIRID")

PCTFREE 01

INITRANS 002

TABLESPACE &ZUTAB&

COMPRESS 1

STORAGE (INITIAL 0000051184 K

NEXT 0000051184 K

MINEXTENTS 0000000001

MAXEXTENTS UNLIMITED

PCTINCREASE 0000

FREELISTS 001) PARALLEL ;

ALTER INDEX "GLPCA~0" NOPARALLEL ;

ind: GLPCA~1

sql: CREATE

INDEX "GLPCA~1" ON "GLPCA"

("KOKRS",

"RYEAR",

"RPRCTR",

"RVERS",

"RACCT")

PCTFREE 01

INITRANS 002

TABLESPACE &ZUTAB&

NOCOMPRESS

STORAGE (INITIAL 0000051184 K

NEXT 0000051184 K

MINEXTENTS 0000000001

MAXEXTENTS UNLIMITED

PCTINCREASE 0000

FREELISTS 001) PARALLEL ;

ALTER INDEX "GLPCA~1" NOPARALLEL ;

ind: GLPCA~2

sql: CREATE UNIQUE INDEX "GLPCA~2" ON "GLPCA"

("DOCNR",

"RYEAR",

"DOCCT",

"RBUKRS",

"RLDNR",

"RCLNT",

"DOCLN")

PCTFREE 01

INITRANS 002

TABLESPACE &ZUTAB&

COMPRESS 6

STORAGE (INITIAL 0000102400 K

NEXT 0000102400 K

MINEXTENTS 0000000001

MAXEXTENTS UNLIMITED

PCTINCREASE 0000

FREELISTS 001) PARALLEL ;

ALTER INDEX "GLPCA~2" NOPARALLEL ;

ind: GLPCA~3

sql: CREATE

INDEX "GLPCA~3" ON "GLPCA"

("REFDOCNR",

"REFRYEAR",

"REFDOCCT",

"RBUKRS",

"RLDNR",

"REFDOCLN",

"RCLNT")

PCTFREE 01

INITRANS 002

TABLESPACE &ZUTAB&

COMPRESS 5

STORAGE (INITIAL 0000102400 K

NEXT 0000102400 K

MINEXTENTS 0000000001

MAXEXTENTS UNLIMITED

PCTINCREASE 0000

FREELISTS 001) PARALLEL ;

ALTER INDEX "GLPCA~3" NOPARALLEL ;

ind: GLPCA~7

sql: CREATE

INDEX "GLPCA~7" ON "GLPCA"

("RHOART",

"KOKRS",

"RYEAR",

"ACTIV",

"POPER")

PCTFREE 01

INITRANS 002

TABLESPACE &ZUTAB&

COMPRESS 5

STORAGE (INITIAL 0000064000 K

NEXT 0000064000 K

MINEXTENTS 0000000001

MAXEXTENTS UNLIMITED

PCTINCREASE 0000

FREELISTS 001) PARALLEL ;

ALTER INDEX "GLPCA~7" NOPARALLEL ;

ind: GLPCA~Z01

sql: CREATE

INDEX "GLPCA~Z01" ON "GLPCA"

("RRCTY",

"RVERS",

"KOKRS",

"RBUKRS",

"RYEAR",

"RACCT",

"POPER",

"AUFNR")

PCTFREE 01

INITRANS 002

TABLESPACE &ZUTAB&

COMPRESS 8

STORAGE (INITIAL 0000051200 K

NEXT 0000051200 K

MINEXTENTS 0000000001

MAXEXTENTS UNLIMITED

PCTINCREASE 0000

FREELISTS 001) PARALLEL ;

ALTER INDEX "GLPCA~Z01" NOPARALLEL ;