field only... option in the datasource

[Former Member]

Hi BW Experts,

When is the "Field known only in Exit" option in the datasource used. Can anyone plz explain this with a real time scenario.

Thanks in advance,

regards,

Vamshi

[Former Member · Accepted solution]

from help.sap

Field only known in exit

You can enhance data by extending the extract structure for a DataSource using fields in append structures.

The indicator Field only known in exit is set for fields of an append structure. In other words, by default these fields are not passed onto the extractor from the field list and selection table.

Deselect the indicator Field only known in Exit to enable the BW Service API to pass on the field of the append structure to the extractor together with the fields of the delivered extract structures in the field list and selection table.

Regards

[Former Member · Accepted solution]

Hi Paolo,

Thanks for the time & prompt reply,

I have gone through the help but can i have some thing more in detail which explains this option in the datasource, i think it can be better explained with an real time example.

regards,

Vamshi

[Former Member · Accepted solution]

Go To T-Code SE11 and open the extract structure DTFIAR_3 . Click on Append structure button to create append structure . Enter component as BKTXT and component type BKTXT for 1 st field . Enter componet as ZALDT and component type as DZALDT for 2nd field . Activate the append structure .

Go to T-code RSA6 .

Select data source 0FI_AR_4 and remove the tick in hide checkbox for fields BKTXT and ZALDT .

Enahancment of first field BKTXT is easy because all the key fields of table BKPF ( BUKRS , BELNR and GJAHR) are present in the extract structure .

You can select a unique record from BKPF for the key combination.

In the source system...Create an append structure to the std datasource's extract structure..then add fields in the append structure.The Z-fields can be named like 'ZZ<field-name>'.(For the data-element,use same data element as that of the fields from where you will pick the data..so that format problems are avoided)Save and activate the append structure and also the datasource extract structure.Added z-fields are hidden by default.Now go to tcode rsa6 and find the std datasource.Click on change button and unhide the added z-fields..but do not remove the checkbox for 'fields known in customer exit'.Now u will have to write user exit in tcode CMOD.Go to CMOD and enter the project name for BW.Then choose radio button components.4 user exits will come up.

Use 2nd one for master data attributes enhancements.You will have to loop on C_T_DATA(or I_T_DATA) and modify it with derived values for the z-fields.Save and activate exit.Then do extract check in rsa3.See that z-fields getting derived OK.In BW,try to find if BC infoobjects available for the required additional attributes.Go to change mode in the std main infoobject and add the new attr at the end.Then replicate datasource in BW,map the transfer and update rules and then load data.Done.Hope I havent missed anything.You dont have an existing project and u have to create one.Select a good name for a project..say ZBIW..and then enter the name and click on create button.It will take u to new screen.There give short text for project name.Above u will see 'enhancement assignments' button.Click it and in the new screen add enhancement RSAP0001.Save and remember to activate project too..(save in appropriate transport request)Then if u click the components button u will see the 4 user exits..Choose the documentation radio button and u will get purpose of all 4 exitsEnahncing the Data Source is nothing but adding fields to DS. and we need to populate the data for the 2 fields through the ABAP Coding.1. go to RSA6 select DS go with Enhance DS, System will propose structure name click on enter. Then it will take you to the Data Dictionary Structure Maintainenance screen provide the field names that's not available in the Standard one.2. Activate the Structure.3. go to CMOD. check is there any projects available for BW. Press F4 ...you could see all the Projects. If not create one.provide enhancement assignment RSAP0001. click on components. select 1st function module(for Transactional DS). it contains one include, we need to write code in that include.Note: if RSAP0001 already assigned to any project we can't assign twice. we need to write the in the existing project.Search in the forum for enhancements you will get lot of material.Tell me which fields we need to enhance i can helpyou outto write the code if you don't know ABAP.Here is one more issue.the fields AMOUNT IN LOCAL CURRENCY (BSEG-WRBTR) and DOCUMENT HEADER TEXT (BKPF-BKTXT) are not present in the DATASOURCE 0FI_AR_4.can you check this code and let me know. I'm expecting the appended new fields are ZZBKTXT and ZZDMBTR. One more thing you gave field for amount in Documetn Currency.