Entering content frame

Dummy text Order Revenues  Locate the document in its SAP Library structure

Technical name: 0ME_ISM_AM_REV_1

Technical Data

Type of DataSource

Transaction Data

Application Component

0IS_ME_AM

Available from OLTP Release

SAP Media 4.63

Available from Plug-In Release

 

RemoteCube compatibility

No

Prerequisites

You have installed the industry-specific component SAP Media, since the DataSource is only available in this component.

You have activated the DataSource in Customizing.

Activity

Menu path

Activate DataSource

Integration with Other mySAP.com Components Data Transfer to the SAP Business Information Warehouse Business Content DataSources Transfer Business Content DataSources

Use

This DataSource provides you with data in the order (values) for which revenue distribution has taken place.

You can define whether an update in the key date tables is to be performed for order and/or billing document revenue recognition in the Customizing settings for the DataSource. You can use these tables to perform restructuring in SAP BW without losing changes that have been made to the documents.

Activity

Menu path

Make settings for the DataSource

SAP Media Information System Evaluations in Advertising Management Business Information Warehouse Revenue Recognition Key Dates

Delta Update

The DataSource supports the ABR (After Image, Before/Reverse Image) delta process, which provides a full delta of changed data with deletion indicators via the delta queue.

Before you can use the delta update function, you must make the following settings in Customizing:

Activity

Menu path

Select the indicator BW active for IS-M/AM.

SAP Media General Settings Maintain General IS-M Control Parameters

Fields of Origin in the Extract Structure

Field in extract structure

Description of field in the extract structure

Table of origin

Field in table of origin

EOBPO

IS-M/AM: Revenue object document item

JHTEWE

EOBPO

EVBWTYP

IS-M/AM: Valuation category in revenue distribution

JHTEWE

EVBWTYP

EVBWKEY

IS-M/AM: Variable valuation key for RD

JHTEWE

EVBWKEY

KWERT_EV

IS-M/AM: Condition value in revenue distribution

JHTEWE

KWERT_EV

SAKN1_EV

IS-M: Actual P&L account

JHTEWE

SAKN1_EV

SAKN2_EV

Interim account for revenue deferral

JHTEWE

SAKN2_EV

KTOPL

Chart of accounts

JHAREV1

KTOPL

REF_BELID

IS-M/AM: Document number of the document object for which revenue distribution has been performed

JHTEK

REF_BELID

REF_POSID

IS-M/AM: Item number of the document object for which revenue distribution has been performed

JHTEK

REF_POSID

REF_BELTYP

IS-M/AM: Document category for which revenue distribution has been performed

JHTEK

REF_BELTYP

REF_WAERS

SD document currency

JHTEK

REF_WAERS

UVEVB

IS-M: Incompleteness status of a revenue object document

JHTEK

UVEVB

EVOBJ

IS-M/AM: Revenue object

JHTEP

EVOBJ

PFOBJ

IS-M/AM: Partner object

JHTEP

PFOBJ

BDJPOPER

IS-M: Posting year and posting period (format YYYYMMMM)

JHTEP

BDJPOPER

AUFNR

Order number

JHTEP

AUFNR

KOSTL

Cost center

JHTEP

KOSTL

PAOBJNR

Number of the profitability segment (CO-PA)

JHTEP

PAOBJNR

KOKRS

Controlling area

JHAREV1

KOKRS

PERIV

Fiscal year variant

JHAREV1

PERIV

STORNO_KZ

IS-M: Reverse leading sign BW

 

Charge-off extractor internally

AVM_NR

IS-M/AM: Sales document number

JHAE

AVM_NR

GPAG

IS-M: Business partner key

JHAK

GPAG

POS_ART

IS-M: Order-publishing-media item type

JHAP

POS_ART

UR_BELEINH

IS-M: Initial booking unit for the OPM item

JHAEA

UR_BELEINH

BELEGEINH

IS-M/AM: Booking unit

JHAEA

BELEGEINH

VKORG

Sales organization

JHAK

VKORG

VTWEG

Distribution channel

JHAK

VTWEG

SPART

Division

JHAK

SPART

VKBUR

Sales office

JHAK

VKBUR

REGULIERER

IS-M: Payer

JHAGA

REGULIERER

INSERENT

IS-M: Advertiser

JHAGA

INSERENT

XFAKT_EE

IS-M: Billed indicator

JHAGA

XFAKT_EE

BER_TERMIN

IS-M: Service creation date from a settlement perspective

JHAGA

BER_TERMIN

VBTYP

Sales document category

JHAK

VBTYP

AUART

IS-M: Sales document type

JHAK

AUART

AUGRU

Reason for order (reason for procedure)

JHAK

AUGRU

VKGRP

Sales group

JHAK

VKGRP

GSBER

Business area

JHAK

GSBER

AVM_HRKNFT

IS-M/AM: Order origin

JHAK

AVM_HRKNFT

VERMITTLER

IS-M: Sales agent with ID for screen

JHAK

VERMITTLER

POS_NR

IS-M: Order-publishing-media item number

JHAGA

POS_NR

BRAN_PAM

IS-M: Current industry sector for the order item

JHAP

BRAN_PAM

KAMPAGNE

IS-M: Campaign (for the customer)

JHAP

KAMPAGNE

INHK_TECH1

IS-M: Technical content component (positioning perspective)

JHAPA

INHK_TECH1

INHK_TLEV1

IS-M: Level 1 content component in the hierarchy

JHAPA

INHK_TLEV1

INHK_TECH2

IS-M: Special publication content component

JHAPA

INHK_TECH2

INHK_KFM

IS-M: Business content component

JHAPA

INHK_KFM

AZART_PLAZ

IS-M: Type of ad with regard to general positioning

JHAEA

AZART_PLAZ

KONKAUS

IS-M: Competitor exclusion

JHAPA

KONKAUS

PRODH

IS-M/AM: Product hierarchy

 JHAPA

PRDH

SI_TYP

IS-M: Ad insert category

JHAPS

SI_TYP

MATNR

IS-M: Material number for service

JHAPD

MATNR

DIENTYP

IS-M: Service type

JHAPD

DIENTYP

DIEN_BE

IS-M/AM: Service: Assigned booking unit

JHAPD

DIEN_BE

DIEN_IKO

IS-M/AM: Service: Assigned content component

JHAPD

DIEN_IKO

XTECH_MIN1

IS-M: Technical processing started (at least one schedule line processed)

JHAPW

XTECH_MIN1

XTECH_EE

IS-M: Technically complete (All schedule line processed completely)

JHAPW

XTECH_EE

GPNR_RECH

IS-M Business partner bill-to party

JHAGA

GPNR_RECH

PSTYV

IS-M: Sales document item category

JHAP

PSTYV

BER_HEFT

IS-M: Copy number for service creation from a settlement perspective

JHAGA

BER_HEFT

VAVARTYP

Actual issue variant type

JHAGA

VAVARTYP

IHKOMP

IS-M: Content component from price hierarchy

JHAGA

IHKOMP

SEITE_FSP

IS-M: Page/column format

JHAGA

SEITE_FSP

SEITE_FORM

IS-M: Page format

JHAGA

SEITE_FORM

SFSP_ABR

IS-M: Column format for settlement

JHAGA

SFSP_ABR

WERBK_TYP

IS-M: Combination sale type

JHAGA

WERBK_TYP

AZART_GEST

IS-M: Design ad type

JHAGA

AZART_GEST

AZART_FORM

IS-M: Shape ad type

JHAGA

AZART_FORM

AZART_FARB

IS-M: Color scheme ad type

JHAGA

AZART_FARB

AZART_SOND

IS-M: Special handling ad type

JHAGA

AZART_SOND

XSTORNIERT

IS-M: Order object reversed indicator

JHAGA

XSTORNIERT

STORNOGRND

IS-M: Reversal reason

JHAGA

STORNOGRND

INHK_KLEV1

IS-M: Level 1 content component in JSBW hierarchy

JHAPA

INHK_KLEV1

BNAME

IS-M: Name of the ordering party JSBW

JHAP

BNAME

GRUPPABRNR

IS-M:  Billing dataset

JHAGA

GRUPPABRNR

BOOK_OL

IS-M/AM: Booking type for online advertising

JHAPO

BOOK_OL

SELDAT_VON

IS-M: Start date for item

JHAPA

SELDAT_VON

SELDAT_BIS

IS-M: End date for item

JHAPA

SELDAT_BIS

WERBK_KNZ

IS-M: Combination sale indicator

JHAGA

WERBK_KNZ

WS_TIMESLC

IS-M: Commercial time slice

JHAEW

WS_TIMESLC

WS_BLOCK

IS-M: Commercial cluster

JHAEW

WS_BLOCK

WS_STELLE

IS-M: Position (sequence) within a commercial cluster

JHAEW

WS_STELLE

FORMAT_ONL

IS-M/AM: Format proposal (online)

JHAEO

FORMAT_ONL

XAEPROV

IS-M: Agency commission credit memo indicator

JHAGA

XAEPROV

IKO_STAT

IS-M: Statistics content component

 

Determined in the DS

BEGRP_STAT

IS-M: BU grouping for statistics

 

Determined in the DS

TERM_TYP

IS-M: Copy number/publication date date category

JHAGA

TERM_TYP

STGVB_PAM

IS-M: Statistics group for sales documents

TJHAKPZ

STGVB_PAM

ERFDATE

Created on

JHAGA

ERFDATE

AENDATE

Date of last change

JHAGA

AENDATE

CAMPAIGN

IS-M: Marketing campaign

JHAP

CAMPAIGN

CAMPAIGN_PSP

Work breakdown structure element (WBS element)

 

Determined in the DS

REF_VBELN

IS-M/AM: Billing document

JHAGA

REF_VBELN

REF_POSNR

IS-M/AM: Item (number) in the settlement document

JHAGA

REF_POSNR

RRREL

IS-M/AM: Revenue recognition category

JHAGA

RRREL

BW_STICHTAG

IS-M/AM: Key date for BW key date logic

 

Determined in the DS

 

 

Leaving content frame