Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Removing filter from PVO - FscmTopModelAM.FinArTopPublicModelAM.SalesInvoiceCustomerTrxLinesPVO

in Supply Chain Orchestration

I have enabled Supply Chain and Order Management in OBIA. As part of this setup, I need to retrieve all invoices. However, I noticed that the W_SALES_INVOICE_LINE_F table is not capturing all invoices.

Upon investigation, I identified a filter condition in the logic that's restricting invoices with a non-DOO interface_line_context from being included in the W_SALES_INVOICE_LINE_F table. The current filter condition is:
(transactionline.interface_line_context = 'DOO')OR(transactionlinelink.interface_line_context = 'DOO')

This filter excludes invoices where interface_line_context has values other than 'DOO'. Below are the other possible interface_line_context values that are being excluded:

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!