-- Demo case: Database object definition for blog post "[Oracle] Insights into SQL hints - Embedded global and local hints and how to use them" -- Date: 21-08-2015 -- References: http://scn.sap.com/community/oracle/blog/2015/08/20/oracle-insights-into-sql-hints--embedded-global-and-local-hints-and-how-to-use-them CREATE TABLE "AFKO" ( "MANDT" VARCHAR2(9) DEFAULT '000' NOT NULL ENABLE, "AUFNR" VARCHAR2(36) DEFAULT ' ' NOT NULL ENABLE, "GLTRP" VARCHAR2(24) DEFAULT '00000000' NOT NULL ENABLE, "GSTRP" VARCHAR2(24) DEFAULT '00000000' NOT NULL ENABLE, "FTRMS" VARCHAR2(24) DEFAULT '00000000' NOT NULL ENABLE, "GLTRS" VARCHAR2(24) DEFAULT '00000000' NOT NULL ENABLE, "GSTRS" VARCHAR2(24) DEFAULT '00000000' NOT NULL ENABLE, "GSTRI" VARCHAR2(24) DEFAULT '00000000' NOT NULL ENABLE, "GETRI" VARCHAR2(24) DEFAULT '00000000' NOT NULL ENABLE, "GLTRI" VARCHAR2(24) DEFAULT '00000000' NOT NULL ENABLE, "FTRMI" VARCHAR2(24) DEFAULT '00000000' NOT NULL ENABLE, "FTRMP" VARCHAR2(24) DEFAULT '00000000' NOT NULL ENABLE, "RSNUM" VARCHAR2(30) DEFAULT '0000000000' NOT NULL ENABLE, "GASMG" NUMBER(13,3) DEFAULT 0 NOT NULL ENABLE, "GAMNG" NUMBER(13,3) DEFAULT 0 NOT NULL ENABLE, "GMEIN" VARCHAR2(9) DEFAULT ' ' NOT NULL ENABLE, "PLNBEZ" VARCHAR2(54) DEFAULT ' ' NOT NULL ENABLE, "PLNTY" VARCHAR2(3) DEFAULT ' ' NOT NULL ENABLE, "PLNNR" VARCHAR2(24) DEFAULT ' ' NOT NULL ENABLE, "PLNAW" VARCHAR2(3) DEFAULT ' ' NOT NULL ENABLE, "PLNAL" VARCHAR2(6) DEFAULT ' ' NOT NULL ENABLE, "PVERW" VARCHAR2(9) DEFAULT ' ' NOT NULL ENABLE, "PLAUF" VARCHAR2(24) DEFAULT '00000000' NOT NULL ENABLE, "PLSVB" NUMBER(13,3) DEFAULT 0 NOT NULL ENABLE, "PLNME" VARCHAR2(9) DEFAULT ' ' NOT NULL ENABLE, "PLSVN" NUMBER(13,3) DEFAULT 0 NOT NULL ENABLE, "PDATV" VARCHAR2(24) DEFAULT '00000000' NOT NULL ENABLE, "PAENR" VARCHAR2(36) DEFAULT ' ' NOT NULL ENABLE, "PLGRP" VARCHAR2(9) DEFAULT ' ' NOT NULL ENABLE, "LODIV" NUMBER(13,3) DEFAULT 0 NOT NULL ENABLE, "STLTY" VARCHAR2(3) DEFAULT ' ' NOT NULL ENABLE, "STLBEZ" VARCHAR2(54) DEFAULT ' ' NOT NULL ENABLE, "STLST" VARCHAR2(6) DEFAULT '00' NOT NULL ENABLE, "STLNR" VARCHAR2(24) DEFAULT ' ' NOT NULL ENABLE, "SDATV" VARCHAR2(24) DEFAULT '00000000' NOT NULL ENABLE, "SBMNG" NUMBER(13,3) DEFAULT 0 NOT NULL ENABLE, "SBMEH" VARCHAR2(9) DEFAULT ' ' NOT NULL ENABLE, "SAENR" VARCHAR2(36) DEFAULT ' ' NOT NULL ENABLE, "STLAL" VARCHAR2(6) DEFAULT ' ' NOT NULL ENABLE, "STLAN" VARCHAR2(3) DEFAULT ' ' NOT NULL ENABLE, "SLSVN" NUMBER(13,3) DEFAULT 0 NOT NULL ENABLE, "SLSBS" NUMBER(13,3) DEFAULT 0 NOT NULL ENABLE, "AUFLD" VARCHAR2(24) DEFAULT '00000000' NOT NULL ENABLE, "DISPO" VARCHAR2(9) DEFAULT ' ' NOT NULL ENABLE, "AUFPL" VARCHAR2(30) DEFAULT '0000000000' NOT NULL ENABLE, "FEVOR" VARCHAR2(9) DEFAULT ' ' NOT NULL ENABLE, "FHORI" VARCHAR2(9) DEFAULT ' ' NOT NULL ENABLE, "TERKZ" VARCHAR2(3) DEFAULT ' ' NOT NULL ENABLE, "REDKZ" VARCHAR2(3) DEFAULT ' ' NOT NULL ENABLE, "APRIO" VARCHAR2(3) DEFAULT ' ' NOT NULL ENABLE, "NTZUE" VARCHAR2(36) DEFAULT ' ' NOT NULL ENABLE, "VORUE" VARCHAR2(12) DEFAULT ' ' NOT NULL ENABLE, "PROFID" VARCHAR2(21) DEFAULT ' ' NOT NULL ENABLE, "VORGZ" VARCHAR2(9) DEFAULT '000' NOT NULL ENABLE, "SICHZ" VARCHAR2(9) DEFAULT '000' NOT NULL ENABLE, "FREIZ" VARCHAR2(9) DEFAULT '000' NOT NULL ENABLE, "UPTER" VARCHAR2(3) DEFAULT ' ' NOT NULL ENABLE, "BEDID" VARCHAR2(36) DEFAULT '000000000000' NOT NULL ENABLE, "PRONR" VARCHAR2(24) DEFAULT '00000000' NOT NULL ENABLE, "ZAEHL" VARCHAR2(24) DEFAULT '00000000' NOT NULL ENABLE, "MZAEHL" VARCHAR2(24) DEFAULT '00000000' NOT NULL ENABLE, "ZKRIZ" VARCHAR2(21) DEFAULT '0000000' NOT NULL ENABLE, "PRUEFLOS" VARCHAR2(36) DEFAULT '000000000000' NOT NULL ENABLE, "KLVARP" VARCHAR2(12) DEFAULT ' ' NOT NULL ENABLE, "KLVARI" VARCHAR2(12) DEFAULT ' ' NOT NULL ENABLE, "RGEKZ" VARCHAR2(3) DEFAULT ' ' NOT NULL ENABLE, "PLART" VARCHAR2(3) DEFAULT ' ' NOT NULL ENABLE, "FLG_AOB" VARCHAR2(3) DEFAULT ' ' NOT NULL ENABLE, "FLG_ARBEI" VARCHAR2(3) DEFAULT ' ' NOT NULL ENABLE, "GLTPP" VARCHAR2(24) DEFAULT '00000000' NOT NULL ENABLE, "GSTPP" VARCHAR2(24) DEFAULT '00000000' NOT NULL ENABLE, "GLTPS" VARCHAR2(24) DEFAULT '00000000' NOT NULL ENABLE, "GSTPS" VARCHAR2(24) DEFAULT '00000000' NOT NULL ENABLE, "FTRPS" VARCHAR2(24) DEFAULT '00000000' NOT NULL ENABLE, "RDKZP" VARCHAR2(3) DEFAULT ' ' NOT NULL ENABLE, "TRKZP" VARCHAR2(3) DEFAULT ' ' NOT NULL ENABLE, "RUECK" VARCHAR2(30) DEFAULT '0000000000' NOT NULL ENABLE, "RMZHL" VARCHAR2(24) DEFAULT '00000000' NOT NULL ENABLE, "IGMNG" NUMBER(13,3) DEFAULT 0 NOT NULL ENABLE, "RATID" VARCHAR2(36) DEFAULT '000000000000' NOT NULL ENABLE, "GROID" VARCHAR2(36) DEFAULT '000000000000' NOT NULL ENABLE, "CUOBJ" VARCHAR2(54) DEFAULT '000000000000000000' NOT NULL ENABLE, "GLUZS" VARCHAR2(18) DEFAULT '000000' NOT NULL ENABLE, "GSUZS" VARCHAR2(18) DEFAULT '000000' NOT NULL ENABLE, "REVLV" VARCHAR2(6) DEFAULT ' ' NOT NULL ENABLE, "RSHTY" VARCHAR2(6) DEFAULT ' ' NOT NULL ENABLE, "RSHID" VARCHAR2(24) DEFAULT '00000000' NOT NULL ENABLE, "RSNTY" VARCHAR2(6) DEFAULT ' ' NOT NULL ENABLE, "RSNID" VARCHAR2(24) DEFAULT '00000000' NOT NULL ENABLE, "NAUTERM" VARCHAR2(3) DEFAULT ' ' NOT NULL ENABLE, "NAUCOST" VARCHAR2(3) DEFAULT ' ' NOT NULL ENABLE, "STUFE" NUMBER(2,0) DEFAULT 0 NOT NULL ENABLE, "WEGXX" NUMBER(4,0) DEFAULT 0 NOT NULL ENABLE, "VWEGX" NUMBER(4,0) DEFAULT 0 NOT NULL ENABLE, "ARSNR" VARCHAR2(30) DEFAULT '0000000000' NOT NULL ENABLE, "ARSPS" VARCHAR2(12) DEFAULT '0000' NOT NULL ENABLE, "MAUFNR" VARCHAR2(36) DEFAULT ' ' NOT NULL ENABLE, "LKNOT" VARCHAR2(36) DEFAULT ' ' NOT NULL ENABLE, "RKNOT" VARCHAR2(36) DEFAULT ' ' NOT NULL ENABLE, "PRODNET" VARCHAR2(3) DEFAULT ' ' NOT NULL ENABLE, "IASMG" NUMBER(13,3) DEFAULT 0 NOT NULL ENABLE, "ABARB" VARCHAR2(9) DEFAULT '000' NOT NULL ENABLE, "AUFNT" VARCHAR2(36) DEFAULT ' ' NOT NULL ENABLE, "AUFPT" VARCHAR2(30) DEFAULT '0000000000' NOT NULL ENABLE, "APLZT" VARCHAR2(24) DEFAULT '00000000' NOT NULL ENABLE, "NO_DISP" VARCHAR2(3) DEFAULT ' ' NOT NULL ENABLE, "CSPLIT" VARCHAR2(12) DEFAULT ' ' NOT NULL ENABLE, "AENNR" VARCHAR2(36) DEFAULT ' ' NOT NULL ENABLE, "CY_SEQNR" VARCHAR2(42) DEFAULT '00000000000000' NOT NULL ENABLE, "BREAKS" VARCHAR2(3) DEFAULT ' ' NOT NULL ENABLE, "VORGZ_TRM" NUMBER(6,3) DEFAULT 0 NOT NULL ENABLE, "SICHZ_TRM" NUMBER(6,3) DEFAULT 0 NOT NULL ENABLE, "TRMDT" VARCHAR2(24) DEFAULT '00000000' NOT NULL ENABLE, "GLUZP" VARCHAR2(18) DEFAULT '000000' NOT NULL ENABLE, "GSUZP" VARCHAR2(18) DEFAULT '000000' NOT NULL ENABLE, "GSUZI" VARCHAR2(18) DEFAULT '000000' NOT NULL ENABLE, "GEUZI" VARCHAR2(18) DEFAULT '000000' NOT NULL ENABLE, "GLUPP" VARCHAR2(18) DEFAULT '000000' NOT NULL ENABLE, "GSUPP" VARCHAR2(18) DEFAULT '000000' NOT NULL ENABLE, "GLUPS" VARCHAR2(18) DEFAULT '000000' NOT NULL ENABLE, "GSUPS" VARCHAR2(18) DEFAULT '000000' NOT NULL ENABLE, "CHSCH" VARCHAR2(18) DEFAULT ' ' NOT NULL ENABLE, "KAPT_VORGZ" VARCHAR2(9) DEFAULT '000' NOT NULL ENABLE, "KAPT_SICHZ" VARCHAR2(9) DEFAULT '000' NOT NULL ENABLE, "LEAD_AUFNR" VARCHAR2(36) DEFAULT ' ' NOT NULL ENABLE, "PNETSTARTD" VARCHAR2(24) DEFAULT '00000000' NOT NULL ENABLE, "PNETSTARTT" VARCHAR2(18) DEFAULT '000000' NOT NULL ENABLE, "PNETENDD" VARCHAR2(24) DEFAULT '00000000' NOT NULL ENABLE, "PNETENDT" VARCHAR2(18) DEFAULT '000000' NOT NULL ENABLE, "KBED" VARCHAR2(3) DEFAULT ' ' NOT NULL ENABLE, "KKALKR" VARCHAR2(3) DEFAULT ' ' NOT NULL ENABLE, "SFCPF" VARCHAR2(18) DEFAULT ' ' NOT NULL ENABLE, "RMNGA" NUMBER(13,3) DEFAULT 0 NOT NULL ENABLE, "GSBTR" VARCHAR2(24) DEFAULT '00000000' NOT NULL ENABLE, "VFMNG" NUMBER(13,3) DEFAULT 0 NOT NULL ENABLE, "NOPCOST" VARCHAR2(3) DEFAULT ' ' NOT NULL ENABLE, "NETZKONT" VARCHAR2(3) DEFAULT ' ' NOT NULL ENABLE, "ATRKZ" VARCHAR2(3) DEFAULT ' ' NOT NULL ENABLE, "OBJTYPE" VARCHAR2(3) DEFAULT ' ' NOT NULL ENABLE, "CH_PROC" VARCHAR2(3) DEFAULT ' ' NOT NULL ENABLE, "KAPVERSA" VARCHAR2(6) DEFAULT '00' NOT NULL ENABLE, "COLORDPROC" VARCHAR2(3) DEFAULT ' ' NOT NULL ENABLE, "KZERB" VARCHAR2(3) DEFAULT ' ' NOT NULL ENABLE, "CONF_KEY" VARCHAR2(24) DEFAULT '00000000' NOT NULL ENABLE, "ST_ARBID" VARCHAR2(24) DEFAULT '00000000' NOT NULL ENABLE, "VSNMR_V" VARCHAR2(36) DEFAULT ' ' NOT NULL ENABLE, "TERHW" VARCHAR2(3) DEFAULT ' ' NOT NULL ENABLE, "SPLSTAT" VARCHAR2(3) DEFAULT ' ' NOT NULL ENABLE, "COSTUPD" VARCHAR2(3) DEFAULT ' ' NOT NULL ENABLE, "ADPSP" VARCHAR2(120) DEFAULT ' ' NOT NULL ENABLE, "RMANR" VARCHAR2(30) DEFAULT ' ' NOT NULL ENABLE, "POSNR_RMA" VARCHAR2(18) DEFAULT '000000' NOT NULL ENABLE, "POSNV_RMA" VARCHAR2(18) DEFAULT '000000' NOT NULL ENABLE, "OIHANTYP" VARCHAR2(6) DEFAULT ' ' NOT NULL ENABLE ) SEGMENT CREATION IMMEDIATE PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 COMPRESS FOR OLTP LOGGING STORAGE(INITIAL 16384 NEXT 2621440 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT); CREATE UNIQUE INDEX "AFKO~0" ON "AFKO" ("MANDT", "AUFNR") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE(INITIAL 16384 NEXT 655360 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT); CREATE INDEX "AFKO~1" ON "AFKO" ("MANDT", "AUFPL") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE(INITIAL 16384 NEXT 655360 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT); CREATE INDEX "AFKO~2" ON "AFKO" ("MANDT", "PRONR") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE(INITIAL 16384 NEXT 655360 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT); CREATE INDEX "AFKO~3" ON "AFKO" ("MANDT", "AUFNT") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE(INITIAL 16384 NEXT 655360 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT); CREATE INDEX "AFKO~4" ON "AFKO" ("MANDT", "AUFPT", "APLZT") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE(INITIAL 16384 NEXT 655360 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT); CREATE INDEX "AFKO~5" ON "AFKO" ("MANDT", "MAUFNR", "PRODNET") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE(INITIAL 16384 NEXT 655360 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT); CREATE INDEX "AFKO~6" ON "AFKO" ("LEAD_AUFNR") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE(INITIAL 16384 NEXT 655360 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT); CREATE INDEX "AFKO~D" ON "AFKO" ("MANDT", "DISPO") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE(INITIAL 16384 NEXT 655360 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT); CREATE INDEX "AFKO~F" ON "AFKO" ("MANDT", "FEVOR") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE(INITIAL 16384 NEXT 655360 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT); CREATE INDEX "AFKO~P" ON "AFKO" ("MANDT", "PLNTY", "PLNNR", "PLNBEZ") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE(INITIAL 16384 NEXT 655360 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT); CREATE TABLE "AUFK" ( "MANDT" VARCHAR2(9) DEFAULT '000' NOT NULL ENABLE, "AUFNR" VARCHAR2(36) DEFAULT ' ' NOT NULL ENABLE, "AUART" VARCHAR2(12) DEFAULT ' ' NOT NULL ENABLE, "AUTYP" VARCHAR2(6) DEFAULT '00' NOT NULL ENABLE, "REFNR" VARCHAR2(36) DEFAULT ' ' NOT NULL ENABLE, "ERNAM" VARCHAR2(36) DEFAULT ' ' NOT NULL ENABLE, "ERDAT" VARCHAR2(24) DEFAULT '00000000' NOT NULL ENABLE, "AENAM" VARCHAR2(36) DEFAULT ' ' NOT NULL ENABLE, "AEDAT" VARCHAR2(24) DEFAULT '00000000' NOT NULL ENABLE, "KTEXT" VARCHAR2(120) DEFAULT ' ' NOT NULL ENABLE, "LTEXT" VARCHAR2(3) DEFAULT ' ' NOT NULL ENABLE, "BUKRS" VARCHAR2(12) DEFAULT ' ' NOT NULL ENABLE, "WERKS" VARCHAR2(12) DEFAULT ' ' NOT NULL ENABLE, "GSBER" VARCHAR2(12) DEFAULT ' ' NOT NULL ENABLE, "KOKRS" VARCHAR2(12) DEFAULT ' ' NOT NULL ENABLE, "CCKEY" VARCHAR2(69) DEFAULT ' ' NOT NULL ENABLE, "KOSTV" VARCHAR2(30) DEFAULT ' ' NOT NULL ENABLE, "STORT" VARCHAR2(30) DEFAULT ' ' NOT NULL ENABLE, "SOWRK" VARCHAR2(12) DEFAULT ' ' NOT NULL ENABLE, "ASTKZ" VARCHAR2(3) DEFAULT ' ' NOT NULL ENABLE, "WAERS" VARCHAR2(15) DEFAULT ' ' NOT NULL ENABLE, "ASTNR" VARCHAR2(6) DEFAULT '00' NOT NULL ENABLE, "STDAT" VARCHAR2(24) DEFAULT '00000000' NOT NULL ENABLE, "ESTNR" VARCHAR2(6) DEFAULT '00' NOT NULL ENABLE, "PHAS0" VARCHAR2(3) DEFAULT ' ' NOT NULL ENABLE, "PHAS1" VARCHAR2(3) DEFAULT ' ' NOT NULL ENABLE, "PHAS2" VARCHAR2(3) DEFAULT ' ' NOT NULL ENABLE, "PHAS3" VARCHAR2(3) DEFAULT ' ' NOT NULL ENABLE, "PDAT1" VARCHAR2(24) DEFAULT '00000000' NOT NULL ENABLE, "PDAT2" VARCHAR2(24) DEFAULT '00000000' NOT NULL ENABLE, "PDAT3" VARCHAR2(24) DEFAULT '00000000' NOT NULL ENABLE, "IDAT1" VARCHAR2(24) DEFAULT '00000000' NOT NULL ENABLE, "IDAT2" VARCHAR2(24) DEFAULT '00000000' NOT NULL ENABLE, "IDAT3" VARCHAR2(24) DEFAULT '00000000' NOT NULL ENABLE, "OBJID" VARCHAR2(3) DEFAULT ' ' NOT NULL ENABLE, "VOGRP" VARCHAR2(12) DEFAULT ' ' NOT NULL ENABLE, "LOEKZ" VARCHAR2(3) DEFAULT ' ' NOT NULL ENABLE, "PLGKZ" VARCHAR2(3) DEFAULT ' ' NOT NULL ENABLE, "KVEWE" VARCHAR2(3) DEFAULT ' ' NOT NULL ENABLE, "KAPPL" VARCHAR2(6) DEFAULT ' ' NOT NULL ENABLE, "KALSM" VARCHAR2(18) DEFAULT ' ' NOT NULL ENABLE, "ZSCHL" VARCHAR2(18) DEFAULT ' ' NOT NULL ENABLE, "ABKRS" VARCHAR2(6) DEFAULT '00' NOT NULL ENABLE, "KSTAR" VARCHAR2(30) DEFAULT ' ' NOT NULL ENABLE, "KOSTL" VARCHAR2(30) DEFAULT ' ' NOT NULL ENABLE, "SAKNR" VARCHAR2(30) DEFAULT ' ' NOT NULL ENABLE, "SETNM" VARCHAR2(36) DEFAULT ' ' NOT NULL ENABLE, "CYCLE" VARCHAR2(30) DEFAULT ' ' NOT NULL ENABLE, "SDATE" VARCHAR2(24) DEFAULT '00000000' NOT NULL ENABLE, "SEQNR" VARCHAR2(12) DEFAULT '0000' NOT NULL ENABLE, "USER0" VARCHAR2(60) DEFAULT ' ' NOT NULL ENABLE, "USER1" VARCHAR2(60) DEFAULT ' ' NOT NULL ENABLE, "USER2" VARCHAR2(60) DEFAULT ' ' NOT NULL ENABLE, "USER3" VARCHAR2(60) DEFAULT ' ' NOT NULL ENABLE, "USER4" NUMBER(11,2) DEFAULT 0 NOT NULL ENABLE, "USER5" VARCHAR2(24) DEFAULT '00000000' NOT NULL ENABLE, "USER6" VARCHAR2(45) DEFAULT ' ' NOT NULL ENABLE, "USER7" VARCHAR2(24) DEFAULT '00000000' NOT NULL ENABLE, "USER8" VARCHAR2(24) DEFAULT '00000000' NOT NULL ENABLE, "USER9" VARCHAR2(3) DEFAULT ' ' NOT NULL ENABLE, "OBJNR" VARCHAR2(66) DEFAULT ' ' NOT NULL ENABLE, "PRCTR" VARCHAR2(30) DEFAULT ' ' NOT NULL ENABLE, "PSPEL" VARCHAR2(24) DEFAULT '00000000' NOT NULL ENABLE, "AWSLS" VARCHAR2(18) DEFAULT ' ' NOT NULL ENABLE, "ABGSL" VARCHAR2(18) DEFAULT ' ' NOT NULL ENABLE, "TXJCD" VARCHAR2(45) DEFAULT ' ' NOT NULL ENABLE, "FUNC_AREA" VARCHAR2(48) DEFAULT ' ' NOT NULL ENABLE, "SCOPE" VARCHAR2(6) DEFAULT ' ' NOT NULL ENABLE, "PLINT" VARCHAR2(3) DEFAULT ' ' NOT NULL ENABLE, "KDAUF" VARCHAR2(30) DEFAULT ' ' NOT NULL ENABLE, "KDPOS" VARCHAR2(18) DEFAULT '000000' NOT NULL ENABLE, "AUFEX" VARCHAR2(60) DEFAULT ' ' NOT NULL ENABLE, "IVPRO" VARCHAR2(18) DEFAULT ' ' NOT NULL ENABLE, "LOGSYSTEM" VARCHAR2(30) DEFAULT ' ' NOT NULL ENABLE, "FLG_MLTPS" VARCHAR2(3) DEFAULT ' ' NOT NULL ENABLE, "ABUKR" VARCHAR2(12) DEFAULT ' ' NOT NULL ENABLE, "AKSTL" VARCHAR2(30) DEFAULT ' ' NOT NULL ENABLE, "SIZECL" VARCHAR2(6) DEFAULT ' ' NOT NULL ENABLE, "IZWEK" VARCHAR2(6) DEFAULT ' ' NOT NULL ENABLE, "UMWKZ" VARCHAR2(15) DEFAULT ' ' NOT NULL ENABLE, "KSTEMPF" VARCHAR2(3) DEFAULT ' ' NOT NULL ENABLE, "ZSCHM" VARCHAR2(21) DEFAULT ' ' NOT NULL ENABLE, "PKOSA" VARCHAR2(36) DEFAULT ' ' NOT NULL ENABLE, "ANFAUFNR" VARCHAR2(36) DEFAULT ' ' NOT NULL ENABLE, "PROCNR" VARCHAR2(36) DEFAULT '000000000000' NOT NULL ENABLE, "PROTY" VARCHAR2(12) DEFAULT ' ' NOT NULL ENABLE, "RSORD" VARCHAR2(3) DEFAULT ' ' NOT NULL ENABLE, "BEMOT" VARCHAR2(6) DEFAULT ' ' NOT NULL ENABLE, "ADRNRA" VARCHAR2(30) DEFAULT ' ' NOT NULL ENABLE, "ERFZEIT" VARCHAR2(18) DEFAULT '000000' NOT NULL ENABLE, "AEZEIT" VARCHAR2(18) DEFAULT '000000' NOT NULL ENABLE, "CSTG_VRNT" VARCHAR2(12) DEFAULT ' ' NOT NULL ENABLE, "COSTESTNR" VARCHAR2(36) DEFAULT '000000000000' NOT NULL ENABLE, "VERAA_USER" VARCHAR2(36) DEFAULT ' ' NOT NULL ENABLE, "ZZSTIMA_COS" NUMBER(11,2) DEFAULT 0 NOT NULL ENABLE, "VNAME" VARCHAR2(18) DEFAULT ' ' NOT NULL ENABLE, "RECID" VARCHAR2(6) DEFAULT ' ' NOT NULL ENABLE, "ETYPE" VARCHAR2(9) DEFAULT ' ' NOT NULL ENABLE, "OTYPE" VARCHAR2(12) DEFAULT ' ' NOT NULL ENABLE, "JV_JIBCL" VARCHAR2(9) DEFAULT ' ' NOT NULL ENABLE, "JV_JIBSA" VARCHAR2(15) DEFAULT ' ' NOT NULL ENABLE, "JV_OCO" VARCHAR2(3) DEFAULT ' ' NOT NULL ENABLE, "VAPLZ" VARCHAR2(24) DEFAULT ' ' NOT NULL ENABLE, "WAWRK" VARCHAR2(12) DEFAULT ' ' NOT NULL ENABLE, "FERC_IND" VARCHAR2(12) DEFAULT ' ' NOT NULL ENABLE ) SEGMENT CREATION IMMEDIATE PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 COMPRESS FOR OLTP LOGGING STORAGE(INITIAL 16384 NEXT 2621440 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT); CREATE UNIQUE INDEX "AUFK~0" ON "AUFK" ("MANDT", "AUFNR") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE(INITIAL 16384 NEXT 655360 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT); CREATE INDEX "AUFK~A" ON "AUFK" ("MANDT", "KOKRS", "ABKRS", "AUART") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE(INITIAL 16384 NEXT 655360 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT); CREATE INDEX "AUFK~B" ON "AUFK" ("MANDT", "AUTYP", "WERKS") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE(INITIAL 16384 NEXT 655360 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT); CREATE INDEX "AUFK~C" ON "AUFK" ("MANDT", "AUART", "KOKRS") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE(INITIAL 16384 NEXT 655360 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT); CREATE INDEX "AUFK~D" ON "AUFK" ("MANDT", "PSPEL") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE(INITIAL 16384 NEXT 655360 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT); CREATE INDEX "AUFK~E" ON "AUFK" ("MANDT", "PROCNR", "PKOSA") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE(INITIAL 16384 NEXT 655360 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT); CREATE OR REPLACE FORCE VIEW "CAUFV" ("MANDT", "AUFNR", "AUART", "AUTYP", "REFNR", "ERNAM", "ERDAT", "AENAM", "AEDAT", "KTEXT", "LTEXT", "BUKRS", "WERKS", "GSBER", "KOKRS", "CCKEY", "KOSTV", "STORT", "SOWRK", "ASTKZ", "WAERS", "STDAT", "IDAT1", "IDAT2", "IDAT3", "OBJID", "LOEKZ", "PLGKZ", "KVEWE", "KAPPL", "KALSM", "ZSCHL", "ABKRS", "KSTAR", "KOSTL", "SETNM", "CYCLE", "SDATE", "SEQNR", "USER4", "OBJNR", "PRCTR", "PSPEL", "AWSLS", "ABGSL", "TXJCD", "FUNC_AREA", "SCOPE", "PLINT", "KDAUF", "KDPOS", "AUFEX", "IVPRO", "LOGSYSTEM", "FLG_MLTPS", "ABUKR", "AKSTL", "SIZECL", "IZWEK", "UMWKZ", "KSTEMPF", "ZSCHM", "PKOSA", "ANFAUFNR", "PROCNR", "PROTY", "RSORD", "BEMOT", "ADRNRA", "ERFZEIT", "AEZEIT", "CSTG_VRNT", "COSTESTNR", "VERAA_USER", "ZZSTIMA_COS", "VNAME", "RECID", "ETYPE", "OTYPE", "JV_JIBCL", "JV_JIBSA", "JV_OCO", "VAPLZ", "WAWRK", "FERC_IND", "GLTRP", "GSTRP", "FTRMS", "GLTRS", "GSTRS", "GSTRI", "GETRI", "GLTRI", "FTRMI", "FTRMP", "RSNUM", "GASMG", "GAMNG", "GMEIN", "PLNBEZ", "PLNTY", "PLNNR", "PLNAW", "PLNAL", "PVERW", "PLAUF", "PLSVB", "PLNME", "PLSVN", "PDATV", "PAENR", "PLGRP", "LODIV", "STLTY", "STLBEZ", "STLST", "STLNR", "SDATV", "SBMNG", "SBMEH", "SAENR", "STLAL", "STLAN", "SLSVN", "SLSBS", "AUFLD", "DISPO", "AUFPL", "FEVOR", "FHORI", "TERKZ", "REDKZ", "APRIO", "NTZUE", "VORUE", "PROFID", "VORGZ", "SICHZ", "FREIZ", "UPTER", "BEDID", "PRONR", "ZAEHL", "MZAEHL", "ZKRIZ", "PRUEFLOS", "KLVARP", "KLVARI", "RGEKZ", "PLART", "FLG_AOB", "FLG_ARBEI", "GLTPP", "GSTPP", "GLTPS", "GSTPS", "FTRPS", "RDKZP", "TRKZP", "RUECK", "RMZHL", "IGMNG", "RATID", "GROID", "CUOBJ", "GLUZS", "GSUZS", "REVLV", "RSHTY", "RSHID", "RSNTY", "RSNID", "NAUTERM", "NAUCOST", "STUFE", "WEGXX", "VWEGX", "ARSNR", "ARSPS", "MAUFNR", "LKNOT", "RKNOT", "PRODNET", "IASMG", "ABARB", "AUFNT", "AUFPT", "APLZT", "NO_DISP", "CSPLIT", "AENNR", "CY_SEQNR", "BREAKS", "VORGZ_TRM", "SICHZ_TRM", "TRMDT", "GLUZP", "GSUZP", "GSUZI", "GEUZI", "GLUPP", "GSUPP", "GLUPS", "GSUPS", "CHSCH", "KAPT_VORGZ", "KAPT_SICHZ", "LEAD_AUFNR", "PNETSTARTD", "PNETSTARTT", "PNETENDD", "PNETENDT", "KBED", "KKALKR", "SFCPF", "RMNGA", "GSBTR", "VFMNG", "NOPCOST", "NETZKONT", "ATRKZ", "OBJTYPE", "CH_PROC", "KAPVERSA", "COLORDPROC", "KZERB", "CONF_KEY", "ST_ARBID", "VSNMR_V", "TERHW", "SPLSTAT", "COSTUPD", "ADPSP", "RMANR", "POSNR_RMA", "POSNV_RMA") AS SELECT T0002."MANDT", T0002."AUFNR", T0002."AUART", T0002."AUTYP", T0002."REFNR", T0002."ERNAM", T0002."ERDAT", T0002."AENAM", T0002."AEDAT", T0002."KTEXT", T0002."LTEXT", T0002."BUKRS", T0002."WERKS", T0002."GSBER", T0002."KOKRS", T0002."CCKEY", T0002."KOSTV", T0002."STORT", T0002."SOWRK", T0002."ASTKZ", T0002."WAERS", T0002."STDAT", T0002."IDAT1", T0002."IDAT2", T0002."IDAT3", T0002."OBJID", T0002."LOEKZ", T0002."PLGKZ", T0002."KVEWE", T0002."KAPPL", T0002."KALSM", T0002."ZSCHL", T0002."ABKRS", T0002."KSTAR", T0002."KOSTL", T0002."SETNM", T0002."CYCLE", T0002."SDATE", T0002."SEQNR", T0002."USER4", T0002."OBJNR", T0002."PRCTR", T0002."PSPEL", T0002."AWSLS", T0002."ABGSL", T0002."TXJCD", T0002."FUNC_AREA", T0002."SCOPE", T0002."PLINT", T0002."KDAUF", T0002."KDPOS", T0002."AUFEX", T0002."IVPRO", T0002."LOGSYSTEM", T0002."FLG_MLTPS", T0002."ABUKR", T0002."AKSTL", T0002."SIZECL", T0002."IZWEK", T0002."UMWKZ", T0002."KSTEMPF", T0002."ZSCHM", T0002."PKOSA", T0002."ANFAUFNR", T0002."PROCNR", T0002."PROTY", T0002."RSORD", T0002."BEMOT", T0002."ADRNRA", T0002."ERFZEIT", T0002."AEZEIT", T0002."CSTG_VRNT", T0002."COSTESTNR", T0002."VERAA_USER", T0002."ZZSTIMA_COS", T0002."VNAME", T0002."RECID", T0002."ETYPE", T0002."OTYPE", T0002."JV_JIBCL", T0002."JV_JIBSA", T0002."JV_OCO", T0002."VAPLZ", T0002."WAWRK", T0002."FERC_IND", T0001."GLTRP", T0001."GSTRP", T0001."FTRMS", T0001."GLTRS", T0001."GSTRS", T0001."GSTRI", T0001."GETRI", T0001."GLTRI", T0001."FTRMI", T0001."FTRMP", T0001."RSNUM", T0001."GASMG", T0001."GAMNG", T0001."GMEIN", T0001."PLNBEZ", T0001."PLNTY", T0001."PLNNR", T0001."PLNAW", T0001."PLNAL", T0001."PVERW", T0001."PLAUF", T0001."PLSVB", T0001."PLNME", T0001."PLSVN", T0001."PDATV", T0001."PAENR", T0001."PLGRP", T0001."LODIV", T0001."STLTY", T0001."STLBEZ", T0001."STLST", T0001."STLNR", T0001."SDATV", T0001."SBMNG", T0001."SBMEH", T0001."SAENR", T0001."STLAL", T0001."STLAN", T0001."SLSVN", T0001."SLSBS", T0001."AUFLD", T0001."DISPO", T0001."AUFPL", T0001."FEVOR", T0001."FHORI", T0001."TERKZ", T0001."REDKZ", T0001."APRIO", T0001."NTZUE", T0001."VORUE", T0001."PROFID", T0001."VORGZ", T0001."SICHZ", T0001."FREIZ", T0001."UPTER", T0001."BEDID", T0001."PRONR", T0001."ZAEHL", T0001."MZAEHL", T0001."ZKRIZ", T0001."PRUEFLOS", T0001."KLVARP", T0001."KLVARI", T0001."RGEKZ", T0001."PLART", T0001."FLG_AOB", T0001."FLG_ARBEI", T0001."GLTPP", T0001."GSTPP", T0001."GLTPS", T0001."GSTPS", T0001."FTRPS", T0001."RDKZP", T0001."TRKZP", T0001."RUECK", T0001."RMZHL", T0001."IGMNG", T0001."RATID", T0001."GROID", T0001."CUOBJ", T0001."GLUZS", T0001."GSUZS", T0001."REVLV", T0001."RSHTY", T0001."RSHID", T0001."RSNTY", T0001."RSNID", T0001."NAUTERM", T0001."NAUCOST", T0001."STUFE", T0001."WEGXX", T0001."VWEGX", T0001."ARSNR", T0001."ARSPS", T0001."MAUFNR", T0001."LKNOT", T0001."RKNOT", T0001."PRODNET", T0001."IASMG", T0001."ABARB", T0001."AUFNT", T0001."AUFPT", T0001."APLZT", T0001."NO_DISP", T0001."CSPLIT", T0001."AENNR", T0001."CY_SEQNR", T0001."BREAKS", T0001."VORGZ_TRM", T0001."SICHZ_TRM", T0001."TRMDT", T0001."GLUZP", T0001."GSUZP", T0001."GSUZI", T0001."GEUZI", T0001."GLUPP", T0001."GSUPP", T0001."GLUPS", T0001."GSUPS", T0001."CHSCH", T0001."KAPT_VORGZ", T0001."KAPT_SICHZ", T0001."LEAD_AUFNR", T0001."PNETSTARTD", T0001."PNETSTARTT", T0001."PNETENDD", T0001."PNETENDT", T0001."KBED", T0001."KKALKR", T0001."SFCPF", T0001."RMNGA", T0001."GSBTR", T0001."VFMNG", T0001."NOPCOST", T0001."NETZKONT", T0001."ATRKZ", T0001."OBJTYPE", T0001."CH_PROC", T0001."KAPVERSA", T0001."COLORDPROC", T0001."KZERB", T0001."CONF_KEY", T0001."ST_ARBID", T0001."VSNMR_V", T0001."TERHW", T0001."SPLSTAT", T0001."COSTUPD", T0001."ADPSP", T0001."RMANR", T0001."POSNR_RMA", T0001."POSNV_RMA" FROM "AFKO" T0001, "AUFK" T0002 WHERE T0001."MANDT" = T0002."MANDT" AND T0001."AUFNR" = T0002."AUFNR";