Insert data in DSO manually

[Former Member]

I have a Standard DSO and I load from file and it's ok.

My problem is that I need to insert data manually from abap program. this is working ok so far, the line is added in the active table of my DSO but in the query this register does not appear. Any idea?

[Former Member · Accepted solution]

Does the data you're loading into the DSO need SIDs? If there are no SIDs for it, that might explain why it doesn't show up in the query.

[Former Member · Accepted solution]

My DSO has no SID field.

The registers loaded from file are shown in the query but the register that I insert manually is not. And none of them has SID.

Could it have something to do with the log table of the DSO? because when the load is from file the data is inserted in the log table but when I insert data manually I only insert data in active table and not in log table of DSO.

Thanks.

[Former Member · Accepted solution]

If you write directly to a DSO and do not maintain the change log, the data should still be reportable from the DSO. But you will have broken the delta mechanism. If you're not using the DSO to generate deltas, it shouldn't be a problem.

How is the DSO defined? Do you have the "SID Generation Upon Activation" checkbox checked? If so, the SIDs on data that you load normally will be generated.

[Former Member · Accepted solution]

I just took a DSO where the SID flag is off. I deleted all the data. Then I inserted one row via an ABAP program. That row is reported by the query designer.

You might want to make sure via SE11, or "Display Data" in RSA1, that the rows that you enter manually are truly there. And check your ABAP program.

[Former Member · Accepted solution]

DSO load full not delta. The flag is checked. Any idea?

[Former Member · Accepted solution]

Is your DSO standard or direct write?. In the program do you use BAPI/FM or "insert command"?

[Former Member · Accepted solution]

It is a standard DSO, not a direct write. No BAPI, just straight SQL.

REPORT zjc_temp.

data: g_s_zfora1d type /bic/azfora1d00.


g_s_zfora1d-/BIC/ZCOMPANY = '500'.
g_s_zfora1d-/BIC/ZCCNTR = '018500'.
g_s_zfora1d-/BIC/ZENDCODE = '036666'.
g_s_zfora1d-FISCPER  = '2006010'.
g_s_zfora1d-FISCVARNT = 'Z0'.
g_s_zfora1d-CHRT_ACCTS = '1000'.
g_s_zfora1d-CREDIT = 2000.
g_s_zfora1d-DEBIT = 4000.
g_s_zfora1d-CURRENCY = 'USD'.
g_s_zfora1d-RECORDMODE = ' '.

insert /bic/azfora1d00 from g_s_zfora1d.

[Former Member · Accepted solution]

Interesting, I just tried the same thing on a DSO with the SID flag checked on, and it did not work.

That could mean that it is the SID flag.

If it is a Dev system, you could try unchecking it.

[Former Member · Accepted solution]

Ok, I have unchecked the flag and this works better but still not properly.

Now, the problem is that if I execute the abap program that insert the register, this register cannot be seen in the query until I load from DTP.

[Former Member · Accepted solution]

Ok, it's work fine.

Thanks