Friday, November 23, 2007

SAP SD Standard InfoCubes and DataSources

Example of Standard InfoObjects::

0BILLTOPRTY - Bill-to party

0COMP_CODE - Company code

0DISTR_CHAN - Distribution channel

0DOC_CATEG - Sales document category

0PLANT - Plant

0SALESORG - Sales organization

0SALES_GRP - Sales group

0SALES_OFF - Sales office

0SHIP_TO - Ship-to party

0SOLD_TO - Sold-to party

0VERSION - Version

0VTYPE - Value type for reporting

0DIVISION - Division

0MATERIAL - Material number

0SHIP_POINT - Shipping point

0PAYER - Payer

0DOC_CLASS - Document class Order/Delivery/Invoice

0DEB_CRED - Credit/debit postings (C/D)

Example of Key figure Infoobjects:

Key Figures - InfoObject - Description

0SUBTOT_1S - Pricing subtotal 1 from pricing determination procedure in statistics currency

0SUBTOT_2S - Pricing subtotal 2 from pricing determination procedure in statistics currency

0SUBTOT_3S - Pricing subtotal 3 from pricing determination procedure in statistics currency

0SUBTOT_4S - Pricing subtotal 4 from pricing determination procedure in statistics currency

0SUBTOT_5S - Pricing subtotal 5 from pricing determination procedure in statistics currency

0SUBTOT_6S - Pricing subtotal 6 from pricing determination procedure in statistics currency

0OPORDQTYBM - Open order quantity in base unit of measure

0OPORDVALSC - Net open order value in statistics currency.

0DLV_QTY_BM - Actual delivered quantity in base unit of measure

0QUANT_B - Quantity in base unit of measure

0DOCUMENTS - Number of documents

0DOC_ITEMS - Number of document items

0NET_VAL_S - Net value in statistics currency

0COST_VAL_S - Cost in statistics currency

0GR_WT_KG - Gross weight in kilograms

0NT_WT_KG - Net weight in kilograms

0VOLUME_CDM - Volumes in cubic decimeters

0DOCUMENTS - Number of documents (document counter)

It is recommend that you only use the document counter along with characteristics from the document header (header characteristics). For example, 0SALES_ORG, 0DISTR_CHAN, 0BILLTOPRTY, 0SHIP_TO, 0SOLD_TO, 0PAYER, 0DOC_CATEG.

No comments:

Blog Archive