I_CustomerComplaintItem

Customer Complaint Item | view: ICUSTCMPLITM | TRAN | Extraction: Not supported | Component: S4CRM: Complaints
Tables used: CRMS4D_COMP_I, MAKT, T006, T006A
Column Name Description
ServiceObjectType FK Business Trans. Cat.
CustomerComplaint Transaction ID
CustomerComplaintItem Shortened Item Number in Document
Column Name Description
Column Name Description
CustCmplItemQuantity CRM: Order Quantity
Column Name Description
Column Name Description
CustomerComplaintItemStatus Life Cycle Status Show values
CustCmplItemHasError Error Status Show values
CustCmplItemIsOpen Status "Open" Show values
CustCmplItmIsComplete Complaint Complete Show values
CustCmplItmIsEntitled Complaint Entitled Show values
CustCmplItmIsAccepted Complaint Accepted Show values
CustCmplItmIsFreeOfCharge Complaint Free Of Charge Show values
CustCmplItmIsGoodwill Complaint Goodwill Show values
Column Name Description Domain name
CustomerComplaintUUID GUID of a CRM Order Object SYSUUID
CustCmplDescription Transaction Description CRM_PROCESS_DESCRIPTION
CustomerComplaintItemUUID GUID of a CRM Order Object SYSUUID
TextObjectKey 32 Character CRM Object GUID (Converted)
CustCmplItemDescription Product Description CRM_PRSHTEXT40_DB
CustCmplItemCreationDateTime Created At TZNTSTMPS
CustCmplItemChangedDateTime Changed At TZNTSTMPS
CustCmplItemCreatedByUser User that Created the Transaction UNAME
CustCmplItemChangedByUser Transaction Last Changed By UNAME
CustCmplItemProduct Product Name Entered CRM_ORDERED_PROD
ProductID Product Number MATNR
CustCmplIssueCausedBy Complaint Issue Caused By CRMS4_COMP_ISS_CAU
ProductName Material Description TEXT40
UnitOfMeasureLongName Unit of Measurement Text (Maximum 30 Characters) TEXT30
Master Data Relations Join Conditions
Customer Contact Person
  • Client
  • Customer Contact Person
  • I_CUSTOMERCOMPLAINTITEM.MANDT == BUT000.CLIENT
  • I_CUSTOMERCOMPLAINTITEM.CONTACTPERSON == BUT000.PARTNER
Complaint Impact
  • Complaint Impact
  • Client
Item Category
  • Item Category
  • Client
Unit of Measure in Which the Product Is Sold
  • Client
  • Unit of Measure in Which the Product Is Sold
  • I_CUSTOMERCOMPLAINTITEM.MANDT == T006.MANDT
  • I_CUSTOMERCOMPLAINTITEM.CUSTCMPLITEMQUANTITYUNIT == T006.MSEHI
Complaint Reason
  • Complaint Reason
  • Client
Business Transaction Type
  • Business Transaction Type
  • Client
Employee Responsible
  • Employee Responsible
  • Client
  • I_CUSTOMERCOMPLAINTITEM.RESPONSIBLEEMPLOYEE == BUT000.PARTNER
  • I_CUSTOMERCOMPLAINTITEM.MANDT == BUT000.CLIENT
CRM Item Object Type I_CUSTOMERCOMPLAINTITEM.SERVICEDOCUMENTITEMOBJECTTYPE == CRMC_SUBOB_CAT_I.SUBOBJ_CATEGORY
Business Trans. Cat. I_CUSTOMERCOMPLAINTITEM.SERVICEOBJECTTYPE == CRMC_SUBOB_CAT.SUBOBJ_CATEGORY
Sold-To Party
  • Client
  • Sold-To Party
  • I_CUSTOMERCOMPLAINTITEM.MANDT == BUT000.CLIENT
  • I_CUSTOMERCOMPLAINTITEM.SOLDTOPARTY == BUT000.PARTNER