Skip to Content

Available Capacity

Hi All,

This is in regard for a PP-BI report.

The requirement is that, I have to get the field ANGEB (available capacity) from a PP table.

I have tried to check for the same by executing in SE16 with the table name 'TCNTX' but found that its all linked to structures.

Could anybody suggest me the direct table from the field value can be fetched?

Thanks and Regards,

Chris.

Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • Posted on Jan 24, 2014 at 09:42 AM

    Hi Chris,

    ANGEB is a flag is field name is "quotation exist" not Available capacity. ANGEB fiels is available in T160S table.

    For capacity check below tables.

    CRCA Work center capacity

    KAKO Capacity Header Segment

    KAKT Capacity Description

    KAPA Shift Parameters for Available Capacity

    KAPE Capacity unit of measure allocation

    KAZY Interval of Available Capacity

    KBED Capacity requirements records

    Thanks and regards,

    Krishnendu.


    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 25, 2014 at 05:26 PM

    Hello Chris,

    'ANGEB- Available capacity' is the field from structure only & so won't be available in any of the table. You will have to think some other way to fetch the required data (mathematical calculation of operating time X No. of individual capacities).

    Mangesh S

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 26, 2014 at 02:51 AM

    Hi Chris,

    Have you checked it? Please revert back with your feedback.

    Regards,

    Krishnendu.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 27, 2014 at 08:59 AM

    Thank You Krishnendu and Mangesh for your replies.

    I got to know that it exists as a field in the structure.

    Please see the link SAP Library - PP Embedded Analytics

    I get values for all the other fields in the extract structure.

    Mangesh, could you be more elaborate on the method of find the same by some other way?

    Regards,

    Chris.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hello Dennis,

      I believe you want to fetch this value from the table,

      Follow the steps to get this data,

      1. Pass work center code as ARBPL in table CRHD & get OBJID (object type).

      2. Pass OBJID in table CRCA & get KAPID (you might be having multiple KAPID also against different capacity category like 001- Machine, 002- Person).

      3. Now pass KAPID in KAKO & get AZNOR, BEGZT, ENDZT, NGRAD, PAUSE.

      4. Apply this formula to get the available capacity,

      {(ENDZT- BEGZT- PAUSE)*NGRAD/100}*AZNOR. This available capacity is in seconds. So if you ned it in hour then divide the value with 3600.

      Do remember this is against the specific capacity category as mentioned in point 2.

      Hope this helps.

      Mangesh S

      Capture.PNG (7.7 kB)

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.