Skip to Content
Technical Articles
Author's profile photo Sunil Yadav

SAP PS- Useful Tables Linkage to fetch data from various tables

Purpose

This document would be useful for beginners who usually post new thread regarding table links. Sometimes we did not able to recall relation between different tables during New Requirement either we have worked before or not.

Information

Plan Cost:

(1) Manual Cost Planning (WBS Elements):

Pass WBS as into PRPS-PSPNR and obtain the PRPS-OBJNR.

Pass PRPS-OBJNR to RPSCO-OBJNR where value type would be RPSCO-WRTTP = 1 and get Plan cost by adding the value of RPSCO table WLP00, WLP01,…to…. WLP16.

(2) Network Costing:

if we does not have network number than Pass WBS number (PRPS-POSID) to AUFK-PSPEL and get AUFK-AUFNR.

Pass the network number to AFKO-AUFNR and obtain AFKO-AUFPL.

Pass AFKO-AUFPL to AFVC-AUFPL and obtain AFVC-OBJNR (object number for Network Activity).

pass AFVC-OBJNR to RPSCO-OBJNR where value type RPSCO-WRTTP = 1 and get Plan cost by adding the valueof RPSCO table WLP00, WLP01,…to…. WLP16

(3) Actual Cost: if you need actual cost from RPSCO table than you should choose WRTTP=4 rest whole logic would be same in above.

other optional table: COEP-CO Object: Line Items (by Period), this table is also useful when we want to create a custom report line item wise or according to Date/period/fiscal year.

Pass OBJNR to COEP-OBJNR and fetch COEP-BELNR, WTGBTR where COEP-WRTTP=4 and VRGNG NE KOAO.

if you need value according to date range

Pass COEP-BELNR to COBK-BELNR fetch COBK-BUDAT

Compare COBK-BUDAT to selection parameter date and select records on or before selection parameter.

If BUDAT is equal or less than selection parameter date which is 01.01.2015 then select this entry.

Compare COBK-BELNR to COEP-BELNR and obtain COEP-WTGBTR

Budget:

Budget Type:

1. Annual Budget

2. Overall Budget

This is defined in budget profile:

   -Only annual budget.
-Overall Budget.
-Annual + Overall Budget

BPJA: this table is for Budget Annual: For this we have pass PRPS-OBJNR to BPJA-OBJNR and fetch BPGE-WTJHR.
BPGE: This table is for Budget Overall: For this we have pass PRPS-OBJNR to BPGE-OBJNR and fetch BPGE-WLGES.

 

In above table we can have link between PRPS and above two tables. we need to pass OBJNR of WBS to BPEG & BPJA table to fetch values.

Status: SAP hase different types of Status as below:

1. System Status: which is SAP Standard Status, User can not interfere with SAP System Status. according to transaction system status would be activated. Example: CRTD, REL, CNF, TECO & CLSD etc

2. User Status: this is a User defined status which user himself creates and use as per business function/process.

Tables:

JEST-Object Status

JCDO-Change Documents for Status Object (Table JSTO)

TJ02-System Status

TJ02T- text for system status

JSTO-Status Object Info

JCDS-change Document for system and user status

TJ30-User Status

TJ30T-Text for user status

Logic to get User Status of Activity:

Pass the network number to AFKO-AUFNR and obtain AFKO-AUFPL.

Pass AFKO-AUFPL to AFVC-AUFPL and obtain AFVC-OBJNR (object number for Network Activity). where VORNR  is equal to activity number.

then Pass AFVC-OBJNR  to JCDS and get status starting with E* where status inactive= blank
Now Pass AFVC-OBJNR to JSTO OBJNR and get STSMA
Pass STSMA  and Status with E* to TJ30T and get TXT04.

if we need status for any object than we should have OBJNR for required object for Example: if we need to fetch status of WBS than Pass PRPS-OBJNR to JEST-OBJNR. this will return like I0001 or I0002 etc which are internal naming but if you want to see text than you should pass I0002 to TJ02T than you will get status as below:

1.JPG

Commitment:

Commitment is a value which are liabilities arising from contractual obligations incurred on time to time basis. i projects we need to estimate our cost/investment.

to get values forcommitment we should use below link:

Table COOI-Commitments Management: Line Items

Pass OBJNR of PS object in COOI-OBJNR to get values

other option is Pass OBJNR to RPSCO table and fetch values basis of RPSCO-WRTTP = 21,22,23,24.

Integration with HR:

In SAP we have major integration between PS and HR.

we need to check table:

CATSDB – CATS: Database Table for Time Sheet

this table contain all data posted to HR like time sheet whether this is approved or not.

Pass WBS/Network to fetch time sheet posted by Personnel Number.

CATSPS- Cross-Application Time Sheet (CATS): Transfer to PS

This table contain all timesheet which are posted and transfer to PS object.

Pass Network in CATSPS-RNPLNR and get personnel Number and Hours posted Etc.

 

CATSCO-Cross-Application Time Sheet (CATS): Transfer to CO

This table contain all timesheet which are transferred to CO Object.

Pass WBS to CATSCO-RPROJ and get personnel Number and Hours posted Etc.

CATSHR-Cross-Application Time Sheet (CATS): Transfer to HR

This table contain all timesheet which are transferred to HR Object.

Pass WBS to CATSHR-RPROJEXT and get personnel Number and Hours posted Etc.

PA0001-HR Master Record: Infotype 0001 (Org. Assignment)

Pass Personnel Number in PA0001-PERNR and get all details of Personnel Number.

PA0027-HR Master Record: Infotype 0027 (Cost Distribution)

Pass Personnel Number or WBS to get cost distribution list.

Integration with MM:

for integration with MM we can refer tables like: EKKN-Account Assignment in Purchasing Document.

EKKN- Account Assignment in Purchasing Document

we can pass WBS element to EKKN-PS_PSP_PNR and Network to EKKN-NPLNR to fetch PO related to PS object.

EKPO -Purchasing Document Item

we can fetch PO related to Account assignment P, N and Q. for this Pass Account Assignment to EKPO-KNTTP and get PO Number (EBELN). we can also fetch Service PO via Entering item category in EKPO-PSTYP.

EBAN – Purchase Requisition

This table is linked with EBKN (Account Assigned PR), and EBKN is linked with all account assigned Objects for example: WBS Element, Network, Plan no.f.oper., To order, Cost Object etc.

RESB: Reservation/dependent requirements

if any reservation is created for any object than you will get from this table like:

Pass WBS Element (RESB-PSPEL) and get Reservation number.

RKPF : Document Header: Reservation

this table contain data related to reservation. linked to AFKO table via RSNUM

there are many more tables like:

EVPOC:-Percentage of completion:

Pass PRPS-OBJNR to EVPOC-OBJNR to fetch Plan or Actual POC

COBRA-Settlement Rule for Order Settlement

PRPS-OBJNR=COBRA-OBJNR

COBRB-Distribution Rules Settlement Rule Order Settlement

PRPS-OBJNR=COBRB-OBJNR

 

COSB-CO Object: Total Variances/Results Analyses

Pass OBJNR and get result analysis data for Object

PRTP-Sub Projects

PRPS-SUBPR = PRTP-SUBPR

PRHIS-Standard Project Hierarchy

this table is used to identify all hierarchy for a selected Standard WBS

Pass Standard WBS to PRHIS-POSNR and check which is Project ID and Immediate lower WBS and Left and right WBS if available.

PRPSS- Standard WBS Element (WBS element) – Master Data

Pass Standard WBS to PRPSS-POSID and get all master data assigned to Standard WBS.

PROJS-Standard Project ID

Pass Standard ProjectID to PROJS-POSID and get all master data assigned to Standard Project.

PLPO- Standard Network Activity

Pass Standard WBS to PLPO-PSPNR to fetch all activity assigned to WBS

MLST- Milestones

if you have WBS, than Pass WBS to MLST-PSPNR and fetch Milestone assigned to WBS

if you have network than you need to fetch plan no of operation and counter, pass these to MLST-AUFPL and MLST-APLZL and fetch MLST-MLST_ZAEHL (Milestone number), MLSTN (Usage) etc.

SMLS-Standard Milestones

standard milestone are attached to PS objects like standard network.

PRTX-WBS PS Text

Pass WBS to PRTX-PRPSPNR to fetch PRTX-PRTXTKY then Pass PRTX-PRTXTKY to PSTX-PSTXTKY and get PSTX-PSTXTTI (Description).

PRST-WBS BOM Link

Pass WBS to PRST-PSPNR to get Material (MATNR).

QBEW-Project Stock valuation

Pass Material  (QSEW-MATNR) and WBS (QBEW-PSPNR) and get stock and values

MSPR-Project Stock

Pass WBS in MSPR-PSPNR and get Material (MSPR-MATNR) with quantity.

AFRU-Confirmation

Pass AFRU-AUFNR and AFRU-APLFL to get confirmation details

COSS- Cost total for internal posting

Pass Object Number of PS Object and get all values.

COSP-Cost total for External Postings.

FMZUOB-Allocation of CO Object to FM Account Assignment

VBAK-Sales Document: Header Data

Pass WBS in VBAK-PS_PSP_PNR to get details for sales order

VMPA-Selection Methods for Search Help VMPA

When business process is link assembly Process and RRB so we need to check link between Sales Document with WBS.

Pass WBS to VMPA-PS_PSP_PNR to get Sales Order Item or vice versa.

COAS- Details for order against WBSE

This is used to find orders created where WBS as Account assignment.

Pass WBS to WBS of COAS(COAS-PSPEL) to get Order and order type.

 

Resource Related Billing tables:

 

AD01DLI: Dynamic items (DI)

Pass Object number and find all details related to RRB

AD01DLISF: DI Flow: Totals Flow

pass DLINR from AD01DLI table

AD01DLIEF: DI flow: Individual flow

Pass DLINR from AD01LIEF table

Fund Management and Project System:

FMDERIVE006-Derivation rule:WBS Element/CE to Commitment Item/Funds Ctr/

This is used to extract Derivation Rules where WBS/Cost Element linked to Commitment Item/Fund Center

FMDERIVE007-Derivation rule:WBS Element to Commitment Item/Funds Ctr/Fun

This is used to extract Derivation Rules where WBS linked to Commitment Item/Fund Center

Thank you for reading and hope you liked it. I will be regularly updating this Document for rest of important formula/links.

Thank you for your time and feedback!

Suggestions would be appreciated and always welcome to improve Quality of this document.

Warm Regards

Sunil Yadav

Assigned tags

      44 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Akbar Ali
      Akbar Ali

      Thanks Sunil for sharing, very useful document.

      Regards

      Akbar

      Author's profile photo Sunil Yadav
      Sunil Yadav
      Blog Post Author

      Thanks Ali for encouraging me and for like 🙂

      Author's profile photo Former Member
      Former Member

      Hi Sunil ,

      This good for refreshing our knowledge and useful for beginner

      Regards

      Deepak

      Author's profile photo Sunil Yadav
      Sunil Yadav
      Blog Post Author

      Thanks Deepak 🙂

      Author's profile photo H.M Hofman
      H.M Hofman

      I did not see this document, but I just completed a document around the tables involved in resource related billing. Perhaps we can incorporate this in this document?

      Resource related billing data flow

      Author's profile photo Sunil Yadav
      Sunil Yadav
      Blog Post Author

      Hi Hofman,

      Sure i will update this document including your tables too and much more table links 🙂

      thanks

      Sunil

      Author's profile photo Sunil Yadav
      Sunil Yadav
      Blog Post Author

      Hi,

      I am not able to see your post 🙁

      Author's profile photo H.M Hofman
      H.M Hofman

      Hi Sunil

      Sorry for the late response, was away from the office. It was removed, will send you a message with the tables.

      Author's profile photo Gaurav Ahuja
      Gaurav Ahuja

      Thanks Sunil for sharing a good piece of information with us regarding table links . 🙂

      Author's profile photo Sunil Yadav
      Sunil Yadav
      Blog Post Author

      Thanks Gaurav 🙂

      Author's profile photo Former Member
      Former Member

      Thanks, Good information & useful document

      Author's profile photo Sunil Yadav
      Sunil Yadav
      Blog Post Author

      Thanks Prasath 🙂

      Author's profile photo Former Member
      Former Member

      Good & Useful document Sunil ! Appreciate it ! Thanks for your valuable time to document the details.

      Author's profile photo Sunil Yadav
      Sunil Yadav
      Blog Post Author

      Thanks Aoron 🙂

      Author's profile photo Former Member
      Former Member

      Thanks

      Really Useful information

      Author's profile photo Sunil Yadav
      Sunil Yadav
      Blog Post Author

      Thanks Omkar

      Author's profile photo Former Member
      Former Member

      Hi Sunil,

      Just Giving you one Suggestion, Pls add COAS table Details for order against WBSE.

      this table helps to find Orders raised using WBS as account assignment.

      Regards,

      Omkar Deshpande

      Author's profile photo Sunil Yadav
      Sunil Yadav
      Blog Post Author

      Hi Omkar,

      thanks for your Suggestion. will update for COAS table with related details.

      thanks a lot

      Sunil

      Author's profile photo Seshagiri Konathala
      Seshagiri Konathala

      Very good information regarding Project related tables. Keep it up. Expecting some more useful information from you.

      Author's profile photo Sunil Yadav
      Sunil Yadav
      Blog Post Author

      Thanks Sesha 🙂

      Will try to post some more useful content.

      Author's profile photo Former Member
      Former Member

      one place for all sap ps related data origin

      Author's profile photo Sunil Yadav
      Sunil Yadav
      Blog Post Author

      Thanks Naseer 🙂

      Author's profile photo Saurabh Johari
      Saurabh Johari

      Its a Nice document Sir.

      Author's profile photo Sunil Yadav
      Sunil Yadav
      Blog Post Author

      Thanks Saurabh 🙂

      Author's profile photo Shubham Srivastava
      Shubham Srivastava

      very well drafted..good

      Author's profile photo Sunil Yadav
      Sunil Yadav
      Blog Post Author

      Thanks Shubham

      Author's profile photo Former Member
      Former Member

      its really helpful document.

      Author's profile photo Sunil Yadav
      Sunil Yadav
      Blog Post Author

      Thanks Vivek

      Author's profile photo Former Member
      Former Member

      Its a helpful document can you also post ps integration with controlling

      Author's profile photo Sunil Yadav
      Sunil Yadav
      Blog Post Author

      Hi Ataul,

      thanks for your remarks. will try to update this documents for CO-PS integration.

      Author's profile photo Kishore JS
      Kishore JS

      Hi Sunil,

      Thanks, it was really helpful and very good document.

      Thanks

      kishore

      Author's profile photo Sunil Yadav
      Sunil Yadav
      Blog Post Author

      Thanks Kishore

      Author's profile photo Srinivasan Desingh
      Srinivasan Desingh

      http://scn.sap.com/docs/DOC-55692

      Hi,

      Indeed a useful document. Have you checked the above link for SAP PS tables?

      Thanks

      Regards

      Srinivasan Desingh

      Author's profile photo Sunil Yadav
      Sunil Yadav
      Blog Post Author

      Hi Srinivasan,

      Yes i have checked this document also and this is very good document.

      i thought that every person has different way of seeing or comfort level. so i have created the same. In real time some consultant use SE11 but some SE16 so its totally depend on individual comfort level.

      as far as my concern, i am able to understand both documents and i usually refer both documents as well.

      Thanks for your support!! and expecting more informative documents so we can learn more.

      thanks & regards

      Sunil

      Author's profile photo Former Member
      Former Member

      Thanks Sunil, Useful document.

      Author's profile photo Sunil Yadav
      Sunil Yadav
      Blog Post Author

      Thanks Sandeep 🙂

      Author's profile photo Raghubir Singh
      Raghubir Singh

      Good Job Sunil Sir

      Really appreciated this help & Support.

      Keep on updating the Blog with useful content related with sap.

       

      Author's profile photo Sunil Yadav
      Sunil Yadav
      Blog Post Author

      Thanks Raghubir.

      Author's profile photo Former Member
      Former Member

      thanks so much

       

      Author's profile photo Sunil Yadav
      Sunil Yadav
      Blog Post Author

      Welcome Omar 🙂

      Author's profile photo nikki carol
      nikki carol

      Thanks for the steps explanation.

      SAP Project System (PS) SAP Project System (PS) is a project management software tool that integrates with other components of the SAP Enterprise Resource Planning (SAP ERP) system.

       

      Author's profile photo Sunil Yadav
      Sunil Yadav
      Blog Post Author

      Thanks Nikki 🙂

      Author's profile photo Ananias Moonda
      Ananias Moonda

      Guys I have Challenge pulling the actual costs.

      project_actual_costs comes as 0.00

       

        DATA:
              it_posid                 TYPE TABLE OF prps-posid WITH HEADER LINE,
              it_prps                 TYPE TABLE OF prps WITH HEADER LINE,
              it_aufk                 TYPE TABLE OF aufk-aufnr WITH HEADER LINE,
              it_afko                 TYPE TABLE OF afko-aufpl WITH HEADER LINE,
              it_afvc                TYPE TABLE OF afvc-objnr WITH HEADER LINE,
              it_rpsco                 TYPE TABLE OF rpsco WITH HEADER LINE
              .
      
        DATA: total TYPE coss-wog001,
              actual_cost TYPE bp_wpl,
              planned_cost TYPE bp_wpl.
        " projn1 TYPE prps-psphi VALUE '00000174'.
      
        RANGES:
        lr_onjnr FOR prps-objnr,
        lr_posid FOR prps-posid,
                lr_aufk_aufnr FOR aufk-aufnr,
                lr_afko_aufpl FOR afko-aufpl,
                lr_afvc_objnr FOR afvc-objnr,
                lr_rpsco_objnr FOR  rpsco-objnr.
      
        lr_posid-sign = 'I'.
        lr_posid-option = 'EQ'.
        SELECT posid INTO it_posid  FROM prps WHERE psphi = projnr.
          lr_posid-low =  it_posid.
          APPEND lr_posid.
        ENDSELECT.
      
        lr_aufk_aufnr-sign = 'I'.
        lr_aufk_aufnr-option = 'EQ'.
        SELECT aufnr FROM aufk INTO it_aufk WHERE  pspel IN lr_posid[].
          lr_aufk_aufnr-low = it_aufk.
          APPEND lr_aufk_aufnr.
        ENDSELECT.
      
        lr_afko_aufpl-sign = 'I'.
        lr_afko_aufpl-option = 'EQ'.
        SELECT aufpl FROM afko INTO it_afko WHERE  aufnr IN lr_aufk_aufnr[].
          lr_afko_aufpl-low = it_afko.
          APPEND lr_afko_aufpl.
        ENDSELECT.
      
        lr_afvc_objnr-sign = 'I'.
        lr_afvc_objnr-option = 'EQ'.
        SELECT objnr FROM afvc INTO it_afvc WHERE  aufpl IN lr_afko_aufpl[].
          lr_afvc_objnr-low = it_afvc.
          APPEND lr_afvc_objnr.
        ENDSELECT.
      
        SELECT * FROM rpsco INTO it_rpsco WHERE objnr IN lr_afvc_objnr AND wrttp = 4.
          project_actual_cost = project_actual_cost + it_rpsco-wlp00 + it_rpsco-wlp01 + it_rpsco-wlp02 + it_rpsco-wlp03 +
          it_rpsco-wlp04 + it_rpsco-wlp05 + it_rpsco-wlp06 + it_rpsco-wlp07 +
          it_rpsco-wlp08 + it_rpsco-wlp09 + it_rpsco-wlp10 + it_rpsco-wlp11 +
          it_rpsco-wlp12 ."+ it_rpsco-wlp13 + it_rpsco-wlp14 + it_rpsco-wlp15 +
          "it_rpsco-wlp16.
      
        ENDSELECT.

       

      Author's profile photo Hiraj Deepakbhai Thakkar
      Hiraj Deepakbhai Thakkar

      Please add the table for finding the Relationships between Activities in Standard & Operational