topic Data Mapping problem with Customer Open Item in Application Development and Automation Discussions

Data Mapping problem with Customer Open Item

Former Member — Thu, 02 Apr 2009 05:05:39 GMT

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

Re: Data Mapping problem with Customer Open Item

Former Member — Thu, 02 Apr 2009 07:54:39 GMT

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

Re: Data Mapping problem with Customer Open Item

Former Member — Fri, 10 Apr 2009 07:31:20 GMT


> 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.

Re: Data Mapping problem with Customer Open Item

Former Member — Fri, 10 Apr 2009 07:37:37 GMT

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

Re: Data Mapping problem with Customer Open Item

Former Member — Fri, 10 Apr 2009 07:48:01 GMT


> 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.

Re: Data Mapping problem with Customer Open Item

Former Member — Fri, 10 Apr 2009 08:02:11 GMT

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

Re: Data Mapping problem with Customer Open Item

Former Member — Fri, 10 Apr 2009 08:11:43 GMT


> 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

Re: Data Mapping problem with Customer Open Item

Former Member — Fri, 10 Apr 2009 08:49:50 GMT

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

Re: Data Mapping problem with Customer Open Item

Former Member — Fri, 10 Apr 2009 09:07:19 GMT

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.

Re: Data Mapping problem with Customer Open Item

Former Member — Fri, 10 Apr 2009 09:24:23 GMT

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

Re: Data Mapping problem with Customer Open Item

Former Member — Mon, 20 Apr 2009 11:43:19 GMT

Closing the thread.

Re: Data Mapping problem with Customer Open Item

Former Member — Mon, 20 Apr 2009 11:44:39 GMT

Thanks Max