cancel
Showing results for 
Search instead for 
Did you mean: 

Spend Report in CLM

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

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.

Former Member
0 Kudos

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