use QDAS
GO


CREATE TABLE PRUEFLOS
(
	PLKEY                         	INT,
	PLTEIL                        	INT,
	PLPRUEFLOSNUMMER              	VARCHAR(50),
	PLSTATUS                      	INT,
	PLDATUMDOWNLOAD               	DATETIME,
	PLPLERSTELLDAT                	DATETIME,
	PLERSTELLER                   	VARCHAR(40),
	PLBEMERKUNG                   	VARCHAR(255),
	PLANZWERTE                    	INT,
	PLANZWERTESOLL                	INT,
	PLTEILKEYFIELD1               	VARCHAR(20),
	PLTEILKEYFIELD2               	VARCHAR(20),
	PLVEKEY                       	INT,
	PLAUFTRAG               				VARCHAR(50)
)
GO


CREATE TABLE SAP_ALL_QAICA
(
	SATZART                       	VARCHAR(3) ,
	KATAB                         	VARCHAR(1) ,
	KATALGART                     	VARCHAR(1) ,
	AUSWMGWRK                     	VARCHAR(4) ,
	AUSWMENGE                     	VARCHAR(8) ,
	CODEGRUPPE                    	VARCHAR(8) ,
	CODE                          	VARCHAR(4) ,
	KURZTEXT                      	VARCHAR(40) ,
	BEWERTUNG                     	VARCHAR(1) ,
	FEHLKLASSE                    	VARCHAR(2) ,
	MUSSTEXTKZ                    	VARCHAR(1) ,
	BB_VORSCH                     	VARCHAR(1) ,
	QKENNZAHL                     	VARCHAR(3) ,
	KATALOG_ID                    	INT ,
	KATALOG_ENTRY                 	INT
)
GO

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

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

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

CREATE TABLE SAP_QDAS_CONTENT_MAPPING
(
	SAP_TABLE                      varchar(50),
	SAP_FIELD					   varchar(50),
	SAP_FIELD_SUBKEY               varchar(50),
	QDAS_FIELD                     varchar(50),
	QDAS_FIELD_SUBKEY              varchar(50),
	SAP_CONTENT                    varchar(50),
	QDAS_CONTENT                   varchar(50)
)
GO

CREATE TABLE SAP_QDAS_MAPPING
(
	SAP_TABLE                     	VARCHAR(20) ,
	SAP_FIELD                     	VARCHAR(20) ,
	QDAS_TABLE                    	VARCHAR(20) ,
	QDAS_FIELD                    	VARCHAR(20) ,
	QDAS_KEY                      	VARCHAR(20) ,
	QDAS_TAKEOVER                 	VARCHAR(20)
)
GO

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

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


CREATE TABLE SAP_VE
(
	VE_KEY                        	INT,
	VE_PRUEFLOS                   	VARCHAR(12),
	VE_AUSWMENGE                  	VARCHAR(8),
	VE_AUSWMGWRK                  	VARCHAR(4),
	VE_CODE                       	VARCHAR(4),
	VE_CODEGRUPPE                 	VARCHAR(8),
	VE_ERSTELLER                  	VARCHAR(12),
	VE_TEXT                       	VARCHAR(80),
	VE_DATUM                      	DATETIME,
	VE_TRANSFERDATUM              	DATETIME,
	VE_TRANSFERSTATUS             	INT
)
GO

ALTER TABLE TRANSMIT_WERTEVAR ADD 
	WV0034                        	INT
GO

ALTER TABLE WERTEVAR ADD 
	WV0034                        	INT
GO

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