on 08-24-2011 1:43 PM
Hi All,
I would like to know which are the tables in which the freight order data is stored. Particularly need to know where the pick period dates in the freight order is stored.
Regards,
Ashwin
For FO root: /SCMTMS/D_TORROT
FO location related data : /SCMTMS/D_TORSTP
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Ashwin,
the freight order is stored in the business object /SCMTMS/TOR. You can use transaction /BOBF/CONF_UI to explore the structure of a business object and transaction /SCMTMS/TEST_UI to explore the data. In an ABAP program you have to use a service manager to access a business object
DATA:
lr_srvmgr TYPE REF TO /bobf/if_tra_service_manager.
lr_srvmgr = /bobf/cl_tra_serv_mgr_factory=>get_service_manager( iv_bo_key = /scmtms/if_tor_c=>sc_bo_key ).
CALL METHOD lr_srvmgr->query
EXPORTING
iv_query_key = /scmtms/if_tor_c=>sc_query-root-planning_attributes
it_selection_parameters = lt_sel_opt
IMPORTING
et_key = lt_tor_key.
Via this service manager you can query and then retrieve data from the business object. Never access the database table directly.
Best regards
Thomas
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Small typo: BOPF test transaction is actually /BOBF/TEST_UI
User | Count |
---|---|
15 | |
4 | |
3 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.