CRMS4D_SERV_I

Items of service transactions | #transactional | Component: S4CRM: Business Transaction Framework
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
GI_VALUE Goods Issue Value
BILLED_VALUE Invoice Value
RELEASED_VALUE Released Value
NET_VALUE_MAN_I Total Expected Net Value Products in Document Currency
COST_AMOUNT_MAN Total Expected Cost Amount in Document Currency
NET_VALUE_I Net Value
NET_PRICE_I Net Price
TAX_AMOUNT_I Tax amount in document currency
FREIGHT_I Shipment costs in document currency
GROSS_VALUE_I Gross Order Value in PO Currency
NET_WO_FREIGHT_I Item Net Value Exclusive Shipment
SUBTOTAL1 Subtotal 1 from pricing procedure for condition
SUBTOTAL2 Subtotal 2 from pricing procedure for condition
SUBTOTAL3 Subtotal 3 from pricing procedure for condition
SUBTOTAL4 Subtotal 4 from pricing procedure for condition
SUBTOTAL5 Subtotal 5 from pricing procedure for condition
SUBTOTAL6 Subtotal 6 from pricing procedure for condition
TOTAL_DISCOUNT_I Price Determination: Condition Value
TARGET_VALUE Target Value
💲 Currency (CRMD_PRICING.CURRENCY):
RECURRING_CHARGE Periodically charged values
RECURRING_TAX Periodically charged taxes
RECURRING_GROSS Periodically charged values including taxes
Column Name Description
GI_QUANTITY Goods Issue Quantity
ORDERED_QUANTITY Ordered Quantity
BILLED_QUANTITY Invoiced Quantity
DLV_QUANTITY Delivered Quantity
RELEASED_QUANTITY Released Quantity
ORIG_ORDER_QTY CRM: Original Order Quantity (Unrounded Cumulated qty.)
ORDER_QTY CRM: Order Quantity
CONFIRMED_QTY CRM: Confirmed Quantity
SRV_CONF_TIME Confirmed Duration
📏 UOM for Auto Renewal Period (AUTO_RENEW_PERIOD_UNIT):
AUTO_RENEW_PERIOD Unit for Auto Renewal Period
📏 UOM for Contract Extension (AUTO_RENEW_EXTEN_UNIT):
AUTO_RENEW_EXTEN Unit for Contract Extension
📏 Unit of Measure in Which the Product Is Sold (PROCESS_QTY_UNIT):
GROSS_WEIGHT_I Gross Weight
NET_WEIGHT_I Net Weight
VOLUME_I Volume Occupied by the Product per Volume Unit
📏 Unit for Duration of Work (DURATION_UNIT):
DURATION Duration
Column Name Description
PROFIT_DETERMINE_DATE Date
EXCHG_DATE Exchange Rate Date
PRICE_DATE Pricing Date
PO_DATE_SOLD Reference Document Date
PO_DATE_SHIP Ship-To Party's Reference Document Date
SRV_RENDERED_DATE Service Rendered Date
POSTING_DATE Posting Date for a Business Transaction
Column Name Description
APRV_ACTIVATED Logical Variable Show values
CHANGE_ALLOWED Logical Variable Show values
SEPA_ON Indicator for SEPA-Relevant Transactions Show values
BILLING_RELEVANCE Billing Relevance Show values
ITM_USAGE Usage of Higher-Level Item Show values
PRODUCT_KIND Product Technical Type Show values
REVACC_RELEVANT_TYPE Revenue Accounting Type Show values
PROFIT_CENTER_ORIGIN Profit Center Source Indicator Show values
SUBSCRPNBILLGCYCLE Billing Cycle Show values
MIDBILLCYCEXPRTNALLWD Allow Mid-Bill-Cycle Expiration Show values
DEFAULT_TERMS_OVRWRT Overwrite Default Terms Show values
SERVICE_ORG_ORI Origin Indicator: Service Organization Show values
SERVICE_ORGR_ORI Origin Indicator: Service Scenario Organizational Unit Show values
SALES_ORG_ORI Origin Indicator: Sales Organization Show values
DIS_CHANNEL_ORI Origin Indicator: Distribution Channel Show values
SALES_OFF_ORI Origin Indicator: Sales Office Show values
SALES_GROUP_ORI Origin Indicator: Sales Group Show values
SALES_ORGR_ORI Origin Indicator: Sales Scenario Organizational Unit Show values
DIVISION_ORI Origin Flag: Division Show values
SERVICE_TEAM_RM_ORI Origin Indicator: Service Team Show values
PRICING_CONTROL Pricing Control Show values
STATISTICAL Statistical values Show values
PRC_INDICATOR Pricing indicator Show values
CREDIT_INDICATOR Credit Debit Indicator Show values
REC_MAIN_ITM_CUM Cumulation of recurring charges on main item level Show values
CASH_DISC Specifies Whether a Cash Discount Can Be Given for the Prod. Show values
PROBABILITY Order Probability Show values
DATE_QTY_FIXED Fixed Date and Quantity Show values
DISPO_FLG Relevant for Resource Planning Show values
CONFIRM_RELEVANT Relevant for Confirmation Show values
DELI_UNLIM_TOL Indicator: Unlimited Overdelivery Allowed Show values
ORDERCOMBIND Indicator: Order Combination Show values
PART_DLV Delivery Control Show values
PART_DLV_ITM Delivery Control (Item) 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_DELIVERY Delivery Status Show values
STAT_GOODS_ISSUE Goods Issue Status Show values
STAT_BILLING Billing Status Show values
STAT_CANCELLED Cancellation Status Show values
STAT_OPEN Status "Open" Show values
STAT_MAINTENANCE Maintenance Status Show values
STAT_TRANSFER Transfer Status Show values
STAT_CHKLST_EXEC Execution Status of Checklist Item Show values
STAT_ACTIVATION Activation Status of Subscription Order/Contract Show values
STAT_CONT_TS Status of Contract Time Slice Show values
STAT_ACCEPTED Acceptance Status Show values
STAT_FOR_BILLING Billing Release Status Show values
STAT_CREDIT Credit Status of Item Show values
TEMPLATE_TYPE Template Type of CRM Transaction Show values
ARCHIVING_FLAG Indicator Whether the Business Transaction Can Be Archived Show values
PROD_SEL_TYPE Product Selection Type Show values
SC_AUTHOR_INFO SC: Author Inform. Show values
SC_OPT_INDICATOR Solution Configurator Optional/Mandatory Indicator Show values
CC_ACCOUNT_SPLIT Split Subscriber Account for SAP CC Show values
FIX_CONFIG Indicator for Fixing Product Configuration Show values
AUTO_RENEW_INDICATOR Auto-Renewal Indicator Show values
PHASE_INDICATOR Phase Indicator Show values
EXIST_VCKEY Indicator Variant Key Available for Item Show values
ROOT_CONFIG Root Configuration Indicator Show values
BILLPLAN_D_RULE_PRICE_DATE Rule for Determining the Pricing Date Show values
NO_BILLITEMS Generate Flag for No Billing Request Items Show values
BILLINGPLANISFINALIZED Billing Plan Is Finalized Show values
HAS_REF_INHOUSE_REPAIR Reference to In-House Repair Exists Show values
Column Name Description Domain name
AC_ASSIGNMENT Settlement Account Assignment CRMT_AC_ASSIGN
AC_PERCENTAGE Percentage of Costs to Be Distributed DEC3_2
PERIOD_DATE Period Date BCOS_TSTMP
SETTL_FROM Start of Settlement for Period BCOS_TSTMP
SETTL_TO End of Settlement for Period BCOS_TSTMP
BILL_DATE Billing Date for Billing Index and Printout TZNTSTMPS
INVCR_DATE Billing Document Creation Date TZNTSTMPS
VALUE_DATE Fixed Value Date BCOS_TSTMP
MANDATE_ID Unique Reference to Mandate per Payment Recipient CRM_MANDATE_ID
DIP_PROFILE Dynamic Item Processor Profile AD01PROFNR
RESULTS_ANALYSIS_KEY Results Analysis Key ABGR_SCHL
CHKL_STEP_GROUP Checklist Step Group GUID CHKLST_STEP_GRP_GUID
CHKL_STEP_NO Checklist Step Number CHKLST_STEP_NO
CHKL_OPTION_ID Checklist Option ID CRM_CHKLST_OPTION
CHKL_PREV_GROUP Checklist Previous Group GUID CHKLST_PREV_GRP_GUID
CHKL_PREV_NO Checklist Previous Group Number CHKLST_PREV_GRP_NO
CHKL_TRIGGER_ID Checklist Trigger ID CRM_CHKLST_TRIGID
VALID_FROM Time Dependency: Validity Start Date BCOS_TSTMP
VALID_TO Time Dependency: Validity End Date BCOS_TSTMP
QUOT_START Quotation: Valid from Date BCOS_TSTMP
QUOT_END Quotation: Valid to Date BCOS_TSTMP
SRV_CUST_BEG Service Request Start Date TZNTSTMPS
SRV_CUST_END Service Request Due Date TZNTSTMPS
SRQ_WORK_DURA Work Duration of Service Transaction CRMS4_SRQ_WORK_DURA
SRQ_WORK_UNIT Work Duration Unit of Service Transaction CRMS4_SRQ_WORK_UNIT
SRQ_TOT_DURA Total Duration of Service Transaction CRMS4_SRQ_TOT_DURA
SRQ_TOT_UNIT Total Duration Unit of Service Transaction CRMS4_SRQ_TOT_UNIT
CONTSTART Contract Start date DEC15
CONTEND Contract End Date DEC15
CONT_START_TS Start of Contract Time Slice DEC15
CONT_END_TS End of Contract Time Slice DEC15
SRV_RFIRST First Response By TZNTSTMPS
SRV_RREADY Due By TZNTSTMPS
SRV_CLOSE Closing Date TZNTSTMPS
AUTO_RENEW_START Start Date of Auto Renewal Period BCOS_TSTMP
SRQ_WORK_DURA_2 Work Duration 2 of Service Transaction CRMS4_SRQ_WORK_DURA_2
SRQ_TOT_DURA_2 Total Duration 2 of Service Transaction CRMS4_SRQ_TOT_DURA_2
SRVC_ACTUAL Service Actual Start Date TZNTSTMPS
SRVC_ACT_TO Service Actual End Date TZNTSTMPS
SPLA_PLANFR Service Planned From Date TZNTSTMPS
SPLA_PLANTO Service Planned To 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)
PROFIT_CENTER Profit Center PRCTR
KOKRS Controlling Area CACCD
REFBUSSOLNORD Reference Solution Order ID CRM_OBJECT_ID
REFBUSSOLNORDITM Item Number in Referenced Solution Order CRMS4_NUMBER_INT
PROJ_ORG_ID Service Organization (Project) /CPD/PWS_WS_ORG_UNIT_ID
COST_CENTER Cost Center KOSTL
SALES_ORG Sales Organization ID HROBJEC_14
SALES_OFFICE Sales Office HROBJEC_14
SALES_GROUP Sales Group HROBJEC_14
SALES_ORG_RESP Organizational Unit (Sales) HROBJEC_14
SERVICE_ORG Service Organization HROBJEC_14
SERVICE_ORG_RESP Organizational Unit (Service) HROBJEC_14
SALES_ORG_SD Sales Organization VKORG
SALES_OFFICE_SD Sales office VKBUR
SALES_GROUP_SD Sales group VKGRP
ENTERPRISE_SERVICE_ORG Enterprise Service Organization CRMS4_ENTERPRISE_SERVICE_ORG
SERVICE_TEAM_RM Service Team (Responsibility Management) HROBJID
EXCHG_RATE Exchange Rate CRM_EXCHG_RATE
VAT_REG_NO Sales tax registration number
PRICE_LIST Price List Type PLTYP
NETPR_PRIC_UNIT Condition Pricing Unit PRC_CONDITION_PRICING_UNIT
REC_DURATION Duration of a recurrence period TIMEDURA
PRICE_SOURCE Source of price in service confirmation PRICE_SOURCE
PRICE_PRODUCT Pricing Reference Product Globally Unique Identifier SYSUUID
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
COMM_GROUP Commission Group CRM_COMM_GROUP
REBATE_GROUP Volume Rebate Group CRM_REBATE_GROUP
PROD_HIERARCHY Product Category COM_CATEGORY_ID
PO_NUMBER_SOLD Sold-To Party's External Reference Number TEXT35
YOUR_REF_SOLD Sold-to Party Reference TEXT12
PO_NUMBER_SHIP Ship-To Party's External Reference Number TEXT35
YOUR_REF_SHIP Ship-To Party Reference TEXT12
SUBMISSION Collective Number for Quotations TEXT10
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
SERVICE_TYPE Service Type CRMT_SERVICE_TYPE
VALUATION_TYPE Valuation Type CRMT_VALUATION_TYPE
SRV_ESCAL Response Profile CRM_SRV_ESCAL
SRV_SERWI Service Profile CRM_SRV_SERWI
SRV_RULE_ID Internal Identification of Rules of Periodic Appointments TEXT25
SRCL_SERVICE_PROFILE Processing Times: Service Profile CRM_SRV_SERWI
SRCL_RESPONSE_PROFILE Processing Time: Response Profile CRM_SRCL_RSPRF
SRV_ESCAL_CHANGED Single-Character Flag CHAR1
SRV_SERWI_CHANGED Single-Character Flag CHAR1
WARRANTY_ID Master warranty number MGANR
OVERTIME_CAT Overtime Category CATS_OVERTIME_CATEGORY
ITEM_PRIORITY Activity Priority SC_PRIO
INCOTERMS2 Incoterms (Part 2) CRM_INCOTERMS2
OVER_DLV_TOL Overdelivery Tolerance Limit PRZ21
UNDER_DLV_TOL Underdelivery Tolerance Limit PRZ21
DLV_GROUP Delivery Group (Items are Delivered Together) CRMT_DLV_GROUP
CATLVLGUID01_01 Category GUID 1- schema 1 SYSUUID
CATLVLGUID02_01 Category GUID 2- schema 1 SYSUUID
CATLVLGUID03_01 Category GUID 3- schema 1 SYSUUID
CATLVLGUID04_01 Category GUID 4- schema 1 SYSUUID
CATLVLGUID05_01 Category GUID 5- schema 1 SYSUUID
CATLVLGUID06_01 Category GUID 6- schema 1 SYSUUID
CATLVLGUID07_01 Category GUID 7- schema 1 SYSUUID
CATLVLGUID08_01 Category GUID 8- schema 1 SYSUUID
CATLVLGUID09_01 Category GUID 9- schema 1 SYSUUID
CATLVLGUID10_01 Category GUID 10- schema 1 SYSUUID
ASP_ID_01 Coherent Cat. - Aspect ID CRMS4_ERMS_CAT_AS_ID_DO
CAT_ID_01 Coherent Cat. - Category ID CRMS4_ERMS_CAT_CA_ID_DO
CATLVLGUID01_02 Category GUID 1- schema 2 SYSUUID
CATLVLGUID02_02 Category GUID 2- schema 2 SYSUUID
CATLVLGUID03_02 Category GUID 3- schema 2 SYSUUID
CATLVLGUID04_02 Category GUID 4- schema 2 SYSUUID
CATLVLGUID05_02 Category GUID 5- schema 2 SYSUUID
CATLVLGUID06_02 Category GUID 6- schema 2 SYSUUID
CATLVLGUID07_02 Category GUID 7- schema 2 SYSUUID
CATLVLGUID08_02 Category GUID 8- schema 2 SYSUUID
CATLVLGUID09_02 Category GUID 9- schema 2 SYSUUID
CATLVLGUID10_02 Category GUID 10- schema 2 SYSUUID
ASP_ID_02 Coherent Cat. - Aspect ID CRMS4_ERMS_CAT_AS_ID_DO
CAT_ID_02 Coherent Cat. - Category ID CRMS4_ERMS_CAT_CA_ID_DO
DESCRIPTION_H Transaction Description CRM_PROCESS_DESCRIPTION
CREATED_AT_H Created At (Output in User Time Zone) COM_TSTMP
CREATED_BY_H User that Created the Transaction UNAME
CHANGED_AT_H Changed At (Output in User Time Zone) COM_TSTMP
CHANGED_BY_H Transaction Last Changed By UNAME
SERV_I_DUMMY_PS 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
CI_CONTRACT_ID IS-T Contract Number IST_EXT_REF
CI_CONTRACT_ITEM Contract Item Identifier SYSUUID
BTMF_PROCESS Process of Maint. FW IST_PROCESS
BTMF_PROCESS_TYPE Process Type IST_ITEM_PROCESS
SC_GROUP Sol. Conf. Group IST_SC_GROUP
SC_DOC_GUID SC: Doc. GUID IST_SC_DOCUMENT_ID
SC_INTERLINKAGE_GUID Internal, Unique ID of a Relationship SYSUUID
CCM_VERSION Version CRM_IST_CCM_VERSION
RATING_AREA Rating Area ID CRM_RAT_AREA
CI_BILLING_PLAN_CYCLE Billing Plan Cycle CYCLE_KK
CONTRACT_CHANGE_REASON Contract Change Reason
MA_HEAD_OBJID Transaction ID CRM_OBJECT_ID
MA_ITEM_OBJID Shortened Item Number in Document CRMS4_NUMBER_INT
MA_ROOT_OBJID Shortened Item Number in Document CRMS4_NUMBER_INT
POOL_AGR_REF Reference to Sharing Contract IST_EXT_REF
MA_SHARE_REF Sharing Order/Contract: Reference to Master Agreement SYSUUID
MA_SHARE_REF_PROD_ID Sharing Order/Contract: Reference to Master Agreement Prod. CRMT_ISX_PRVMA_PROD_ID
SHARING_GROUP_ID Sharing Group ID CRMS4_SOM_SHARING_GROUP_ID
LOCK_REASON Lock Reason IST_LOCK_REASON
CHANGEPROCESSGROUP BTMF Process Group CRMS4_BTMF_PROCESS_GROUP
SUCCESSOR_OF Shortened Item Number in Document CRMS4_NUMBER_INT
CONT_REF_ITEM Shortened Item Number in Document CRMS4_NUMBER_INT
CONT_REF Transaction ID CRM_OBJECT_ID
INT_OBJ_NO Configuration (Internal Object Number) IB_INSTANCE
BILLPLAN_START_DATE Start Date of Billing Plan BCOS_TSTMP
BILLPLAN_END_DATE End Date of Billing Plan BCOS_TSTMP
BILLPLAN_DATE_FROM Dates From BCOS_TSTMP
BILLPLAN_DATE_TO Dates To BCOS_TSTMP
CASHFLOW_TYPE Flow Category CRMT_CASHFLOW_TYPE
REF_INHOUSE_REPAIR Reference In-House Repair CRM_OBJECT_ID
REF_INHOUSE_REPAIR_ITEM Reference In-House Repair Item CRMS4_NUMBER_INT
Master Data Relations | to Other Relations ↓ Join Conditions
Accounting Indicator
  • CRMS4D_SERV_I.CLIENT == TBMOT.MANDT
  • CRMS4D_SERV_I.AC_INDICATOR == TBMOT.BEMOT
Object Type for Settlement Account Assignment
Approval Procedure
Authorization Scope
  • ?
  • Authorization Scope
Base Unit of Measure of Product
  • CRMS4D_SERV_I.CLIENT == T006.MANDT
  • CRMS4D_SERV_I.BASE_QTY_UNIT == T006.MSEHI
Business Partner: Billing Block Reason
  • CRMS4D_SERV_I.CLIENT == TVFS.MANDT
  • CRMS4D_SERV_I.BILLING_BLOCK == TVFS.FAKSP
Time Zone of Billing Plan Set
  • CRMS4D_SERV_I.CLIENT == TTZZ.CLIENT
  • CRMS4D_SERV_I.BILLING_TIMEZONE == TTZZ.TZONE
Time Zone of Billing Plan Set
  • CRMS4D_SERV_I.CLIENT == TTZZ.CLIENT
  • CRMS4D_SERV_I.BILLPLAN_D_TIMEZONE == TTZZ.TZONE
ID of Billing Plan Line
  • ID of Billing Plan Line
  • Client
  • Billing Plan Type
Time Zone of Billing Plan Set
  • CRMS4D_SERV_I.CLIENT == TTZZ.CLIENT
  • CRMS4D_SERV_I.BILLPLAN_TIMEZONE == TTZZ.TZONE
Billing Plan Type
  • Billing Plan Type
  • Client
Bill-To Party
  • Bill-To Party
  • Client
  • CRMS4D_SERV_I.BILL_TO_PARTY == BUT000.PARTNER
  • CRMS4D_SERV_I.CLIENT == BUT000.CLIENT
CRM Business Transaction Classification
  • CRM Business Transaction Classification
  • ?
Cancelling Party
  • Cancelling Party
  • Client
Cancellation Procedure
  • Cancellation Procedure
  • Client
CRM Service : Reason for Cancellation
Checklist Step ID
  • Checklist Step ID
  • Client
Billing Cycle
  • CRMS4D_SERV_I.CLIENT == TFK2607.MANDT
  • CRMS4D_SERV_I.CI_BILLING_CYCLE == TFK2607.CYCLE
Partner Settlement Rule
Client CRMS4D_SERV_I.CLIENT == T000.MANDT
Customer Contact Person
  • Customer Contact Person
  • Client
  • CRMS4D_SERV_I.CONTACT_PERSON == BUT000.PARTNER
  • CRMS4D_SERV_I.CLIENT == BUT000.CLIENT
Contract Account Number
  • CRMS4D_SERV_I.CLIENT == FKKVK.MANDT
  • CRMS4D_SERV_I.CONTRACT_ACCOUNT == FKKVK.VKONT
Currency
  • CRMS4D_SERV_I.CLIENT == TCURC.MANDT
  • CRMS4D_SERV_I.CURRENCY == TCURC.WAERS
Business Partner Type
  • CRMS4D_SERV_I.CLIENT == TB004.CLIENT
  • CRMS4D_SERV_I.CUSTOMER_TYPE == TB004.BPKIND
Customer Group
  • Customer Group
  • Client
  • CRMS4D_SERV_I.CUST_GROUP == T151.KDGRP
  • CRMS4D_SERV_I.CLIENT == T151.MANDT
Customer Group 1
  • CRMS4D_SERV_I.CLIENT == TVV1.MANDT
  • CRMS4D_SERV_I.CUST_GROUP1 == TVV1.KVGR1
Customer Group 2
  • CRMS4D_SERV_I.CLIENT == TVV2.MANDT
  • CRMS4D_SERV_I.CUST_GROUP2 == TVV2.KVGR2
Customer Group 3
  • Customer Group 3
  • Client
  • CRMS4D_SERV_I.CUST_GROUP3 == TVV3.KVGR3
  • CRMS4D_SERV_I.CLIENT == TVV3.MANDT
Customer Group 4
  • CRMS4D_SERV_I.CLIENT == TVV4.MANDT
  • CRMS4D_SERV_I.CUST_GROUP4 == TVV4.KVGR4
Customer Group 5
  • Customer Group 5
  • Client
  • CRMS4D_SERV_I.CUST_GROUP5 == TVV5.KVGR5
  • CRMS4D_SERV_I.CLIENT == TVV5.MANDT
Customer Pricing Procedure
  • Customer Pricing Procedure
  • Client
  • CRMS4D_SERV_I.CUST_PRIC_PROC == TVKD.KALKS
  • CRMS4D_SERV_I.CLIENT == TVKD.MANDT
Business Partner: Delivery Block Reason
  • CRMS4D_SERV_I.CLIENT == TVLS.MANDT
  • CRMS4D_SERV_I.DELIVERY_BLOCK == TVLS.LIFSP
Language Key of Description CRMS4D_SERV_I.DESCR_LANGUAGE == T002.SPRAS
Distribution Channel
  • Distribution Channel
  • Client
  • CRMS4D_SERV_I.DIS_CHANNEL == TVTW.VTWEG
  • CRMS4D_SERV_I.CLIENT == TVTW.MANDT
Division
  • CRMS4D_SERV_I.CLIENT == TSPA.MANDT
  • CRMS4D_SERV_I.DIVISION == TSPA.SPART
Delivery Priority
  • CRMS4D_SERV_I.CLIENT == TPRIO.MANDT
  • CRMS4D_SERV_I.DLV_PRIO == TPRIO.LPRIO
Exchange Rate Type
  • CRMS4D_SERV_I.CLIENT == TCURV.MANDT
  • CRMS4D_SERV_I.EXCHG_TYPE == TCURV.KURST
Incoterms (Part 1)
  • Incoterms (Part 1)
  • Client
  • CRMS4D_SERV_I.INCOTERMS1 == TINC.INCO1
  • CRMS4D_SERV_I.CLIENT == TINC.MANDT
Industry Sector
  • Industry Sector
  • Client
  • CRMS4D_SERV_I.INDUSTRY == T016.BRSCH
  • CRMS4D_SERV_I.CLIENT == T016.MANDT
Item Category
Item Category Usage
Date type
Date type
Date type
Date type
Date type
Date type
Date type
Date type
Date type
Date type
Condition Unit
  • CRMS4D_SERV_I.CLIENT == T006.MANDT
  • CRMS4D_SERV_I.NETPR_UOM == T006.MSEHI
Business Trans. Cat. CRMS4D_SERV_I.OBJTYPE_H == CRMC_SUBOB_CAT.SUBOBJ_CATEGORY
CRM Item Object Type CRMS4D_SERV_I.OBJTYPE_I == CRMC_SUBOB_CAT_I.SUBOBJ_CATEGORY
Payer
  • Payer
  • Client
  • CRMS4D_SERV_I.PAYER == BUT000.PARTNER
  • CRMS4D_SERV_I.CLIENT == BUT000.CLIENT
Employee Responsible
  • Employee Responsible
  • Client
  • CRMS4D_SERV_I.PERSON_RESP == BUT000.PARTNER
  • CRMS4D_SERV_I.CLIENT == BUT000.CLIENT
Plant
  • CRMS4D_SERV_I.CLIENT == T001W.MANDT
  • CRMS4D_SERV_I.PLANT == T001W.WERKS
Terms of Payment
  • Terms of Payment
  • ?
  • Client
  • CRMS4D_SERV_I.PMNTTRMS == T052.ZTERM
  • CRMS4D_SERV_I.[column in domain "DZTAGG_052"] == T052.ZTAGG
  • CRMS4D_SERV_I.CLIENT == T052.MANDT
Material Group 1
  • Material Group 1
  • Client
  • CRMS4D_SERV_I.PRC_GROUP1 == TVM1.MVGR1
  • CRMS4D_SERV_I.CLIENT == TVM1.MANDT
Material Group 2
  • Material Group 2
  • Client
  • CRMS4D_SERV_I.PRC_GROUP2 == TVM2.MVGR2
  • CRMS4D_SERV_I.CLIENT == TVM2.MANDT
Material Group 3
  • CRMS4D_SERV_I.CLIENT == TVM3.MANDT
  • CRMS4D_SERV_I.PRC_GROUP3 == TVM3.MVGR3
Material Group 4
  • CRMS4D_SERV_I.CLIENT == TVM4.MANDT
  • CRMS4D_SERV_I.PRC_GROUP4 == TVM4.MVGR4
Material Group 5
  • CRMS4D_SERV_I.CLIENT == TVM5.MANDT
  • CRMS4D_SERV_I.PRC_GROUP5 == TVM5.MVGR5
Customer Price Group
  • Customer Price Group
  • Client
  • CRMS4D_SERV_I.PRICE_GRP == T188.KONDA
  • CRMS4D_SERV_I.CLIENT == T188.MANDT
Activity Priority
  • CRMS4D_SERV_I.CLIENT == SCPRIO.CLIENT
  • CRMS4D_SERV_I.PRIORITY == SCPRIO.PRIORITY
Unit of Measure in Which the Product Is Sold
  • CRMS4D_SERV_I.CLIENT == T006.MANDT
  • CRMS4D_SERV_I.PROCESS_QTY_UNIT == T006.MSEHI
Business Transaction Type
Material Price Group
  • CRMS4D_SERV_I.CLIENT == T178.MANDT
  • CRMS4D_SERV_I.PROD_PR_GROUP == T178.KONDM
Time unit of a recurrence period
  • Time unit of a recurrence period
  • Client
  • CRMS4D_SERV_I.REC_TIME_UNIT == TIMECUUT.NAME_UNIT
  • CRMS4D_SERV_I.CLIENT == TIMECUUT.CLIENT
Reference Currency
  • CRMS4D_SERV_I.CLIENT == TCURC.MANDT
  • CRMS4D_SERV_I.REF_CURRENCY == TCURC.WAERS
Region (State, Province, County)
  • ?
  • Region (State, Province, County)
  • CRMS4D_SERV_I.CLIENT == T005S.MANDT
  • CRMS4D_SERV_I.[column in domain "LAND1"] == T005S.LAND1
  • CRMS4D_SERV_I.REGION == T005S.BLAND
Cancellation Reason Code
  • CRMS4D_SERV_I.CLIENT == TVAG.MANDT
  • CRMS4D_SERV_I.REJECTION == TVAG.ABGRU
Responsible Group
  • Responsible Group
  • Client
  • CRMS4D_SERV_I.RESP_GROUP == BUT000.PARTNER
  • CRMS4D_SERV_I.CLIENT == BUT000.CLIENT
Executing Service Employee
  • Executing Service Employee
  • Client
  • CRMS4D_SERV_I.SERVICE_EMPLOYEE == BUT000.PARTNER
  • CRMS4D_SERV_I.CLIENT == BUT000.CLIENT
Service Team
  • Service Team
  • Client
  • CRMS4D_SERV_I.SERVICE_TEAM == BUT000.PARTNER
  • CRMS4D_SERV_I.CLIENT == BUT000.CLIENT
Shipping Conditions
  • CRMS4D_SERV_I.CLIENT == TVSB.MANDT
  • CRMS4D_SERV_I.SHIP_COND == TVSB.VSBED
Ship-To Party
  • Ship-To Party
  • Client
  • CRMS4D_SERV_I.SHIP_TO_PARTY == BUT000.PARTNER
  • CRMS4D_SERV_I.CLIENT == BUT000.CLIENT
Country/Region
  • Country/Region
  • Client
  • CRMS4D_SERV_I.SOLD_TO_COUNTRY == T005.LAND1
  • CRMS4D_SERV_I.CLIENT == T005.MANDT
Sold-To Party
  • Sold-To Party
  • Client
  • CRMS4D_SERV_I.SOLD_TO_PARTY == BUT000.PARTNER
  • CRMS4D_SERV_I.CLIENT == BUT000.CLIENT
Region (State, Province, County)
  • Country/Region
  • Region (State, Province, County)
  • CRMS4D_SERV_I.CLIENT == T005S.MANDT
  • CRMS4D_SERV_I.SOLD_TO_COUNTRY == T005S.LAND1
  • CRMS4D_SERV_I.SOLD_TO_REGION == T005S.BLAND
Tax Jurisdiction Code (Structure for tax calculation)
  • ?
  • Tax Jurisdiction Code (Structure for tax calculation)
  • CRMS4D_SERV_I.CLIENT == TTXJ.MANDT
  • CRMS4D_SERV_I.[column in domain "TAX_KALSM"] == TTXJ.KALSM
  • CRMS4D_SERV_I.TAXJURCODE == TTXJ.TXJCD
Tax Destination Country/Region
  • Tax Destination Country/Region
  • Client
  • CRMS4D_SERV_I.TAX_DEST_CTY == T005.LAND1
  • CRMS4D_SERV_I.CLIENT == T005.MANDT
Region (State, Province, County)
  • Tax Destination Country/Region
  • Region (State, Province, County)
  • CRMS4D_SERV_I.CLIENT == T005S.MANDT
  • CRMS4D_SERV_I.TAX_DEST_CTY == T005S.LAND1
  • CRMS4D_SERV_I.TAX_DEST_REG == T005S.BLAND
Usage Indicator
  • Usage Indicator
  • Client
  • CRMS4D_SERV_I.USAGE_TYPE == TVLV.ABRVW
  • CRMS4D_SERV_I.CLIENT == TVLV.MANDT
Unit for the Volume of a Product
  • CRMS4D_SERV_I.CLIENT == T006.MANDT
  • CRMS4D_SERV_I.VOLUME_UNIT_I == T006.MSEHI
Weight Unit
  • CRMS4D_SERV_I.CLIENT == T006.MANDT
  • CRMS4D_SERV_I.WEIGHT_UNIT_I == T006.MSEHI
Other Relations | to Master Data Relations ↑ Join Conditions
Rule for Determining the Next Billing Date
  • Rule for Determining the Next Billing Date
  • Client
  • CRMS4D_SERV_I.BILLPLAN_D_RULE_BILL_DATE == TIMERULEH.RULE_ID
  • CRMS4D_SERV_I.CLIENT == TIMERULEH.CLIENT
Rule for Determining Next Billing Document Creation Date
  • Rule for Determining Next Billing Document Creation Date
  • Client
  • CRMS4D_SERV_I.BILLPLAN_D_RULE_INVCR_DATE == TIMERULEH.RULE_ID
  • CRMS4D_SERV_I.CLIENT == TIMERULEH.CLIENT
Rule for Determining the Period Date
  • Rule for Determining the Period Date
  • Client
  • CRMS4D_SERV_I.BILLPLAN_D_RULE_PERIOD_DATE == TIMERULEH.RULE_ID
  • CRMS4D_SERV_I.CLIENT == TIMERULEH.CLIENT
Rule for Determining Start of Settlement Period
  • Rule for Determining Start of Settlement Period
  • Client
  • CRMS4D_SERV_I.BILLPLAN_D_RULE_SETTL_FROM == TIMERULEH.RULE_ID
  • CRMS4D_SERV_I.CLIENT == TIMERULEH.CLIENT
Rule for Determining End of Settlement Period
  • Rule for Determining End of Settlement Period
  • Client
  • CRMS4D_SERV_I.BILLPLAN_D_RULE_SETTL_TO == TIMERULEH.RULE_ID
  • CRMS4D_SERV_I.CLIENT == TIMERULEH.CLIENT
Rule for Determining the Next Billing Date
  • Rule for Determining the Next Billing Date
  • Client
  • CRMS4D_SERV_I.RULE_BILL_DATE == TIMERULEH.RULE_ID
  • CRMS4D_SERV_I.CLIENT == TIMERULEH.CLIENT
Rule for Determining Dates from
  • Rule for Determining Dates from
  • Client
  • CRMS4D_SERV_I.RULE_DATE_FROM == TIMERULEH.RULE_ID
  • CRMS4D_SERV_I.CLIENT == TIMERULEH.CLIENT
Rule for Determining Dates To
  • Rule for Determining Dates To
  • Client
Rule for Determining Billing Plan End Date
  • Rule for Determining Billing Plan End Date
  • Client
  • CRMS4D_SERV_I.RULE_END_DATE == TIMERULEH.RULE_ID
  • CRMS4D_SERV_I.CLIENT == TIMERULEH.CLIENT
Rule for Determining Horizon in Billing Plan
  • Rule for Determining Horizon in Billing Plan
  • Client
Rule for Determining Next Billing Document Creation Date
  • Rule for Determining Next Billing Document Creation Date
  • Client
  • CRMS4D_SERV_I.RULE_INVCR_DATE == TIMERULEH.RULE_ID
  • CRMS4D_SERV_I.CLIENT == TIMERULEH.CLIENT
Rule for Determining the Period Date
  • Rule for Determining the Period Date
  • Client
  • CRMS4D_SERV_I.RULE_PERIOD_DATE == TIMERULEH.RULE_ID
  • CRMS4D_SERV_I.CLIENT == TIMERULEH.CLIENT
Rule for Determining Start of Settlement Period
  • Rule for Determining Start of Settlement Period
  • Client
  • CRMS4D_SERV_I.RULE_SETTL_FROM == TIMERULEH.RULE_ID
  • CRMS4D_SERV_I.CLIENT == TIMERULEH.CLIENT
Rule for Determining End of Settlement Period
  • Rule for Determining End of Settlement Period
  • Client
  • CRMS4D_SERV_I.RULE_SETTL_TO == TIMERULEH.RULE_ID
  • CRMS4D_SERV_I.CLIENT == TIMERULEH.CLIENT
Rule for Determining Billing Plan Start Date
  • Rule for Determining Billing Plan Start Date
  • Client
  • CRMS4D_SERV_I.RULE_START_DATE == TIMERULEH.RULE_ID
  • CRMS4D_SERV_I.CLIENT == TIMERULEH.CLIENT
Rule for Origin of Next Fixed Value Date
  • Rule for Origin of Next Fixed Value Date
  • Client
  • CRMS4D_SERV_I.RULE_VALUE_DATE == TIMERULEH.RULE_ID
  • CRMS4D_SERV_I.CLIENT == TIMERULEH.CLIENT