Skip to Content
0
Former Member
Jul 27, 2011 at 08:45 AM

COPA Datasource creation and Masterdata loading for characteristics

349 Views

HI,

I am creating a Costing based COPA datasource for client requirement.

There are fileds from

Characteristics from the segment level:

Currency type PALEDGER

Fiscal Year GJAHR

Period/year PERIO

Plan/Act. Indicator PLIKZ

Record Type VRGAR

Version VERSI

*Characteristics from the segment table:

Company Code BUKRS

Billing Type FKART

Brand KMBRND

Brand EXTWG

Business Area GSBER

CO Area KOKRS

Category WW010

Country LAND1

Customer KNDNR

Customer group KDGRP

Distr. Channel VTWEG

Division SPART

Material Group MATKL

Not Used-Level4 WW040

Plant WERKS

Prod.hierarchy PRODH

Product ARTNR

Product hierarchy WW050

Profit Center PRCTR

Sales Group KMVKGR

Sales Office KMVKBU

Sales Ord. Item KDPOS

Sales Order KAUFN

Sales Org. VKORG

Sales district BZIRK

Sales employee KMVTNR

Sub Group WW020

Sub Sub Group WW030

Vol. rebate grp BONUS

Characteristics from the line items:

Record Currency REC_WAERS

Billing Date FADAT

Canceled doc. STO_BELNR

Canceled item STO_POSNR

Cost Element KSTAR

Cost Object KSTRG

Document number BELNR

Goods Issue WADAT

Item number POSNR

Order RKAUFNR

Partner PC PPRCTR

Posting date BUDAT

Ref.doc.number RBELN

Reference item RPOSN

Sender BProc PRZNR

Sender cost ctr SKOST

WBS Element PSPNR

Value fields:

Administration Costs KWGOHD

Bonuses KWBONI

Customer Discount KWKDRB

Direct mat. costs KWMAEK

FOB Charges VV020

Freight KWFRGR

Gross sales KWBRUM

Insurance KWINSR

Miscellaneous chargs VV030

Other Charges VV010

Other Discounts RABAT

Other overhead KWSGEK

PAL/Packing charges VV040

Revenue ERLOS

Sales costs KWSOHD

Sales quantity ABSMG

Stock Value VRPRS

Calculated Key Figures from the Key Figure Scheme:

Sales unit COPASLQTU

Sales quantity COPASLQTY

Revenue COPAREVEN

Cust. discnt COPACDSCN

Base on the above characteristic fields how can i consider the infoobjects from BW to laod masterdata.

Do i need to consider the base tables for characteristics and for value fileds apart from CE1XXX,CE2XX,CE3XXX,CE4XXX tables.

Please give me your ideas on this.

Thanks,

Satya