Kontakt

Ansicht
Dokumentation

DataSources for Sales and Distribution (Enhanced) ( RELNSD_606_ANALYTICS_DS )

DataSources for Sales and Distribution (Enhanced) ( RELNSD_606_ANALYTICS_DS )

General Data in Customer Master   ROGBILLS - Synchronize billing plans  
This documentation is copyright by SAP AG.
SAP E-Book

Short text

DataSources for Sales and Distribution (Enhanced)

Use

As of SAP Enhancement Package 6 for SAP ERP 6.0 (SAP_APPL 606), Business Function Sales and Distribution, Analytics 01 (LOG_SD_ANALYTICS_01), you can use existing DataSources both for data replication in a BW system (SAP Business Warehouse) as was previously possible, and for analytics with direct access to an ERP system (operational data provisioning).

When you activate this business function, there are the following enhancements for DataSources:

  • The DataSources contain a new ODP extractor for operative reporting in the ERP system.
  • For some DataSources, the extract structures contain additional fields. Note the indexing information under Effects on System Administration.

DataSources with Additional Fields

The following overview lists the additional fields for the individual DataSources (database table - field).

Sales

  • 2LIS_11_VAHDR (Sales Document: Header Data)
    Net Value in Document Currency (VBAK-NETWR)
    Overall Rejection Status of all Sales and Distribution Document Items (VBUK-ABSTK)
    Overall Status of all Goods Movements (VBUK-WBSTK)
    Planning Handling of Contract Release Types (VBAK-ABDIS)
    Last Change Data (VBAK-AEDAT)
    Sales Probability of Item (VBAK-AWAHR)
    Shipping Condition (VBAK-VSBED)
    Employee Responsible (VBAK-PZPERS, partner role ZM)
    Overall Reference Status of all Items (VBUK-RFGSK)
    Status for Reference Document Header (VBUK-RFSTK)
  • 2LIS_11_VAITM (Sales Document: Item Data)
    Employee Responsible (VBAP-PZPERS, partner role ZM)
    Overall Reference Status (VBUP-RFGSA)
    Reference Status (VBUP-RFSTA)
    Root Item Date (ROOT_DATE, technical use)
    Root Header Document Number (ROOT_HEAD, technical use)
    Root Item Number (ROOT_ITEM, technical use)
  • 2LIS_11_VASCL (Sales Document: Schedule Line)
    Employee Responsible (VBAP-PZPERS, partner role ZM)
  • 2LIS_11_VAKON (Sales Document: Conditions)
    Employee Responsible (VBAP-PZPERS, partner role ZM)
    Overall Reference Status (VBUP-RFGSA)
    Reference Status (VBUP-RFSTA)

Allocation

  • 2LIS_11_V_ITM (Sales-Shipping: Allocation Item Data)
    Employee Responsible (VBAP-PZPERS, partner role ZM)
  • 2LIS_11_V_SCL (Sales-Shipping: Allocation Schedule Line)
    Employee Responsible (VBAP-PZPERS, partner role ZM)

For these structures, note the information on the ABR delta procedure.

Shipping

  • 2LIS_12_VCHDR (Delivery: Header Data)
    Employee Responsible (LIKP-PZPERS, partner role ZM)
    Delivery Priority (LIKP-LPRIO)
    Plant (LIKP-WERKS)
    Overall Status of all Goods Movements (VBUK-WBSTK)
    Overall Picking/Putaway Status (VBUK-KOSTK)
  • 2LIS_12_VCITM (Item Data)
    Employee Responsible (LIKS-PZPERS, partner role ZM)
    Overall Status of all Goods Movements (VBUK-WBSTK)
    Overall Picking/Putaway Status (VBUK-KOSTK)

Billing

  • 2LIS_13_VDHDR (Billing Document: Header Data)
    Net Value in Document Currency (VBRK-NETWR)
    Employee Responsible (VBRK-PZPERS, partner role ZM)
    Name of Employee who Created Billing Document (VBRK-ERNAM)
    Incoterms Part 1 (VBRK-INCO1)
    Incoterms Part 2 (VBRK-INCO2)
    Division (VBRK-SPART)
    Billing Document Posting Status (VBUK-BUCHK)
    Overal Processing Status of Sales and Distribution Document (VBUK-GBSTK)
  • 2LIS_13_VDITM (Billing Document: Item Data)
    Employee Responsible (VBRP-PZPERS, partner role ZM)
  • 2LIS_13_VDKON (Billing Document: Conditions)
    Employee Responsible (VBRP-PZPERS, partner role ZM)

ABR Delta Procedure

In the standard system, the delta update of the data records for the following extract structures is a combination of ABR and ADD delta procedures:

  • MC11V_0ITM - Sales-Shipping: Allocation Item Data
    Use in DataSource 2LIS_11_V_ITM - Sales-Shipping: Allocation Item
  • MC11V_0SCL - Sales-Shipping: Allocation Schedule Line
    Use in DataSource 2LIS_11_V_SCL - Sales-Shipping: Allocation Schedule Line

If the data is determined via the SAP NetWeaver Business Warehouse Accelerator (BWA), BWA indexing can only be performed correctly if you follow the ABR delta procedure throughout.
You must therefore specify that you want the extract structures extracting allocation data from delivery-relevant items to transfer the delta update entirely according to the ABR delta procedure.

The ABR images deliver the following data:

  • The after image delivers the data record after the change.
  • The before image delivers the data record before the change with a minus sign.
  • The reverse image also sends the data record with a minus sign, and at the same time marks it for deletion.

So that the system updates the changed data records entirely according to the ABR delta procedure, you must activate this function explicitly for each extract structure.
Activate the ABR delta procedure in Customizing for Sales and Distribution, under Operative Reporting -> Activate Analytics.

Effects on System Administration

Using selection programs, the system determines sales and distribution data requiring indexing in the Logistics Information System (LIS), and adds it to the setup tables. Before you start setup, ensure that no data is waiting to be posted.
For more information, refer to Customizing for Sales and Distribution, under Search and Operative Reporting -> Enterprise Search, in the Overview: Settings for Search with SAP Enterprise Search document.






SUBST_MERGE_LIST - merge external lists to one complete list with #if... logic for R3up   CPI1466 during Backup  
This documentation is copyright by SAP AG.

Length: 6968 Date: 20240604 Time: 065128     sap01-206 ( 71 ms )