Friday, May 8, 2009

Note 428147 - Extraction of data from an SNP planning area

Note 428147 - Extraction of data from an SNP planning area

Summary

Symptom

When extracting data from an SNP planning area, you must take account of some special features. These are explained in this note.


Solution
    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

Software
Component
Release
From
Release
To
Release
And
subsequent
SAP_APO
30
30A
30A

SAP_APO
310
310
310

SCM
400
400
400

SCM
410
410
410

SCM
415
415
415

SCM
500
500
500

SCM
510
510
510

Related Notes




1045639 - Consulting notes in SNP/CTM

837004 - Values from auxiliary key figures are not extracted

657774 - SNP data extraction: Error "Invalid data status"

549184 - FAQ: What is important for extraction

540571 - Collective consulting note on data extraction in DP

453644 - No use of navigation attributes in SNP

441653 - SNP: Data extraction to transportation lanes

373756 - Data extraction from a planning area

No comments: