SAP ABAP View V_ERCHV_BW (Consumption View for BW Extraction)

Hierarchy

☛ IS-UT (Software Component) SAP Utilities/Telecommunication
   ⤷ IS-U-CS-MA (Application Component) Marketing
     ⤷ EE_CRM_MKT_BIW (Package) BW Extractors fur IS-U/CRM Marketing

Basic Data

View Type	D	Database View
Database View	V_ERCHV_BW
Short Description	Consumption View for BW Extraction
Root table	ERCH	Billing Doc. Data

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	ERCH	ERCH
2	DBERCHV

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	DBERCHV	MANDT	JL	EQ				0	0
2	ERCH	MANDT	JR	EQ			AND	0	0
3	DBERCHV	BELNR	JL	EQ				0	0
4	ERCH	BELNR	JR	EQ			AND	0	0
5	ERCH	SIMULATION		EQ	' '			0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	DBERCHV	MANDT		☐	MANDT	☐	Client
2	BELNR	DBERCHV	BELNR		☐	E_BELNR	☐	Number of a billing document
3	LFDNR	DBERCHV	LFDNR		☐	LFDNR	☐	Sequence Number
4	AB	DBERCHV	AB		☐	ABZEITSCH	☐	Date from which time slice is valid
5	BIS	DBERCHV	BIS		☐	BISZEITSCH	☐	Date at Which a Time Slice Expires
6	MASSBILL	DBERCHV	MASSBILL		☐	E_MASSBILL	☐	Unit of measurement for billing
7	NETTOBTR	DBERCHV	NETTOBTR		☐	NETTOBTR	☐	Net amount of billing line item
8	TWAERS	DBERCHV	TWAERS		☐	TWAERS	☐	Transaction Currency
9	ABRMENGE	DBERCHV	EZ_ABRMENGE		☐	EZ_ABRMENGE	☐	Billing Quantity
10	ARTMENGE	DBERCHV	ARTMENGE		☐	ARTMENGE	☐	Classification of billed quantity for statistics
11	SPARTE	ERCH	SPARTE		☐	SPARTE	☐	Division
12	GPARTNER	ERCH	GPARTNER		☐	BU_PARTNER	☐	Business Partner Number
13	VKONT	ERCH	VKONT		☐	VKONT_KK	☐	Contract Account Number
14	VERTRAG	ERCH	VERTRAG		☐	VERTRAG	☐	Contract
15	STORNODAT	ERCH	STORNODAT		☐	STORNODAT	☐	Reversal date
16	ERDAT	ERCH	ERDAT		☐	ERDAT	☐	Date on which the record was created
17	ERCHV_BW_REL	DBERCHV	ERCHV_BW_REL		☐	ERCHV_BW_REL	☐	Not Relevant for Consumption History in BW
18	PREISTYP	DBERCHV	PREISTYP		☐	PREISTYP	☐	Price category
19	TOBRELEASD	ERCH	TOBRELEASD		☐	TOBRELEASD	☐	Indicator: document not released yet

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

History

Last changed by/on	SAP	20110901
SAP Release Created in	463