SAP Table CRMD_CUSTOMER_I stores Transaction Item - Customer Extensiondata

  

In this post, I will try and describe everything you need to know about the SAP crmd_customer_i table. What it is, including what type of data it stores.

A list of fields which make up the table structure and on an S/4Hana System for CRMD_CUSTOMER_I what does this table look like.

And what relationships it has with other SAP tables.

Also see here for example ABAP code to select data from CRMD_CUSTOMER_I....Right lets get started!


SAP CRMD_CUSTOMER_I dictionary attributes

Object Name: CRMD_CUSTOMER_I
Dictionary Type: Transparent table
Description: Transaction Item - Customer Extension


CRMD_CUSTOMER_I field list

Field Data Element Data Type length (Dec) Check table Description Conversion Routine Domain Name MemoryID AppClass SHLP SHLP Field ConvExit
CLIENTMANDTCLNT3(0) *ClientMANDTTESTCRM
GUIDCRMT_OBJECT_GUIDRAW16(0) GUID of a CRM Order ObjectSYSUUIDCRM
CUSTOMER_INTDUMMYCHAR1(0) Dummy function in length 1DUMMYSAPCRM
CUSTOMER_EXTDUMMYCHAR1(0) Dummy function in length 1DUMMYSAPCRM
ZZVENDOR_REFZEEW_DATAELEMENT0134CHAR30(0) CRM
ZZJOB_NOZEEW_DATAELEMENT0135CHAR12(0) CRM
ZZDEPOT_IDZEEW_DATAELEMENT0136CHAR4(0) CRM
ZZTOW_DISTANCEZEEW_DATAELEMENT0137CHAR3(0) CRM
ZZCHARGE_FLAGZEEW_DATAELEMENT0138CHAR1(0) CRM
ZZINC_COMPLZEEW_DATAELEMENT0139CHAR8(0) CRM
ZZJOB_COMPLZEEW_DATAELEMENT0140CHAR8(0) CRM
ZZLOCATIONZEEW_DATAELEMENT0141CHAR40(0) CRM
ZZPROB_DESCZEEW_DATAELEMENT0142CHAR40(0) CRM
ZZREGISTRATIONZEEW_DATAELEMENT0143CHAR8(0) CRM
ZZPOLICYZEEW_DATAELEMENT0144CHAR16(0) CRM
ZZJOB_TYPEZEEW_DATAELEMENT0146CHAR8(0) CRM
ZZPRODUCTZEEW_DATAELEMENT0147CHAR20(0) CRM
ZZETAZEEW_DATAELEMENT0153CHAR16(0) CRM
ZZARRIVALZEEW_DATAELEMENT0154CHAR16(0) CRM
ZZSTART_TIMEZEEW_DATAELEMENT0155CHAR16(0) CRM
ZZNOMINATED_VEHZEEW_DATAELEMENT0157CHAR1(0) ZCRMC_EEW_0101CRM
ZZPR_CARAVANCLUZC_PR_CARAVANCLUCHAR1(0) CRM
ZZPR_CLUBSTATUSZC_PR_CLUBSTATUSCHAR4(0) CRM
ZZPR_COMPLIMENTZC_PR_COMPLIMENTCHAR1(0) CRM
ZZPR_CONCESSIONZC_PR_CONCESSIONCHAR1(0) CRM
ZZPR_DISABLEMOTZC_PR_DISABLEMOTCHAR1(0) CRM
ZZPR_DISCOUNTDIZC_PR_DISCOUNTDICHAR1(0) CRM
ZZPR_FREE2GOPROZC_PR_FREE2GOPROCHAR1(0) CRM
ZZPR_MEM_CATZC_PR_MEM_CATCHAR3(0) CRM
ZZPR_SERVICECARZC_PR_SERVICECARCHAR2(0) CRM
ZZPR_STAFFZC_PR_STAFFCHAR1(0) CRM
ZZPR_TYPEZC_PR_BU_TYPECHAR1(0) CRM
ZZPR_DOBDATUMDATS8(0) DateDATUMSAPCRM
ZZPR_SERSTARTDTDATUMDATS8(0) DateDATUMSAPCRM
ZZPR_ROUNDINGZC_PR_ROUNDINGCHAR1(0) CRM
ZZPR_ROUNDING2ZC_PR_ROUNDING2CHAR1(0) CRM
ZZPR_MEMDT_SPLDATUMDATS8(0) DateDATUMSAPCRM
ZZFREE2G_PL_SPLZEEW_DATAELEMENT0215CHAR1(0) CRM
ZZPR_FR2GOPRO_SZC_PR_FREE2GOPROCHAR1(0) CRM
ZZMLAP_ITMZEEW_DATAELEMENT0407CHAR1(0) CRM
ZZMLVC_ITMZEEW_DATAELEMENT0411CHAR1(0) CRM
ZZMLUP_ITMZEEW_DATAELEMENT0412CHAR1(0) CRM
ZZMLTC_ITMZEEW_DATAELEMENT0413CHAR1(0) CRM
ZZMLF2_ITMZEEW_DATAELEMENT0414CHAR1(0) CRM
ZZMLF3_ITMZEEW_DATAELEMENT0415CHAR1(0) CRM
ZZMLF4_ITMZEEW_DATAELEMENT0416CHAR1(0) CRM
ZZ1PM_ITMZEEW_DATAELEMENT0417CHAR80(0) CRM
ZZ1PY_ITMZEEW_DATAELEMENT0418CHAR80(0) CRM
ZZMLONACPD_ITMZEEW_DATAELEMENT0419CHAR1(0) CRM
ZZPR_CANC_RSNCRMT_SRV_CANCEL_REASONCHAR4(0) *CRM Service : Reason for CancellationQCODEQSSCRM
ZZYEARSNCAREZEEW_DATAELEMENT0301NUMC2(0) CRM
ZZVEH_COUNTZC_VEH_COUNTINT410(0) CRM
ZZMULTIYEAR_LINKZEEW_DATAELEMENT0302CHAR32(0) CRM
ZZCURRENT_YEARZEEW_DATAELEMENT0303NUMC2(0) CRM
ZZINITIAL_STATUSZEEW_DATAELEMENT0304CHAR5(0) CRM
ZZSCV_LINKZEEW_DATAELEMENT0305CHAR1(0) CRM
ZZREGRADE_FLAGZEEW_DATAELEMENT0306CHAR1(0) CRM
ZZREGRADE_LINKZEEW_DATAELEMENT0307CHAR32(0) CRM
ZZREGRADE_FROMZEEW_DATAELEMENT0308CHAR32(0) CRM
ZZREGRADE_TOZEEW_DATAELEMENT0309CHAR32(0) CRM
ZZREGRADE_DATEZEEW_DATAELEMENT0310DATS8(0) CRM
ZZREGRADE_PRO_YRZEEW_DATAELEMENT0311NUMC2(0) CRM
ZZREF_NUMBERZEEW_DATAELEMENT0312CHAR40(0) CRM
ZZRENEWAL_IZEEW_DATAELEMENT0313CHAR1(0) CRM
ZZTRANS_INDZEEW_DATAELEMENT0314CHAR1(0) ZCRMC_EEW_0301CRM
ZZORG_ITM_ST_DTZEEW_DATAELEMENT0315DATS8(0) CRM
ZZESTAT_UPGRADEZZESTAT_UPGRADECHAR5(0) *CRM
ZZOLD_ITEM_CATZEEW_DATAELEMENT0316CHAR4(0) CRM
ZZREF_VEHZEEW_DATAELEMENT0201CHAR40(0) CRM
ZZIND_OBJZEEW_DATAELEMENT0202CHAR40(0) CRM
ZZADDOTHVEHZEEW_DATAELEMENT0203CHAR1(0) CRM
ZZCHECK_DONEZEEW_DATAELEMENT0204CHAR1(0) CRM
ZZREG_NOZEEW_DATAELEMENT0211CHAR15(0) CRM
ZZREF_VEH_GUIDZC_REF_VEH_GUIDCHAR32(0) CRM
ZZCOLOURZEEW_DATAELEMENT0212CHAR30(0) CRM
ZZRENEWAL_ITEMZEEW_DATAELEMENT0213CHAR32(0) CRM
ZZJOINING_RESZC_JOINING_RESCHAR3(0) ZCRMC_EEW_0201CRM
ZZFREE2G_PLZEEW_DATAELEMENT0215CHAR1(0) ZCRMC_EEW_0202CRM
ZZYEAR12CH_BOXZEEW_DATAELEMENT0216CHAR1(0) CRM
ZZRECEIPT_IDZEEW_DATAELEMENT0217CHAR10(0) CRM
ZZRECEIPT_LINE_IZEEW_DATAELEMENT0218CHAR6(0) CRM
ZZPR_FREE_PRODZC_PR_FREE_PRODUCTCHAR1(0) CRM
ZZCUSTOMER_I0801ZEEW_DATAELEMENT0801CHAR17(0) CRM
ZZCUSTOMER_I0802ZEEW_DATAELEMENT0802NUMC10(0) CRM
ZZCUSTOMER_I1001ZEEW_DATAELEMENT1001CHAR6(0) CRM
ZZCUSTOMER_I1002ZEEW_DATAELEMENT1002CHAR6(0) CRM
ZZCUSTOMER_I1003ZEEW_DATAELEMENT1003CHAR6(0) CRM
ZZCUSTOMER_I1101ZEEW_DATAELEMENT1101CHAR6(0) CRM
ZZCUSTOMER_I1201ZEEW_DATAELEMENT1201CHAR6(0) CRM
ZZCUSTOMER_I1401ZEEW_DATAELEMENT1401CHAR1(0) CRM
ZZCUSTOMER_I1801ZEEW_DATAELEMENT1801DEC15(0) CRM
ZZCUSTOMER_I2601ZEEW_DATAELEMENT2601NUMC2(0) CRM