SAP Table CRMD_CL_SALES stores Table for Sales Attributes to MSAdata

  

In this post, I will try and describe everything you need to know about the SAP crmd_cl_sales 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_CL_SALES 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_CL_SALES....Right lets get started!


SAP CRMD_CL_SALES dictionary attributes

Object Name: CRMD_CL_SALES
Dictionary Type: Transparent table
Description: Table for Sales Attributes to MSA


CRMD_CL_SALES 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
GUIDCDB_CL_OM_GUID_SALESRAW16(0) GUID for Sales Attribute RecordSYSUUIDCRM
GUID_ORGUNITCDB_CL_OM_GUID_ORGOBJRAW16(0) CRMD_CL_OMObject GUIDSYSUUIDCRM
OTYPEOTYPECHAR2(0) *Object TypeOTYPEPOTPPCRM
OBJIDOBJEKTIDNUMC8(0) Object IDNUM08PONPPCRM
BEGDABEGDATUMDATS8(0) Start DateDATUMBEGPPCRM
ENDDAENDDATUMDATS8(0) End DateDATUMENDPPCRM
SALES_ORGCRMT_SALES_ORGCHAR14(0) Sales OrganizationHROBJEC_14CRM_ORGMAN_SALES_ORGSALES_ORGCRM
SALES_OFFICECRMT_SALES_OFFICECHAR14(0) Sales OfficeHROBJEC_14CRM_ORGMAN_SALES_OFFICESALES_OFFICECRM
SALES_GROUPCRMT_SALES_GROUPCHAR14(0) Sales GroupHROBJEC_14CRM_ORGMAN_SALES_GROUPSALES_GROUPCRM
VKORGVKORGCHAR4(0) *Sales OrganizationVKORGVKOVC_VKORGVKORGCRM
IS_VKORGCDB_CL_OM_SALES_IS_VKORGCHAR1(0) Indicator: R/3 Sales OrganizationFLAGCRM
VKBURVKBURCHAR4(0) *Sales OfficeVKBURVKBVCRM
VKGRPVKGRPCHAR3(0) *Sales GroupVKGRPVKGVCRM
SALES_CURRENCYCRMT_CURRENCYCUKY5(0) *CurrencyWAERSFWSCRM
COUNTRYKLANDCHAR3(0) *CountryLAND1PPCRM