Using BAPI_ACC_DOCUMENT_POST to post in FB70

[Jay_Kamdar]

Hello Experts,

I am doing this for the first time so i need ur help,

I have a requirement regarding transaction FB70 as follows :

1. user will upload an excel sheet containing the below fields  : (for example)

Customer

Document Date

Reference

Amount

currency

Text

G/L Account

Internal Order

Assignment

HeaderText

Ref.key 1

Ref.key 2

Ref.key 3

100021

28.04.2013

Jay

50

INR

a

7000400

R1000003

1

z

as

qw

rt

SAP fieldnames:

accnt TYPE invfo-accnt, "Customer
   bldat TYPE invfo-bldat,"Invoice Date
   xblnr TYPE invfo-xblnr,"Reference
   wrbtr TYPE invfo-wrbtr,"Amount
   waers TYPE invfo-waers,"Currency
*  mwskz TYPE invfo-mwskz,"Tax Code
   sgtxt TYPE invfo-sgtxt, "Text
  hkont type acgl_item-hkont,"G/L account
  aufnr type acgl_item-aufnr,"Order
   zuonr TYPE invfo-zuonr,"Assignment
   bktxt TYPE invfo-bktxt,"Header Text
   xref1 TYPE invfo-xref1,"Reference Key 1
   xref2 TYPE invfo-xref2,"Reference Key 2
   xref3 TYPE invfo-xref3,"Reference Key 3

I have to POST this data into transaction FB70.

I have completed the conversion part of converting the excel file into SAP format and stored it in Internal Table - it_data.

How to use BAPI_ACC_DOCUMENT_POST using the above information ?

How am i supposed to find that which field in the above field-list belongs to which table in the Tables list of the BAPI ????

What should i export to the import field DOCUMENTHEADER in the BAPI considering the above explanation?

Will the export fields of the BAPI be required?

[Former Member]

Hi,

You can use where used list to find program where the BAPI is used .Please find some links

with helpful content.

http://www.saptechnical.com/Tutorials/BAPI/FI/Index.htm

https://scn.sap.com/thread/228177

[RaymondGiuseppi]

How to use BAPI_ACC_DOCUMENT_POST using the above information ?

Reading the BAPI documentation, searching for sample at scn

How am i supposed to find that which field in the above field-list belongs to which table in the Tables list of the BAPI ????

Using data elements, reading parameter documentation

What should i export to the import field DOCUMENTHEADER in the BAPI considering the above explanation?

Reading the documentation of the parameter

Will the export fields of the BAPI be required?

Reading the documentation of the parameters

Also perform some where-used to find SAP sample like ACC_BAPI_SXDA_DOCUMENT_POST or

ACC_BAPI_TEST_DOCUMENT.

In OSS you could find Note 306504 - Collective note: BAPIs for the AC interface  and Note 626235 - Tax postings with accounting BAPIs.

Regards,

Raymond