导出客户客户代码名称销售机构分销渠道部门销售组织销售组创建日期创建人业务员代码业务员名称

最新推荐文章于 2022-10-31 10:18:45 发布

gavin_gxh

最新推荐文章于 2022-10-31 10:18:45 发布

阅读量210

点赞数

分类专栏： BASIS SD ABAP 文章标签：其他经验分享

gavin-gxh

本文链接：https://blog.csdn.net/xiaofei2008gxh/article/details/126409113

版权

ABAP 同时被 3 个专栏收录

223 篇文章 17 订阅

订阅专栏

BASIS

101 篇文章 9 订阅

订阅专栏

48 篇文章 3 订阅

订阅专栏

SELECT knvv.kunnr,kna1.name1,knvv.VKORG ,knvv.VTWEG ,knvv.SPART ,knvv.VKBUR,tvkbt.BEZEI  ,knvv.KDGRP,tvgrt.BEZEI  ,knvv.BZIRK ,t171t.BZTXT , knvv.KONDA,t188t.VTEXT 
,knvv.ERDAT,knvv.ERNAM  ,knvp.PERNR ,pa0001.ENAME 
FROM sapsr3.knvv
JOIN kna1 ON kna1.kunnr = knvv.kunnr AND knvv.MANDT  = kna1.MANDT 
LEFT JOIN T171T ON  T171T.BZIRK  = knvv.BZIRK  AND t171t.SPRAS  = '1' AND T171T.MANDT  = knvv.MANDT 
LEFT JOIN TVKBT ON  TVKBT.SPRAS  = '1' AND TVKBT.VKBUR  = knvv.VKBUR  AND TVKBT.MANDT  = knvv.MANDT 
LEFT JOIN t188t ON  t188t.SPRAS  = '1' AND t188t.KONDA  = knvv.KONDA  AND t188t.MANDT  = knvv.MANDT 
LEFT JOIN TVGRT ON TVGRT.VKGRP  = knvv.VKGRP  AND TVGRT.SPRAS  = '1' AND tvgrt.MANDT = knvv.MANDT 
LEFT JOIN knvp ON knvp.KUNNR  = knvv.KUNNR  AND knvp.VKORG  = knvv.VKORG  AND knvp.VTWEG  = knvv.VTWEG  AND knvp.MANDT  = knvv.MANDT  AND knvp.PARVW  = 'ZE'
LEFT JOIN pa0001 ON pa0001.pernr = knvp.pernr AND pa0001.MANDT  = knvp.MANDT