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

[sunil_yadav2]

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:

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

[mirakbar_ali]

Thanks Sunil for sharing, very useful document.

Regards

Akbar

[sunil_yadav2]

Thanks Ali for encouraging me and for like :smile:

[Former Member]

Hi Sunil ,

This good for refreshing our knowledge and useful for beginner

Regards

Deepak

[former_member218251]

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

[sunil_yadav2]

Hi Hofman,

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

thanks

Sunil

[sunil_yadav2]

Thanks Deepak :smile:

[sunil_yadav2]

Hi,

I am not able to see your post :sad:

[former_member225123]

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

[sunil_yadav2]

Thanks Gaurav :smile:

[Former Member]

Thanks, Good information & useful document

[sunil_yadav2]

Thanks Prasath :smile:

[former_member218251]

Hi Sunil

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

[Former Member]

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

[sunil_yadav2]

Thanks Aoron :smile:

[Former Member]

Thanks

Really Useful information

[sunil_yadav2]

Thanks Omkar

[former_member218047]

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

[sunil_yadav2]

Thanks Sesha :smile:

Will try to post some more useful content.

[Former Member]

one place for all sap ps related data origin

[sunil_yadav2]

Thanks Naseer :smile:

[former_member228007]

Its a Nice document Sir.

[sunil_yadav2]

Thanks Saurabh :smile:

[Shubham1]

very well drafted..good

[former_member183349]

its really helpful document.

[sunil_yadav2]

Thanks Shubham

[sunil_yadav2]

Thanks Vivek

[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

[sunil_yadav2]

Hi Omkar,

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

thanks a lot

Sunil

[Former Member]

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

[sunil_yadav2]

Hi Ataul,

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

[jskishore]

Hi Sunil,

Thanks, it was really helpful and very good document.

Thanks

kishore

[sunil_yadav2]

Thanks Kishore

[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

[Former Member]

Thanks Sunil, Useful document.

[sunil_yadav2]

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

[sunil_yadav2]

Thanks Sandeep :smile:

[raghubirsap]

Good Job Sunil Sir

Really appreciated this help & Support.

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

 

[sunil_yadav2]

Thanks Raghubir.

[Former Member]

thanks so much

 

[sunil_yadav2]

Welcome Omar 🙂

[former_member391408]

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.

[sunil_yadav2]

Thanks Nikki 🙂

[ananias]

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.

[hthakar]

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

[engmarcel]

@sunil.yadav2 Can explain more on Project System & Funds Management Links?