Customer Line Item Split in Accounting Doc based on Material Group

[Former Member]

Hi Gurus

Need some urgent help.

When we are posting the accounting Document for a Billing with Materials belonging to Bundle SKU (of Different Material Groups), the Customer line item in the Accounting Document is getting split based on the Material group in the Entry View itself.

Is there some standard configuration which causes the Customer Line Item in the Accounting Document to get split based on the Material Groups in the Sales Order?

Please help

Thanks in Advance

Ambarish

[Former Member · Accepted solution]

Thanks Michael for your reply.

I found the root cause and it was actually due to Withholding Tax Calculation, which basically divided the customer items based on the External Material type and its corresponding Withholding Tax applicability.

Thanks Again.

[michael_kozlowski]

Please check Business Account Area Assignment

IMG ->Sales & Distribution->Basic Functions->Account Assignment/Costing->Business Area Account Assignment

Also check in accounting document if business area is populated in lines.

[Former Member]

Hi Michael

The issue is not with the Business Area assignment. Also the business area is getting populated in the line items.

The problem is that there are two different set of Bundle SKU Materials belonging to two different Material Groups in a single Sales Order and corresponding single Billing.

The problem is that while creating the Accounting Document there are two Customer Line items getting generated for the two different group of Materials. Hence this is creating two customer line items for same customer code for the same accounting invoice reference.

Regards

Ambarish

[michael_kozlowski]

Are business areas different in customer accounting line items?

[Former Member]

Nope. All belong to the same business area.

[michael_kozlowski]

In OBCY for VBRK. What are the settings?

In table BSEG for customer lines is there any difference in fields except amounts?

Check also if any user exits have been activated see note 301077 http://service.sap.com/sap/support/notes/301077

[Former Member]

Hi Michael

1. In OBCY the setting is:

Table Name     Field Name

BSEG               PPRCT

Is there some way I can club the two customer items by adding some setting in the above OBCY? If so, what exactly?

2. In table BSEG for the customer lines only the following amount related fields values are different, rest are same (ofcourse other than line item no BUZEI):

Field Label	Field Name
Amt.in loc.cur.	DMBTR
Amount	WRBTR
General ledger amount	PSWBT
Withhold.tax base	QSSHB
Credit control amnt	KLIBT
LC3 amount	DMBE3

3. The following User Exits are active out of the list mentioned in the note

EXIT_SAPLV60B_004

EXIT_SAPLV60B_008

I debugged the Exit and the splitting of customer lines are getting determined in the internal table XACCIT before these exits are even called. Hence the splitting doesnt seem to be as a result of the exits.

Also, you can refer to this thread: https://scn.sap.com/thread/1709742

My requirement is exactly the opposite of the requirement stated here.

Thanks for your help.

Regards

Ambarish

[michael_kozlowski]

In OBCY try:

Table Name     Field Name

*                          *

please check out also note

http://service.sap.com/sap/support/notes/36353