Question:
Hello together,
in which database tables I find the values of durations for the Service
Contract, for example in the database table SCAPPTSEG is duration (for example CONTDURA) -
in the column TXT_PUB_ID (internal identification of the rule of periodic dates)
am located DUR#######MINUTE X ##,
in the column - TST_FROM time stamp (UTC) of the start time of the date stands for 0.
But in this table no values of durations for the Service Contract are present.
Thanks and best regards,
Guest_
Answer:
ITs in TST_FROM and TST_TO only.
If you have 0 then service contract also has 0
Check for aPPT_TYPe = contstart and contend.
Also try to open that contract from SAPGUI.
if you can find the dates there then these dates should be same for the Contract guid.
Answer:
Hello sreedhar53,
in Service contract durations have values (3 MONTH, 2 Weeks),
but in database table SCAPPTSEG durations have 0.
Date Types Contstart and Contend in table SCAPPTSEG has values.
Thanks in advance,
Guest_
Answer:
How do you say that the contract start and end dates have values. but in the table scapptseg the values are 0.
Ok.. do one thing.. find the Transaction number for your contract.
then go to crmd_order_index table and search for that trasaction number and find the guid.
with this guid go and search in the scaaptseg for the application guid.
It should list two rows. if you can check the start and end dates in this this should correspond to that you have in the contract.
Let me know ur findings..
Answer:
Sorry
do the following.
Find the Contract guid.. using transaction number filter in CRMD_ORDER_INDEX table.
With that guid.. go to crmd_link table.
filter for GUID_HI as that ..
Get guid_set.. for OBJTYPE_SET = 30
Use that guidset and filter that in the scapptseg..
now analyze..
Answer:
Sorry ..
do the following..
Find the Guid of the Contract from the CRMD_ORDER_INDEX table.
using that GUID for filter for the field GUID_HI and object_type = '30' in the table CRMD_LINK.
Get the GUID_SET from that..
use that guid to filter SCAAPTSEG for that APPL_GUID.
You will probably will get 3 records with APPT_TYPE as contstart, contend and contdura.. Even if cont dura =0.. the start and end are fetched form the other..
hope thhis helps..
Ok let me know ur findings..