topic FORMAT ERROR in Application Development and Automation Discussions

FORMAT ERROR

durgaprasad_sharma2 — Sun, 06 Nov 2016 19:47:15 GMT

Hello Friends,

I have created a BDC salary upload for jv transactions. but when i pass data from excel to tcode fb50 company code is assigned but i am getting error in date format and amount in document currency that is waers is left with and error like "FORMATTING ERROR and AMOUNT IN DOCUMENT CURRENCY LEFT BLANK " please help me to resolve this issue i m stuck in this from 2 days ....

Please do the needfull...

Re: FORMAT ERROR

RaymondGiuseppi — Mon, 07 Nov 2016 07:05:31 GMT

You must input amount fields with the same format that the user passed in BDC_OPEN_GROUP.Same rule to apply for date format and any field. Try to execute the BDC (SM35) in foreground or display error mode and correct your mapping of data field by field.

Regards,
Raymond

Re: FORMAT ERROR

Sandra_Rossi — Mon, 07 Nov 2016 09:53:18 GMT

Additional info: if the OP is really talking about a batch input session (SM35), it may be recorded with a fixed date/number formats, so that any user can run the session, whatever its date/number formats are. For more information, see SAP note 634956 (Batch input: Starting sessions indep.)|https://service.sap.com/sap/support/notes/634956

Re: FORMAT ERROR

renato_parise — Mon, 07 Nov 2016 11:45:35 GMT

HI,

Sometimes we need a auxiliar to write the data.

Like: WRITE sy-datum TO v_datum(type char10) DDMMYYYY

WRITE currency TO v_curr(type char20) CURRENCY cur.

Renato Parise

Re: FORMAT ERROR

durgaprasad_sharma2 — Mon, 07 Nov 2016 12:04:50 GMT

thank you sir for your precious answers but my problem is solved by just adding wrbtr field to character format

Re: FORMAT ERROR

RaymondGiuseppi — Mon, 07 Nov 2016 12:15:58 GMT

In a BDC you always pass external format, so always a character field.

Re: FORMAT ERROR

durgaprasad_sharma2 — Mon, 07 Nov 2016 12:26:57 GMT

thank you sir looking forward to get some more knowledge by you in future.. 🙂