Automate

I need to extract data that lists all invoices created against one sales order.  The results in FBL5N are exactly what I need but since it's in a structure, not a table I have not been able to find a way to download the results.

Does anyone have any ideas that don't involve joins at the line item level; i.e. I know I can get to the data via VBFA or VBAK-VBRP-VBRK and/or through joins to deliveries, but I don't want the line level detail as then document numbers can be listed more than once and I don't know of an automated way to dedupe them in a script.

Any assistance or suggestions would be greatly appreciated.

Rita

------------------------------
Rita Schoeppe | SAP Business Process Analyst
Haworth, Inc. | 6163401988
------------------------------

Hi Rita
Please check out the BSID table.  It will contain the open invoices for a customer.
The other option is the use the tables you called out, and then use a pivot table to roll up the numbers.
Best Regards,
Sigrid

------------------------------
Sigrid Kok
PSE | Winshuttle NA
------------------------------

Original Message:
Sent: 11-12-2021 19:58
From: Rita Schoeppe
Subject: Invoices Associated to Sales Orders

I need to extract data that lists all invoices created against one sales order.  The results in FBL5N are exactly what I need but since it's in a structure, not a table I have not been able to find a way to download the results.

Does anyone have any ideas that don't involve joins at the line item level; i.e. I know I can get to the data via VBFA or VBAK-VBRP-VBRK and/or through joins to deliveries, but I don't want the line level detail as then document numbers can be listed more than once and I don't know of an automated way to dedupe them in a script.

Any assistance or suggestions would be greatly appreciated.

Rita

------------------------------
Rita Schoeppe | SAP Business Process Analyst
Haworth, Inc. | 6163401988
------------------------------

Hello Sigrid,

Sorry for the late reply!  Thank you so much.  The BSID table is just what I need!

Rgds,
Rita

------------------------------
Rita Schoeppe | SAP Business Process Analyst
Haworth, Inc. | 6163401988
------------------------------

Original Message:
Sent: 11-16-2021 10:07
From: Sigrid Kok
Subject: Invoices Associated to Sales Orders

Hi Rita
Please check out the BSID table.  It will contain the open invoices for a customer.
The other option is the use the tables you called out, and then use a pivot table to roll up the numbers.
Best Regards,
Sigrid

------------------------------
Sigrid Kok
PSE | Winshuttle NA

Original Message:
Sent: 11-12-2021 19:58
From: Rita Schoeppe
Subject: Invoices Associated to Sales Orders

I need to extract data that lists all invoices created against one sales order.  The results in FBL5N are exactly what I need but since it's in a structure, not a table I have not been able to find a way to download the results.

Does anyone have any ideas that don't involve joins at the line item level; i.e. I know I can get to the data via VBFA or VBAK-VBRP-VBRK and/or through joins to deliveries, but I don't want the line level detail as then document numbers can be listed more than once and I don't know of an automated way to dedupe them in a script.

Any assistance or suggestions would be greatly appreciated.

Rita

------------------------------
Rita Schoeppe | SAP Business Process Analyst
Haworth, Inc. | 6163401988
------------------------------

That's great, Rita!  Thanks for letting us know.

Best Regards,
Sigrid

------------------------------
Sigrid Kok
PSE | Winshuttle NA
------------------------------

Original Message:
Sent: 11-23-2021 21:45
From: Rita Schoeppe
Subject: Invoices Associated to Sales Orders

Hello Sigrid,

Sorry for the late reply!  Thank you so much.  The BSID table is just what I need!

Rgds,
Rita

------------------------------
Rita Schoeppe | SAP Business Process Analyst
Haworth, Inc. | 6163401988

Original Message:
Sent: 11-16-2021 10:07
From: Sigrid Kok
Subject: Invoices Associated to Sales Orders

Hi Rita
Please check out the BSID table.  It will contain the open invoices for a customer.
The other option is the use the tables you called out, and then use a pivot table to roll up the numbers.
Best Regards,
Sigrid

------------------------------
Sigrid Kok
PSE | Winshuttle NA

Original Message:
Sent: 11-12-2021 19:58
From: Rita Schoeppe
Subject: Invoices Associated to Sales Orders

I need to extract data that lists all invoices created against one sales order.  The results in FBL5N are exactly what I need but since it's in a structure, not a table I have not been able to find a way to download the results.

Does anyone have any ideas that don't involve joins at the line item level; i.e. I know I can get to the data via VBFA or VBAK-VBRP-VBRK and/or through joins to deliveries, but I don't want the line level detail as then document numbers can be listed more than once and I don't know of an automated way to dedupe them in a script.

Any assistance or suggestions would be greatly appreciated.

Rita

------------------------------
Rita Schoeppe | SAP Business Process Analyst
Haworth, Inc. | 6163401988
------------------------------