Ansicht
Dokumentation
CS_BOM_DYNSQL_PE_HANA - Dynamic SQL Generation for Parameter Effectivity
CL_GUI_FRONTEND_SERVICES - Frontend Services BAL_S_LOG - Application Log: Log header dataThis documentation is copyright by SAP AG.
Purpose
You can use this report to generate dynamic SQL for parameter effectivity, when there is change in Customizing. You have to provide a reference to table AEFF, copy the SQL code in the method MAT_CHECK_ECN_PE of the ABAP managed procedure CL_CS_BOM_AMDPand activate it.
Integration
Prerequisites
Features
This report can be used if there is a change in the following Customizing:
- Change in Active Profile in Logistics-General→Engineering Change Management→Set Control Data.
- Change in effectivity type in active profile in Logistics-General→Engineering Change Management→Parameter Effectivity →Maintain Effectivity Profiles.
You can also use this report when a material is added to a specific profile under:
SAP Easy Access Menu → Logistics →Central Functions→Engineering→Engineering Change Management→Environment→Parameter Effectivity→ Assign Material to Profile.
Selection
Standard Variants
Output
Activities
Example
Generated Code for the Report:
METHOD MAT_CHECK_ECN_PE
by database procedure for hdb language sqlscript
options READ-ONLY
using AEEF.
BEGIN
SET01 =SELECT AEEF.* ,AENNR_TAB.THE_INDEX
FROM AEEF AS AEEF
INNER JOIN :AENNR_TAB AS AENNR_TAB ON AEEF.MANDT = AENNR_TAB.MANDT AND AEEF.AENNR = AENNR_TAB.AENNR
INNER JOIN :PAR_EFF as PAR_EFF on AENNR_TAB.THE_INDEX = PAR_EFF.THE_INDEX AND AENNR_TAB.MANDT = PAR_EFF.MANDT
WHERE AENNR_TAB.CLINT IN ( '0000000004' )
AND AEEF.MATNR_LO = PAR_EFF.VALUE AND PAR_EFF.FIELDNAME = 'MATNR_LO' AND AEEF. MATNR_LO <>'';
/*****************End of MATNR Parameter**********/
VALID_AENNR_PAR_EFF = SELECT MANDT, THE_INDEX, AENNR FROM :SET01;
END;
ENDMETHOD.
BAL_S_LOG - Application Log: Log header data ABAP Short Reference
This documentation is copyright by SAP AG.
Length: 3027 Date: 20240520 Time: 081430 sap01-206 ( 41 ms )