CREATE TABLE PRUEFLOS
(
	PLKEY                         	NUMBER(10, 0),
	PLTEIL                        	NUMBER(10, 0),
	PLPRUEFLOSNUMMER              	VARCHAR2(50),
	PLSTATUS                      	NUMBER(10, 0),
	PLDATUMDOWNLOAD               	DATE,
	PLPLERSTELLDAT                	DATE,
	PLERSTELLER                   	VARCHAR2(40),
	PLBEMERKUNG                   	VARCHAR2(255),
	PLANZWERTE                    	NUMBER(10, 0),
	PLANZWERTESOLL                	NUMBER(10, 0),
	PLTEILKEYFIELD1               	VARCHAR2(20),
	PLTEILKEYFIELD2               	VARCHAR2(20),
	PLVEKEY                       	NUMBER(10, 0),
	PLAUFTRAG               				VARCHAR2(50)
)
;

CREATE TABLE SAP_ALL_QAICA
(
	SATZART                       	VARCHAR2(3) ,
	KATAB                         	VARCHAR2(1) ,
	KATALGART                     	VARCHAR2(1) ,
	AUSWMGWRK                     	VARCHAR2(4) ,
	AUSWMENGE                     	VARCHAR2(8) ,
	CODEGRUPPE                    	VARCHAR2(8) ,
	CODE                          	VARCHAR2(4) ,
	KURZTEXT                      	VARCHAR2(40) ,
	BEWERTUNG                     	VARCHAR2(1) ,
	FEHLKLASSE                    	VARCHAR2(2) ,
	MUSSTEXTKZ                    	VARCHAR2(1) ,
	BB_VORSCH                     	VARCHAR2(1) ,
	QKENNZAHL                     	VARCHAR2(3) ,
	KATALOG_ID                    	NUMBER(10, 0) ,
	KATALOG_ENTRY                 	NUMBER(10, 0)
)
;

CREATE TABLE SAP_QAICA
(
	SATZART                       	VARCHAR2(3),
	KATAB                         	VARCHAR2(1),
	KATALGART                     	VARCHAR2(1),
	AUSWMGWRK                     	VARCHAR2(4),
	AUSWMENGE                     	VARCHAR2(8),
	CODEGRUPPE                    	VARCHAR2(8),
	CODE                          	VARCHAR2(4),
	KURZTEXT                      	VARCHAR2(40),
	BEWERTUNG                     	VARCHAR2(1),
	FEHLKLASSE                    	VARCHAR2(2),
	MUSSTEXTKZ                    	VARCHAR2(1),
	BB_VORSCH                     	VARCHAR2(1),
	QKENNZAHL                     	VARCHAR2(3)
)
;

CREATE TABLE SAP_QAIMV
(
	SATZART                       	VARCHAR2(3),
	RUECKMELNR                    	VARCHAR2(8),
	ERFASSART                     	VARCHAR2(1),
	KZBEWSUBSY                    	VARCHAR2(1),
	BEWART                        	VARCHAR2(1),
	KZRZWANG                      	VARCHAR2(1),
	STATUSV                       	VARCHAR2(1),
	STATUSR                       	VARCHAR2(1),
	KZPRUMF                       	VARCHAR2(1),
	KZDOKU                        	VARCHAR2(1),
	KZSERNR                       	VARCHAR2(1),
	KZTSTICHPR                    	VARCHAR2(1),
	KZRAST                        	VARCHAR2(1),
	RASTER                        	VARCHAR2(3),
	SOLLSTPANZ                    	VARCHAR2(5),
	BEWARTSP                      	VARCHAR2(1),
	PRUEFLOS                      	VARCHAR2(12),
	PLNFL                         	VARCHAR2(6),
	VORNR                         	VARCHAR2(4),
	MERKNR                        	VARCHAR2(4),
	QPMK_WERKS                    	VARCHAR2(4),
	VERWMERKM                     	VARCHAR2(8),
	MKVERSION                     	VARCHAR2(6),
	QMTB_WERKS                    	VARCHAR2(4),
	PMETHODE                      	VARCHAR2(8),
	PMTVERSION                    	VARCHAR2(6),
	PMTKURZTXT                    	VARCHAR2(40),
	PRUEFQUALI                    	VARCHAR2(5),
	MERKGEW                       	VARCHAR2(2),
	GEWKURZTXT                    	VARCHAR2(40),
	KURZTEXT                      	VARCHAR2(40),
	FORMEL                        	VARCHAR2(120),
	DUMMY10                       	VARCHAR2(10),
	DUMMY20                       	VARCHAR2(20),
	DUMMY40                       	VARCHAR2(40),
	STELLEN                       	VARCHAR2(2),
	MASSEINHSW                    	VARCHAR2(3),
	SOLLWERT                      	VARCHAR2(16),
	TOLERANZOB                    	VARCHAR2(16),
	TOLERANZUN                    	VARCHAR2(16),
	PLAUSIOBEN                    	VARCHAR2(16),
	PLAUSIUNTE                    	VARCHAR2(16),
	GRENZEOB1                     	VARCHAR2(16),
	GRENZEUN1                     	VARCHAR2(16),
	GRENZEOB2                     	VARCHAR2(16),
	GRENZEUN2                     	VARCHAR2(16),
	KATAB1                        	VARCHAR2(1),
	KATALGART1                    	VARCHAR2(1),
	AUSWMGWRK1                    	VARCHAR2(4),
	AUSWMENGE1                    	VARCHAR2(8),
	KATAB2                        	VARCHAR2(1),
	KATALGART2                    	VARCHAR2(1),
	AUSWMGWRK2                    	VARCHAR2(4),
	AUSWMENGE2                    	VARCHAR2(8),
	KATAB3                        	VARCHAR2(1),
	KATALGART3                    	VARCHAR2(1),
	AUSWMGWRK3                    	VARCHAR2(4),
	AUSWMENGE3                    	VARCHAR2(8),
	KATAB4                        	VARCHAR2(1),
	KATALGART4                    	VARCHAR2(1),
	AUSWMGWRK4                    	VARCHAR2(4),
	AUSWMENGE4                    	VARCHAR2(8),
	KATAB5                        	VARCHAR2(1),
	KATALGART5                    	VARCHAR2(1),
	AUSWMGWRK5                    	VARCHAR2(4),
	AUSWMENGE5                    	VARCHAR2(8),
	SOLLSTPUMF                    	VARCHAR2(7),
	PROBEMGEH                     	VARCHAR2(3),
	PROBMGFAK                     	VARCHAR2(6),
	ANNAHMEZ                      	VARCHAR2(5),
	RUECKWEZ                      	VARCHAR2(5),
	KFAKTOR                       	VARCHAR2(16),
	QRKNR                         	VARCHAR2(12),
	PHYSPROBE                     	VARCHAR2(6),
	KZKORRTRAN                    	VARCHAR2(1),
	ZAEHL                         	VARCHAR2(8),
	ANTVERF                       	VARCHAR2(1),
	METEIL                        	NUMBER(10, 0),
	MEMERKMAL                     	NUMBER(10, 0),
	MODIFIED                      	NUMBER(10, 0)
)
;

CREATE TABLE SAP_QAIVC
(
	SATZART                       	VARCHAR2(3),
	PRUEFLOS                      	VARCHAR2(12),
	PLNFL                         	VARCHAR2(6),
	VORNR                         	VARCHAR2(4),
	WERK                          	VARCHAR2(4),
	ART                           	VARCHAR2(8),
	HERKUNFT                      	VARCHAR2(2),
	ENTSTEHDAT                    	DATE,
	ERSTELLER                     	VARCHAR2(12),
	AENDERER                      	VARCHAR2(12),
	AENDERDAT                     	DATE,
	KZVESUBSYS                    	VARCHAR2(1),
	VKATART                       	VARCHAR2(1),
	VWERKS                        	VARCHAR2(4),
	VAUSWAHLMG                    	VARCHAR2(8),
	PPVEKATART                    	VARCHAR2(1),
	PPVEWERK                      	VARCHAR2(4),
	PPVEMENGE                     	VARCHAR2(8),
	PPVECODGRA                    	VARCHAR2(8),
	PPVECODEA                     	VARCHAR2(4),
	PPVECODGRR                    	VARCHAR2(8),
	PPVECODER                     	VARCHAR2(4),
	PLNTY                         	VARCHAR2(1),
	PLNNR                         	VARCHAR2(8),
	PPLVERW                       	VARCHAR2(3),
	PLNAL                         	VARCHAR2(2),
	ZAEHL                         	VARCHAR2(8),
	PLANKTEXT                     	VARCHAR2(40),
	DATUV                         	DATE,
	PASTRTERM                     	DATE,
	PAENDTERM                     	DATE,
	KUNNR                         	VARCHAR2(10),
	NAME1KUN                      	VARCHAR2(35),
	LIFNR                         	VARCHAR2(10),
	NAME1LIF                      	VARCHAR2(35),
	HERSTELLER                    	VARCHAR2(10),
	NAME1HER                      	VARCHAR2(35),
	MATNR                         	VARCHAR2(18),
	KTEXTMAT                      	VARCHAR2(40),
	KTEXTLOS                      	VARCHAR2(40),
	CHARG                         	VARCHAR2(10),
	LAGORTCHRG                    	VARCHAR2(4),
	LICHN                         	VARCHAR2(15),
	IDNLF                         	VARCHAR2(35),
	KDMAT                         	VARCHAR2(35),
	POSTX                         	VARCHAR2(40),
	WERKVORG                      	VARCHAR2(4),
	LAGORTVORG                    	VARCHAR2(4),
	LOSMENGE                      	VARCHAR2(17),
	MENGENEINH                    	VARCHAR2(3),
	GESSTICHPR                    	VARCHAR2(17),
	EINHPROBE                     	VARCHAR2(3),
	EBELN                         	VARCHAR2(10),
	EBELP                         	VARCHAR2(5),
	MJAHR                         	VARCHAR2(4),
	MBLNR                         	VARCHAR2(10),
	ZEILE                         	VARCHAR2(4),
	BUDAT                         	DATE,
	AUFNR                         	VARCHAR2(12),
	KDAUF                         	VARCHAR2(10),
	KDPOS                         	VARCHAR2(6),
	VORKTXT                       	VARCHAR2(40),
	PRPLATZ                       	VARCHAR2(8),
	PRPLATZWRK                    	VARCHAR2(4),
	PRPLATZTXT                    	VARCHAR2(40),
	SUBSYS                        	VARCHAR2(6),
	QKZPRZEIT                     	VARCHAR2(1),
	QKZPRMENG                     	VARCHAR2(1),
	QKZPRFREI                     	VARCHAR2(1),
	QRASTZEHT                     	VARCHAR2(3),
	QRASTZFAK                     	VARCHAR2(6),
	QRASTMENG                     	VARCHAR2(17),
	QRASTEREH                     	VARCHAR2(3),
	PPKTTYP                       	VARCHAR2(1),
	KZEQUNR                       	VARCHAR2(1),
	SWEQUNR                       	VARCHAR2(20),
	KZTPLNR                       	VARCHAR2(1),
	SWTPLNR                       	VARCHAR2(20),
	KZPHYNR                       	VARCHAR2(1),
	SWPHYNR                       	VARCHAR2(20),
	KZUSERC1                      	VARCHAR2(1),
	SWUSERC1                      	VARCHAR2(20),
	KZUSERC2                      	VARCHAR2(1),
	SWUSERC2                      	VARCHAR2(20),
	KZUSERN1                      	VARCHAR2(1),
	SWUSERN1                      	VARCHAR2(20),
	KZUSERN2                      	VARCHAR2(1),
	SWUSERN2                      	VARCHAR2(20),
	KZUSERD1                      	VARCHAR2(1),
	SWUSERD1                      	VARCHAR2(20),
	KZUSERT1                      	VARCHAR2(1),
	SWUSERT1                      	VARCHAR2(20),
	TEILLOSPFL                    	VARCHAR2(1),
	CHARGPFL                      	VARCHAR2(1),
	QUANTITIES                    	VARCHAR2(1),
	EVALUATION                    	VARCHAR2(1),
	KOSTL                         	VARCHAR2(10),
	KZKORRTRAN                    	VARCHAR2(1),
	PRUEFSTAT                     	VARCHAR2(1),
	EINHVORG                      	VARCHAR2(3),
	RUECKMPP                      	VARCHAR2(1),
	MODIFIED                      	NUMBER(10, 0)
)
;

CREATE TABLE SAP_QDAS_CONTENT_MAPPING
(
	SAP_TABLE                     	VARCHAR2(50),
	SAP_FIELD                     	VARCHAR2(50),
	SAP_FIELD_SUBKEY              	VARCHAR2(50),
	QDAS_FIELD                    	VARCHAR2(50),
	QDAS_FIELD_SUBKEY             	VARCHAR2(50),
	SAP_CONTENT                   	VARCHAR2(50),
	QDAS_CONTENT                  	VARCHAR2(50)
)
;

CREATE TABLE SAP_QDAS_MAPPING
(
	SAP_TABLE                     	VARCHAR2(20),
	SAP_FIELD                     	VARCHAR2(20),
	QDAS_TABLE                    	VARCHAR2(20),
	QDAS_FIELD                    	VARCHAR2(20),
	QDAS_KEY                      	VARCHAR2(20),
	QDAS_TAKEOVER                 	VARCHAR2(20)
)
;


CREATE TABLE SAP_QIERR
(
	LFDNR                         	VARCHAR2(4),
	MSGID                         	VARCHAR2(20),
	MSGNR                         	VARCHAR2(3),
	MSGTYPE                       	VARCHAR2(1),
	MSGTEXT                       	VARCHAR2(73),
	LOG_NO                        	VARCHAR2(20),
	LOG_MSG_NO                    	VARCHAR2(6),
	PARAM_NAME                    	VARCHAR2(32),
	PARAM_ROW                     	NUMBER(10, 0),
	PARAM_FIELD                   	VARCHAR2(30),
	PRUEFLOS                      	VARCHAR2(12),
	PLNFL                         	VARCHAR2(6),
	VORNR                         	VARCHAR2(4),
	VORGLFNR                      	VARCHAR2(8),
	MERKNR                        	VARCHAR2(4),
	KATAB                         	VARCHAR2(1),
	KATALGART                     	VARCHAR2(1),
	AUSWMGWRK                     	VARCHAR2(4),
	AUSWMENGE                     	VARCHAR2(8),
	CODEGRUPPE                    	VARCHAR2(8),
	CODE                          	VARCHAR2(4),
	RUECKMELNR                    	VARCHAR2(8),
	PROBENR                       	VARCHAR2(6),
	STUECKNR                      	VARCHAR2(4),
	SATZART                       	VARCHAR2(3)
)
;

CREATE TABLE SAP_QIWLR
(
	MANDANT                       	VARCHAR2(3),
	SUBSYS                        	VARCHAR2(6),
	PRUEFLOS                      	VARCHAR2(12),
	PLNFL                         	VARCHAR2(6),
	VORNR                         	VARCHAR2(4),
	PRPLATZ                       	VARCHAR2(8),
	PRPLATZWRK                    	VARCHAR2(4),
	EINFUEGDAT                    	DATE,
	EINFUEGTIM                    	DATE,
	AENDERDAT                     	DATE,
	AENDERTIM                     	DATE,
	SENDATERST                    	DATE,
	SENTIMERST                    	DATE,
	SENDATKOR                     	DATE,
	SENTIMKOR                     	DATE,
	SENDSTAT                      	VARCHAR2(1),
	PRUEFSTAT                     	VARCHAR2(1),
	ART                           	VARCHAR2(8),
	ENSTEHDAT                     	DATE,
	HERKUNFT                      	VARCHAR2(2),
	VORGWERK                      	VARCHAR2(4),
	MATNR                         	VARCHAR2(18),
	CHARG                         	VARCHAR2(10),
	AUFNR                         	VARCHAR2(12),
	LIFNR                         	VARCHAR2(10),
	KUNNR                         	VARCHAR2(10),
	MBLNR                         	VARCHAR2(10),
	UPSL                          	VARCHAR2(1)
)
;

CREATE TABLE SAP_VE
(
	VE_KEY                        	NUMBER(10, 0),
	VE_PRUEFLOS                   	VARCHAR2(12),
	VE_AUSWMENGE                  	VARCHAR2(8),
	VE_AUSWMGWRK                  	VARCHAR2(4),
	VE_CODE                       	VARCHAR2(4),
	VE_CODEGRUPPE                 	VARCHAR2(8),
	VE_ERSTELLER                  	VARCHAR2(12),
	VE_TEXT                       	VARCHAR2(80),
	VE_DATUM                      	DATE,
	VE_TRANSFERDATUM              	DATE,
	VE_TRANSFERSTATUS             	NUMBER(10, 0)
)
;



ALTER TABLE TRANSMIT_WERTEVAR ADD 
(
	WV0034                        	NUMBER(10, 0)
)
;

ALTER TABLE WERTEVAR ADD 
(
	WV0034                        	NUMBER(10, 0)
)
;



INSERT INTO SAP_QDAS_MAPPING VALUES ('SPECIAL','LOSABSCHLUSS','','K1113','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SPECIAL','MMABSCHLUSS','','K2090','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QIWLR','MANDANT','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QIWLR','SUBSYS','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QIWLR','PRUEFLOS','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QIWLR','PLNFL','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QIWLR','VORNR','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QIWLR','PRPLATZ','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QIWLR','PRPLATZWRK','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QIWLR','EINFUEGDAT','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QIWLR','EINFUEGTIM','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QIWLR','AENDERDAT','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QIWLR','AENDERTIM','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QIWLR','SENDATERST','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QIWLR','SENTIMERST','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QIWLR','SENDATKOR','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QIWLR','SENTIMKOR','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QIWLR','SENDSTAT','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QIWLR','PRUEFSTAT','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QIWLR','ART','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QIWLR','ENSTEHDAT','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QIWLR','HERKUNFT','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QIWLR','VORGWERK','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QIWLR','MATNR','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QIWLR','CHARG','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QIWLR','AUFNR','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QIWLR','LIFNR','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QIWLR','KUNNR','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QIWLR','MBLNR','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QIWLR','UPSL','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIVC','SATZART','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIVC','PRUEFLOS','','K1302','2','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIVC','PLNFL','','K1011','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIVC','VORNR','','K1086','3','2')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIVC','WERK','','K1303','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIVC','ART','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIVC','HERKUNFT','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIVC','ENTSTEHDAT','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIVC','ERSTELLER','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIVC','AENDERER','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIVC','AENDERDAT','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIVC','KZVESUBSYS','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIVC','VKATART','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIVC','VWERKS','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIVC','VAUSWAHLMG','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIVC','PPVEKATART','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIVC','PPVEWERK','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIVC','PPVEMENGE','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIVC','PPVECODGRA','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIVC','PPVECODEA','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIVC','PPVECODGRR','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIVC','PPVECODER','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIVC','PLNTY','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIVC','PLNNR','','K1341','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIVC','PPLVERW','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIVC','PLNAL','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIVC','ZAEHL','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIVC','PLANKTEXT','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIVC','DATUV','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIVC','PASTRTERM','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIVC','PAENDTERM','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIVC','KUNNR','','K1061','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIVC','NAME1KUN','','K1062','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIVC','LIFNR','','K1071','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIVC','NAME1LIF','','K1072','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIVC','HERSTELLER','','K1021','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIVC','NAME1HER','','K1022','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIVC','MATNR','','K1001','1','1')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIVC','KTEXTMAT','','K1002','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIVC','KTEXTLOS','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIVC','CHARG','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIVC','LA;RTCHRG','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIVC','LICHN','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIVC','IDNLF','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIVC','KDMAT','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIVC','POSTX','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIVC','WERKVORG','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIVC','LA;RTVORG','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIVC','LOSMENGE','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIVC','MENGENEINH','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIVC','GESSTICHPR','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIVC','EINHPROBE','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIVC','EBELN','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIVC','EBELP','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIVC','MJAHR','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIVC','MBLNR','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIVC','ZEILE','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIVC','BUDAT','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIVC','AUFNR','','K1053','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIVC','KDAUF','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIVC','KDPOS','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIVC','VORKTXT','','K1087','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIVC','PRPLATZ','','K1206','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIVC','PRPLATZWRK','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIVC','PRPLATZTXT','','K1202','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIVC','SUBSYS','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIVC','QKZPRZEIT','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIVC','QKZPRMENG','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIVC','QKZPRFREI','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIVC','QRASTZEHT','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIVC','QRASTZFAK','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIVC','QRASTMENG','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIVC','QRASTEREH','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIVC','PPKTTYP','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIVC','KZEQUNR','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIVC','SWEQUNR','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIVC','KZTPLNR','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIVC','SWTPLNR','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIVC','KZPHYNR','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIVC','SWPHYNR','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIVC','KZUSERC1','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIVC','SWUSERC1','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIVC','KZUSERC2','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIVC','SWUSERC2','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIVC','KZUSERN1','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIVC','SWUSERN1','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIVC','KZUSERN2','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIVC','SWUSERN2','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIVC','KZUSERD1','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIVC','SWUSERD1','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIVC','KZUSERT1','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIVC','SWUSERT1','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIVC','TEILLOSPFL','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIVC','CHARGPFL','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIVC','QUANTITIES','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIVC','EVALUATION','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIVC','KOSTL','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIVC','KZKORRTRAN','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIVC','PRUEFSTAT','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIVC','EINHVORG','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIVC','RUECKMPP','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIMV','SATZART','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIMV','RUECKMELNR','','K2307','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIMV','ERFASSART','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIMV','KZBEWSUBSY','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIMV','BEWART','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIMV','KZRZWANG','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIMV','STATUSV','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIMV','STATUSR','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIMV','KZPRUMF','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIMV','KZDOKU','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIMV','KZSERNR','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIMV','KZTSTICHPR','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIMV','KZRAST','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIMV','RASTER','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIMV','SOLLSTPANZ','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIMV','BEWARTSP','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIMV','PRUEFLOS','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIMV','PLNFL','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIMV','VORNR','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIMV','MERKNR','','K2001','4','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIMV','QPMK_WERKS','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIMV','VERWMERKM','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIMV','MKVERSION','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIMV','QMTB_WERKS','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIMV','PMETHODE','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIMV','PMTVERSION','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIMV','PMTKURZTXT','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIMV','PRUEFQUALI','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIMV','MERKGEW','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIMV','GEWKURZTXT','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIMV','KURZTEXT','','K2002','','3')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIMV','FORMEL','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIMV','DUMMY10','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIMV','DUMMY20','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIMV','DUMMY40','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIMV','STELLEN','','K2022','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIMV','MASSEINHSW','','K2142','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIMV','SOLLWERT','','K2101','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIMV','TOLERANZOB','','K2111','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIMV','TOLERANZUN','','K2110','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIMV','PLAUSIOBEN','','K2131','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIMV','PLAUSIUNTE','','K2130','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIMV','GRENZEOB1','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIMV','GRENZEUN1','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIMV','GRENZEOB2','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIMV','GRENZEUN2','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIMV','KATAB1','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIMV','KATALGART1','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIMV','AUSWMGWRK1','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIMV','AUSWMENGE1','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIMV','KATAB2','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIMV','KATALGART2','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIMV','AUSWMGWRK2','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIMV','AUSWMENGE2','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIMV','KATAB3','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIMV','KATALGART3','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIMV','AUSWMGWRK3','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIMV','AUSWMENGE3','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIMV','KATAB4','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIMV','KATALGART4','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIMV','AUSWMGWRK4','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIMV','AUSWMENGE4','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIMV','KATAB5','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIMV','KATALGART5','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIMV','AUSWMGWRK5','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIMV','AUSWMENGE5','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIMV','SOLLSTPUMF','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIMV','PROBEMGEH','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIMV','PROBMGFAK','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIMV','ANNAHMEZ','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIMV','RUECKWEZ','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIMV','KFAKTOR','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIMV','QRKNR','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIMV','PHYSPROBE','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIMV','KZKORRTRAN','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIMV','ZAEHL','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAIMV','ANTVERF','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAICA','SATZART','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAICA','KATAB','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAICA','KATALGART','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAICA','AUSWMGWRK','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAICA','AUSWMENGE','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAICA','CODEGRUPPE','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAICA','CODE','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAICA','KURZTEXT','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAICA','BEWERTUNG','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAICA','FEHLKLASSE','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAICA','MUSSTEXTKZ','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAICA','BB_VORSCH','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QAICA','QKENNZAHL','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QIERR','LFDNR','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QIERR','MSGID','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QIERR','MSGNR','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QIERR','MSGTYPE','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QIERR','MSGTEXT','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QIERR','LOG_NO','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QIERR','LOG_MSG_NO','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QIERR','PARAM_NAME','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QIERR','PARAM_ROW','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QIERR','PARAM_FIELD','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QIERR','PRUEFLOS','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QIERR','PLNFL','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QIERR','VORNR','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QIERR','VORGLFNR','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QIERR','MERKNR','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QIERR','KATAB','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QIERR','KATALGART','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QIERR','AUSWMGWRK','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QIERR','AUSWMENGE','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QIERR','CODEGRUPPE','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QIERR','CODE','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QIERR','RUECKMELNR','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QIERR','PROBENR','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QIERR','STUECKNR','','','','')
;
INSERT INTO SAP_QDAS_MAPPING VALUES ('SAP_QIERR','SATZART','','','','')
;
