S/4HANA product search后台生成的SQL查询语句

版权声明：本文为博主原创文章，遵循 CC 4.0 by-sa 版权协议，转载请附上原文出处链接和本声明。

本文链接：https://jerry.blog.csdn.net/article/details/99699043

CL_SADL_QUERY_ENGINE_SQL_BASE~GENERATE_SQL_STATEMENT CL_SADL_SQL_STATEMENT~GET_SECTIONS_FOR_SELECT

在这里插入图片描述

LV_SELECT: C_Product~ACTIVEPRODUCT AS ACTIVEPRODUCT, C_Product~ARTICLECATEGORY AS ARTICLECATEGORY, C_Product~DRAFTADMINISTRATIVEDATAUUID AS DRAFTADMINISTRATIVEDATAUUID, C_Product~DRAFTKEY AS DRAFTKEY, C_Product~HASACTIVEENTITY AS HASACTIVEENTITY, C_Product~HASDRAFTENTITY AS HASDRAFTENTITY, C_Product~ISACTIVEENTITY AS ISACTIVEENTITY, C_Product~LASTCHANGEDATE AS LASTCHANGEDATE, C_Product~LASTCHANGEDBYUSER AS LASTCHANGEDBYUSER, C_Product~PRODUCT AS PRODUCT, C_Product~PRODUCTDESCRIPTION AS PRODUCTDESCRIPTION, C_Product~PRODUCTGROUP AS PRODUCTGROUP, C_Product~PRODUCTIMAGEURL AS PRODUCTIMAGEURL, C_Product~PRODUCTSTANDARDID AS PRODUCTSTANDARDID, C_Product~PRODUCTTYPE AS PRODUCTTYPE LV_TABLE: C_PRODUCT AS C_Product LEFT OUTER JOIN C_COMPETITORIDTEMP AS BSA_E25X1 ON C_Product~COMPETITORID = BSA_E25X1~COMPETITORID LEFT OUTER JOIN C_PRODUCT AS nav_SIBLINGENTITYC_Pr_41 ON NOT C_Product~ISACTIVEENTITY = nav_SIBLINGENTITYC_Pr_41~ISACTIVEENTITY AND C_Product~ACTIVEPRODUCT = nav_SIBLINGENTITYC_Pr_41~ACTIVEPRODUCT LEFT OUTER JOIN I_DIVISION AS BSA_E29X1 ON C_Product~DIVISION = BSA_E29X1~DIVISION LEFT OUTER JOIN I_DIVISIONTEXT AS BSA_E29X2 ON BSA_E29X1~DIVISION = BSA_E29X2~DIVISION AND BSA_E29X2~LANGUAGE = ‘E’ LEFT OUTER JOIN I_PRODUCTSTATUS AS BSA_E7X1 ON C_Product~CROSSPLANTSTATUS = BSA_E7X1~STATUS LEFT OUTER JOIN I_PRODUCTSTATUSTEXT AS BSA_E7X2 ON BSA_E7X1~STATUS = BSA_E7X2~STATUS AND BSA_E7X2~LANGUAGE = ‘E’ LEFT OUTER JOIN I_MATLABCCLASSIFICATION AS BSA_E80X1 ON C_Product~CONSUMPTIONVALUECATEGORY = BSA_E80X1~MATERIALABCCLASSIFICATION LEFT OUTER JOINI_MATLABCCLASSIFICATIONTEXT AS BSA_E80X2 ON BSA_E80X1~MATERIALABCCLASSIFICATION = BSA_E80X2~MATERIALABCCLASSIFICATION AND BSA_E80X2~LANGUAGE = ‘E’ LV_WHERE: ( C_Product~ISACTIVEENTITY = ’ ’ OR nav_SIBLINGENTITYC_Pr_41~ISACTIVEENTITY IS NULL ) AND %_native_pred( hdb = %_native( 'CONTAINS(' ), %_native( '(' ), C_Product~ACTIVEPRODUCT, %_native( ',' ), C_Product~BASEUNIT, %_native( ',' ), C_Product~CREATEDBYUSER, %_native( ',' ), C_Product~CREATIONDATE, %_native( ',' ), C_Product~CROSSPLANTSTATUS, %_native( ',' ), BSA_E25X1~CUSTOMERNAME, %_native( ',' ), BSA_E80X2~MATERIALABCCLASSIFICATIONDESC, %_native( ',' ), BSA_E7X2~MATERIALUSABILITYPROFILENAME, %_native( ',' ), BSA_E29X2~DIVISIONNAME, %_native( ',' ), C_Product~LASTCHANGEDATE, %_native( ',' ), C_Product~LASTCHANGEDBYUSER, %_native( ',' ), C_Product~PRODUCT, %_native( ',' ), C_Product~PRODUCTDESCRIPTION, %_native( ',' ), C_Product~PRODUCTGROUP, %_native( ')' ), %_native( ',' ), CAST( 'java' AS CHAR ), %_native( ',' ), %_native( 'FUZZY(' ), %_native( '(' ), '1.0', %_native( ')' ), %_native( ',' ), %_native( '(' ), '0.8', %_native( ',' ), '''similarCalculationMode=search''', %_native( ')' ), %_native( ',' ), %_native( '(' ), '0.8', %_native( ',' ), '''similarCalculationMode=search''', %_native( ')' ), %_native( ',' ), %_native( '(' ), '0.8', %_native( ',' ), '''similarCalculationMode=search''', %_native( ')' ), %_native( ',' ), %_native( '(' ), '0.8', %_native( ',' ), '''similarCalculationMode=search''', %_native( ')' ), %_native( ',' ), %_native( '(' ), '0.8', %_native( ',' ), '''similarCalculationMode=search''', %_native( ')' ), %_native( ',' ), %_native( '(' ), '0.8', %_native( ',' ), '''similarCalculationMode=search''', %_native( ')' ), %_native( ',' ), %_native( '(' ), '0.8', %_native( ',' ), '''similarCalculationMode=search''', %_native( ')' ), %_native( ',' ), %_native( '(' ), '0.8', %_native( ',' ), '''similarCalculationMode=search''', %_native( ')' ), %_native( ',' ), %_native( '(' ), '0.8', %_native( ',' ), '''similarCalculationMode=search''', %_native( ')' ), %_native( ',' ), %_native( '(' ), '0.8', %_native( ',' ), '''similarCalculationMode=search''', %_native( ')' ), %_native( ',' ), %_native( '(' ), '0.8', %_native( ',' ), '''similarCalculationMode=search''', %_native( ')' ), %_native( ',' ), %_native( '(' ), '0.8', %_native( ',' ), '''similarCalculationMode=search''', %_native( ')' ), %_native( ',' ), %_native( '(' ), '0.8', %_native( ',' ), '''similarCalculationMode=search''', %_native( ')' ), %_native( ')' ), %_native( ')' ) ) LV_GROUP_BY: C_Product~DRAFTKEY ASCENDING, C_Product~ACTIVEPRODUCT ASCENDING LV_LIMIT: 25