CMDET_S06667 - Individual Records for Updating External Credit Data

Individual Records for Updating External Credit Data information is stored in SAP table CMDET_S06667.
It is part of development package CRM in software component LO-INT-CRM. This development package consists of objects that can be grouped under "Customer Relationship Management (Interfaces SFA Server)".

Fields for table CMDET_S06667

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
MANDT	Client	X	MANDT	CLNT	3	*
WAITING	Document Not Updated, Waiting for Predecessor/Successor	X	CRMT_WAITING_FOR_REF	CHAR	1
.INCLUDE		X		CRMT_CREDIT_VALUES_KEY	0
GUID	Individual Credit Record GUID(from Schedule Line or Bil.Doc)	X	CRMT_CREDIT_ITEM_GUID	CHAR	32
KUNNR	Customer Number		KUNNR	CHAR	10	*
BUKRS	Company Code		BUKRS	CHAR	4	*
.INCLUDE				CRMT_CREDIT_VALUES_DATA	0
HEAD_GUID	Header GUID for CRM Transaction or Billing Eng. Billing Doc.		CMRT_BUS_TRANS_HEAD_GUID	CHAR	32
ITEM_GUID	Item GUID for CRM Transaction or Billing Engine Billing Doc.		CRMT_BUS_TRANS_ITEM_GUID	CHAR	32
ITEM_NUMBER_INT	Item Number		CRMT_NUMBER_INT	NUMC	10
ITM_TYPE	CRM Item Category		CRMT_ITM_TYPE	CHAR	4
REF_HEAD_GUID	Header GUID for CRM Transaction or Billing Eng. Billing Doc.		CMRT_BUS_TRANS_HEAD_GUID	CHAR	32
REF_ITEM_GUID	Item GUID for CRM Transaction or Billing Engine Billing Doc.		CRMT_BUS_TRANS_ITEM_GUID	CHAR	32
PAYER	CRM Business Partner (Payer)		CRMT_PAYER_GUID	CHAR	32
SALES_ORG	Sales Organization		VKORG	CHAR	4	*
DISTR_CHAN	Distribution Channel		VTWEG	CHAR	2	*
DIVISION	Division		SPART	CHAR	2	*
LOCAL_CURR	Local Currency		LOCAL_CURR	CUKY	5
EXCHG_RATE	Exchange Rate		EXCHANGE_RATE	DEC	5
CURRENCY	Currency Key		CURRENCY	CUKY	5	*
TIME_ZONE	Time Zone		TIMEZONE	CHAR	6	*
KKBER	Credit control area		KKBER	CHAR	4	*
PROD_PR_GROUP	CRM Product Group		CRMT_PROD_GROUP	CHAR	2
OP_QUOTE_NETV	Credit: Open Net Quotation Value in Document Currency		CRMT_OQNV	CURR	8
OP_QUOTE_NETV_GU	Credit: Open Secured Net Quotation Value in BW		CRMT_OQNVG	CURR	8
OP_QUOTE_TAXV	Credit: Open Taxable Quotation Value in Document Currency		CRMT_OQTV	CURR	8
OP_QUOTE_TAXV_GU	Credit: Open Secured Taxable Quotation Value in BW		CRMT_OQTVG	CURR	8
OPEN_QUOTE_DATE	Credit: Date for Open Quotation Value		CRMT_OQDT	CHAR	14
OP_ORDER_NETV	Credit: Open Sales Order Net Value in Document Currency		CRMT_OONV	CURR	8
OP_ORDER_NETV_GU	Credit: Open Secured Sales Order Value in BW		CRMT_OONVG	CURR	8
OP_ORDER_TAXV	Credit: Open Taxable Order Value in Document Currency		CRMT_OOTV	CURR	8
OP_ORDER_TAXV_GU	Credit: Open Secured Taxable Order Value in BW		CRMT_OOTVG	CURR	8
OP_ORDER_DATE	Credit: Date for Open Sales Order Value		CRMT_OODT	CHAR	14
OP_ORDER_SUPPL	Open Sales Order Value Delivered, Service Performed		CRMT_OOSPL	CHAR	1
OP_DELIV_NETV	Credit: Open Net Delivery Value in Document Currency		CRMT_ODNV	CURR	8
OP_DELIV_NETV_GU	Credit: Open Guaranteed Net Delivery Value in BW		CRMT_ODNVG	CURR	8
OP_DELIV_TAXV	Credit: Open Delivery Control Value in Document Currency		CRMT_ODTV	CURR	8
OP_DELIV_TAXV_GU	Credit: Open Secured Delivery Control Value in BW		CRMT_ODTVG	CURR	8
OP_INVOICE_NETV	Credit: Open Billing Document Net Value in Doc. Currency		CRMT_OINV	CURR	8
OP_INV_NETV_GU	Credit: Open Secured Billing Doc. Net Value in Doc. Currency		CRMT_OINVG	CURR	8
OP_INVOICE_TAXV	Credit: Open Billing Document Net Value in Doc. Currency		CRMT_OITV	CURR	8
OP_INV_TAXV_GU	Credit: Open Secured Billing Document Net Value in BW		CRMT_OITVG	CURR	8
OP_INVOICE_DATE	Credit: Date for Open Billing Document Value		CRMT_OIDT	CHAR	14