Show TOC

 Billing Data

Technical name: 0BEA_CRMB

Technical Data

Type of DataSource

Transaction data

Application Component

Extraction billing data for CRM billing (CRM-BE-BD)

Available as of OLTP Release

CRM 3.0

Available as of PlugIn Release

Not applicable

RemoteCube-Compatible

Use

This DataSource contains the fields that are necessary for the extraction of information, from the billing data for CRM billing, to the corresponding BW Info Source.

Delta Update

You can carry out an initial upload, a complete upload, and a delta upload for this DataSource.

Origin Fields in the Extraction Structure

Field in Extraction Structure

Description of Field in Extraction Structure

Origin Table

Field in Origin Table

APPLICATION

Application

Constant 'CRMB'

BDH_GUID

GUID of a billing header

/1BEA/CRMB_BDH

BDH_GUID

BDI_GUID

GUID of a billing document item

/1BEA/CRMB_BDI

BDI_GUID

HEADNO_EXT

Billing document

/1BEA/CRMB_BDH

HEADNO_EXT

BILL_TYPE

Billing type

/1BEA/CRMB_BDH

BILL_TYPE

BILL_DATE

Billing date

/1BEA/CRMB_BDH

BILL_DATE

REF_CURRENCY

Reference currency

/1BEA/CRMB_BDH

REF_CURRENCY

DOC_CURRENCY

Document currency

/1BEA/CRMB_BDH

DOC_CURRENCY

MAINT_DATE

Processing date

/1BEA/CRMB_BDH

MAINT_DATE

MAINT_USER

Creator/last changed by

/1BEA/CRMB_BDH

MAINT_USER

RECORDMODE

BW delta process:update mode

ITEMNO_EXT

Billing document item (external identification)

/1BEA/CRMB_BDI

ITEMNO_EXT

ITEM_CATEGORY

Item category of billing

/1BEA/CRMB_BDI

ITEM_CATEGORY

BW_ASSIGN

Assignment BW and CO

Fixed values from domain CRMT_BW_ASSIGN

NET_VALUE

Net value in document currency

/1BEA/CRMB_BDI

NET_VALUE

TAX_VALUE

Tax amount in document currency

/1BEA/CRMB_BDI

TAX_VALUE

GROSS_VALUE

Gross value in document currency

/1BEA/CRMB_BDI

GROSS_VALUE

EXCHANGE_TYPE

Exchange rate type

/1BEA/CRMB_BDI

EXCHANGE_TYPE

EXCHANGE_RATE

Exchange rate

/1BEA/CRMB_BDI

EXCHANGE_RATE

EXCHANGE_DATE

Conversion date

/1BEA/CRMB_BDI

EXCHANGE_DATE

REVERSAL

Reversal indicator

/1BEA/CRMB_BDI

REVERSAL

IS_REVERSED

Indicator: billing item is offset

/1BEA/CRMB_BDI

IS_REVERSED

BILL_ORG

Billing unit

/1BEA/CRMB_BDH

BILL_ORG

SALES_ORG

Sales organization

/1BEA/CRMB_BDI

SALES_ORG

SERVICE_ORG

Object ID

/1BEA/CRMB_BDI

SERVICE_ORG

DIS_CHANNEL

Distribution channel

/1BEA/CRMB_BDI

DIS_CHANNEL

DIVISION

Division

/1BEA/CRMB_BDI

DIVISION

BEA_LOGSYS

Logical system billing

Logical system billing

SRC_HEADNO

Transaction number

/1BEA/CRMB_BDI

SRC_HEADNO

SRC_ITEMNO

Item number in document

/1BEA/CRMB_BDI

SRC_ITEMNO

LOGSYS

Logical system preceding document

/1BEA/CRMB_BDI

LOGSYS

OBJTYPE

Business transaction category

/1BEA/CRMB_BDI

OBJTYPE

SOLD_TO_PARTY

Sold-to party ID

COMT_PARTNER_WRK

EXTERNAL_PARTNER_NUMBER

SHIP_TO_PARTY

Ship-to party ID

COMT_PARTNER_WRK

EXTERNAL_PARTNER_NUMBER

BILL_TO_PARTY

Bill-to party ID

COMT_PARTNER_WRK

EXTERNAL_PARTNER_NUMBER

PAYER

Payer

COMT_PARTNER_WRK

EXTERNAL_PARTNER_NUMBER

PRODUCT

Internal, unique identifier of product

/1BEA/CRMB_BDI

PRODUCT

PRODUCT_ID

Product ID

COMM_PRODUCT

PRODUCT_ID

SHORT_TEXT_UC

Short text for product in upper case for BW

/1BEA/CRMB_BDI

PRODUCT_DESCR

MATERIAL

Distribution CRM -> R/3: Material

COMM_PR_MATERIAL

MATERIAL_NUMBER

QUANTITY

Quantity

/1BEA/CRMB_BDI

QUANTITY

RENDERED_DATE

Date of services rendered

/1BEA/CRMB_BDI

RENDERED_DATE

QTY_UNIT

Unit of measure in which the product is sold

/1BEA/CRMB_BDI

QTY_UNIT

PRICING_DATE

Pricing date

/1BEA/CRMB_BDI

PRICING_DATE

BASE_QTY_UNIT

Base unit of measure for product

COMT_PR_UNIT

UNIT

PROCESS_QTY_NUM

Numerator (factor) for conversion of transaction quantity to base unit

COMT_PR_UNIT

NUMERATOR

PROCESS_QTY_DEN

Denominator (factor) for conversion of transaction quantity to base unit

COMT_PR_UNIT

DENOMINATOR

EXPONENT10

10-exponent for quantity conversion

COMT_PR_UNIT

EXPONENT10

NUM_OF_HEAD

Number of billing headers

Numerator

NUM_OF_ITEM

Number of billing document items

Numerator

SUBTOTAL1

Condition subtotal 1 from pricing procedure

SUBTOTAL2

Condition subtotal 2 from pricing procedure

SUBTOTAL3

Condition subtotal 3 from pricing procedure

SUBTOTAL4

Condition subtotal 4 from pricing procedure

SUBTOTAL5

Condition subtotal 5 from pricing procedure

SUBTOTAL6

Condition subtotal 6 from pricing procedure

BILL_CATEGORY

Category of billing

/1BEA/CRMB_BDH

BILL_CATEGORY