2009 Jan 21 9:26 AM
What is the link between the tables BSEG and TCJ_POSITIONS/ TCJ_DOCUMENTS?
2009 Jan 21 9:33 AM
Hello,
You can use the following params:
BSEG-BUKRS = TCJ_POSITIONS-COMP_CODE
BSEG-GJAHR = TCJ_POSITIONS-FISC_YEAR
BSEG-BELNR = TCJ_POSITIONS-POSTING_NUMBER
BSEG-BUZEI = TCJ_POSITIONS-POSITION_NUMBER
I think this will help.
BR,
Suhas
2009 Jan 21 9:29 AM
You are not getting BELNR and BUZEI as common ?
2009 Jan 21 9:31 AM
TCJ_DOCUMENTS-POSTING_NUMBER = TCJ_POSITIONS-POSTING_NUMBER
TCJ_DOCUMENTS -COMP_CODE =TCJ_POSITIONS-COMP_CODE
2013 Jan 01 11:13 AM
PARAMETERS: p_bukrs type bkpf-bukrs,
p_gjahr type bkpf-gjahr,
p_belnr type bkpf-belnr.
data: p_num type tcj_documents-posting_number,
CJ_NUM type tcj_documents-CAJO_NUMBER.
data: v_name type tcj_documents-bp_name.
data: v_awkey type bkpf-awkey.
select single awkey into v_awkey from bkpf where belnr = p_belnr and bukrs = P_bukrs and gjahr = p_gjahr.
p_num = v_awkey+0(10).
cj_num = v_awkey+10(4).
select single BP_NAME into v_name from tcj_documents where COMP_CODE = p_bukrs and CAJO_NUMBER = cj_num and
FISC_YEAR = p_gjahr and POSTING_NUMBER = p_num.
write: v_name.
2013 Jan 01 11:15 AM
Bluesky
