Explore topic-wise InterviewSolutions in .

FULL, IMT of DELTA and delta.

Full, imt of delta and delta.

Assume that you have done mit of DELTA and deltas for an ODS; you find that there is a problem with certain loaded data and you would like to do a full LOAD without destroying the delta IMTS; you first do a selective deletion of the data from ODS and schedule a full load with this SELECTION and make it REPAIR request (Scheduler -> Repair full request).

Assume that you have done mit of delta and deltas for an ODS; you find that there is a problem with certain loaded data and you would like to do a full load without destroying the delta imts; you first do a selective deletion of the data from ODS and schedule a full load with this selection and make it repair request (Scheduler -> Repair full request).

a. new status only; this sends RECORDS of changed records; only ODS and cube can not be used.
b. additive delta — just change in key figures is SENT; can be used in ODS and in cube.

a. new status only; this sends records of changed records; only ODS and cube can not be used.
b. additive delta — just change in key figures is sent; can be used in ODS and in cube.

Instead of updating entire DATA, SAP USES a change log (for BUSINESS content extractor and TIME stamp (CO-PA) to do delta update.

Instead of updating entire data, SAP uses a change log (for business content extractor and Time stamp (CO-PA) to do delta update.

RSA7.

RSA7.

BSIK — OPEN INVOICES and BSAK — CLEARED invoices.

BSIK — Open invoices and BSAK — cleared invoices.

BSID — OPEN INVOICES and BSAD — CLEARED invoices.

BSID — Open invoices and BSAD — Cleared invoices.

a. manual input.
b. fill up from OLAP variables — USE variables CREATED in BEX .
c. ABAP routine.

a. manual input.
b. fill up from OLAP variables — use variables created in Bex .
c. ABAP routine.

a. Install XML 3.0 parser
b. Create an info source
c. Assign PC file as DATA source
d. Create transfer and communication structure and activate
e. From transfer structure screen select Extras -> Create BW datasource with SOAP application
f. After successful generation, the data source is connected to myself datamart; the name of the data source is 6A*
G. Create an info package
h. Load data from xml file

a. Install XML 3.0 parser
b. Create an info source
c. Assign PC file as data source
d. Create transfer and communication structure and activate
e. From transfer structure screen select Extras -> Create BW datasource with SOAP application
f. After successful generation, the data source is connected to myself datamart; the name of the data source is 6A*
g. Create an info package
h. Load data from xml file

a. “F’ — Flat file provides delta.
b. “A” — USES ALE.
c. “D” — Application DETERMINES the delta queue; example LO.
d. “E” — Extractor determines delta; example CO-PA, LIS.

a. “F’ — Flat file provides delta.
b. “A” — uses ALE.
c. “D” — Application determines the delta queue; example LO.
d. “E” — Extractor determines delta; example CO-PA, LIS.

Use table ROOSOURCE; the DELTA column shows the delta METHOD (A — ALE, E- Extractor, etc); the value AIM DESCRIBES type of delta LIKE Fl for function MODULE, V — view, Q — infoset query.

Use table ROOSOURCE; the delta column shows the delta method (A — ALE, E- Extractor, etc); the value AIM describes type of delta like Fl for function module, V — view, Q — infoset query.

From table RODELTAM.

From table RODELTAM.

a. Create the RFC connection (SM59) and test it with datastage system
b. Define the job in data stage
C. Create a source system (type third party)
d. Load transfer structure from BW
e. Map columns to BW structure
F. Define and load info package.

a. Create the RFC connection (SM59) and test it with datastage system
b. Define the job in data stage
c. Create a source system (type third party)
d. Load transfer structure from BW
e. Map columns to BW structure
f. Define and load info package.

This is the process in which you run the mit of delta and LOAD the delta queue in parallel; the LO EXTRACTION supports this; you use this option in the INFO package screen.

This is the process in which you run the mit of delta and load the delta queue in parallel; the LO extraction supports this; you use this option in the info package screen.

a. define the properties
b. create class types; this controls the classes assigned to them; for example class type can be material
C. create classes and assign to a class type; for example class could be digital cameras
d. assign objects
e. now searches can be done on classes; for example get all the cameras with 3.0 MEGA pixels.
f. These values are transferred to BW as Omaterial attributes

a. define the properties
b. create class types; this controls the classes assigned to them; for example class type can be material
c. create classes and assign to a class type; for example class could be digital cameras
d. assign objects
e. now searches can be done on classes; for example get all the cameras with 3.0 mega pixels.
f. These values are transferred to BW as Omaterial attributes

To GROUP OBJECTS TOGETHER; improves in searching, etc.

To group objects together; improves in searching, etc.

SBIW and SELECT MAINTAIN data source for classification data.

SBIW and select maintain data source for classification data.

a. SELECT the data source for ASSIGNING classes; example select OMATERIAL_A1TR .
b. select the class.
c. generate the data source; a PREFIX 1CL is added to the data sources generated.

a. select the data source for assigning classes; example select OMATERIAL_A1TR .
b. select the class.
c. generate the data source; a prefix 1CL is added to the data sources generated.

a. execute transaction RSO2
b. select the data source NAME and description
c. select a table, view or a SAP query/info set for the source for data
d. flag the fields for selection
e. flag the fields to be hidden
f. activate the data source
g. replicate, assign info source, define communication STRUCTURE and transfer rules; create info package and LOAD data.

a. execute transaction RSO2
b. select the data source name and description
c. select a table, view or a sap query/info set for the source for data
d. flag the fields for selection
e. flag the fields to be hidden
f. activate the data source
g. replicate, assign info source, define communication structure and transfer rules; create info package and load data.

a. In the create data source screen, click on the generic delta button
b. Type the delta specific field; SELECT whether this is time stamp, calendar day or numeric POINTER.
c. Specify safety interval
d. Select delta type — New STATUS for changed records -> this is after image which can be used with ODS; Additive Delta — aggregated records
e. Generate the data source
f. Now you will see the delta FLAG being enabled

a. In the create data source screen, click on the generic delta button
b. Type the delta specific field; select whether this is time stamp, calendar day or numeric pointer.
c. Specify safety interval
d. Select delta type — New status for changed records -> this is after image which can be used with ODS; Additive Delta — aggregated records
e. Generate the data source
f. Now you will see the delta flag being enabled

RMCSBIWC.

RMCSBIWC.

LOGISTICS Information System; USED in R13 for reporting so that reporting PROGRAMS will not SLOW down ONLINE transactions.

Logistics Information System; used in R13 for reporting so that reporting programs will not slow down online transactions.

2_US_01_Sxxx where XXX is the US table NAME.

2_US_01_Sxxx where xxx is the US table name.

The entire DATA from the S table EXAMPLE S301 is WRITTEN to the info PROVIDER;

The entire data from the S table example S301 is written to the info provider;

DELTA is EXTRACTED from one of the BIW TABLES DESCRIBED before.

Delta is extracted from one of the BIW tables described before.

a. run transaction RMCSB1WC
b. set up the US environment
c. Generate the data source; in this select the fields for selections and mark fields as hidden and cancellation fields.
d. Generate the update PROGRAM for Delta
e. REPLICATE the data source, assign info source, MAINTAIN communication structure and transfer rules, create info package.
f. Do the mit of delta on BW side
g. Activate the Delta
h. Start LOADING the delta info packages on BW.

a. run transaction RMCSB1WC
b. set up the US environment
c. Generate the data source; in this select the fields for selections and mark fields as hidden and cancellation fields.
d. Generate the update program for Delta
e. Replicate the data source, assign info source, maintain communication structure and transfer rules, create info package.
f. Do the mit of delta on BW side
g. Activate the Delta
h. Start loading the delta info packages on BW.

During ut of delta, the data is extracted from the S tables DIRECTLY; the delta update programs when activated, START collecting delta data and populates into ONE of the SB1W tables (1 or 2); during delta update on BW either one of these tables is read and data is extracted.

During ut of delta, the data is extracted from the S tables directly; the delta update programs when activated, start collecting delta data and populates into one of the SB1W tables (1 or 2); during delta update on BW either one of these tables is read and data is extracted.

a. improved performance and reduced volume
b. no US functionality meaning you don’t need to SETUP US on R/3
C. single solution for all LOGISTICS applications
d. no 2 table use like in LIS
e. detailed EXTRACTION
f. only data that are changed from BW perspective are added in the delta queue
g. updated with batch process (V3 update)

a. improved performance and reduced volume
b. no US functionality meaning you don’t need to setup US on R/3
c. single solution for all logistics applications
d. no 2 table use like in LIS
e. detailed extraction
f. only data that are changed from BW perspective are added in the delta queue
g. updated with batch process (V3 update)

SM 13.

SM 13.

2LIS_nn_xxxxx where nn is the NUMBER and xxxx is the source of DATA; example
2LIS_12_VAHDR for SALES DOCUMENT header.

2LIS_nn_xxxxx where nn is the number and xxxx is the source of data; example
2LIS_12_VAHDR for sales document header.

a. LBWE — Customizing COCKPIT,
b. LBWF - BW log
c. LBWG — Delete setup TABLES
d. OLI*BW — Initialization/Setup

a. LBWE — Customizing cockpit,
b. LBWF - BW log
c. LBWG — Delete setup tables
d. OLI*BW — Initialization/Setup

This is for mit of delta similar to refreshing the LIS STATISTICAL DATA; when you do this the data tables like VBAK are FILLED into relevant communication structure; this data is stored in cluster tables <extraction Structure>_Setup from where they are READ when mit of delta is done on BW.

This is for mit of delta similar to refreshing the LIS statistical data; when you do this the data tables like VBAK are filled into relevant communication structure; this data is stored in cluster tables <extraction Structure>_Setup from where they are read when mit of delta is done on BW.

SET up table is used MAINLY to do FULL UPDATE or MIT of Delta.

Set up table is used mainly to do Full update or mit of Delta.

a. S263 order DELIVERY LIS is converted to ITEM and scheduling lines LO DATA SOURCES (MCi 1V_O1TM and MC1 1V_OSCL).
b. S262 billing is converted to VD header and VD item (MC13VDOHDR and MC 1 3VDOITM).

a. S263 order delivery LIS is converted to item and scheduling lines LO data sources (MCi 1V_O1TM and MC1 1V_OSCL).
b. S262 billing is converted to VD header and VD item (MC13VDOHDR and MC 1 3VDOITM).

a. issues with posting MULTIPLE updates within a second.
b. issues with multiple language in serialized V3 update.

a. issues with posting multiple updates within a second.
b. issues with multiple language in serialized V3 update.

a. DIRECT delta — data is transferred to BW delta queue for each document posting; useful for low volume CUSTOMERS.
b. queued delta — extraction data is collected for the affected application instead of being collected in an extraction queue; serialization is ensured; for large volume customers .
c. non serialized V3 UPDATE — the data in the updating run are read without regard to the SEQUENCE from update TABLES.

a. direct delta — data is transferred to BW delta queue for each document posting; useful for low volume customers.
b. queued delta — extraction data is collected for the affected application instead of being collected in an extraction queue; serialization is ensured; for large volume customers .
c. non serialized V3 update — the data in the updating run are read without regard to the sequence from update tables.

You create multiple BATCH JOBS with DIFFERENT selection criteria; for example when you do setup table for SD, USE different document NUMBER ranges and do the setup in parallel.

You create multiple batch jobs with different selection criteria; for example when you do setup table for SD, use different document number ranges and do the setup in parallel.

a. S260 Sales ORDER and S264 Request =&GT; VA header, Item and Unit
b. S261 Delivery => VC Header, Item and Unit
c. S262 BILLING => VD Header and VD item.

a. S260 Sales order and S264 Request => VA header, Item and Unit
b. S261 Delivery => VC Header, Item and Unit
c. S262 Billing => VD Header and VD item.

CO-PA is HIGHLY CUSTOMIZABLE and value fields and characteristics are DEFINED differently between CUSTOMERS, SAP has given CO-PA as a GENERIC extraction which can be customized.

CO-PA is highly customizable and value fields and characteristics are defined differently between customers, SAP has given CO-PA as a generic extraction which can be customized.

This is to GROUP COMPANIES.

This is to group companies.

This is a ORGANIZATIONAL STRUCTURE which GROUPS CONTROLLING AREAS.

This is a organizational structure which groups controlling areas.

These are DEFINED as LEVELS where information is maintained; example customer GROUPS, DIVISIONS, etc.

These are defined as levels where information is maintained; example customer groups, divisions, etc.

These are the values in the CHARACTERISTICS; for example if you take customer GROUPS it could be national chains, RETAILERS, ETC.

These are the values in the characteristics; for example if you take customer groups it could be national chains, retailers, etc.

This is DEFINED as a combination of characteristics values and it is FIXED EXAMPLE Over the counter medicines, NATIONAL chains.

This is defined as a combination of characteristics values and it is fixed example Over the counter medicines, National chains.

Some characteristics LIKE COMPANY code, MATERIAL and CUSTOMER are predefined.

Some characteristics like company code, material and customer are predefined.

50.

50.

Key FIGURES LIKE QUANTITY sold, costs, etc are called value FIELDS.

Key figures like quantity sold, costs, etc are called value fields.

BW updates RECORDS only at LEAST 30 minutes old.

BW updates records only at least 30 minutes old.

CO_PA_<SYS>_<CLIENT>_<OPC0N> - where sys — system ID, client - client number and opcon — OPERATING concern NAME.

CO_PA_<SYS>_<CLIENT>_<OPC0N> - where sys — system ID, client - client number and opcon — operating concern name.

Not all the FIELDS are REPLICATED; some fields are CONVERTED into BW fields; the WEEK ALTPERIO is converted into OCALWEEK.

Not all the fields are replicated; some fields are converted into BW fields; the week ALTPERIO is converted into OCALWEEK.