SAP B1 AP invoice Contents Table query

[former_member820000]

Hi all

i'm using SAP B1

by the way i can extract All AP invoice now

but i don't know how to get information line item each Invoice

i need decription line by line. maybe whole contents line ltem

" not only 1 invoice. at least bunch of invoices" at once

do you guys know any Query code or how to do that?

[former_member820000]

Hi all

i'm using SAP B1

by the way i can extract All AP invoice now

but i don't know how to get information line item each Invoice

i need decription line by line. maybe whole contents line ltem

" not only 1 invoice. at least bunch of invoices" at once

do you guys know any Query code or how to do that?

[AlexGourdet]

Thank you for visiting SAP Community to get answers to your questions.

As you're looking to get most out of your community membership, please consider include a profile picture to increase user engagement & additional resources to your reference that can really benefit you:

• Profile https://developers.sap.com/tutorials/community-profile.html
• Tips for Questions: https://community.sap.com/resources/questions-and-answers
• Consider to take our Q&A tutorial at: https://developers.sap.com/tutorials/community-qa.html.

I hope you find this advice useful, and we're happy to have you as part of SAP Community!

All the best,

-Alex

[mgregur]

Hi,

all you need is to join OINV and INV1:

SELECT *
FROM OINV T0
INNER JOIN INV1 T1 ON T0."DocEntry" = T1."DocEntry"

BR,

Matija