| How to determine whether or not fields are being populated using transaction code ST05 |
|
Scenario: Business Content objects contain several fields that we (Whirlpool) are not using. You want to turn these fields “off” in the InfoSets that use them.
First, determine the name of the database table.
For master data Characteristic, you can use either transaction code RSA1 or RSD1 to navigate to the screen below.
|
 |
|
To determine DB2 table name for an ODS Object, go to transaction RSA1 or RSD1 and display the ODS Object.
Click on the “Information” icon (the blue “i") 
Click on “Dictionary/DB status” button
|
 |
|
The “active table” is the DB2 table name.
|
Then go to transaction code ST05
Click on button “Enter SQL Statement” |
|
|
Enter SQL Statement: Select * from sapr3."TABLENAME" . . . in this example, where table name equals /BI0/PCUSTOMER; i.e., Select * from sapr3."/BI0/PCUSTOMER" then click on “Explain” button.
|
|
|
Answer “Yes” to turn on parallelilsm.
|
|
Select (Highlight) the row on the ‘Table information” tab then click on “Col.card.” button.
|
|
|
Columns with a cardinality of “1” are potentially not being populated. It is also possible that all the rows have the same single value (also a cardinality of 1) such as field for Client (mandt) having all rows of value 510. Hint: You can use either the “Print” icon or the “Export” icon to save this list to a Local File.
|
|
To make sure that the “1” value is a null versus having one single value, navigate to transaction code SE16 (Data Browser).
Enter table name then click on “Table Contents” icon.
|
|
 Go to Settings à List Format à Choose Fields.
|
|
Deselect all Fields except the one you are checking then click on “Transfer” button.
|
|
 Click on “Execute” button.
|
|
 If all the values are null (characteristics) or zero (for key figures), then it is not being populated. In the example below, there is a cardinality of 1 value for the field “Latitude” and the 1 single value is always “0.000000000000”
|
|
|
|
|
Achieves
|
|
HOW TO RUN
EXTRACT IN NMP FOR CUSTOMER BUSINESS PARTNER XREF
|
|
How to Edit
Records in the PSA
|
|
How to create reports in sap portal
|
|
