Цитата:
есть ли в таблицах DDXTT и DDXTF какие-то записи?
в DDXTT есть список неактивированных вьюшек
CDS_M_M2S_PD_ITM
CDS_M_M2S_PD_I_C
CDS_M_M2S_POIV_B
CDS_M_M2S_POIV_M
CDS_M_PHL_EKBE_C
CDS_M_PHL_VAL
CDS_M_POH_AGGR
CDS_M_POH_EKBEMC
CDS_M_POH_EKBE_C
CDS_M_POH_EKBZMC
CDS_M_POH_VAL
судя по логам
АБАП стошнило от запроса, который написал чистый SQL-щик, который похоже в глаза не видел АБАПа,
и не знает, что вьюшки должны быть по деревянному склеены.
Code:
3 ETP000 CREATE VIEW "CDS_M_PHL_EKBE_C" AS SELECT "EKBE"."MANDT" AS
3 ETP000 "MANDT", "EKBE"."EBELN", "EKBE"."EBELP", "EKBE"."ZEKKN",
3 ETP000 "EKBE"."VGABE" AS "VGABE", "EKBE"."MEINS", "EKBE"."PSTYP",
3 ETP000 "EKBE"."VRTKZ", "EKBE"."BEWTP" AS "BEWTP", "EKBE"."MENGE",
3 ETP000 "EKBE"."DMBTR" AS "DMBTR", "EKBE"."AREWR", "EKBE"."WESBS_A",
3 ETP000 "EKBE"."SHKZG" AS "SHKZG", "EKBE"."ELIKZ", "EKBE"."MATNR",
3 ETP000 "EKBE"."LIFNR", "EKBE"."EKORG", "EKBE"."EKGRP", "EKBE"."BSTYP",
3 ETP000 "EKBE"."BSART", "EKBE"."WERKS", "EKBE"."FPLNR", "EKBE"."HSWAE",
3 ETP000 "EKBE"."RTYPE", "EKBE"."KSCHL", "EKBE"."TBTKZ", "EKBE"."SHKZG_FACTOR"
3 ETP000 AS "SHKZG_FACTOR", CASE "EKBE"."VGABE" WHEN '2' THEN ( cast( cast(
3 ETP000 "EKBE"."SHKZG_FACTOR" * "EKBE"."REWRB" as decimal(000018,000002) ) as
3 ETP000 decimal(000019,000002) ) ) ELSE END REWRB_OD, CASE "EKBE"."VGABE"
3 ETP000 WHEN '2' THEN ( cast( cast( "EKBE"."SHKZG_FACTOR" * "EKBE"."DMBTR"
3 ETP000 as decimal(000026,000002) ) as decimal(000019,000002) ) ) WHEN 'K'
3 ETP000 THEN ( cast( cast( "EKBE"."SHKZG_FACTOR" * "EKBE"."DMBTR" as
3 ETP000 decimal(000026,000002) ) as decimal(000019,000002) ) ) ELSE ( CASE
3 ETP000 "EKBE"."VGABE" WHEN '3' THEN ( CASE "EKBE"."BEWTP" WHEN 'W' THEN
3 ETP000 CAST( 0 AS TINYINT) ELSE ( cast( cast( "EKBE"."SHKZG_FACTOR" *
3 ETP000 "EKBE"."DMBTR" as decimal(000026,000002) ) as decimal(000019,000002)
3 ETP000 ) ) END ) WHEN 'K' THEN ( CASE "EKBE"."BEWTP" WHEN 'W' THEN CAST(
3 ETP000 0 AS TINYINT) ELSE ( cast( cast( "EKBE"."SHKZG_FACTOR" *
3 ETP000 "EKBE"."DMBTR" as decimal(000026,000002) ) as decimal(000019,000002)
3 ETP000 ) ) END ) ELSE END ) END REWRT, CASE "EKBE"."VGABE" WHEN '1'
3 ETP000 THEN ( cast( cast( "EKBE"."SHKZG_FACTOR" * "EKBE"."DMBTR" as
3 ETP000 decimal(000026,000002) ) as decimal(000019,000002) ) ) ELSE END
3 ETP000 WEWRT, CASE "EKBE"."VGABE" WHEN '2' THEN ( cast( cast(
3 ETP000 "EKBE"."SHKZG_FACTOR" * "EKBE"."MENGE" as decimal(000018,000003) ) as
3 ETP000 decimal(000015,000003) ) ) WHEN 'K' THEN ( cast( cast(
3 ETP000 "EKBE"."SHKZG_FACTOR" * "EKBE"."MENGE" as decimal(000018,000003) ) as
3 ETP000 decimal(000015,000003) ) ) ELSE ( cast( CAST( 0 AS TINYINT) as
3 ETP000 decimal(000015,000003) ) ) END REMNG, CASE "EKBE"."VGABE" WHEN '1'
3 ETP000 THEN ( cast( cast( "EKBE"."SHKZG_FACTOR" * "EKBE"."MENGE" as
3 ETP000 decimal(000018,000003) ) as decimal(000015,000003) ) ) ELSE ( cast(
3 ETP000 CAST( 0 AS TINYINT) as decimal(000015,000003) ) ) END WEMNG, CASE
3 ETP000 "EKBE"."VGABE" WHEN '1' THEN ( cast( "EKBE"."SHKZG_FACTOR" *
3 ETP000 "EKBE"."WESBS_A" as decimal(000018,000003) ) ) ELSE END WESBS,
3 ETP000 CASE "EKBE"."VGABE" WHEN '6' THEN ( cast( cast( CAST( -1 AS
3 ETP000 SMALLINT) * "EKBE"."SHKZG_FACTOR" as int ) * "EKBE"."MENGE" as
3 ETP000 decimal(000023,000003) ) ) ELSE END WAMNG FROM "CDS_M_PHL_EKBE"
3 ETP000 "EKBE"
3 ETP000
2WETP000 01:27:01: Retcode 1: error in DDL statement for "CDS_M_PHL_EKBE_C " - repeat
2EETP345 01:27:13: Retcode 1: SQL-error "156-[ASE Error SQL156]Incorrect syntax near the keyword 'E
2EETP345 ND'.
2EETP345 " in DDL statement for "CDS_M_PHL_EKBE_C "
2 ETP000 --------------- DB-ROLLBACK() ---------------
2EETP334 01:27:13: error in DDL, nametab for "CDS_M_PHL_EKBE_C" not activated
кстати, если посмотреть созданные вьюшки такого типа в SE11,
то там в левом нижнем появляется "желтая аллергическая реакция" -
Цитата:
Generated DDL SQL views are only supported in limited way by SE11
Message no. E2340
Diagnosis
DDL SQL views are generated objects that are created from ABAP DDL source code. Direct changes to generated DDL SQL views are not possible with SE11 (Dictionary View Editor). In SE11, all change functions are deactivated for DDL SQL views.
The display of generated DDL SQL views is supported in SE11 to a limited degree only. This applies particularly to SQL features that are not within the function range of SE11 but canbe used in ABAP DDL source code. Examples include UNION, UNION ALL, LEFT OUTER JOIN. The displayed information on generated DDL SQL views is possibly incomplete or unclear for these features.
Procedure
Use the editor for ABAP DDL source code (part of the ABAP development tools in Eclipse) in order to change DDL source code. These changes are propagated to the generated DDL SQL view when the DDL source code is activated.
похоже чем дальше, тем больше SQLщиков будет тошнить от АБАПа, АБАП - от SQL, а нам достанутся результаты их взаимного несварения.
Вход
Регистрация
FAQ пользователя
Поиск
