  
YEARS,t1.SCENARIO,m1.MEMBER_NM SCENARIO_NAME,
t1.VERSION,m2.MEMBER_NM VERSION_name,
t1.ENTITY,m3.MEMBER_NM ENTITY_name,
t1.PRODUCT,m4.MEMBER_NM PRODUCT_name,
t1.MATERIAL,m5.MEMBER_NM MATERIAL_name,
t1.PROJECT,m6.MEMBER_NM PROJECT_name,
t1.TRANSUNIT,m7.MEMBER_NM TRANSUNIT_name,
t1.MISC,m8.MEMBER_NM MISC_name,
t1.WORKCENTER,m9.MEMBER_NM WORKCENTER_name,
t1.,m10.MEMBER_NM TYPE_name,
t1.,m11.MEMBER_NM ACCOUNT_name,
t1.BEGBALANCE,m12.MEMBER_NM BEGBALANCE_name,
t1.JAN,t1.FEB,t1.MAR,t1.APR,t1.MAY,t1.JUN,t1.JUL,t1.AUG,t1.SEP,t1.OCT,t1.NOV,t1.ODS_YS_ZTBMS_DATA2BI_FIN7 t1
ODS_YS_V_SRFD_DIM m1 t1.SCENARIO=m1.MEMBER_CD (m1.dim_cd)=ODS_YS_V_SRFD_DIM m2 t1.VERSION=m2.MEMBER_CD (m2.dim_cd)=ODS_YS_V_SRFD_DIM m3 t1.ENTITY=m3.MEMBER_CD (m3.dim_cd)=ODS_YS_V_SRFD_DIM m4 t1.PRODUCT=m4.MEMBER_CD (m4.dim_cd)=ODS_YS_V_SRFD_DIM m5 t1.MATERIAL=m5.MEMBER_CD (m5.dim_cd)=ODS_YS_V_SRFD_DIM m6 t1.PROJECT=m6.MEMBER_CD (m6.dim_cd)=ODS_YS_V_SRFD_DIM m7 t1.TRANSUNIT=m7.MEMBER_CD (m7.dim_cd)=ODS_YS_V_SRFD_DIM m8 t1.MISC=m8.MEMBER_CD (m8.dim_cd)=ODS_YS_V_SRFD_DIM m9 t1.WORKCENTER=m9.MEMBER_CD (m9.dim_cd)=ODS_YS_V_SRFD_DIM m10 t1.=m10.MEMBER_CD (m10.dim_cd)=ODS_YS_V_SRFD_DIM m11 t1.=m11.MEMBER_CD (m11.dim_cd)=ODS_YS_V_SRFD_DIM m12 t1.BEGBALANCE=m12.MEMBER_CD (m12.dim_cd)=YEARS=${(len(p_base)>,+p_base+,)}
${(len(p_yx)>,+p_yx+,)}
${(len(p_ys)>,+p_ys+,)}
${(len(p_ycbm)>,+p_ycbm+,)}
${(len(p_cbfl)>,+p_cbfl+,)}
${(len(p_cl)>,+p_cl+,)} |
1min目标场景问卷
立即参与
