SAP Table CRMD_ORDERADM_I stores Business Transaction Itemdata

  

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


SAP CRMD_ORDERADM_I dictionary attributes

Object Name: CRMD_ORDERADM_I
Dictionary Type: Transparent table
Description: Business Transaction Item


CRMD_ORDERADM_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) *ClientMANDTTEST
GUIDCRMT_OBJECT_GUIDRAW16(0) GUID of a CRM Order ObjectSYSUUID
CREATED_ATCOMT_CREATED_AT_USRDEC15(0) Created At (Output in User Time Zone)COM_TSTMP
CREATED_BYCRMT_CREATED_BYCHAR12(0) User that Created the TransactionUNAMEUSER_ADDRBNAME
CHANGED_ATCOMT_CHANGED_AT_USRDEC15(0) Changed At (Output in User Time Zone)COM_TSTMP
CHANGED_BYCRMT_CHANGED_BYCHAR12(0) Transaction Last Changed ByUNAME
OBJECT_TYPECRMT_SWO_OBJTYP_PROCESS_ITM_DBCHAR10(0) *CRM Item Object TypeCRM_OJ_NAME_PROCESS_ITEM
DESCRIPTION_UCCRMT_PRSHTEXTG_DBCHAR40(0) Product Short Text in Upper Case for F4 HelpCRM_PRSHTEXTG40_DB
HEADERCRMT_OBJECT_GUIDRAW16(0) GUID of a CRM Order ObjectSYSUUID
PARENTCRMT_OBJECT_GUIDRAW16(0) GUID of a CRM Order ObjectSYSUUID
ALTERNATIVECRMT_OBJECT_GUIDRAW16(0) GUID of a CRM Order ObjectSYSUUID
PRODUCTCRMT_PRODUCT_GUID_DBRAW16(0) Internal Unique ID of ProductSYSUUID
PRODUCT_SRC_SYSCRMT_PRODUCT_SRC_SYSCHAR10(0) *Logical System from Which Product OriginatesLOGSYS
ORDERED_PRODCRMT_ORDERED_PROD_DBCHAR54(0) Product Name EnteredCRM_ORDERED_PROD
PARTNER_PRODCRMT_ITEM_DESCR_PARTNERCHAR40(0) Product Number of Business PartnerPRSHTEXT40
DESCRIPTIONCRMT_PRSHTEXTX_DBCHAR40(0) Product Short TextCRM_PRSHTEXT40_DB
ITM_LANGUAGECRMT_ITEM_LANGULANG1(0) Short Text Language for an ItemSYLANGU
NUMBER_INTCRMT_ITEM_NONUMC10(0) Item Number in DocumentCRM_ITEM_NO
NUMBER_EXTCRMT_ITEM_NO_EXTNUMC10(0) External Item Number
ITM_TYPECRMT_ITEM_TYPE_DBCHAR4(0) *Item CategoryCRM_ITEM_TYPE
ORDER_DATECRMT_ORDER_DATEDEC15(0) Posting DateBCOS_TSTMP
SUBST_REASONCRMT_ITEM_SUBSTITUTIONCHAR4(0) *Reason for Product SubstitutionCRM_ITEM_SUBSTITUTION
ITM_USAGECRMT_ITEM_USAGECHAR2(0) Usage of Higher-Level ItemCRM_ITEM_USAGE
ITM_TYPE_USAGECRMT_IT_TYPE_USAGECHAR4(0) *Item Category UsageCRM_IT_TYPE_USAGE
PRODUCT_KINDCRMT_PRODUCT_KINDCHAR1(0) Technnical Type of ProductCRM_PRODUCT_KIND
LOG_SYSTEM_EXTCRMT_LOGSYSCHAR10(0) *Logical SystemLOGSYS
ORDERADM_I_DUMMYDUMMYCHAR1(0) Dummy function in length 1DUMMYSAP