Note 428147 - Extraction of data from an SNP planning area
Summary
When extracting data from an SNP planning area, you must take account of some special features. These are explained in this note.
- 1. Data can be extracted only for existing SNP aggregates.
Existing SNP aggregates are:
- 9AAC (9AACTNAME - APO Activity)
- 9AACPR (9AACTNAME, 9APPMNAME - APO PPM/PDS Name)
- 9ALA (9ATRNAME - APO Transportn Lane)
- 9ALO (9ALOCNO - APO Location)
- 9ALORE (9ALOCNO, 9ARNAME - APO Resource)
- 9AMA (9AMATNR)
- 9AMALA (9AMATNR, 9ATRNAME)
- 9AMALARE (9AMATNR, 9ARNAME, 9ATRNAME)
- 9AMALO (9ALOCNO, 9AMATNR)
- 9AMALORE (9ALOCNO, 9AMATNR, 9ARNAME)
- 9AMAPR (9AMATNR, 9APPMNAME)
- 9AMARE (9AMATNR, 9ARNAME)
- 9APR (9APPMNAME)
- 9ARE (9ARNAME)
- 9AREPR (9APPMNAME, 9ARNAME)
Only the characteristic/characteristic combinations contained in these aggregates may be used in the InfoSource, transfer structure and transfer rules.The simplest way of doing this is by always generating Export-DataSources for SNP planning areas to one of the aggregates and not to the Basis planning object structure '9ASNPBAS'.A typical result of using the Basis planning object structure '9ASNPBAS' without correcting the transfer structure is that, while data is transferred to a RemoteCube, it cannot be extracted in a BasisCube.
As of APO 3.0 Support Package 17 (or note 443613), only export DataSources for aggregates can be generated in SNP planning areas, they are no longer generated for the Basis planning object structure.
Furthermore, note that the navigation attributes 9ATTYPE, 9ALOCTO, and 9ALOCFROM up to APO 3.0 Support Package 17 (or note 441653) must be deleted from the transfer structure for the SNP aggregates '9AMALA' (9AMATNR/9ATRNAME) and '9AMALARE' (9AMATNR/9ATRNAME/9ARNAME). These navigation attributes can be used from the specified correction.
Due to technical restrictions the characteristics '9ATRNAME' and '9ATTYPE' can only be restricted with single values in the selection for the data extraction.The use of intervals and formatting characters (+/*) is not allowed for these characteristics.
- 2. For an SNP aggregate, only the key figures assigned to it can be extracted. You can see which key figures are assigned to an aggregate in transaction /SAPAPO/MSDP_ADMIN on the Key figure assignment tab of the relevant planning area. As of APO 3.0 Support Package 17 (or note 439366), only the key figures assigned to this aggregate are taken into account when an export DataSource is being generated for aggregates.
- 3. During the definition of queries, the following restrictions apply:
In the case of queries for the aggregate '9AMALA', certain key figures can only ever be extracted with another key figure.The key figure combinations that can only be extracted together are:
- (9AFSHIP, 9ADMDDF, 9ADMDDFVMI)
- (9AFSHIPLP, 9ADMDDFLP)
- (9AFSHIPVMI, 9ADMDDFVMI)
- (9APSHIP, 9ADMDDI, 9ADMDDIVMI)
- (9APSHIPLP, 9ADMDDILP)
- (9APSHIPVMI, 9ADMDDIVMI)
- (9ATSHIP, 9ADMDDT, 9ADMDDTVMI)
- (9ATSHIPVMI, 9ADMDDTVMI)
Header Data
Release Status: | Released for Customer |
Released on: | 02.01.2003 09:56:17 |
Master Language: | German |
Priority: | Correction with medium priority |
Category: | Consulting |
Primary Component: | SCM-APO-FCS-EXT Extraction |
Secondary Components: | SCM-APO-SNP Supply Network Planning (SNP) |
Affected Releases
|
Related Notes
No comments:
Post a Comment