从STORE 然后从客户销售视图中取值
来源:互联网 发布:时时彩源码搭建教程 编辑:程序博客网 时间:2024/06/13 03:49
BREAK-POINT.
*
*TYPES: BEGIN OF TY_S_STORE,
* /BIC/ZSTORE type /BIC/OIZSTORE,
*
* CUSTOMER type /BI0/OICUSTOMER,
* /BIC/ZQDLX TYPE /BIC/OIZQDLX,
* division TYPE /bi0/oidivision,
*/BIC/ZSYB TYPE /BIC/OIZSYB,
* END OF TY_S_STORE,
* TY_T_STORE TYPE TABLE OF TY_S_STORE.
*DATA: LT_STORE TYPE TY_T_STORE,
* LS_STORE TYPE TY_S_STORE,
*LT_STORE2 TYPE TY_T_STORE.
*TYPES:BEGIN OF ty_s_custsales,
* division TYPE /bi0/oidivision,
* /BIC/ZSYB TYPE /BIC/OIZSYB, "
* /BIC/ZQDLX TYPE /BIC/OIZQDLX,
* customer TYPE /bi0/oicustomer,
*
* END OF ty_s_custsales,
* ty_t_custsales TYPE TABLE OF ty_s_custsales.
*DATA: lt_custsales TYPE ty_t_custsales,
* ls_custsales TYPE ty_s_custsales.
*
*
*
*REFRESH: LT_STORE.
*
*SELECT /BIC/ZSTORE CUSTOMER /BIC/ZQDLX
* division INTO TABLE LT_STORE
* FROM /BIC/PZSTORE
* FOR ALL ENTRIES IN RESULT_PACKAGE
* WHERE /BIC/ZSTORE = RESULT_PACKAGE-/BIC/zstore
* AND division <> ''
* AND CUSTOMER <> ''
* AND /BIC/ZQDLX <> ''.
**
*SORT LT_STORE BY /BIC/ZSTORE.
*DELETE ADJACENT DUPLICATES FROM LT_STORE COMPARING /BIC/ZSTORE.
**
*
*SELECT division /BIC/ZSYB /BIC/ZQDLX CUST_SALES
* INTO TABLE lt_custsales
* FROM /BIC/AZIMDD00100
* FOR ALL ENTRIES IN LT_STORE
* WHERE customer = LT_STORE-customer
* AND division = LT_STORE-division
* AND /BIC/ZQDLX = LT_STORE-/BIC/ZQDLX
* AND /BIC/ZSYB NE ''.
*
* LT_STORE2[] = LT_STORE[].
* CLEAR LT_STORE.
* LOOP AT LT_STORE2 INTO LS_STORE.
* LOOP AT lt_custsales INTO lS_custsales
* WHERE CUSTOMER = LS_STORE-customer
* AND division = LS_STORE-division
* AND /BIC/ZQDLX = LS_STORE-/BIC/ZQDLX
* AND /BIC/ZSYB NE ''.
* LS_STORE-/BIC/ZSYB = LS_CUSTSALES-/BIC/ZSYB.
* APPEND LS_STORE TO LT_STORE.
* ENDLOOP.
* ENDLOOP.
*
*
*
*LOOP AT RESULT_PACKAGE ASSIGNING <result_fields>.
* LOOP AT lt_STORE INTO ls_STORE
* WHERE /BIC/ZSTORE = <Result_fields>-/BIC/ZSTORE.
* <RESULT_FIELDS>-/BIC/ZSYB = LS_STORE-/BIC/ZSYB.
*
* ENDLOOP.
**"**********************
*ENDLOOP.
********************************************以下为从STORE中取值
*TYPES: BEGIN OF TY_S_STORE,
* /BIC/ZSTORE type /BIC/OIZSTORE,
*/BIC/ZSYB TYPE /BIC/OIZSYB,
* END OF TY_S_STORE,
* TY_T_STORE TYPE TABLE OF TY_S_STORE.
*DATA: LT_STORE TYPE TY_T_STORE,
* LS_STORE TYPE TY_S_STORE.
*
*SELECT /BIC/ZSTORE /BIC/ZSYB
* INTO TABLE LT_STORE
* FROM /BIC/PZSTORE
* FOR ALL ENTRIES IN RESULT_PACKAGE
* WHERE /BIC/ZSTORE = RESULT_PACKAGE-/BIC/zstore
* AND division <> ''
* AND CUSTOMER <> ''
* AND /BIC/ZQDLX <> ''.
*
*LOOP AT RESULT_PACKAGE ASSIGNING <result_fields>.
* loop at LT_STORE into LS_STORE
* where /BIC/ZSTORE = <result_fields>-/BIC/ZSTORE.
* <result_fields>-/BIC/ZSYB = LS_STORE-/BIC/ZSYB.
* ENDLOOP.
* ENDLOOP.
*
*TYPES: BEGIN OF TY_S_STORE,
* /BIC/ZSTORE type /BIC/OIZSTORE,
*
* CUSTOMER type /BI0/OICUSTOMER,
* /BIC/ZQDLX TYPE /BIC/OIZQDLX,
* division TYPE /bi0/oidivision,
*/BIC/ZSYB TYPE /BIC/OIZSYB,
* END OF TY_S_STORE,
* TY_T_STORE TYPE TABLE OF TY_S_STORE.
*DATA: LT_STORE TYPE TY_T_STORE,
* LS_STORE TYPE TY_S_STORE,
*LT_STORE2 TYPE TY_T_STORE.
*TYPES:BEGIN OF ty_s_custsales,
* division TYPE /bi0/oidivision,
* /BIC/ZSYB TYPE /BIC/OIZSYB, "
* /BIC/ZQDLX TYPE /BIC/OIZQDLX,
* customer TYPE /bi0/oicustomer,
*
* END OF ty_s_custsales,
* ty_t_custsales TYPE TABLE OF ty_s_custsales.
*DATA: lt_custsales TYPE ty_t_custsales,
* ls_custsales TYPE ty_s_custsales.
*
*
*
*REFRESH: LT_STORE.
*
*SELECT /BIC/ZSTORE CUSTOMER /BIC/ZQDLX
* division INTO TABLE LT_STORE
* FROM /BIC/PZSTORE
* FOR ALL ENTRIES IN RESULT_PACKAGE
* WHERE /BIC/ZSTORE = RESULT_PACKAGE-/BIC/zstore
* AND division <> ''
* AND CUSTOMER <> ''
* AND /BIC/ZQDLX <> ''.
**
*SORT LT_STORE BY /BIC/ZSTORE.
*DELETE ADJACENT DUPLICATES FROM LT_STORE COMPARING /BIC/ZSTORE.
**
*
*SELECT division /BIC/ZSYB /BIC/ZQDLX CUST_SALES
* INTO TABLE lt_custsales
* FROM /BIC/AZIMDD00100
* FOR ALL ENTRIES IN LT_STORE
* WHERE customer = LT_STORE-customer
* AND division = LT_STORE-division
* AND /BIC/ZQDLX = LT_STORE-/BIC/ZQDLX
* AND /BIC/ZSYB NE ''.
*
* LT_STORE2[] = LT_STORE[].
* CLEAR LT_STORE.
* LOOP AT LT_STORE2 INTO LS_STORE.
* LOOP AT lt_custsales INTO lS_custsales
* WHERE CUSTOMER = LS_STORE-customer
* AND division = LS_STORE-division
* AND /BIC/ZQDLX = LS_STORE-/BIC/ZQDLX
* AND /BIC/ZSYB NE ''.
* LS_STORE-/BIC/ZSYB = LS_CUSTSALES-/BIC/ZSYB.
* APPEND LS_STORE TO LT_STORE.
* ENDLOOP.
* ENDLOOP.
*
*
*
*LOOP AT RESULT_PACKAGE ASSIGNING <result_fields>.
* LOOP AT lt_STORE INTO ls_STORE
* WHERE /BIC/ZSTORE = <Result_fields>-/BIC/ZSTORE.
* <RESULT_FIELDS>-/BIC/ZSYB = LS_STORE-/BIC/ZSYB.
*
* ENDLOOP.
**"**********************
*ENDLOOP.
********************************************以下为从STORE中取值
*TYPES: BEGIN OF TY_S_STORE,
* /BIC/ZSTORE type /BIC/OIZSTORE,
*/BIC/ZSYB TYPE /BIC/OIZSYB,
* END OF TY_S_STORE,
* TY_T_STORE TYPE TABLE OF TY_S_STORE.
*DATA: LT_STORE TYPE TY_T_STORE,
* LS_STORE TYPE TY_S_STORE.
*
*SELECT /BIC/ZSTORE /BIC/ZSYB
* INTO TABLE LT_STORE
* FROM /BIC/PZSTORE
* FOR ALL ENTRIES IN RESULT_PACKAGE
* WHERE /BIC/ZSTORE = RESULT_PACKAGE-/BIC/zstore
* AND division <> ''
* AND CUSTOMER <> ''
* AND /BIC/ZQDLX <> ''.
*
*LOOP AT RESULT_PACKAGE ASSIGNING <result_fields>.
* loop at LT_STORE into LS_STORE
* where /BIC/ZSTORE = <result_fields>-/BIC/ZSTORE.
* <result_fields>-/BIC/ZSYB = LS_STORE-/BIC/ZSYB.
* ENDLOOP.
* ENDLOOP.
0 0
- 从STORE 然后从客户销售视图中取值
- 从开发到销售:软件商如何管理你的典型客户
- 从开发到销售:如何对来公司参观的客户进行介绍
- 从开发到销售:如何对来公司参观的客户进行介绍
- 从开发到销售:软件商如何管理你的典型客户
- iOS从子视图返回根视图,然后切换tabbar遇到的坑
- 从客户角度来说
- SAP的SD模块中客户的销售视图--扩充客户销售范围
- 从软件到销售,再从销售到软件
- 从程序员到销售总监
- 华为:从销售到营销
- 最近的3个困惑:信守承诺、技术产品先行还是市场销售先行、客户从哪来
- 2-读书笔记----iOS开发指南:从零基础到App Store上架--iOS视图和控件
- 3-读书笔记----iOS开发指南:从零基础到App Store上架--iOS表视图
- 从store中获取数据
- 从store中获取数据
- 从store中获取数据
- 如何从客户中赢利
- Android手势使用之 GestureDetector
- firefox中使用ocx的方法
- 业余09—中科院博士教你如何查找外文文献
- Django学习之----model(2)
- (四十三)作业题
- 从STORE 然后从客户销售视图中取值
- android select采用代码实现按钮背景
- beyond compare
- OpenStack, OpenDaylight, OpenFlow and Open vSwitch
- 如何开发线程安全的Servlet?
- 剑指offer7 斐波那契数列
- Just Say It!——DNN在语音识别系统中的应用
- CocoaPods 模块管理
- android样式和主题