Skip to Content
0
Jan 19, 2016 at 10:27 AM

Getting error during INNER JOIN in SQL SAP HANA below

73 Views

Message :

Repository: Encountered an error in repository runtime extension;Model inconsistency. Deploy Calculation View: SQL: transaction rolled back by an internal error: invalid column name: T1.CNT: line 11 col 13 (at pos 553)

Set Schema DDL statement: set schema "SYSTEM"

Type DDL: create type "_SYS_BIC"."sales_pipeline/INNER_SQL1/proc/tabletype/VAR_OUT" as table ("PARTNER" NVARCHAR(10), "BU_GROUP" NVARCHAR(4), "CNT" INTEGER, "PARTNER_GUID" VARBINARY(16), "MANDT" NVARCHAR(3))

Procedure DDL: create procedure "_SYS_BIC"."sales_pipeline/INNER_SQL1/proc" ( OUT var_out "_SYS_BIC"."sales_pipeline/INNER_SQL1/proc/tabletype/VAR_OUT" ) language sqlscript sql security definer reads sql data as

/********* Begin Procedure Script ************/

BEGIN

var_out = SELECT T2."PARTNER",T1."BU_GROUP",T1."CNT",T1."PARTNER_GUID",T1."MANDT"

from "SAPDM1"."BUT000" AS T1

INNER JOIN

"SAPDM1"."BUT100" AS T2

ON T1."PARTNER" = T2."PARTNER" AND

T1."BU_GROUP" = T1."BU_GROUP" AND

T1."CNT" = T2."CNT" AND

T1."PARTNER_GUID" = T1."PARTNER_GUID" AND

T1."MANDT" = T2."MANDT" ;

END /********* End Procedure Script ************/

Attachments

Capture1.PNG (30.7 kB)