SAP ABAP Table CRMT_COMPL_BEA_ITEM (Billing Doc. Item Data (BE): Wrapper /1BEA/S_CRMB_BDI_WRK)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-BTX-COM (Application Component) Complaints / Returns / In-House Repair
     ⤷ CRM_COMPLAINT (Package) Complaints

Basic Data

Table Category	INTTAB	Structure
Structure	CRMT_COMPL_BEA_ITEM	Table Relationship Diagram
Short Description	Billing Doc. Item Data (BE): Wrapper /1BEA/S_CRMB_BDI_WRK

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	BDI_GUID	☐	BEA_BDI_GUID	SYSUUID	RAW	16	0	GUID of Billing Item
3	BDH_GUID	☐	BEA_BDH_GUID	SYSUUID	RAW	16	0	Unique Internal ID of a Billing Header
4	ACCREF_GUID	☐	BEA_ACCREF_GUID	SYSUUID	RAW	16	0	Reference to CO Account Assignment
5	INDICATOR_IC	☐	BEA_INDICATOR_IC	BEA_INDICATOR_IC	CHAR	1	0	Indicator for Intercompany Billing
6	PARSET_GUID	☐	BEA_PARSET_GUID	SYSUUID	RAW	16	0	Partner Set GUID; GUID Fld.in CRMD_PARTNER(CRMT_OBJECT_GUID)
7	PRICING_STATUS	☐	BEA_PRICING_STATUS	BEA_PRICING_STATUS	CHAR	1	0	Pricing Status
8	TEXT_ERROR	☐	BEA_TEXT_ERROR	BEA_TEXT_ERROR	CHAR	1	0	Text Processing Status
9	ITEMNO_EXT	☐	BEA_ITEMNO_EXT	NUMC10	NUMC	10	0	Billing Item (External Identifier)
10	REVERSAL	☐	BEA_REVERSAL	BEA_REVERSAL	CHAR	1	0	Reversal Indicator
11	IS_REVERSED	☐	BEA_IS_REVERSED	BEA_IS_REVERSED	CHAR	1	0	Flag: Billing Item Is Offset
12	ITEM_CATEGORY	☐	BEA_ITEM_CATEGORY	BEA_ITEM_CATEGORY	CHAR	4	0	Billing Item Category	*
13	SRVDOC_SOURCE	☐	BEA_SRVDOC_SOURCE	BEA_SRVDOC_SOURCE	CHAR	1	0	Origin of Price Document
14	CREATION_CODE	☐	BEA_CREATION_CODE	BEA_CREATION_CODE	CHAR	1	0	Creation Code
15	NET_VALUE	☐	CRMT_NET_VALUE	WERTV8	CURR	15	2	Net Value
16	TAX_VALUE	☐	CRMT_TAX_AMOUNT	WERTV8	CURR	15	2	Tax amount in document currency
17	GROSS_VALUE	☐	CRMT_GROSS_VALUE	WERTV8	CURR	15	2	Gross Order Value in PO Currency
18	DOC_CURRENCY	☐	BEA_DOC_CURRENCY	WAERS	CUKY	5	0	Document Currency	*
19	EXCHANGE_RATE	☐	CRMT_EXCHG_RATE	CRM_EXCHG_RATE	DEC	9	5	Exchange Rate
20	EXCHANGE_DATE	☐	CRMT_EXCHG_DATE	CRM_EXCHG_DATE	DATS	8	0	Exchange Rate Date
21	BASE_TIMEZONE	☐	CRMT_TIMEZONE	TZNZONE	CHAR	6	0	Time Zone	*
22	BASE_TIME_FROM	☐	CRMT_TIMESTAMP	BCOS_TSTMP	DEC	15	0	Time Stamp (Date and Time)
23	BASE_TIME_TO	☐	CRMT_TIMESTAMP	BCOS_TSTMP	DEC	15	0	Time Stamp (Date and Time)
24	BUSINESSSCENARIO	☐	BEA_BUSINESS_SCENARIO	BEA_BUSINESS_SCENARIO	CHAR	1	0	Business Scenario
25	DIS_CHANNEL	☐	CRMT_DISTRIBUTION_CHANNEL	CRM_DISTRIBUTION_CHANNEL	CHAR	2	0	Distribution Channel	*
26	DIVISION	☐	CRMT_DIVISION	CRM_DIVISION	CHAR	2	0	Division	*
27	DIVISION_H	☐	CRMT_DIVISION	CRM_DIVISION	CHAR	2	0	Division	*
28	GROSS_WEIGHT	☐	CRMT_GROSS_WEIGHT	MENG15	QUAN	15	3	Gross Weight
29	LOGSYS	☐	CRMT_LOGSYS	LOGSYS	CHAR	10	0	Logical System	*
30	NET_VALUE_MAN	☐	CRMT_NET_VALUE_MAN	WERTV8	CURR	15	2	Total Expected Net Value Products in Document Currency
31	NET_WEIGHT	☐	CRMT_NET_WEIGHT	MENG15	QUAN	15	3	Net Weight
32	OBJTYPE	☐	SWO_OBJTYP	OJ_NAME	CHAR	10	0	Object Type	*
33	PARENT_ITEMNO	☐	CRMT_ITEM_NO_PARENT	CRM_ITEM_NO	NUMC	10	0	Higher-Level Item Number in Transaction
34	PRC_INDICATOR	☐	CRMT_PRICING_INDICATOR	CRM_PRICING_INDICATOR	CHAR	1	0	Pricing indicator
35	PRICING_DATE	☐	CRMT_PRICE_DATE	CRM_PRICE_DATE	DATS	8	0	Pricing Date
36	PRODUCT	☐	CRMT_PRODUCT_GUID_DB	SYSUUID	RAW	16	0	Internal Unique ID of Product
37	PRODUCT_DESCR	☐	CRMT_PRSHTEXTX_DB	CRM_PRSHTEXT40_DB	CHAR	40	0	Product Short Text
38	QTY_UNIT	☐	CRMT_PROCESS_QTY_UNIT	MEINS	UNIT	3	0	Unit of Measure in Which the Product Is Sold	*
39	QUANTITY	☐	CRMT_SCHEDLIN_QUAN	MENG13	QUAN	13	3	CRM Schedule Line Quantity
40	RENDERED_DATE	☐	BEA_RENDERED_DATE	SYDATS	DATS	8	0	Date of Services Rendered
41	SALES_ORG	☐	CRMT_SALES_ORG	HROBJEC_14	CHAR	14	0	Sales Organization ID
42	SERVICE_ORG	☐	CRMT_SERVICE_ORG	HROBJEC_14	CHAR	14	0	Service Organization
43	SERVICE_TYPE	☐	CRMT_SERVICE_TYPE	CRMT_SERVICE_TYPE	CHAR	4	0	Service Type	*
44	SRC_GUID	☐	GUID		RAW	16	0	Globally Unique Identifier
45	SRC_HEADNO	☐	BEA_SRC_HEADNO	BEA_SRC_HEADNO_EXT	CHAR	10	0	Source Application Document Number
46	SRC_ITEMNO	☐	CRMT_ITEM_NO	CRM_ITEM_NO	NUMC	10	0	Item Number in Document
47	SRC_ITEM_TYPE	☐	CRMT_ITEM_TYPE	CRM_ITEM_TYPE	CHAR	4	0	Item Category	*
48	SRC_PROCESS_TYPE	☐	CRMT_PROCESS_TYPE	CRM_PROCESS_TYPE	CHAR	4	0	Business Transaction Type	*
49	TAX_DEST_COUNTRY	☐	CRMT_TAX_LAND	LAND1	CHAR	3	0	Tax Country	*
50	VALUATION_TYPE	☐	CRMT_VALUATION_TYPE	CRMT_VALUATION_TYPE	CHAR	6	0	Valuation Type	*
51	VENDOR	☐	BU_PARTNER_GUID	SYSUUID	RAW	16	0	Business Partner GUID
52	WEIGHT_UNIT	☐	CRMT_QUANTITY_UNIT	MEINS	UNIT	3	0	Unit of Measure in Doc.Flow	*
53	BDI_PRICING_TYPE	☐	BEA_PRICING_TYPE	BEA_PRICING_TYPE	CHAR	1	0	Pricing Type
54	BDI_PRCCOPY_TYPE	☐	BEA_PRICING_COPY_TYPE	PRC_COPY_TYPE	CHAR	5	0	Copying Type for Pricing Service	*
55	ROOT_DLITEM_GUID	☐	BEA_ROOT_DLITEM_GUID	SYSUUID	RAW	16	0	GUID of BDL Item From Which a Billing Item Stems
56	REVERSED_BDI_GUID	☐	BEA_REVERSED_BDI_GUID	SYSUUID	RAW	16	0	GUID of Offset Billing Item
57	UPD_TYPE	☐	UPDATE_TYPE	UPDATE_TYPE	CHAR	1	0	Type of Change
58	REF_QTY_UNIT	☐	CRMT_QUANTITY_UNIT	MEINS	UNIT	3	0	Unit of Measure in Doc.Flow	*
59	REF_QUANTITY	☐	CRMT_SCHEDLIN_QUAN	MENG13	QUAN	13	3	CRM Schedule Line Quantity
60	SOLD_TO_GUID	☐	CRMT_SOLD_TO_PARTY	SYSUUID	RAW	16	0	Sold-to Party GUID
61	PRV_ITEM_GUID	☐	BEA_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a BEA Object
62	PRV_PRIDOC_GUID	☐	BEA_PRIDOC_GUID	SYSUUID	RAW	16	0	ID of Pricing Document
63	SUC_ITEM_GUID	☐	BEA_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a BEA Object
64	SUC_PRIDOC_GUID	☐	BEA_PRIDOC_GUID	SYSUUID	RAW	16	0	ID of Pricing Document
65	CONDITION_SPLIT	☐	BEA_CONDITION_SPLIT	BEA_CONDITION_SPLIT	CHAR	1	0	Indicator for Invoice Split via Conditions
66	ORDERED_PROD	☐	CRMT_ORDERED_PROD_DB	CRM_ORDERED_PROD	CHAR	54	0	Product Name Entered
67	PRODUCT_KIND	☐	CRMT_PRODUCT_KIND	CRM_PRODUCT_KIND	CHAR	1	0	Technnical Type of Product
68	TAX_GROUP_P	☐	CRMT_TAX_GROUP	CRM_TAX_GROUP	CHAR	20	0	Product Tax Group
69	TAX_GROUP_P_CTY	☐	CRMT_TAX_LAND	LAND1	CHAR	3	0	Tax Country	*
70	TAX_GROUP_P_REG	☐	CRMT_TAX_REGION	REGIO	CHAR	3	0	Tax Region	*
71	TAX_GROUP_P_TTP	☐	CRMT_TAX_TYPE	BUTX_TAX_TYPE	CHAR	4	0	Tax Type
72	TAX_EXEMPT_GUID	☐	CRM_TAX_EXEMPT_HEADER_GUID	SYSUUID	RAW	16	0	Object Header GUID

History

Last changed by/on	SAP	20130604
SAP Release Created in	500