Skip to Content
0
Former Member
Aug 15, 2013 at 04:00 PM

Date conversion in CE_CALC

47 Views

Hi, All.

Why does error "Attribute not found in column table: /BIC/ZBSTDK_E" occur in PRE_ORDER_PROJ_2?

PRE_ORDER_TAB = CE_COLUMN_TABLE("SAPBH1"."/BIC/AZSD_O0100",

["DOC_NUMBER",

"/BIC/ZBSTDK_E",

"SUBTOTAL_2",

"DOC_CURRCY"

]);

PRE_ORDER_PROJ_1 = CE_PROJECTION(:PRE_ORDER_TAB,

["DOC_NUMBER",

"/BIC/ZBSTDK_E" AS "BSTDK_E",

"SUBTOTAL_2" AS "ORDER_SUM",

"DOC_CURRCY"

],

'"DOC_NUMBER" = '':PRM_ORDER''');

PRE_ORDER_PROJ_2 = CE_PROJECTION(:PRE_ORDER_TAB,

["DOC_NUMBER",

CE_CALC('TO_DATE("/BIC/ZBSTDK_E")',DATE) AS "BSTDK_E",

"SUBTOTAL_2" AS "ORDER_SUM",

"DOC_CURRCY"

],

'"DOC_NUMBER" = '':PRM_ORDER''');