Ship to party details are not populated in FBL5N report

[Former Member]

Hi All,

I executed the FBL5N report and found that, Ship-To party details are not getting populated in the report.

When checked the billing document->header partner i found ship to party details are not coming here from delivery document.

Both in Sales order header and delivery document level the ship to party is maintained.

What could be the reason? Is this issue has some thing to do with partner determination procedure for billing documents?

please suggest.

[ajitsingh6 · Accepted solution]

Hi Prince,

Rightly suggested by Jaydeep as per standard SAP the ship to party can not be in FBL5N. You need to take help of user exist.

Pls go through following link,

http://scn.sap.com/thread/100937

Regards,

Ajit K Singh

[Former Member]

Hi Prince,

According to standard SAP, you can not have ship to party at header level. Please find the link below which may be helpful to you.

http://scn.sap.com/thread/3170840

Regards,

Jaydeep

[former_member211635]

Hi Prince,

FBL5N is a view for FI Entries which comes from Sold to Party details, hence I don't think so that such details will be available

You can get the data from SD reports:-

1. Run VF05n --> download in excel

2. get the Customer Sold to Party and Ship to Party from SAP Table - KNVP and KNVV --> Download in excel

Do a vlookup

Alternatively you can also use query joiner (T.Code SQVI) or create a custom report to get the details from above fields as mentioned above

Thank You

Nishu    

[Former Member]

Hi Nishu,

In existing FBL5N report, i have the following fields. Only data which is not coming is Ship-to party.

Account

Inv. ref.

Assignment

DocumentNo

Typ

Pstng Date

Amt in loc.cur.

Reference

Ref.key 1

Dv

Ref. Key 1

Ref. Key 2

Reference Key 3

ShipP

Ship-To-Party Name

Division Description

Transaction Type Des

Salesman Name

1000005

9078476

681392465

9078476

ZT

15-09-13

(0.71)

3416

1.22E+08

10

14601

400012643

105710

Mars

Sales Return Invoice

AHMED

And i want the reason why this is not getting populated......

[former_member211635]

Hi Price,

It fetches data from FI Tables like BSID, BSAD and these tables does not have any field which captures ship to party

You can also add fields from other FI Tables like BSEG table, but unfortunately this field is not captured in bseg table also

You will have to use SD table to fetch the report or use Business Transaction Event (BTE) if you want to add any of the field

Thank You   

Nishu