CRMS4_IU_I_S_CTI

Utilities Sales Contract Item | view: CRMS4IUSICTI | Extraction: Not supported | Component: S4CRM: Utilities Industry
Column Name Description
BusinessObjectType FK Business Trans. Cat.
UtilitiesSalesContract FK Transaction ID
UtilitiesSalesContractItem Shortened Item Number in Document
Column Name Description
Column Name Description
Column Name Description
PostingDate Posting Date for a Business Transaction
Column Name Description
UtilsSalesContrItemLifeCycle Life Cycle Status Show values
UtilsSalesContrItemHasError Error Status Show values
UtilsSalesContrItemIsOpen Status "Open" Show values
UtilsSalesContrItemIsReleased Release Status Show values
UtilsSalesContrItemIsRejected Cancellation Status Show values
UtilsSalesContrItemIsQuotation Quotation Status Show values
UtilsSalesContrItemIsArchivabl Archivable Show values
UtilsSalesContrItemIsArchived Archived Show values
UtilsSalesContrItemStatus Contract Item Status Show values
Column Name Description Domain name
UtilitiesSalesContractUUID GUID of a CRM Order Object SYSUUID
UtilsSalesContrItemUUID GUID of a CRM Order Object SYSUUID
UtilsSalesContrItemCharUUID 32 Character CRM Object GUID (Converted)
UtilsSalesContrItemObjectType CRM Item Object Type CRM_OJ_NAME_PROCESS_ITEM
ParentUtilsSalesContrItemUUID GUID of a CRM Order Object SYSUUID
UtilsSalesContrItemDescription Product Description CRM_PRSHTEXT40_DB
UtilsSalesContrLogicalItem Logical Identifier for Associated Contract Items CRMS4_IU_LOGICAL_CONTRACT_ITEM
ItemPostingDateTime Posting Date BCOS_TSTMP
UtilsSalesContrDescription Transaction Description CRM_PROCESS_DESCRIPTION
SoldToPartyCountry Country/Region LAND1
SoldToPartyRegion Region (State, Province, County) REGIO
ServiceTeam Service Team BU_PARTNER
ResponsibleEmployee Employee Responsible BU_PARTNER
ServiceEmployee Executing Service Employee BU_PARTNER
ContactPerson Customer Contact Person BU_PARTNER
PayerParty Payer BU_PARTNER
BillToParty Bill-To Party BU_PARTNER
UtilsSalesContrItemCrtedDteTme Created At TZNTSTMPS
UtilsSalesContrItemChgdDteTme Changed At TZNTSTMPS
UtilsSalesContrItemCrtedByUser User that Created the Transaction UNAME
UtilsSalesContrItemChgdByUser Transaction Last Changed By UNAME
OriginallyRequestedProduct Product Name Entered CRM_ORDERED_PROD
UtilsSalesContrItemStartDteTme Contract Start date DEC15
UtilsSalesContrItemEndDteTme Contract End Date DEC15
UtilsSalesContrLogStartDteTme Earliest Contract Start Date DEC15
UtilsSalesContrLogEndDteTme Latest Contract End Date DEC15
FirstItemPostingDateTime First Purchase Date DEC15
LatestItem Shortened Item Number in Document CRMS4_NUMBER_INT
LatestEndDateTime null
LatestStartDateTime null
ProductName Product Description TEXT40
DivisionName Division Description TEXT20
Language Short Text Language for an Item SYLANGU
Master Data Relations Join Conditions
Business Trans. Cat. CRMS4_IU_I_S_CTI.BUSINESSOBJECTTYPE == CRMC_SUBOB_CAT.SUBOBJ_CATEGORY
Product Number
  • Client
  • Product Number
  • CRMS4_IU_I_S_CTI.MANDT == MARA.MANDT
  • CRMS4_IU_I_S_CTI.PRODUCT == MARA.MATNR
Sold-To Party
  • Client
  • Sold-To Party
  • CRMS4_IU_I_S_CTI.MANDT == BUT000.CLIENT
  • CRMS4_IU_I_S_CTI.SOLDTOPARTY == BUT000.PARTNER
Contract
  • Client
  • Contract
  • CRMS4_IU_I_S_CTI.MANDT == EVER.MANDT
  • CRMS4_IU_I_S_CTI.UTILITIESCONTRACT == EVER.VERTRAG
Contract Account Number
  • Client
  • Contract Account Number
  • CRMS4_IU_I_S_CTI.MANDT == FKKVK.MANDT
  • CRMS4_IU_I_S_CTI.UTILITIESCONTRACTACCOUNT == FKKVK.VKONT
Installation CRMS4_IU_I_S_CTI.UTILITIESINSTALLATION == EANL.MANDT
Premise
  • Client
  • Premise
  • CRMS4_IU_I_S_CTI.MANDT == EVBS.MANDT
  • CRMS4_IU_I_S_CTI.UTILITIESPREMISE == EVBS.VSTELLE
Other Relations | to Master Data Relations ↑ Join Conditions
Division
  • Client
  • Division
  • CRMS4_IU_I_S_CTI.MANDT == TESPT.MANDT
  • CRMS4_IU_I_S_CTI.DIVISION == TESPT.SPARTE