CRMS4D_IUCI_I

OneOrder - Utilities Contract - Item | #transactional | Component: S4CRM: Utilities Industry
Column Name Description
CLIENT FK Client
OBJTYPE_H FK Business Trans. Cat.
OBJECT_ID FK Transaction ID
NUMBER_INT Shortened Item Number in Document
Column Name Description
Column Name Description
Column Name Description
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
SEPA_ON Indicator for SEPA-Relevant Transactions Show values
STAT_LIFECYCLE Life Cycle Status Show values
STAT_RELEASED Release Status Show values
STAT_QUOTATION Quotation Status Show values
STAT_ERROR Error Status Show values
STAT_CANCELLED Cancellation Status Show values
STAT_OPEN Status "Open" Show values
STAT_ARCHIVABLE Archivable Show values
STAT_ARCHIVED Archived Show values
SDM_STATUS Silent Data Migration Status Show values
Column Name Description Domain name
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
OBJTYPE_I CRM Item Object Type CRM_OJ_NAME_PROCESS_ITEM
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
ITM_TYPE Item Category CRM_ITEM_TYPE
ORDER_DATE Posting Date BCOS_TSTMP
ITM_TYPE_USAGE Item Category Usage CRM_IT_TYPE_USAGE
REVACC_REFID Revenue Accounting Reference ID
REVACC_REFTYPE Revenue Accounting Reference Type
ITEM_GUID_CHAR 32 Character CRM Object GUID (Converted)
PREVIOUS_ITEM Shortened Item Number in Document CRMS4_IU_NUMBER_INT
PF_PROCESS Technical Name of Process CRMS4_IU_PFPROCESSNAME
UI_PROCESS Technical Name of UI Process CRMS4_IU_UIPROCESSNAME
LOGICAL_CONTRACT_ITEM Logical Identifier for Associated Contract Items CRMS4_IU_LOGICAL_CONTRACT_ITEM
CONTSTART Contract Start date DEC15
CONTEND Contract End Date DEC15
PERIOD_DATE Period Date BCOS_TSTMP
RULE_PERIOD_DATE Rule for Determining the Period Date TIMERULEID
SETTL_FROM Start of Settlement for Period BCOS_TSTMP
RULE_SETTL_FROM Rule for Determining Start of Settlement Period TIMERULEID
SETTL_TO End of Settlement for Period BCOS_TSTMP
RULE_SETTL_TO Rule for Determining End of Settlement Period TIMERULEID
BILL_DATE Billing Date for Billing Index and Printout TZNTSTMPS
RULE_BILL_DATE Rule for Determining the Next Billing Date TIMERULEID
INVCR_DATE Billing Document Creation Date TZNTSTMPS
RULE_INVCR_DATE Rule for Determining Next Billing Document Creation Date TIMERULEID
VALUE_DATE Fixed Value Date BCOS_TSTMP
RULE_VALUE_DATE Rule for Origin of Next Fixed Value Date TIMERULEID
BILLING_TIMEZONE Time Zone of Billing Plan Set TZNZONE
BILLING_BLOCK Business Partner: Billing Block Reason FAKSP
MANDATE_ID Unique Reference to Mandate per Payment Recipient CRM_MANDATE_ID
KIND_PERIOD_DATE Date type SC_APPTTYP
KIND_SETTL_FROM Date type SC_APPTTYP
KIND_SETTL_TO Date type SC_APPTTYP
KIND_BILL_DATE Date type SC_APPTTYP
KIND_INVCR_DATE Date type SC_APPTTYP
KIND_VALUE_DATE Date type SC_APPTTYP
KIND_START_DATE Date type SC_APPTTYP
KIND_END_DATE Date type SC_APPTTYP
KIND_DATE_FROM Date type SC_APPTTYP
KIND_DATE_TO Date type SC_APPTTYP
CANCPROC Cancellation Procedure CRM_CANCPROCEDURE
CANCPARTY Cancelling Party CRM_CANC_PARTY
CANC_REASON CRM Service : Reason for Cancellation CRMS4_CANC_REASON
IUCT_I_DUMMY_PS Single-Character Flag CHAR1
IUCT_I_DUMMY_TR Single-Character Flag CHAR1
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
Master Data Relations Join Conditions
Client CRMS4D_IUCI_I.CLIENT == T000.MANDT
Contract Account Number
  • CRMS4D_IUCI_I.CLIENT == FKKVK.MANDT
  • CRMS4D_IUCI_I.CONTRACT_ACCOUNT == FKKVK.VKONT
Installation CRMS4D_IUCI_I.INSTALLATION == EANL.MANDT
Contract
  • CRMS4D_IUCI_I.CLIENT == EVER.MANDT
  • CRMS4D_IUCI_I.ISU_CONTRACT == EVER.VERTRAG
Business Trans. Cat. CRMS4D_IUCI_I.OBJTYPE_H == CRMC_SUBOB_CAT.SUBOBJ_CATEGORY
Premise
  • Premise
  • Client
  • CRMS4D_IUCI_I.PREMISE == EVBS.VSTELLE
  • CRMS4D_IUCI_I.CLIENT == EVBS.MANDT
Product Number
  • Product Number
  • Client
  • CRMS4D_IUCI_I.PRODUCT_ID == MARA.MATNR
  • CRMS4D_IUCI_I.CLIENT == MARA.MANDT