Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

Off-setting Account number in Purchasing doc

Former Member

‎2006 Nov 04 4:45 PM

0 Likes
514

Hello friends

I have to make a report in which FI Documents related to GR/IR are showns the user wants that the off-setting account number of each respective line item is also reflected. Please let me now the link of tables if any one has made some report of this kind.

Thanks in advance

Hello friends

I have to make a report in which FI Documents related to GR/IR are showns the user wants that the off-setting account number of each respective line item is also reflected. Please let me now the link of tables if any one has made some report of this kind.

Thanks in advance

Reply
3 REPLIES 3
Read only

Former Member

‎2006 Nov 06 5:07 AM

0 Likes
466

Hi Bhavana ,

make use of this FM AC_DOCUMENT_RECORD /FI_DOCUMENT_RECORD these will give Accouting document number of that IR.

sample code :
CALL FUNCTION 'FI_DOCUMENT_READ'
  EXPORTING
    i_awtyp   = 'RMRP'
    i_awref   = mm_belnr---->IR
    i_aworg   = mm_gjahr---->year
  TABLES
    t_bseg    = it_bseg
    t_bkpf    = it_bkpf
  EXCEPTIONS
    not_found = 2

for ac_docu_read

I_AWTYP                         RMRP                                                                    
I_AWREF                         5105642563                                                              
I_AWORG                         2006                                                                    
I_AWSYS                                                                                
I_AWTYP_INCL                                                                                
I_AWTYP_EXCL                                                                                
I_BUKRS                         PIH                                                                     
I_VALUTYP                       0                                                                       
X_DIALOG

and U have to maintain list of off-set accounts.

Regards

Prabhu

Read only

anversha_s
Active Contributor

‎2006 Nov 06 5:12 AM

0 Likes
466

hi,

chk this.

CALL FUNCTION 'AC_DOCUMENT_RECORD' 
EXPORTING 
I_AWTYP = 'VBRK' 
I_AWREF = VBRK-VBELN 
I_AWSYS = VBRK-LOGSYS 
I_BUKRS = VBRK-BUKRS 
TABLES 
T_DOCUMENTS = DOC_NUM 
EXCEPTIONS 
NO_DOCUMENT = 1.

regards

Anver

Read only

Former Member

‎2006 Nov 06 5:34 AM

0 Likes
466

Hi Bhavana

You may try this way:

<b>EKKO->EKPO->EKBE->BKPF->BSEG.</b>

Kind Regards

Eswar