on 06-01-2011 7:32 PM
Dear Expert,
I Am new to SAP CLM, and I am developing one report. Pls help me to find out the fileds and Logic for the same.
Below are the fileds
Vendor #
Vendor Name
Contract Name
Contract ID
SRM Contract Id
Contract Type
Product Category
Invoice Company Code
Invoice Cost Center
PO#
Invoice #
PO Spend with Contract #
PO Spend witout Contract #
FA Invoice Spend
Total Spend
Logic:-
Logic Condition one result Condition 2 result Action Action Filter
Invoice Does the Invoice has PO Yes Does the PO has Contract # Yes Map to Vendor Id an contract id in CLM Add Spend to PO with Contract Field Only if vendor has atleast one contract in CLM
Any Help will be appreciated:
Thanks,
Ahmad
Hi Ahmad,
The resource guide will have all of the database table and field names you will need for the query. It also looks like you are using extensions...the browse extension schema should point you to those field names.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear Howie Wexler
We are in process of developing the spend report and having some problems in Joining the spend tables (FCI_SA_FACT_DETAIL001) with the normal contract tables (FCI_CONTRACT and FCI_AGREEMENT). like Primary Key etc
Also we are some having the problem in finding the Purchase Order #, Invoice number #, Invoice Company Code and Invoice Cost Center fields in the CLM table, if you can help us in provide the table name that will be great.
Many Thanks
Iqbal
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.