信贷余额表取数逻辑
来源:互联网 发布:怪诞小镇知乎 编辑:程序博客网 时间:2024/04/28 13:11
FORM GET_DATA .
DATA:LT_KNA1 LIKE TABLE OF KNA1 WITH HEADER LINE,
LT_S066 LIKE TABLE OF S066 WITH HEADER LINE,
LT_S067 LIKE TABLE OF S067 WITH HEADER LINE,
LT_T001 LIKE TABLE OF T001 WITH HEADER LINE,
LT_ZFT_HKH LIKE TABLE OF ZFT_HKH WITH HEADER LINE.
SELECT KUNNR KLIMK KNKLI
FROM KNKK
INTO CORRESPONDING FIELDS OF TABLE GT_ITAB
WHERE KKBER = P_KKBER
AND KUNNR IN S_KUNNR.
IF GT_ITAB[] IS NOT INITIAL.
SELECT * FROM KNA1 INTO TABLE LT_KNA1
FOR ALL ENTRIES IN GT_ITAB
WHERE KUNNR = GT_ITAB-KUNNR.
SELECT * FROM S066 INTO TABLE LT_S066
FOR ALL ENTRIES IN GT_ITAB
WHERE KKBER = P_KKBER
AND KNKLI = GT_ITAB-KNKLI.
SELECT * FROM S067 INTO TABLE LT_S067
FOR ALL ENTRIES IN GT_ITAB
WHERE KKBER = P_KKBER
AND KNKLI = GT_ITAB-KNKLI.
SELECT * FROM T001 INTO TABLE LT_T001
WHERE KKBER = P_KKBER.
IF LT_T001[] IS NOT INITIAL.
SELECT * FROM ZFT_HKH INTO TABLE LT_ZFT_HKH
FOR ALL ENTRIES IN GT_ITAB
WHERE KUNNR = GT_ITAB-KUNNR
AND LOEDK = ''
AND ZKSTO = ''
AND ZFBSK = 'B'.
ENDIF.
ENDIF.
LOOP AT GT_ITAB ASSIGNING <ITAB>.
READ TABLE LT_KNA1 WITH KEY KUNNR = <ITAB>-KUNNR.
IF SY-SUBRC = 0.
<ITAB>-NAME1 = LT_KNA1-NAME1.
ENDIF.
LOOP AT LT_S066 WHERE KNKLI = <ITAB>-KNKLI.
ADD LT_S066-OEIKW TO <ITAB>-OEIKW.
ENDLOOP.
LOOP AT LT_S067 WHERE KNKLI = <ITAB>-KNKLI.
ADD LT_S067-OLIKW TO <ITAB>-OLIKW.
ADD LT_S067-OFAKW TO <ITAB>-OFAKW.
ENDLOOP.
LOOP AT LT_T001 WHERE KKBER = P_KKBER.
LOOP AT LT_ZFT_HKH WHERE BUKRS = LT_T001-BUKRS
AND KUNNR = <ITAB>-KUNNR.
ADD LT_ZFT_HKH-HKBTR TO <ITAB>-HKBTR.
ENDLOOP.
ENDLOOP.
<ITAB>-KYED = <ITAB>-KLIMK + <ITAB>-HKBTR - <ITAB>-OEIKW - <ITAB>-OLIKW - <ITAB>-OFAKW.
ENDLOOP.
ENDFORM. " GET_DATA
DATA:LT_KNA1 LIKE TABLE OF KNA1 WITH HEADER LINE,
LT_S066 LIKE TABLE OF S066 WITH HEADER LINE,
LT_S067 LIKE TABLE OF S067 WITH HEADER LINE,
LT_T001 LIKE TABLE OF T001 WITH HEADER LINE,
LT_ZFT_HKH LIKE TABLE OF ZFT_HKH WITH HEADER LINE.
SELECT KUNNR KLIMK KNKLI
FROM KNKK
INTO CORRESPONDING FIELDS OF TABLE GT_ITAB
WHERE KKBER = P_KKBER
AND KUNNR IN S_KUNNR.
IF GT_ITAB[] IS NOT INITIAL.
SELECT * FROM KNA1 INTO TABLE LT_KNA1
FOR ALL ENTRIES IN GT_ITAB
WHERE KUNNR = GT_ITAB-KUNNR.
SELECT * FROM S066 INTO TABLE LT_S066
FOR ALL ENTRIES IN GT_ITAB
WHERE KKBER = P_KKBER
AND KNKLI = GT_ITAB-KNKLI.
SELECT * FROM S067 INTO TABLE LT_S067
FOR ALL ENTRIES IN GT_ITAB
WHERE KKBER = P_KKBER
AND KNKLI = GT_ITAB-KNKLI.
SELECT * FROM T001 INTO TABLE LT_T001
WHERE KKBER = P_KKBER.
IF LT_T001[] IS NOT INITIAL.
SELECT * FROM ZFT_HKH INTO TABLE LT_ZFT_HKH
FOR ALL ENTRIES IN GT_ITAB
WHERE KUNNR = GT_ITAB-KUNNR
AND LOEDK = ''
AND ZKSTO = ''
AND ZFBSK = 'B'.
ENDIF.
ENDIF.
LOOP AT GT_ITAB ASSIGNING <ITAB>.
READ TABLE LT_KNA1 WITH KEY KUNNR = <ITAB>-KUNNR.
IF SY-SUBRC = 0.
<ITAB>-NAME1 = LT_KNA1-NAME1.
ENDIF.
LOOP AT LT_S066 WHERE KNKLI = <ITAB>-KNKLI.
ADD LT_S066-OEIKW TO <ITAB>-OEIKW.
ENDLOOP.
LOOP AT LT_S067 WHERE KNKLI = <ITAB>-KNKLI.
ADD LT_S067-OLIKW TO <ITAB>-OLIKW.
ADD LT_S067-OFAKW TO <ITAB>-OFAKW.
ENDLOOP.
LOOP AT LT_T001 WHERE KKBER = P_KKBER.
LOOP AT LT_ZFT_HKH WHERE BUKRS = LT_T001-BUKRS
AND KUNNR = <ITAB>-KUNNR.
ADD LT_ZFT_HKH-HKBTR TO <ITAB>-HKBTR.
ENDLOOP.
ENDLOOP.
<ITAB>-KYED = <ITAB>-KLIMK + <ITAB>-HKBTR - <ITAB>-OEIKW - <ITAB>-OLIKW - <ITAB>-OFAKW.
ENDLOOP.
ENDFORM. " GET_DATA
1 0
- 信贷余额表取数逻辑
- 信贷
- 信贷危机
- 信贷紧缩
- 信贷证明
- Oracle EBS 科目余额表取数SQL
- 情感余额 金钱余额
- 交通银行信贷管理信息系统案例
- 交通银行信贷管理信息系统案例
- 信贷紧缩 credit squeeze
- 信贷危机趣解
- 央行确认信贷放松
- 公司信贷(一)
- 信贷(Credit)
- 公司信贷基础知识介绍
- 和信贷,超收益
- SAP信贷出口
- 修改信贷接口
- 操作系统常见面试题总结
- 字符串模式匹配
- 双网卡同时上内外网方法
- Java并发编程:Thread类的使用
- mvc 模型验证问题总结
- 信贷余额表取数逻辑
- linux 常用命令汇总
- 小工具 - 批量删除Maven下载失败的文件夹
- 寻找jar包的好方法
- [android] “坐标”相关的一些故事
- 第三天(条件选择结构)
- 使用HttpClient发送Post Http请求
- IOS控件学习之UI ScrollView(6)
- sakai用的maven2 settings.xml