Current Position:Home > Values from CRCO Table.

Values from CRCO Table.

Update:10-11Source: network consolidation
Advertisement
Hi all ,
I need to retreive some values from CRCO table based on the balues fetched from AFRU table. I am writing a select like this
select single KOKRS KOSTL into table itab from CRCO
          where OBJTY = 'A'
             and OBJID  = AFRU-ARBID
             and ENDDA >= AFRU-BUDAT
             and BEGDA <= AFRU-BUDAT.
As I need to retreive a single record from above select, but as a result i am getting multiple records.
Can anybody tell me what other keys from AFRU I can specify in the select in order to fetch only a single record.
Thanks,
Mungala.

The Best Answer

Advertisement
Object ID you can get from ARBID from AFRU Table. Put value of ARBID in OBJID in table CRCO & get values of KOKRS & KOSTL. That value will be unique for an work center But if ARBID values are many for an AUFNR(order no.) that mean you are using different work center where in may be you are using different cost center(i think controlling area will remain same). & hence SAP creates different records.
Regards
Prashant Jaiswal
  • Values from CRCO Table. Update:10-11

    Hi all , I need to retreive some values from CRCO table based on the balues fetched from AFRU table. I am writing a select like this select single KOKRS KOSTL into table itab from CRCO           where OBJTY = 'A'              and OBJID  = AFRU-ARBID

  • Select statement having internal table in the wher clause... Update:10-11

    Hi, will all the entry from the internal i_crhd will be pased to the next select statement in the sample code below without looping? Thanks  a lot! REFRESH i_crhd.    SELECT objid vgwts      FROM crhd INTO CORRESPONDING FIELDS OF TABLE i_crhd      WH

  • List of table Name and Descrition Update:10-11

    Hi Experts Can u send me list of standard tables with descriptionCheck below SAP PP Master Data Tables MASTER DATA Engineering Change Management AENR        Customer and priority AEOI          Revision Numbers Work Center CRHD         Workcenter Head