JD Edwards/EXTOL - Setting up 856 Outbound Hierarchy Levels in E1

Below are the SQL statements to execute to set-up different SQL views for the different HLs.


We will apply these views within an EXTOL Binding

Create the following views for each E1 environment
  • CREATE VIEW VW_F470371S AS SELECT * FROM "CRPDTA"."F470371" WHERE SZHL03="S";
  • CREATE VIEW VW_F470371O AS SELECT * FROM "CRPDTA"."F470371" WHERE SZHL03="O";
  • CREATE VIEW VW_F470371T AS SELECT * FROM "CRPDTA"."F470371" WHERE SZHL03="T";
  • CREATE VIEW VW_F470371P AS SELECT * FROM "CRPDTA"."F470371" WHERE SZHL03="P";
  • CREATE VIEW VW_F470371I AS SELECT * FROM "CRPDTA"."F470371" WHERE SZHL03="I";



EXTOL Business Partner Logo

Cleo/ERP Set-ups

We have examples for many ERPs that interface with Cleo. We customize interfaces for JDEdwards, SAP, VAI/S2K, and Oracle.