topic Re: Off-setting Account number in Purchasing doc in Application Development and Automation Discussions

Off-setting Account number in Purchasing doc

Former Member — Sat, 04 Nov 2006 16:45:54 GMT

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

Re: Off-setting Account number in Purchasing doc

Former Member — Mon, 06 Nov 2006 05:07:38 GMT

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

Re: Off-setting Account number in Purchasing doc

anversha_s — Mon, 06 Nov 2006 05:12:47 GMT

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

Re: Off-setting Account number in Purchasing doc

Former Member — Mon, 06 Nov 2006 05:34:04 GMT

Hi Bhavana

You may try this way:

Kind Regards

Eswar