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

Dictionary Type: Table
Description: Individual Records for Updating External Credit Data




ABAP Code to SELECT data from CMDET_S06667
Related tables to CMDET_S06667
Access table CMDET_S06667




Table field list including key, data, relationships and ABAP select examples

CMDET_S06667 is a standard SAP Table which is used to store Individual Records for Updating External Credit Data data and is available within R/3 SAP systems depending on the version and release level.

The CMDET_S06667 table consists of various fields, each holding specific information or linking keys about Individual Records for Updating External Credit Data data available in SAP. These include WAITING (Document Not Updated, Waiting for Predecessor/Successor), GUID (Individual Credit Record GUID(from Schedule Line or Bil.Doc)), KUNNR (Customer Numbers), BUKRS (Company Code).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified


SAP CMDET_S06667 table fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3Assigned to domainMANDT
WAITINGDocument Not Updated, Waiting for Predecessor/Successor CRMT_WAITING_FOR_REFCHAR1BOOLEAN
GUIDIndividual Credit Record GUID(from Schedule Line or Bil.Doc) CRMT_CREDIT_ITEM_GUIDCHAR32CRMD_GUID_C
KUNNRCustomer Numbers KUNNRCHAR10Assigned to domainALPHAKUNNRKUNC_KUNNR
BUKRSCompany Code BUKRSCHAR4Assigned to domainBUKRSBUKC_T001
HEAD_GUIDHeader GUID for CRM Transaction or Billing Eng. Billing Doc. CMRT_BUS_TRANS_HEAD_GUIDCHAR32CRMD_GUID_C
ITEM_GUIDItem GUID for CRM Transaction or Billing Engine Billing Doc. CRMT_BUS_TRANS_ITEM_GUIDCHAR32CRMD_GUID_C
ITEM_NUMBER_INTItem Number CRMT_NUMBER_INTNUMC10
ITM_TYPECRM Item Category CRMT_ITM_TYPECHAR4CRMD_ITEM_TYPE
REF_HEAD_GUIDHeader GUID for CRM Transaction or Billing Eng. Billing Doc. CMRT_BUS_TRANS_HEAD_GUIDCHAR32CRMD_GUID_C
REF_ITEM_GUIDItem GUID for CRM Transaction or Billing Engine Billing Doc. CRMT_BUS_TRANS_ITEM_GUIDCHAR32CRMD_GUID_C
PAYERCRM Business Partner (Payer) CRMT_PAYER_GUIDCHAR32CRMD_GUID_C
SALES_ORGSales Organization VKORGCHAR4Assigned to domainVKORGVKOC_VKORG
DISTR_CHANDistribution Channel VTWEGCHAR2Assigned to domainVTWEGVTWC_VTWEG
DIVISIONDivision SPARTCHAR2Assigned to domainSPARTSPAC_SPART
LOCAL_CURRLocal Currency LOCAL_CURRCUKY5CURRENCY
EXCHG_RATEExchange Rate EXCHANGE_RATEDEC9(5) EXCHANGE_RATE
CURRENCYCurrency Key CURRENCYCUKY5Assigned to domainWAERS
TIME_ZONETime Zone TIMEZONECHAR6Assigned to domainTZNZONE
KKBERCredit control area KKBERCHAR4Assigned to domainKKBERKKB
PROD_PR_GROUPCRM Product Group CRMT_PROD_GROUPCHAR2CRMD_PROD_GROUP
OP_QUOTE_NETVCredit: Open Net Quotation Value in Document Currency CRMT_OQNVCURR15(2) WERTV8
OP_QUOTE_NETV_GUCredit: Open Secured Net Quotation Value in BW CRMT_OQNVGCURR15(2) WERTV8
OP_QUOTE_TAXVCredit: Open Taxable Quotation Value in Document Currency CRMT_OQTVCURR15(2) WERTV8
OP_QUOTE_TAXV_GUCredit: Open Secured Taxable Quotation Value in BW CRMT_OQTVGCURR15(2) WERTV8
OPEN_QUOTE_DATECredit: Date for Open Quotation Value CRMT_OQDTCHAR14TIMESTAMP
OP_ORDER_NETVCredit: Open Sales Order Net Value in Document Currency CRMT_OONVCURR15(2) WERTV8
OP_ORDER_NETV_GUCredit: Open Secured Sales Order Value in BW CRMT_OONVGCURR15(2) WERTV8
OP_ORDER_TAXVCredit: Open Taxable Order Value in Document Currency CRMT_OOTVCURR15(2) WERTV8
OP_ORDER_TAXV_GUCredit: Open Secured Taxable Order Value in BW CRMT_OOTVGCURR15(2) WERTV8
OP_ORDER_DATECredit: Date for Open Sales Order Value CRMT_OODTCHAR14TIMESTAMP
OP_ORDER_SUPPLOpen Sales Order Value Delivered, Service Performed CRMT_OOSPLCHAR1BOOLEAN
OP_DELIV_NETVCredit: Open Net Delivery Value in Document Currency CRMT_ODNVCURR15(2) WERTV8
OP_DELIV_NETV_GUCredit: Open Guaranteed Net Delivery Value in BW CRMT_ODNVGCURR15(2) WERTV8
OP_DELIV_TAXVCredit: Open Delivery Control Value in Document Currency CRMT_ODTVCURR15(2) WERTV8
OP_DELIV_TAXV_GUCredit: Open Secured Delivery Control Value in BW CRMT_ODTVGCURR15(2) WERTV8
OP_INVOICE_NETVCredit: Open Billing Document Net Value in Doc. Currency CRMT_OINVCURR15(2) WERTV8
OP_INV_NETV_GUCredit: Open Secured Billing Doc. Net Value in Doc. Currency CRMT_OINVGCURR15(2) WERTV8
OP_INVOICE_TAXVCredit: Open Billing Document Net Value in Doc. Currency CRMT_OITVCURR15(2) WERTV8
OP_INV_TAXV_GUCredit: Open Secured Billing Document Net Value in BW CRMT_OITVGCURR15(2) WERTV8
OP_INVOICE_DATECredit: Date for Open Billing Document Value CRMT_OIDTCHAR14TIMESTAMP

Key field Non-key field



How do I retrieve data from SAP table CMDET_S06667 using ABAP code

The following ABAP code Example will allow you to do a basic selection on CMDET_S06667 to SELECT all data from the table
DATA: WA_CMDET_S06667 TYPE CMDET_S06667.

SELECT SINGLE *
FROM CMDET_S06667
INTO CORRESPONDING FIELDS OF WA_CMDET_S06667
WHERE...

How to access SAP table CMDET_S06667

Within an ECC or HANA version of SAP you can also view further information about CMDET_S06667 and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!