Data Mapping problem with Customer Open Item

[Former Member]

Hi,

I am using the the Direct input method in LSMW for Posting the Open Customer documents. Following are the details:

Object : 0100

Method: 0000

Program name: RFBIBL00.

I have a problem, the client wants the VBELN(BSID table) also to be posted.I checked the BSID table and the target Structure BBSEG and found the field VBELN missing from the strcuture. I found the field VBEL2 in the structure. Can anybody suggest any field in BBSEG where I can map the VBELN from table BSID.

Regards,

Prashant.

Edited by: Prashant Kumar Upadhyay on Apr 2, 2009 7:06 AM

[Former Member]

try BBSEG-REBZG

BBSEG-RKE_KAUFN has also domain VBELN so please try this also

Edited by: Madan Gopal Sharma on Apr 2, 2009 9:56 AM

[Former Member]

>

> try BBSEG-REBZG
> 
> BBSEG-RKE_KAUFN has also domain VBELN so please try this also
> 
> Edited by: Madan Gopal Sharma on Apr 2, 2009 9:56 AM

I tried but it not working, can anybody suggest any other approach to migrate VBELN to BSID table.

Regards,

Prashant.

[Former Member]

Hi

BBSEG-RKE_KAUFN is a field for CO/COPA, the field BBSEG-VBELN is filled by SD transaction (like the billing) so it's not available for FI trx.

U should say to your client it's better not to fill that field and use another one, like the attribution (ZUONR)

Max

[Former Member]

>

> Hi
> 
> BBSEG-RKE_KAUFN is a field for CO/COPA, the field BBSEG-VBELN is filled by SD transaction (like the billing) so it's not available for FI trx.
> 
> U should say to your client it's better not to fill that field and use another one, like the attribution (ZUONR)
> 
> Max

Hi Max,

Thanks for the prompt reply, can you suggest from which SD transaction or field it is getting updated.

Regards,

Prashant.

[Former Member]

Hi

That field should be filled as soon as the bill is posted in FI so trx like VF01, VF02 and VF04.

The RV_ACCOUNTING_DOCUMENT_CREATE is fm creates the FI invoice from billing.

Max

[Former Member]

>

> Hi
> 
> That field should be filled as soon as the bill is posted in FI so trx like VF01, VF02 and VF04.
> 
> The RV_ACCOUNTING_DOCUMENT_CREATE is fm creates the FI invoice from billing.
> 
> Max

Hi Max,

I have just 1 question, If I upload (or Release) Billing Doc for accounting first and then later on Upload the Customer open itm data in BSID , will the VBELN field get updated in db table. Thanks in advance.

Regards,

Prashant

[Former Member]

Hi

I don't understand which is your target.

The first thing is why you need to post the open item again?

If you release the bill and the post the open item the result is to post the bill twice!

What do you need to do?

Max

[Former Member]

Hi Max,

I am working in a upgradation+ reimplemenatation project, I need to migrate data from ECC5 to ECC6, I have to upload all the Data related to Customer Open Item to BSID in ECC6 including the VBELN from old ECC5 system to ECC6. This is all it is, please let me know, if you need further clarification.

Regards,

Prashant.

[Former Member]

Hi

So u need to migrate all open item of customer from old system to new one, if it's so u need to speak to your FI consulting in order to decide where the bill number has to be placed in the document of the new system.

The VBELN can't be available in BI:

it usually uses the field like ZUONR, SGTXT, XREF1, XREF2 or XREF3 for migration: here u can store the old bill number.

If your client wants to fill VBELN u should try to create a FI substitution.

Max

[Former Member]

Closing the thread.

[Former Member]

Thanks Max