cancel
Showing results for 
Search instead for 
Did you mean: 

Structure of flat file for loading demo cube 0D_DECU?

Former Member
0 Kudos

Hi everyone,

I'm attempting to load up the SD Demo cube in BI 7.0 using the provided 0D_DECU_TRDAT.CSV file. However, the demo transfer structure does not seem to match the file layout. Does anyone have a mapping of the columns in this CSV file?

Here is an example row in the CSV:

2000;10;7;M01;13000100;1710;1000;2000;0;22;ST;1313;CAD;1796;198;20040224

Thanks for any help.

Wang

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Could you post the error that you got when try to preview the file?

Regards

Former Member
0 Kudos

Hi - I had a unit conversion error on one of the fields. It was obvious that the SAP Demo delivered transfer structure didn't match the provided CSV file. Got it to work after tweaking a bit and will post the mapping here shortly. FYI - the last field - VTYPE (value type) - is not provided in the CSV file. For my purposes, I left that infoobject unpopulated in the cube. Thanks.

Former Member
0 Kudos

Just in case anyone needs it, below is the mapping that I used for the 0D_DECU transfer structure. Prefix each tech name with an "0" to get the InfoObject. Note that Value Type is not available from the CSV demo file delivered with BI Content 7.0 (Release 703, Level 0005).


D_CO_CODE	Company code
D_DIS_CHAN	Distribution channel
D_DIV	Division
D_MATERIAL	Material
D_PROD_HIE	Product hierarchy
D_SALE_EMP	Sales Personnel
D_SALE_ORG	Sales organization
D_SOLD_TO	Sold-to party
D_VERSION	Version
D_INV_QTY	Billed Quantity
SALES_UNIT	Sales unit
D_COST	Costs (SAP Demo)
DOC_CURRCY	Document currency
D_NETVLINV	Net Value
D_TAXAMOUN	Tax Amount
CALDAY	Calendar Day
D_VTYPE	Value Type