08-03-2007 11:15 AM
Customized new table:
Info for the customized table:
Table Name: ZIN_BONDINV
Field Name Data Element Type Length Short Text
MANDT MANDT CLNT 03 Client
VBELN VBELN_VF CHAR 10 Billing Document
EXNUM J_1IEXCNUM CHAR 10 BOE or Excise Invoice #
EXYEAR J_1IEXYEAR NUMC 04 Excise Year
ZEILE J_1IZEILE1 NUMC 04 Item no - GR at depot
ZVBELN VBELN_VL CHAR 10 Delivery Number
Z POSNR POSNR_VL CHAR 06 Delivery item
ZWERKS WERKS_D CHAR 04 Plant
This table to be used for storing the invoice created using delivery document along with other information extracted during billing document creation.
Logic for populating the table:
User Exit: RV60AFZC
Form: USEREXIT_FILL_VBRK_VBRP
This user exit should be used to update records in the customized table for the data with which billing document is created. The data should be populated as follows:
VBELN = VBRK-VBELN
EXNUM = J_1IRG23D-EXNUM*
EXYEAR = J_1IRG23D-EXYEAR*
ZEILE = J_1IRG23D-ZEILE*
ZVBELN = VBRP-VGBEL
ZPOSNR = VBRP-VGPOS
ZWERKS = VBRP-WERKS
*The above data is read during splitting the billing document based on BOE (copy control routine 602) and should be used from there.
08-03-2007 11:52 AM
08-03-2007 11:55 AM
Tip: Do you want someone to write the code for you? In that case end your post with "Give exact code please"
08-03-2007 12:12 PM
Hi,
I have already created the table named ZIN_BONDINV , there i have to insert the values and that has to be done according to the logic written in user-exit named:RV60AFZC(INCLUDE).