Table and Field for Text delivery to Proforma invoice

[rajiv_trivedi]

Hi Experts,

I have created successfully Header text to flow to Proforma invoice header Text.

Now I need to understand which filed from delivery to proforma invoice is flowing? STXH is having Text ID text object VBBK are available.

Let me know which Table/field relates for VBRK data? As I could not find delivery table in invoice.

Appreciate for early help.

[prasanna_kumar4 · Accepted solution]

Hi,

Tell to ABAP like the below logic

Functional Module: READ_TEXT

ID : Give the Text ID

Language : EN

NAME: Give the Delivery number or billing number (if it is header Level ) or Give the Delivery Number with Item number or billing number with item number

Object: VBBK (Header Data) , VBBP (Item Data)

Regards,

Prasanna

[rajiv_trivedi · Accepted solution]

Hi PPIO,

Thanks for your reply. I had advised ABAPer as below

The following text (refer to the Proforma Invoice example) will be printed:

u201C*** Proforma Invoice Note***

After printing the text above, insert text to delivery header.

Goto VBRK (Invoice-Header) and paste VBRK-VBELN (Invoice number)

Get the delivery number from Document Flow VBFA-VBELV where VBTYP_N =u201DMu201D Invoice

Pull the required text detail from delivbery number as below logic

Use function module READ_TEXT in function group STXH Header Table (STXD SAP script text file header)

STXH-TDOBJECT=VBBK will bring back Proforma Invoice Note from the delivery header Text LIKP

TDID = Z004 u201CProforma Invoice Noteu201D

LANGUAGE = EN

TDNAME = delivery order number

OBJECT = VBBK (for header texts).

OBJECT = u2018VBBKu2019 (Header Text)

Print text in TDLINE

I have rewarded points to you. Thanks for your valued time. Problem Resolved.

[former_member184701 · Accepted solution]

dear friend,

you wrote that "I have rewarded points to you"

are you sure?)

i didn't get them.

regards,

Edited by: Lakshmipathi on Dec 15, 2011 1:22 PM It is really regret to note having earned more than 2500 points, you are still asking which you should be aware is against the forum rules

[rajiv_trivedi · Accepted solution]

I have marked as Very Helpful Button. Where else I have to do?

[former_member184701 · Accepted solution]

dear,

you replied twice to prasanna_sap

please find my posts on this page and reply/award to them

thank you.

regards,

[rajiv_trivedi · Accepted solution]

Yes I rewarded.

[former_member184701 · Accepted solution]

Thanks a lot friend!

[rajiv_trivedi · Accepted solution]

You are welcome. Appreciate your help.

[former_member184701]

dear friend,

if you run t-code VTFL to see a copy control from your delivery to invoice

please goto relevant ItemCategory (use 'Details' )and look at field "Data VBRK/VBRP" - you will see some roitines there which move data from delivery to invoice

if you run t-code VOFM in another session and go to Data transfer-Billing documents you will see all codes

you can create your own routine ,say 901, and set it into copy control (in VTAA)

please ask abaper to help

good luck!

P.S. the table you're after is TFRM

[rajiv_trivedi]

Hi,

Many thanks for tips. I shall appreciate if you let me know which are table & field in VBRK header text where I can see delivery reference. Say for example I want to to write FSF coding how to get details.

VBRK table is not showing any related link for delivery. So need functional specifications to explain ABAPer.

Thanks for your time.

[former_member184701]

dear,

LIKP-VBELN is your delivery

take this number and goto VBFA and paste this value to VBFA-VBELV where VBTYP_N = 'M' (invoice)

your invoice number is VBFA-VBELN where VBTYP_N = 'M'

now take this VBFA-VBELN and goto VBRK and paste into VBRK-VBELN

good luck!

[former_member184701]

please check out the field VBRK-ZUONR