SAP table CRMD_ORDERADM_I (Business Transaction Item)

SAP table CRMD_ORDERADM_I has 2 primary key fields being CLIENT,GUID.

Field Description Data Type Length Decimals Checktable Data Element
CLIENT Client CLNT 3 0 * MANDT
GUID GUID of a CRM Order Object RAW 16 0 CRMT_OBJECT_GUID
CREATED_AT Created At (Output in User Time Zone) DEC 15 0 COMT_CREATED_AT_USR
CREATED_BY User that Created the Transaction CHAR 12 0 CRMT_CREATED_BY
CHANGED_AT Changed At (Output in User Time Zone) DEC 15 0 COMT_CHANGED_AT_USR
CHANGED_BY Transaction Last Changed By CHAR 12 0 CRMT_CHANGED_BY
OBJECT_TYPE CRM Item Object Type CHAR 10 0 * CRMT_SWO_OBJTYP_PROCESS_ITM_DB
DESCRIPTION_UC Product Description in Uppercase for F4 Help CHAR 40 0 CRMT_PRSHTEXTG_DB
HEADER GUID of a CRM Order Object RAW 16 0 CRMT_OBJECT_GUID
PARENT GUID of a CRM Order Object RAW 16 0 CRMT_OBJECT_GUID
ALTERNATIVE GUID of a CRM Order Object RAW 16 0 CRMT_OBJECT_GUID
PRODUCT Internal Unique ID of Product RAW 16 0 CRMT_PRODUCT_GUID_DB
PRODUCT_SRC_SYS Logical System from Which Product Originates CHAR 10 0 * CRMT_PRODUCT_SRC_SYS
ORDERED_PROD Product Name Entered CHAR 54 0 CRMT_ORDERED_PROD_DB
PARTNER_PROD Product Number of Business Partner CHAR 40 0 CRMT_ITEM_DESCR_PARTNER
DESCRIPTION Product Description CHAR 40 0 CRMT_PRSHTEXTX_DB
ITM_LANGUAGE Short Text Language for an Item LANG 1 0 CRMT_ITEM_LANGU
NUMBER_INT Item Number in Document NUMC 10 0 CRMT_ITEM_NO
NUMBER_EXT External Item Number NUMC 10 0 CRMT_ITEM_NO_EXT
ITM_TYPE Item Category CHAR 4 0 * CRMT_ITEM_TYPE_DB
ORDER_DATE Posting Date DEC 15 0 CRMT_ORDER_DATE
SUBST_REASON Reason for Product Substitution CHAR 4 0 * CRMT_ITEM_SUBSTITUTION
ITM_USAGE Usage of Higher-Level Item CHAR 2 0 CRMT_ITEM_USAGE
ITM_TYPE_USAGE Item Category Usage CHAR 4 0 * CRMT_IT_TYPE_USAGE
PRODUCT_KIND Product Technical Type CHAR 1 0 CRMT_PRODUCT_KIND
LOG_SYSTEM_EXT Logical System CHAR 10 0 * CRMT_LOGSYS
ORDERADM_I_DUMMY Dummy function in length 1 CHAR 1 0 DUMMY
ALTID_TYPE ID Type for Alternative IDs CHAR 16 0 COMT_ALTID_TYPE
PARENT_IN_COMP_TX Higher-Level Item Number in Composite Transaction RAW 16 0 CRMT_COMP_TX_PARENT_GUID
NUMBER_INT_COMP_TX Composite Transaction-Specific Item Number NUMC 10 0 CRMT_COMP_TX_ITEM_NO
REVACC_REFID Revenue Accounting Reference ID CHAR 30 0 CRMT_REVACC_REFID
REVACC_REFTYPE Revenue Accounting Reference Type CHAR 3 0 CRMT_REVACC_REFTYPE
REVACC_RELEVANT_TYPE Revenue Accounting Type CHAR 1 0 CRMT_REVACC_RELEVANT_TYPE
Not relevant for Revenue Accounting
X Relevant for Revenue Accounting
Y Relevant for Revenue Accounting due to Operational Load
PROFIT_CENTER Profit Center CHAR 10 0 PRCTR
PROFIT_CENTER_ORIGIN Profit Center Source Indicator CHAR 1 0 CRMS4_SRVC_PROFIT_CNTR_ORIGIN
A Determined Automatically
C Manually Entered/Selected
KOKRS Controlling Area CHAR 4 0 * KOKRS
PROFIT_DETERMINE_DATE Date DATS 8 0 DATUM
REFBUSSOLNORD Reference Solution Order ID CHAR 10 0 CRMS4_REF_SOLO_OBJECT_ID
REFBUSSOLNORDITM Item Number in Referenced Solution Order NUMC 6 0 CRMS4_REF_SOLO_NUMBER_INT
SUBSCRPNBILLGCYCLE Billing Cycle CHAR 4 0 CRMS4_SUBSCRPN_BILLG_CYCLE
1001 Monthly on First Day of Month
1002 Monthly on Reference Date
1003 Quarterly on First Day of Quarter
1004 Quarterly on Reference Date
1005 Half-Yearly on First Day of Half-Year
1006 Half-Yearly on Reference Date
1007 Yearly on January 1st
1008 Yearly on Reference Date
MIDBILLCYCEXPRTNALLWD Allow Mid-Bill-Cycle Expiration CHAR 1 0 CRMS4_MIDBILL_CYC_EXPRTN_ALLWD
Not Allowed
X Allowed
DEFAULT_TERMS_OVRWRT Overwrite Default Terms CHAR 1 0 CRMS4_OVRWRT_DEFAULT_TERMS_WRK
No
X Yes
PROJ_ORG_ID Service Organization (Project) CHAR 5 0 * CRMS4_PROJ_ORG_ID
COST_CENTER Cost Center CHAR 10 0 * KOSTL