SAP ABAP Table CMDET_S06667 (Individual Records for Updating External Credit Data)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM (Package) Customer Relationship Management (Interfaces SFA Server)

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	CMDET_S06667	Table Relationship Diagram
Short Description	Individual Records for Updating External Credit Data

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	*
2	WAITING	☑	CRMT_WAITING_FOR_REF	BOOLEAN	CHAR	1	0	Document Not Updated, Waiting for Predecessor/Successor
3	.INCLUDE	☑				0	0	Credit Values, Key
4	GUID	☑	CRMT_CREDIT_ITEM_GUID	CRMD_GUID_C	CHAR	32	0	Individual Credit Record GUID(from Schedule Line or Bil.Doc)
5	KUNNR	☐	KUNNR	KUNNR	CHAR	10	0	Customer Number	*
6	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
7	.INCLUDE	☐				0	0	Credit Values, Data Part
8	HEAD_GUID	☐	CMRT_BUS_TRANS_HEAD_GUID	CRMD_GUID_C	CHAR	32	0	Header GUID for CRM Transaction or Billing Eng. Billing Doc.
9	ITEM_GUID	☐	CRMT_BUS_TRANS_ITEM_GUID	CRMD_GUID_C	CHAR	32	0	Item GUID for CRM Transaction or Billing Engine Billing Doc.
10	ITEM_NUMBER_INT	☐	CRMT_NUMBER_INT		NUMC	10	0	Item Number
11	ITM_TYPE	☐	CRMT_ITM_TYPE	CRMD_ITEM_TYPE	CHAR	4	0	CRM Item Category
12	REF_HEAD_GUID	☐	CMRT_BUS_TRANS_HEAD_GUID	CRMD_GUID_C	CHAR	32	0	Header GUID for CRM Transaction or Billing Eng. Billing Doc.
13	REF_ITEM_GUID	☐	CRMT_BUS_TRANS_ITEM_GUID	CRMD_GUID_C	CHAR	32	0	Item GUID for CRM Transaction or Billing Engine Billing Doc.
14	PAYER	☐	CRMT_PAYER_GUID	CRMD_GUID_C	CHAR	32	0	CRM Business Partner (Payer)
15	SALES_ORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	*
16	DISTR_CHAN	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	*
17	DIVISION	☐	SPART	SPART	CHAR	2	0	Division	*
18	LOCAL_CURR	☐	LOCAL_CURR	CURRENCY	CUKY	5	0	Local Currency
19	EXCHG_RATE	☐	EXCHANGE_RATE	EXCHANGE_RATE	DEC	9	5	Exchange Rate
20	CURRENCY	☐	CURRENCY	WAERS	CUKY	5	0	Currency Key	*
21	TIME_ZONE	☐	TIMEZONE	TZNZONE	CHAR	6	0	Time Zone	*
22	KKBER	☐	KKBER	KKBER	CHAR	4	0	Credit control area	*
23	PROD_PR_GROUP	☐	CRMT_PROD_GROUP	CRMD_PROD_GROUP	CHAR	2	0	CRM Product Group
24	OP_QUOTE_NETV	☐	CRMT_OQNV	WERTV8	CURR	15	2	Credit: Open Net Quotation Value in Document Currency
25	OP_QUOTE_NETV_GU	☐	CRMT_OQNVG	WERTV8	CURR	15	2	Credit: Open Secured Net Quotation Value in BW
26	OP_QUOTE_TAXV	☐	CRMT_OQTV	WERTV8	CURR	15	2	Credit: Open Taxable Quotation Value in Document Currency
27	OP_QUOTE_TAXV_GU	☐	CRMT_OQTVG	WERTV8	CURR	15	2	Credit: Open Secured Taxable Quotation Value in BW
28	OPEN_QUOTE_DATE	☐	CRMT_OQDT	TIMESTAMP	CHAR	14	0	Credit: Date for Open Quotation Value
29	OP_ORDER_NETV	☐	CRMT_OONV	WERTV8	CURR	15	2	Credit: Open Sales Order Net Value in Document Currency
30	OP_ORDER_NETV_GU	☐	CRMT_OONVG	WERTV8	CURR	15	2	Credit: Open Secured Sales Order Value in BW
31	OP_ORDER_TAXV	☐	CRMT_OOTV	WERTV8	CURR	15	2	Credit: Open Taxable Order Value in Document Currency
32	OP_ORDER_TAXV_GU	☐	CRMT_OOTVG	WERTV8	CURR	15	2	Credit: Open Secured Taxable Order Value in BW
33	OP_ORDER_DATE	☐	CRMT_OODT	TIMESTAMP	CHAR	14	0	Credit: Date for Open Sales Order Value
34	OP_ORDER_SUPPL	☐	CRMT_OOSPL	BOOLEAN	CHAR	1	0	Open Sales Order Value Delivered, Service Performed
35	OP_DELIV_NETV	☐	CRMT_ODNV	WERTV8	CURR	15	2	Credit: Open Net Delivery Value in Document Currency
36	OP_DELIV_NETV_GU	☐	CRMT_ODNVG	WERTV8	CURR	15	2	Credit: Open Guaranteed Net Delivery Value in BW
37	OP_DELIV_TAXV	☐	CRMT_ODTV	WERTV8	CURR	15	2	Credit: Open Delivery Control Value in Document Currency
38	OP_DELIV_TAXV_GU	☐	CRMT_ODTVG	WERTV8	CURR	15	2	Credit: Open Secured Delivery Control Value in BW
39	OP_INVOICE_NETV	☐	CRMT_OINV	WERTV8	CURR	15	2	Credit: Open Billing Document Net Value in Doc. Currency
40	OP_INV_NETV_GU	☐	CRMT_OINVG	WERTV8	CURR	15	2	Credit: Open Secured Billing Doc. Net Value in Doc. Currency
41	OP_INVOICE_TAXV	☐	CRMT_OITV	WERTV8	CURR	15	2	Credit: Open Billing Document Net Value in Doc. Currency
42	OP_INV_TAXV_GU	☐	CRMT_OITVG	WERTV8	CURR	15	2	Credit: Open Secured Billing Document Net Value in BW
43	OP_INVOICE_DATE	☐	CRMT_OIDT	TIMESTAMP	CHAR	14	0	Credit: Date for Open Billing Document Value

History

Last changed by/on	SAP	20130529
SAP Release Created in	2002_1_46C