如何在应付帐款发票中链接OPCH,OJDT和JDT1

2020-09-01 08:13发布

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

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


我想为应付发票创建一个新的模板,该模板可以在文档中显示日记帐分录详细信息。 但是,当我建立OPCH,OJDT和JDT1的链接时,将显示AP发票的重复行,并且journa输入字段为空白。 下面是查询:

选择" OPCH"。" DocNum"," OPCH"。" CardCode"," OPCH"。" LicTradNum"," OPCH"。" U_BP_Name"," OPCH"。" TaxDate"," OPCH"。" DocDueDate "," OPCH"。" DocCur"," OPCH"。" NumAtCard"," OPCH"。"地址"," NNM1"。" BeginStr"," OCRD"。"电话1"," OCTG"。" PymntGroup", " PCH1"。" TreeType"," PCH1"。" ItemCode"," PCH1"。"说明"," PCH1"。"数量"," PCH1"。"价格"," PCH1"。" VatPrcnt"," PCH1 "。" GTotal"," PCH1"。" GTotalFC"," OPCH"。"注释"," JDT1"。"短名称" FROM(((((((((" SAP_FANS_Production"。" dbo"。" OPCH"" OPCH"左 外部联接" SAP_FANS_Production"。" dbo"。" NNM1"" NNM1"在" OPCH"上。"系列" =" NNM1"。"系列")左外部联接" SAP_FANS_Production"。" dbo"。" OCRD"" OCRD" ON" OPCH"。" CardCode" =" OCRD"。" CardCode")左外联接" SAP_FANS_Production"。" dbo"。" OCTG"" OCTG" ON" OPCH"。" GroupNum" =" OCTG"。" GroupNum" )内部联接" SAP_FANS_Production"。" dbo"。" PCH1"" PCH1"在" OPCH"上。" DocEntry" =" PCH1"。" DocEntry")内部联接" SAP_FANS_Production"。" dbo"。" OJDT"" OJDT" ON" OPCH"。" TransId" =" OJDT"。" TransId")左外联接" SAP_FANS_Product ion"。" dbo"。" JDT1"" JDT1" ON(((((" OJDT"。" TransId" =" JDT1"。" TransId")AND(" OJDT"。" DueDate" =" JDT1"。" DueDate ""))AND(" OJDT"。" TransType" =" JDT1"。" TransType"))AND(" OJDT"。" CreatedBy" =" JDT1"。" CreatedBy"))AND(" OJDT"。" RefDate" =" JDT1"。" RefDate")在" OPCH"。" DocNum" = 1910000054 ORDER BY" OPCH"。" DocNum"

1.jpg (72.0 kB)

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

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


我想为应付发票创建一个新的模板,该模板可以在文档中显示日记帐分录详细信息。 但是,当我建立OPCH,OJDT和JDT1的链接时,将显示AP发票的重复行,并且journa输入字段为空白。 下面是查询:

选择" OPCH"。" DocNum"," OPCH"。" CardCode"," OPCH"。" LicTradNum"," OPCH"。" U_BP_Name"," OPCH"。" TaxDate"," OPCH"。" DocDueDate "," OPCH"。" DocCur"," OPCH"。" NumAtCard"," OPCH"。"地址"," NNM1"。" BeginStr"," OCRD"。"电话1"," OCTG"。" PymntGroup", " PCH1"。" TreeType"," PCH1"。" ItemCode"," PCH1"。"说明"," PCH1"。"数量"," PCH1"。"价格"," PCH1"。" VatPrcnt"," PCH1 "。" GTotal"," PCH1"。" GTotalFC"," OPCH"。"注释"," JDT1"。"短名称" FROM(((((((((" SAP_FANS_Production"。" dbo"。" OPCH"" OPCH"左 外部联接" SAP_FANS_Production"。" dbo"。" NNM1"" NNM1"在" OPCH"上。"系列" =" NNM1"。"系列")左外部联接" SAP_FANS_Production"。" dbo"。" OCRD"" OCRD" ON" OPCH"。" CardCode" =" OCRD"。" CardCode")左外联接" SAP_FANS_Production"。" dbo"。" OCTG"" OCTG" ON" OPCH"。" GroupNum" =" OCTG"。" GroupNum" )内部联接" SAP_FANS_Production"。" dbo"。" PCH1"" PCH1"在" OPCH"上。" DocEntry" =" PCH1"。" DocEntry")内部联接" SAP_FANS_Production"。" dbo"。" OJDT"" OJDT" ON" OPCH"。" TransId" =" OJDT"。" TransId")左外联接" SAP_FANS_Product ion"。" dbo"。" JDT1"" JDT1" ON(((((" OJDT"。" TransId" =" JDT1"。" TransId")AND(" OJDT"。" DueDate" =" JDT1"。" DueDate ""))AND(" OJDT"。" TransType" =" JDT1"。" TransType"))AND(" OJDT"。" CreatedBy" =" JDT1"。" CreatedBy"))AND(" OJDT"。" RefDate" =" JDT1"。" RefDate")在" OPCH"。" DocNum" = 1910000054 ORDER BY" OPCH"。" DocNum"

1.jpg (72.0 kB)
付费偷看设置
发送
2条回答
浮生未央
1楼-- · 2020-09-01 08:35

你好,

如果我的记忆正确,则可以使用OJDT的TransType和BaseRef链接到子报表中。

谢谢。

d56caomao
2楼-- · 2020-09-01 08:37

嗨,谢谢。 我添加了子报表,并使用TransId进行链接,它可以正常工作。

一周热门 更多>