CRMS4D_COMP_I

Item Table for Complaints | #transactional | Component: S4CRM: Complaints
Column Name Description
CLIENT FK Client
OBJTYPE_H FK Business Trans. Cat.
OBJECT_ID Transaction ID
NUMBER_INT Shortened Item Number in Document
Column Name Description
Column Name Description
ORIG_ORDER_QTY CRM: Original Order Quantity (Unrounded Cumulated qty.)
ORDER_QTY CRM: Order Quantity
CONFIRMED_QTY CRM: Confirmed Quantity
Column Name Description
POSTING_DATE Posting Date for a Business Transaction
Column Name Description
ITM_USAGE Usage of Higher-Level Item Show values
PRODUCT_KIND Product Technical Type Show values
REVACC_RELEVANT_TYPE Revenue Accounting Type Show values
STAT_LIFECYCLE Life Cycle Status Show values
STAT_ERROR Error Status Show values
STAT_OPEN Status "Open" Show values
TEMPLATE_TYPE Template Type of CRM Transaction Show values
ARCHIVING_FLAG Indicator Whether the Business Transaction Can Be Archived Show values
CMPL_ITM_IS_COMPLETE Complaint Complete Show values
CMPL_ITM_IS_ENT Complaint Entitled Show values
CMPL_ITM_IS_ACC Complaint Accepted Show values
CMPL_ITM_IS_FOC Complaint Free Of Charge Show values
CMPL_ITM_IS_GOW Complaint Goodwill Show values
Column Name Description Domain name
SRV_CUST_END Service Request Due Date TZNTSTMPS
ITEM_GUID GUID of a CRM Order Object SYSUUID
CREATED_AT_I Created At TZNTSTMPS
CREATED_BY_I User that Created the Transaction UNAME
CHANGED_AT_I Changed At TZNTSTMPS
CHANGED_BY_I Transaction Last Changed By UNAME
HEADER_GUID GUID of a CRM Order Object SYSUUID
PARENT GUID of a CRM Order Object SYSUUID
ALTERNATIVE GUID of a CRM Order Object SYSUUID
PRODUCT Internal Unique ID of Product SYSUUID
ORDERED_PROD Product Name Entered CRM_ORDERED_PROD
PARTNER_PROD Product Number of Business Partner PRSHTEXT40
DESCRIPTION_I Product Description CRM_PRSHTEXT40_DB
ITM_LANGUAGE Short Text Language for an Item SYLANGU
NUMBER_EXT External Item Number
ORDER_DATE Posting Date BCOS_TSTMP
REVACC_REFID Revenue Accounting Reference ID
REVACC_REFTYPE Revenue Accounting Reference Type
PRODUCT_ID Product Number MATNR
ITEM_GUID_CHAR 32 Character CRM Object GUID (Converted)
REPORTER Customer Contact Person BU_PARTNER
PROCESS_QTY_NUM Numerator (factor) for conversion trans. quantity in BME CRM_PROCESS_QTY_NUM
PROCESS_QTY_DEN Denominator (factor) for conversion trans. quantity in BME CRM_PROCESS_QTY_DEN
EXPONENT10 10 Exponent for Quantity Conversion CRM_EXPONENT10
LATEST_CONF_DATE Latest Confirmation Date for an Item BCOS_TSTMP
DLV_GROUP_DATE Delivery Group Date BCOS_TSTMP
LATEST_REQ_DATE Latest Requested Date for an Item BCOS_TSTMP
FIRST_REQ_DATE First Requested Delivery Date for an Item BCOS_TSTMP
FIRST_CONF_DATE First Confirmed Delivery Date for Item BCOS_TSTMP
DESCRIPTION_H Transaction Description CRM_PROCESS_DESCRIPTION
CREATED_AT_H Created At TZNTSTMPS
CREATED_BY_H User that Created the Transaction UNAME
CHANGED_AT_H Changed At TZNTSTMPS
CHANGED_BY_H Transaction Last Changed By UNAME
ITEM_NO_APPT Shortened Item Number in Document CRMS4_NUMBER_INT
ITEM_NO_PARTNER Shortened Item Number in Document CRMS4_NUMBER_INT
ITEM_NO_QUALIF Shortened Item Number in Document CRMS4_NUMBER_INT
ITEM_NO_REFOBJ Shortened Item Number in Document CRMS4_NUMBER_INT
ITEM_NO_SUBJECT Shortened Item Number in Document CRMS4_NUMBER_INT
ITEM_NO_SURVEY Shortened Item Number in Document CRMS4_NUMBER_INT
ITEM_NO_BILLPLAN Shortened Item Number in Document CRMS4_NUMBER_INT
ITEM_NO_PAYPLAN Shortened Item Number in Document CRMS4_NUMBER_INT
ISSUE_CAUSED_BY Complaint Issue Caused By CRMS4_COMP_ISS_CAU
COMP_I_DUMMY_PS Single-Character Flag CHAR1
Master Data Relations Join Conditions
Authorization Scope
  • ?
  • Authorization Scope
Base Unit of Measure of Product
  • CRMS4D_COMP_I.CLIENT == T006.MANDT
  • CRMS4D_COMP_I.BASE_QTY_UNIT == T006.MSEHI
CRM Business Transaction Classification
  • CRM Business Transaction Classification
  • ?
Client CRMS4D_COMP_I.CLIENT == T000.MANDT
Complaint Impact
Complaint Reason
Customer Contact Person
  • Customer Contact Person
  • Client
  • CRMS4D_COMP_I.CONTACT_PERSON == BUT000.PARTNER
  • CRMS4D_COMP_I.CLIENT == BUT000.CLIENT
Language Key of Description CRMS4D_COMP_I.DESCR_LANGUAGE == T002.SPRAS
Item Category
Item Category Usage
Business Trans. Cat. CRMS4D_COMP_I.OBJTYPE_H == CRMC_SUBOB_CAT.SUBOBJ_CATEGORY
CRM Item Object Type CRMS4D_COMP_I.OBJTYPE_I == CRMC_SUBOB_CAT_I.SUBOBJ_CATEGORY
Employee Responsible
  • Employee Responsible
  • Client
  • CRMS4D_COMP_I.PERSON_RESP == BUT000.PARTNER
  • CRMS4D_COMP_I.CLIENT == BUT000.CLIENT
Activity Priority
  • CRMS4D_COMP_I.CLIENT == SCPRIO.CLIENT
  • CRMS4D_COMP_I.PRIORITY == SCPRIO.PRIORITY
Unit of Measure in Which the Product Is Sold
  • CRMS4D_COMP_I.CLIENT == T006.MANDT
  • CRMS4D_COMP_I.PROCESS_QTY_UNIT == T006.MSEHI
Business Transaction Type
Sold-To Party
  • Sold-To Party
  • Client
  • CRMS4D_COMP_I.SOLD_TO_PARTY == BUT000.PARTNER
  • CRMS4D_COMP_I.CLIENT == BUT000.CLIENT