SAP ABAP Table BEAS_BW_DS (Data Source for Billing Documents)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-BE-BW (Application Component) Connection to BW
     ⤷ BEA_BW (Package) BE Application - Service - BW

Basic Data

Table Category	INTTAB	Structure
Structure	BEAS_BW_DS	Table Relationship Diagram
Short Description	Data Source for Billing Documents

Delivery and Maintenance

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

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	CLIENT	☐	MANDT	MANDT	CLNT	3	0	Client	*
2	APPLICATION	☐	BEF_APPL	BEF_APPL	CHAR	4	0	Application	*
3	BDH_GUID	☐	BEA_BDH_GUID	SYSUUID	RAW	16	0	Unique Internal ID of a Billing Header
4	BDI_GUID	☐	BEA_BDI_GUID	SYSUUID	RAW	16	0	GUID of Billing Item
5	HEADNO_EXT	☐	BEA_HEADNO_EXT	BEA_HEADNO_EXT	CHAR	10	0	Billing Document
6	BILL_TYPE	☐	BEA_BILL_TYPE	BEA_BILL_TYPE	CHAR	4	0	Billing Type	*
7	BILL_DATE	☐	BEA_BILL_DATE	SYDATS	DATS	8	0	Billing Date
8	REF_CURRENCY	☐	BEA_REF_CURRENCY	WAERS	CUKY	5	0	Reference Currency	*
9	DOC_CURRENCY	☐	BEA_DOC_CURRENCY	WAERS	CUKY	5	0	Document Currency	*
10	REFERENCE_NO	☐	BEA_REFERENCE_NO	CHAR30	CHAR	30	0	Reference Number
11	TERMS_OF_PAYMENT	☐	BEA_TERMS_OF_PAYMENT	CRM_PMNTTRMS	CHAR	4	0	Terms of Payment	*
12	INCOTERMS1	☐	CRMT_INCOTERMS1	CRM_INCOTERMS1	CHAR	3	0	Incoterms (Part 1)	*
13	INCOTERMS2	☐	CRMT_INCOTERMS2	CRM_INCOTERMS2	CHAR	28	0	Incoterms (Part 2)
14	MAINT_DATE	☐	BEA_MAINT_DATE	SYDATS	DATS	8	0	Processing Date
15	MAINT_USER	☐	BEA_MAINT_USER	USERNAME	CHAR	12	0	Created/Last Changed By
16	RECORDMODE	☐	BEA_BW_RODMUPDMOD	BEA_BW_RODMUPDMOD	CHAR	1	0	BW Delta Process: Update Mode
17	ITEMNO_EXT	☐	BEA_ITEMNO_EXT	NUMC10	NUMC	10	0	Billing Item (External Identifier)
18	ITEM_CATEGORY	☐	BEA_ITEM_CATEGORY	BEA_ITEM_CATEGORY	CHAR	4	0	Billing Item Category	*
19	BW_ASSIGN	☐	CRMT_BW_ASSIGN	CRMT_BW_ASSIGN	CHAR	1	0	Assign BW and CO
20	NET_VALUE	☐	BEA_NET_VALUE	WERTV8	CURR	15	2	Net Value in Document Currency
21	TAX_VALUE	☐	BEA_TAX_VALUE	WERTV8	CURR	15	2	Tax Amount in Document Currency
22	GROSS_VALUE	☐	BEA_GROSS_VALUE	WERTV8	CURR	15	2	Gross Value in Document Currency
23	EXCHANGE_TYPE	☐	CRMT_EXCHG_TYPE	KURST	CHAR	4	0	Exchange Rate Type	*
24	EXCHANGE_RATE	☐	BEA_EXCHANGE_RATE	BEA_EXCHANGE_RATE	DEC	9	5	Exchange Rate
25	EXCHANGE_DATE	☐	BEA_EXCHANGE_DATE	SYDATS	DATS	8	0	Conversion Date
26	REVERSAL	☐	BEA_REVERSAL	BEA_REVERSAL	CHAR	1	0	Reversal Indicator
27	IS_REVERSED	☐	BEA_IS_REVERSED	BEA_IS_REVERSED	CHAR	1	0	Flag: Billing Item Is Offset
28	BILL_ORG	☐	BEA_BILL_ORG	BU_PARTNER	CHAR	10	0	Billing Unit	*
29	SALES_ORG	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
30	SERVICE_ORG	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
31	DIS_CHANNEL	☐	CRMT_DISTRIBUTION_CHANNEL	CRM_DISTRIBUTION_CHANNEL	CHAR	2	0	Distribution Channel	*
32	DIVISION	☐	CRMT_DIVISION	CRM_DIVISION	CHAR	2	0	Division	*
33	BEA_LOGSYS	☐	CRMT_LOGSYS	LOGSYS	CHAR	10	0	Logical System	*
34	SRC_HEADNO	☐	CRMT_OBJECT_ID	CRM_OBJECT_ID	CHAR	10	0	Transaction ID
35	SRC_ITEMNO	☐	CRMT_ITEM_NO	CRM_ITEM_NO	NUMC	10	0	Item Number in Document
36	LOGSYS	☐	CRMT_LOGSYS	LOGSYS	CHAR	10	0	Logical System	*
37	OBJTYPE	☐	CRMT_SUBOBJECT_CATEGORY	CRM_OJ_NAME_PROCESS	CHAR	10	0	Business Transaction Category	*
38	SOLD_TO_PARTY	☐	CRMT_SOLD_TO_PARTY_ID	BU_PARTNER	CHAR	10	0	Sold-To Party ID	*
39	SHIP_TO_PARTY	☐	CRMT_SHIP_TO_PARTY_ID	BU_PARTNER	CHAR	10	0	Ship-to Party ID	*
40	BILL_TO_PARTY	☐	CRMT_BILL_TO_PARTY_ID	BU_PARTNER	CHAR	10	0	Bill-To Party ID	*
41	PAYER	☐	BEA_PAYER	BU_PARTNER	CHAR	10	0	Payer	*
42	PRODUCT	☐	COMT_PRODUCT_GUID	SYSUUID	RAW	16	0	Internal Unique ID of Product
43	PRODUCT_ID	☐	COMT_PRODUCT_ID	COM_PRODUCT_ID	CHAR	40	0	Product ID
44	SHORT_TEXT_UC	☐	COMT_PRSHTEXTX_UP	PRSHTEXTG40	CHAR	40	0	Product Description
45	MATERIAL	☐	CRMT_R3_MATERIAL	CRM_R3_MATERIAL	CHAR	18	0	Distribution CRM -> R/3: Material
46	QUANTITY	☐	BEA_QUANTITY	MENGV13	QUAN	13	3	Quantity
47	RENDERED_DATE	☐	BEA_RENDERED_DATE	SYDATS	DATS	8	0	Date of Services Rendered
48	QTY_UNIT	☐	CRMT_PROCESS_QTY_UNIT	MEINS	UNIT	3	0	Unit of Measure in Which the Product Is Sold	*
49	PRICING_DATE	☐	CRMT_PRICE_DATE	CRM_PRICE_DATE	DATS	8	0	Pricing Date
50	BASE_QTY_UNIT	☐	COMT_PRODUCT_BASE_UOM	MEINS	UNIT	3	0	Base Unit of Measure of Product	*
51	PROCESS_QTY_NUM	☐	CRMT_PROCESS_QTY_NUM	CRM_PROCESS_QTY_NUM	INT4	10	0	Numerator (factor) for conversion trans. quantity in BME
52	PROCESS_QTY_DEN	☐	CRMT_PROCESS_QTY_DEN	CRM_PROCESS_QTY_DEN	INT4	10	0	Denominator (factor) for conversion trans. quantity in BME
53	EXPONENT10	☐	CRMT_EXPONENT10	CRM_EXPONENT10	INT2	5	0	10 Exponent for Quantity Conversion
54	LOC_GUID	☐	CRMT_LOC_GUID	SYSUUID_C	CHAR	32	0	Letter of Credit GUID from SAP Global Trade Services
55	NUM_OF_HEAD	☐	BEA_NUMBER_OF_H	INT4	INT4	10	0	Number of Billing Headers
56	NUM_OF_ITEM	☐	BEA_NUMBER_OF_I	INT4	INT4	10	0	Number of Billing Items
57	SUBTOTAL1	☐	CRMT_SUBTOTAL1	WERTV8	CURR	15	2	Subtotal 1 from pricing procedure for condition
58	SUBTOTAL2	☐	CRMT_SUBTOTAL2	WERTV8	CURR	15	2	Subtotal 2 from pricing procedure for condition
59	SUBTOTAL3	☐	CRMT_SUBTOTAL3	WERTV8	CURR	15	2	Subtotal 3 from pricing procedure for condition
60	SUBTOTAL4	☐	CRMT_SUBTOTAL4	WERTV8	CURR	15	2	Subtotal 4 from pricing procedure for condition
61	SUBTOTAL5	☐	CRMT_SUBTOTAL5	WERTV8	CURR	15	2	Subtotal 5 from pricing procedure for condition
62	SUBTOTAL6	☐	CRMT_SUBTOTAL6	WERTV8	CURR	15	2	Subtotal 6 from pricing procedure for condition
63	BILL_CATEGORY	☐	BEA_BILL_CATEGORY	BEA_BILL_CATEGORY	CHAR	1	0	Billing Category	*
64	SRC_GUID	☐	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
65	PARTBILL_STAT	☐	BEA_PARTBILL_STAT	BEA_PARTBILL_STAT	CHAR	1	0	Partial Settlement Status of Settlement Item
66	BILL_RELEVANCE	☐	BEA_BILL_RELEVANCE	BEA_BILL_RELEVANCE	CHAR	1	0	Billing Relevance
67	CREDIT_DEBIT	☐	BEA_CREDIT_DEBIT	BEA_CREDIT_DEBIT	CHAR	1	0	Debit/Credit Indicator
68	EXPENSE_TYPE	☐	CRM_FM_EXPENSE_TYPE	CRM_FM_EXPENSE_TYPE	CHAR	4	0	Expense Type
69	FUND	☐	CRM_FM_FND_FUND_GUID	SYSUUID	RAW	16	0	GUID of Fund Business Object
70	FUNDS_PLAN	☐	CRM_FM_FND_FUNDPLAN_GUID	SYSUUID	RAW	16	0	Funds Plan GUID
71	FUND_USAGE_ITEM	☐	CRM_FM_FU_ITEM_GUID	SYSUUID	RAW	16	0	TFM Fund Usage: Fund Usage Item Guid
72	PREPAYMENT_ITEM	☐	CRMT_ITEM_GUID	SYSUUID	RAW	16	0	Item GUID for a CRM Document
73	CLAIM_SUBMISSION	☐	CRMT_HEADER_GUID	SYSUUID	RAW	16	0	GUID for a CRM Document Header
74	INITIATIVE	☐	CRM_MKTPL_GUID	CRM_MKTPL_GUID	RAW	16	0	CRM Marketing Planning - Marketing Element GUID
75	CAMPAIGN	☐	CRM_MKTPL_GUID	CRM_MKTPL_GUID	RAW	16	0	CRM Marketing Planning - Marketing Element GUID
76	PROGRAM_GUID	☐	CRM_MKTPL_GUID	CRM_MKTPL_GUID	RAW	16	0	CRM Marketing Planning - Marketing Element GUID
77	CASE_GUID	☐	SCMG_CASE_GUID	SYSUUID_C	CHAR	32	0	Technical Case Key (Case GUID)
78	TRADE_PROMOTION	☐	CRM_MKTPL_GUID	CRM_MKTPL_GUID	RAW	16	0	CRM Marketing Planning - Marketing Element GUID
79	SPEC_PROGRAM_GUID	☐	CRM_MKTPL_GUID	CRM_MKTPL_GUID	RAW	16	0	CRM Marketing Planning - Marketing Element GUID
80	TRANSFER_DATE	☐	BEA_TRANSFER_DATE	SYDATS	DATS	8	0	Value Date
81	ITEM_TYPE	☐	BEA_ITEM_TYPE	BEA_ITEM_TYPE	CHAR	1	0	Billing Document Item Type
82	TRANSFER_TYPE	☐	BEA_TRANSFER_TYPE	BEA_TRANSFER_TYPE	CHAR	1	0	Type of Integration to Follow-On Applications
83	VENDOR	☐	BU_PARTNER_GUID	SYSUUID	RAW	16	0	Business Partner GUID
84	TPOP_PLANT	☐	BEA_TPOP_PLANT	CRM_APO_LOCNO	CHAR	20	0	Plant for TPOP
85	TAX_EXEMPT_ID	☐	CRM_TAX_EXEMPT_ID	CRM_TAX_EXEMPT_ID	CHAR	30	0	Customer Tax Exemption Certificate ID
86	POINT_TYPE	☐	CRMT_MKTPL_LOY_POINT_CODE	CRM_MKTPL_LOY_POINT_CODE	CHAR	10	0	ID of Point Type
87	POINT_SPENT	☐	CRMT_LOY_POINTS_SPENT		DEC	10	2	Loyalty Points Spent
88	POINTS	☐	CRM_LOY_PT_POINT		DEC	10	2	Loyalty Point
89	DECISION_CODE	☐	CRMT_DECISION_CODE	CRM_INSPECTION_CODE	CHAR	16	0	Concatenated string of defect 'catalog codegroup code'
90	DEFECT_CODE	☐	CRMT_DEFECT_CODE	CRM_INSPECTION_CODE	CHAR	16	0	Concatenated string of defect 'catalog codegroup code'
91	P_LOGSYS	☐	CRMT_LOGSYS	LOGSYS	CHAR	10	0	Logical System	*
92	P_OBJTYPE	☐	BEA_OBJTYPE	BEA_OBJTYPE	CHAR	10	0	Object Type
93	P_SRC_HEADNO	☐	BEA_P_SRC_HEADNO	BEA_SRC_HEADNO_EXT	CHAR	10	0	Preceding Document Number
94	P_SRC_ITEMNO	☐	CRMT_ITEM_NO	CRM_ITEM_NO	NUMC	10	0	Item Number in Document
95	PRC_GROUP1	☐	CRMT_PRC_GROUP1	CRM_PRC_GROUP1	CHAR	3	0	Product Group 1	*
96	PRC_GROUP2	☐	CRMT_PRC_GROUP2	CRM_PRC_GROUP2	CHAR	3	0	Product Group 2	*
97	PRC_GROUP3	☐	CRMT_PRC_GROUP3	CRM_PRC_GROUP3	CHAR	3	0	Product Group 3	*
98	PRC_GROUP4	☐	CRMT_PRC_GROUP4	CRM_PRC_GROUP4	CHAR	3	0	Product Group 4	*
99	PRC_GROUP5	☐	CRMT_PRC_GROUP5	CRM_PRC_GROUP5	CHAR	3	0	Product Group 5	*
100	PROD_HIERARCHY	☐	CRMT_PROD_HIERARCHY	COM_CATEGORY_ID	CHAR	20	0	Product Category
101	PROD_PR_GROUP	☐	CRMT_PROD_PR_GROUP	CRM_PROD_PR_GROUP	CHAR	2	0	Product Group	*
102	SEPA_MNDID	☐	CRMT_MANDATE_ID	CRM_MANDATE_ID	CHAR	35	0	Unique Reference to Mandate per Payment Recipient

History

Last changed by/on	SAP	20130604
SAP Release Created in	30A