0

I need to find PO and SO using item code through Service Layer, but was not able to find a way to retrieve the items using a contain clause in child items. Any ideas on how to build this query?

Geovane
  • 31
  • 2

1 Answers1

0

for sales order you should create view and expose service layer, and get view sl with parameter

1- create view create view ORDERLINEB1SLQuery as select ord.*, r1.ItemCode from ORDR ord inner join RDR1 r1 on r1.DocEntry=ord.DocEntry

2- expose this view in service layer https://....:50000/b1s/v1/SQLViews('ORDERLINEB1SLQuery')/Expose

3- run view with ItemCode parameter https://....:50000/b1s/v1/view.svc/ORDERLINEB1SLQuery?$filter=ItemCode eq 'A00006'

Özer Aydın
  • 11
  • 1