存储过程在运行时在GroupBy和语法中出现一些问题 [英] stored procedure while Running Occur some problem in GroupBy and syntax

问题描述

我的要求是
所有列均来自IV00104
1.物料主表kititem101
2.项目KIT表组件det104
3.物料销售交易表的表头是ItemSalesHeader200
4.物料销售交易表行物料明细表为ItemSalesdet300

基于以下物品的套件物品X
套件A的组件
套件B的组件
套件C的组件

1.使用公共字段SOPNUMBE和联接表ItemSalesHeader200和ItemSalesdet300
2.检查售出的物品是否为KIT物品
3.链接表kititem101以检查项目类型是否为KIT项目SO ITEMTYPE = 3
4.如果项目是KIT项目，则该套件项目的组成部分在IV00104中进行检查
5.将IV00101链接到kititem104
6.套件详细信息以及组件成本
7.在SOP30300中，如果该项目作为KIT项目出售，那么在此表中，它不显示KIT的组成部分，因为我们执行了任务2、3、4、5和6
8.如果要获得组件销售价格或套件组件利润的逻辑下面的KIT项，我们想带数据.



某些机构可以帮助我吗?

Hi,

my requirements are
All column from IV00104
1. Item Master table kititem101
2. Item KIT table componentdet104
3. Items sales transactions table header is ItemSalesHeader200
4. Items sales transactions table line item details table is ItemSalesdet300

Kit Item X based on following items
Component of Kit Item A
Component of Kit Item B
Component of Kit Item C

1. With common field SOPNUMBE and join table ItemSalesHeader200 AND ItemSalesdet300
2. Check whether sold item is KIT item
3. Link table kititem101 to check item type is KIT item SO ITEMTYPE = 3
4. If item is KIT item what are the component of this kit item check in IV00104
5. Link IV00101 TO kititem104
6. Kit details with component cost
7. In SOP30300 if item sold as KIT item then in this table its doesn’t display the what are the component of KIT there for we made task 2, 3, 4,5, and 6
8. Here we want to bring data if there is KIT items below logic we execute to get sale price of component or margin of kit component items.



Can some body help me

推荐答案

我们希望您花一些时间来解决您面临的问题，然后再花一些时间来提出问题.

这是询问者的期望:
1. 先尝试您要做什么！
2.制定看起来像问题/无法解决的问题.

试试看，告诉他们是否遇到问题.
成员将很乐意为您提供帮助.

We expect you to put some time in trying the issue that you are facing and then some time in formulating the question while posting here.

Here is what is expected by enquirers:
1. TRY first what you want to do!
2. Formulate what was done by you that looks like an issue/not working.

Try them and tell if you face issues.
Members will be more than happy to help like this.

这篇关于存储过程在运行时在GroupBy和语法中出现一些问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！