要求BusinessPartners的清单,包括CashDiscounts

2020-08-18 09:18发布

点击此处---> 群内免费提供SAP练习系统(在群公告中)加入QQ群:457200227(SAP S4 HANA技术交流) 群内免费提供SAP练习系统(在群公告中)你好 我希望收到所有Busin...

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

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


你好

我希望收到所有BusinessPartners的列表,其中包括CashDiscount行的所有行。

我只能获取BusinessPartner/PaymentTermsTypes/CashDiscounts

现在,我想获得CashDiscounts/DiscountLines,因为我不需要为NumOfDays减少折扣

示例:
NumOfDays = 10,折扣= 3
NumOfDays = 20,折扣= 1,5

我现在需要第一行,因为10小于20

我现在已经知道如何进行管理。

请按F1

关于Carsten

我的实际测试:
HTTPS://192.168.6.10:50000/b1s/v2/$crossjoin(BusinessPartners,PaymentTermsTypes,CashDiscounts)?$ expand = BusinessPartners($ select = CardCode,CardName,CardType,Address,ZipCode,City,Country,EmailAddress,IBAN,FederalTaxID,EmailAddress,Website,Notes,ValidFrom,ValidTo,UpdateDate,CreateDate),PaymentTermsTypes($ select = GroupNumber,PaymentTermsGroupName,NumberOfAdditionalDays,DiscountCode) ($ select = Code,CashDiscounts/DiscountLines/Discount)&$ filter = BusinessPartners/PayTermsGrpCode eq PaymentTermsTypes/GroupNumber和PaymentTermsTypes/DiscountCode eq CashDiscounts/Code

1条回答
黑丝骑士
2020-08-18 09:20

你好,

前进一步:
$ crossjoin(BusinessPartners,PaymentTermsTypes,CashDiscounts,CashDiscounts/DiscountLines)?$ expand = BusinessPartners($ select = CardCode,CardName,CardType,Address,ZipCode,City,Country,EmailAddress,IBAN, FederalTaxID,EmailAddress,网站,注释,ValidFrom,ValidTo,UpdateDate,CreateDate),PaymentTermsTypes($ select = GroupNumber,PaymentTermsGroupName,NumberOfAdditionalDays,DiscountCode),CashDiscounts($ select = Code),CashDiscounts/DiscountLines($ select = NumDay) &$ filter = BusinessPartners/PayTermsGrpCode eq PaymentTermsTypes/GroupNumber和PaymentTermsTypes/DiscountCode eq CashDiscounts/Code&$ orderby = UpdateDate desc

但是现在,我只获得了CashDiscount合作伙伴。 我喜欢得到所有。

一周热门 更多>