Scribd Logo
Upload

Welcome to Scribd!

  • 671 views

    PS Tables

    Uploaded by

    narender9679
    This document provides descriptions of tables and fields used in project management and cost accounting. It describes the relationships between key tables like PRPS, AFVC, AUFK, and RPSCO. It also provides instructions for how to check which materials are assigned to a project, work breakdown structure element, or network using these tables.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd

    PS Tables

    Uploaded by

    narender9679
    671 views8 pages
    This document provides descriptions of tables and fields used in project management and cost accounting. It describes the relationships between key tables like PRPS, AFVC, AUFK, and RPSCO. It also provides instructions for how to check which materials are assigned to a project, work breakdown structure element, or network using these tables.

    Original Description:

    PS Table

    Copyright

    © © All Rights Reserved

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document provides descriptions of tables and fields used in project management and cost accounting. It describes the relationships between key tables like PRPS, AFVC, AUFK, and RPSCO. It also provides instructions for how to check which materials are assigned to a project, work breakdown structure element, or network using these tables.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    671 views8 pages

    PS Tables

    Uploaded by

    narender9679
    This document provides descriptions of tables and fields used in project management and cost accounting. It describes the relationships between key tables like PRPS, AFVC, AUFK, and RPSCO. It also provides instructions for how to check which materials are assigned to a project, work breakdown structure element, or network using these tables.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    You are on page 1of 8

    Table

    Field

    PROJ
    PRPS
    PRPS
    AFVV

    PSPID
    POSID
    POSID
    AUFNR

    (For Descritpion
    Field Name)
    POST1
    POST1
    POST1

    Proj Def
    NTD-0000976

    1st Level Wbs 2nd Level Wbs Network Activity

    Material

    NTD-0000976
    NTD-0000976-1
    4008855
    10
    2027
    20
    30
    NTD-0000976-2
    4008856
    40
    50
    60

    PROJ
    PRPS
    PRTE
    PRHI
    AFVC
    AFVV
    AFRU
    EVPOC
    BPJA
    RPSCO
    CAUFV

    Table Desription
    Project Definition
    WBS Element Master Data
    Scheduling of WBS elements
    WBS element Hierarchy pointer
    Operation within an order Activities
    Scheduling of Activities
    Activity Confirmations
    Percentage of completion
    Total costs for Annual period CO Object(WBS related Budgets)
    WBS and Activities /Network related Actual costs
    View Orders (PP/CO)- Networks

    Table Links
    1.) Links to PRPS Table
    PROJ : PROJ-PSPNR = PRPS-PSPHI
    PRTE : PRTE- POSNR = PRPS-PSPNR , PRPS-PSPHI = PRTE-PSPHI
    PRHI : PRPS-PSPNR = PRHI-POSNR
    AFVC : PRPS-PSPNR = AFVC-PROJN
    BPJA : PRPS-OBJNR = BPJA-OBJNR
    RPSCO : PRPS-OBJNR = RPSCO-OBJNR
    2.) Links to AFVC Table
    CAUFV :AFVC-AUFPL = CAUFV-AUFPL
    RPSCO :AFVC-OBJNR = RPSCO-OBJNR
    EVPOC : AFVC-OBJNR = EVPOC-OBJNR
    AFRU: AFVC-AUFPL = AFRU-AUFPL
    AFVV: AFVC-AUFPL = AFVV-AUFPL , AFVC-APLZL = AFVV-APLZL

    Table
    RPSCO

    BPEG
    BPEJ
    BPGE
    BPJA
    PROJ
    PRPS
    MLST
    AFVC
    AUFK
    COEP
    COBRA
    COSS
    COSP
    RPSQT
    Master Data
    PROJ
    PRPS
    PRHI
    PRTE
    AUFK
    AFKO
    AFVC / AFVU / AFVV
    RESB
    MLST
    Transaction data
    RPSCO
    RPSQT
    COSP
    COSS
    COEP
    COOI
    COEJ
    BPGE
    BPJA
    QBEW
    MSPR

    Description
    Proj. Infor Data base; Cost, revenue, finance
    Field
    VORGA
    KBUD
    KBRO
    KBNO
    KBFR
    Budget Revision Header (Line Item Overall Values)
    Line Item Annual Values
    Total Record for Total Value
    Total Record for Annual Value
    Proj. Def.
    WBS Overview
    Milestone
    Network (Opr. Within an order)
    Network order master data
    CJI3 Actual Cost line item (By period)
    Settlement Rule For Order Settlement
    Secondary cost planning - Cost total for internal posting
    Primary cost planning - For external posting
    Proj. info database - Quantities

    Proj Def.
    WBS
    WBS hierarchy
    Scheduling Data
    Order / Network Header
    Prod. Order / Network
    Network Activites
    Reservation / Dependent requirement
    Milestone

    Proj. Info database (Cost, Revenue, Finance)


    Proj. Info database (Quantities)
    Cost total for external posting (Primary cost)
    Cost total for Internal posting (Secondary cost)
    Line Item Actual
    Line Item Commitment
    Line Item Planned Order
    Budget Overall
    Budget Annual
    Proj. stock valuation
    proj. stock (Included Non Valuated)

    Budget Type
    Original Budget
    Return Budget
    Supplement Budget
    Release Budget

    If want to check any material assigned under proj. / WBS / Network


    1
    Use Table PRPS (For WBS) and enter input in Current proj no field as project code and ex
    2
    Copy data from POSID field. (i.e. WBS nos.)
    3
    Use Table AUFK (For Network) and enter data of PRPS-POSID in AUFK-PSPEL (i.e. WBS ele
    4
    Copy data from AUFNR field (i.e. Network Order No.)
    5
    Use Table RESB (For Reservation / Dependent requirement) and enter data of AUFK-AUFN
    6
    Now check the result of RESB-MATNR.

    as project code and execute it.

    FK-PSPEL (i.e. WBS element) and execute it.

    ter data of AUFK-AUFNR in RESB-AUFNR and execute it.

    You might also like