查询OCRD和OCQG

2020-09-23 23:36发布

点击此处---> 群内免费提供SAP练习系统(在群公告中)加入QQ群:457200227(SAP S4 HANA技术交流) 群内免费提供SAP练习系统(在群公告中) Buenas tardesco...

         点击此处--->   EasySAP.com群内免费提供SAP练习系统(在群公告中)

加入QQ群:457200227(SAP S4 HANA技术交流) 群内免费提供SAP练习系统(在群公告中)


Buenas tardescompañeros,necesito hacer la union de estas 2表格OCRD和OCQG

OCRD datos maestros socios negocio

OCQG negocio社团

Para ver el CardCode,CardName(OCRD),GroupName(OCQG)

E intentado varias cosas pero no le doy con el chiste,espero me puedan ayudar muchas gracias。

3条回答
clasier
2020-09-23 23:47 .采纳回答

OCRD与OCQG的合规性最终定案,由OCQ与OCQG共同完成,由AlQuénéde la de la de la de la de la de la de la de la de la de la de la de lacéode la de la de la de la de la de la de la de la de lacéo 礼炮。

 SELECT DISTINCT T0。" CardCode",T0。" CardName",T1。" GroupName"
 从OCRD T0左加入OCQG T1到
 (在T0时为例。" QryGroup1" ='Y'THEN 1在(T0。" QryGroup2" ='Y'时)THEN 2
 当(T0。" QryGroup3" ='Y')则3
 当(T0。" QryGroup5" ='Y')则5
 当(T0。" QryGroup7" ='Y')则7
 当(T0。" QryGroup9" ='Y')则9当(T0。" QryGroup10" ='Y')则10
 当(T0。" QryGroup11" ='Y')则11
 当(T0。" QryGroup13" ='Y')则13
 当(T0。" QryGroup15" ='Y')则15
 当(T0。" QryGroup17" ='Y')则17当(T0。" QryGroup18" ='Y')则18
 当(T0。" QryGroup19" ='Y')则19当(T0。" QryGroup20" ='Y')则20
 当(T0。" QryGroup21" ='Y')则21
 当(T0。" QryGroup23" ='Y')则23当(T0。" QryGroup24" ='Y')则24
 当(T0。" QryGroup25" ='Y')则25
 当(T0。" QryGroup27" ='Y')则27
 当(T0。" QryGroup29" ='Y')则29当(T0。" QryGroup30" ='Y')则30
 当(T0。" QryGroup31" ='Y')则31
 当(T0。" QryGroup33" ='Y')然后33
 当(T0。" QryGroup35" ='Y')则35
 当(T0。" QryGroup37" ='Y')则37
 当(T0。" QryGroup39" ='Y')则39当(T0。" QryGroup40" ='Y')则40
 当(T0。" QryGroup41" ='Y')则41
 当(T0。" QryGroup43" ='Y')则43
 当(T0。" QryGroup45" ='Y')则45
 当(T0。" QryGroup47" ='Y')则47当(T0。" QryGroup48" ='Y')则48
 当(T0。" QryGroup49" ='Y')则49当(T0。" QryGroup50" ='Y')则50
 当(T0。" QryGroup51" ='Y')则51当(T0。" QryGroup52" ='Y')则52
 当(T0。" QryGroup53" ='Y')则53当(T0。" QryGroup54" ='Y')则54
 当(T0。" QryGroup55" ='Y')则55
 当(T0。" QryGroup57" ='Y')则57
 当(T0。" QryGroup59" ='Y')则59当(T0。" QryGroup60" ='Y')则60
 当(T0。" QryGroup61" ='Y')则61
 当(T0。" QryGroup63" ='Y')则63
 END)= T1。" GroupCode"

 在T0。" QryGroup1" ='Y'或" QryGroup2" ='Y'或" QryGroup3" ='Y'或" QryGroup4" ='Y'
 或" QryGroup5" ='Y'或" QryGroup6" ='Y'或" QryGroup7" ='Y'或" QryGroup8" ='Y'
 或" QryGroup9" ='Y'或" QryGroup10" ='Y'或" QryGroup11" ='Y'或" QryGroup12" ='Y'
 或" QryGroup13" ='Y'或" QryGroup14" ='Y'或" QryGroup15" ='Y'或" QryGroup16" ='Y'
 或" QryGroup17" ='Y'或" QryGroup18" ='Y'或" QryGroup19" ='Y'或" QryGroup20" ='Y'
 或" QryGroup21" ='Y'或" QryGroup22" ='Y'或" QryGroup23" ='Y'或" QryGroup24" ='Y'
 或" QryGroup25" ='Y'或" QryGroup26" ='Y'或" QryGroup27" ='Y'或" QryGroup28" ='Y'
 或" QryGroup29" ='Y'或" QryGroup30" ='Y'或" QryGroup31" ='Y'或" QryGroup32" ='Y'
 或" QryGroup33" ='Y'或" QryGroup34" ='Y'或" QryGroup35" ='Y'或" QryGroup36" ='Y'
 或" QryGroup37" ='Y'或" QryGroup38" ='Y'或" QryGroup39" ='Y'或" QryGroup40" ='Y'
 或" QryGroup41" ='Y'或" QryGroup42" ='Y'或" QryGroup43" ='Y'或" QryGroup44" ='Y'
 或" QryGroup45" ='Y'或" QryGroup46" ='Y'或" QryGroup47" ='Y'或" QryGroup48" ='Y'
 或" QryGroup49" ='Y'或" QryGroup50" ='Y'或" QryGroup51" ='Y'或" QryGroup52" ='Y'
 或" QryGroup53" ='Y'或" QryGroup54" ='Y'或" QryGroup55" ='Y'或" QryGroup56" ='Y'
 或" QryGroup57" ='Y'或" QryGroup58" ='Y'或" QryGroup59" ='Y'或" QryGroup60" ='Y'
 或" QryGroup61" ='Y'或" QryGroup62" ='Y'或" QryGroup63" ='Y'或" QryGroup64" ='Y'
 
 订单由T1。" GroupName" ASC,T0。" CardCode" ASC 

一周热门 更多>