SAP table CRMS4D_SERV_I (Items of service transactions)

SAP table CRMS4D_SERV_I has 4 primary key fields being CLIENT,OBJTYPE_H,OBJECT_ID,NUMBER_INT.

Field Description Data Type Length Decimals Checktable Data Element
CLIENT Client CLNT 3 0 T000 MANDT
OBJTYPE_H Business Trans. Cat. CHAR 10 0 CRMC_SUBOB_CAT CRMT_SUBOBJECT_CATEGORY_DB
OBJECT_ID Transaction ID CHAR 10 0 CRMT_OBJECT_ID_DB
NUMBER_INT Shortened Item Number in Document NUMC 6 0 CRMS4_NUMBER_INT
AC_OBJECT_TYPE Object Type for Settlement Account Assignment CHAR 2 0 CRMC_AC_ASSIGN CRMT_AC_OBJECT_TYPE
AC_ASSIGNMENT Settlement Account Assignment CHAR 50 0 CRMT_AC_ASSIGN
AC_PERCENTAGE Percentage of Costs to Be Distributed DEC 5 2 CRMT_AC_COST_PERCENTAGE
APRV_ACTIVATED Logical Variable CHAR 1 0 CRMT_BOOLEAN
APRV_PROCEDURE Approval Procedure CHAR 8 0 CRMC_APRV_PROC CRMT_APPROVAL_PROCEDURE
CHANGE_ALLOWED Logical Variable CHAR 1 0 CRMT_BOOLEAN
PERIOD_DATE Period Date DEC 15 0 CRMT_PERIOD_DATE
RULE_PERIOD_DATE Rule for Determining the Period Date RAW 16 0 TIMERULEH CRMT_RULE_PERIOD_DATE
SETTL_FROM Start of Settlement for Period DEC 15 0 CRMT_SETTL_FROM
RULE_SETTL_FROM Rule for Determining Start of Settlement Period RAW 16 0 TIMERULEH CRMT_RULE_SETTL_FROM
SETTL_TO End of Settlement for Period DEC 15 0 CRMT_SETTL_TO
RULE_SETTL_TO Rule for Determining End of Settlement Period RAW 16 0 TIMERULEH CRMT_RULE_SETTL_TO
BILL_DATE Billing Date for Billing Index and Printout DEC 15 0 CRMS4_BILL_DATE_TSTMP
RULE_BILL_DATE Rule for Determining the Next Billing Date RAW 16 0 TIMERULEH CRMT_RULE_BILL_DATE
INVCR_DATE Billing Document Creation Date DEC 15 0 CRMS4_INVCR_DATE_TSTMP
RULE_INVCR_DATE Rule for Determining Next Billing Document Creation Date RAW 16 0 TIMERULEH CRMT_RULE_INVCR_DATE
VALUE_DATE Fixed Value Date DEC 15 0 CRMT_VALUE_DATE
RULE_VALUE_DATE Rule for Origin of Next Fixed Value Date RAW 16 0 TIMERULEH CRMT_RULE_VALUE_DATE
BILLING_TIMEZONE Time Zone of Billing Plan Set CHAR 6 0 TTZZ CRMT_BILLING_TIMEZONE
BILLING_BLOCK Business Partner: Billing Block Reason CHAR 2 0 TVFS CRMT_BUS_BILL_BLOCK_REASON
SEPA_ON Indicator for SEPA-Relevant Transactions CHAR 1 0 CRMT_SEPA_ON
MANDATE_ID Unique Reference to Mandate per Payment Recipient CHAR 35 0 CRMT_MANDATE_ID
KIND_PERIOD_DATE Date type CHAR 12 0 SCAPPTTYPE TIMENAEVEN
KIND_SETTL_FROM Date type CHAR 12 0 SCAPPTTYPE TIMENAEVEN
KIND_SETTL_TO Date type CHAR 12 0 SCAPPTTYPE TIMENAEVEN
KIND_BILL_DATE Date type CHAR 12 0 SCAPPTTYPE TIMENAEVEN
KIND_INVCR_DATE Date type CHAR 12 0 SCAPPTTYPE TIMENAEVEN
KIND_VALUE_DATE Date type CHAR 12 0 SCAPPTTYPE TIMENAEVEN
KIND_START_DATE Date type CHAR 12 0 SCAPPTTYPE TIMENAEVEN
KIND_END_DATE Date type CHAR 12 0 SCAPPTTYPE TIMENAEVEN
KIND_DATE_FROM Date type CHAR 12 0 SCAPPTTYPE TIMENAEVEN
KIND_DATE_TO Date type CHAR 12 0 SCAPPTTYPE TIMENAEVEN
CONTRACT_ACCOUNT Contract Account Number CHAR 12 0 FKKVK VKONT_KK
DIP_PROFILE Dynamic Item Processor Profile CHAR 8 0 AD01PROFNR
RESULTS_ANALYSIS_KEY Results Analysis Key CHAR 6 0 * ABGR_SCHL_APPL
BILLING_RELEVANCE Billing Relevance CHAR 1 0 CRMS4_BILLING_RELEVANCE
D Billing on Completion
F Price/Cost - Main Item
G Price/Cost - Sub Item
N Not Relevant for Billing
CHKL_STEP_GROUP Checklist Step Group GUID CHAR 32 0 CHKLST_STEP_GRP_GUID
CHKL_STEP_ID Checklist Step ID CHAR 8 0 CRMC_CHKLST_ST CHKLST_STEP_ID
CHKL_STEP_NO Checklist Step Number NUMC 10 0 CHKLST_STEP_NO
CHKL_OPTION_ID Checklist Option ID CHAR 8 0 CHKLST_OPTION_ID
CHKL_PREV_GROUP Checklist Previous Group GUID CHAR 32 0 CHKLST_PREV_GRP_GUID
CHKL_PREV_NO Checklist Previous Group Number NUMC 10 0 CHKLST_PREV_GRP_NO
CHKL_TRIGGER_ID Checklist Trigger ID CHAR 15 0 CHKLST_TRIGGER_ID
GI_QUANTITY Goods Issue Quantity QUAN 15 3 CRMS4_GI_QUANTITY
GI_VALUE Goods Issue Value CURR 19 2 CRMS4_GI_VALUE
ORDERED_QUANTITY Ordered Quantity QUAN 15 3 CRMS4_ORD_QUANTITY
BILLED_VALUE Invoice Value CURR 19 2 CRMS4_INV_VALUE
BILLED_QUANTITY Invoiced Quantity QUAN 15 3 CRMS4_INV_QUANTITY
DLV_QUANTITY Delivered Quantity QUAN 15 3 CRMS4_DLV_QUANTITY
RELEASED_QUANTITY Released Quantity QUAN 15 3 CRMS4_RLSD_QUANTITY
RELEASED_VALUE Released Value CURR 19 2 CRMS4_RLSD_VALUE
VALID_FROM Time Dependency: Validity Start Date DEC 15 0 CRMT_VALID_FROM
VALID_TO Time Dependency: Validity End Date DEC 15 0 CRMT_VALID_TO
QUOT_START Quotation: Valid from Date DEC 15 0 CRMS4_QUOT_START_DATE
QUOT_END Quotation: Valid to Date DEC 15 0 CRMS4_QUOT_END_DATE
SRV_CUST_BEG Service Request Start Date DEC 15 0 CRMS4_SRV_CUST_BEG_TSTMP
SRV_CUST_END Service Request Due Date DEC 15 0 CRMS4_SRV_CUST_END_TSTMP
SRQ_WORK_DURA Work Duration of Service Transaction DEC 8 2 CRMS4_SRQ_WORK_DURA
SRQ_WORK_UNIT Work Duration Unit of Service Transaction CHAR 2 0 CRMS4_SRQ_WORK_UNIT
SRQ_TOT_DURA Total Duration of Service Transaction DEC 8 2 CRMS4_SRQ_TOT_DURA
SRQ_TOT_UNIT Total Duration Unit of Service Transaction CHAR 2 0 CRMS4_SRQ_TOT_UNIT
CONTSTART Contract Start date DEC 15 0 CRMS4_CONT_START
CONTEND Contract End Date DEC 15 0 CRMS4_CONT_END
CONT_START_TS Start of Contract Time Slice DEC 15 0 CRMS4_CONT_START_TS_DATE
CONT_END_TS End of Contract Time Slice DEC 15 0 CRMS4_CONT_END_TS_DATE
SRV_RFIRST First Response By DEC 15 0 CRMS4_SRV_RFIRST
SRV_RREADY Due By DEC 15 0 CRMS4_SRV_RREADY
SRV_CLOSE Closing Date DEC 15 0 CRMS4_SRV_CLOSE
AUTO_RENEW_PERIOD Unit for Auto Renewal Period QUAN 13 0 CRMS4_AUTO_RENEW_PERIOD_DURA
AUTO_RENEW_PERIOD_UNIT UOM for Auto Renewal Period UNIT 3 0 CRMS4_AUTO_RENEW_PERIOD_UNIT
AUTO_RENEW_EXTEN Unit for Contract Extension QUAN 13 0 CRMS4_AUTO_RENEW_EXTEN_DURA
AUTO_RENEW_EXTEN_UNIT UOM for Contract Extension UNIT 3 0 CRMS4_AUTO_RENEW_EXTEN_UNIT
AUTO_RENEW_START Start Date of Auto Renewal Period DEC 15 0 CRMS4_AUTO_RENEW_START_DATE
SRQ_WORK_DURA_2 Work Duration 2 of Service Transaction DEC 13 0 CRMS4_SRQ_WORK_DURA_2
SRQ_TOT_DURA_2 Total Duration 2 of Service Transaction DEC 13 0 CRMS4_SRQ_TOT_DURA_2
SRVC_ACTUAL Service Actual Start Date DEC 15 0 CRMS4_SRVC_ACTUAL_TSTMP
SRVC_ACT_TO Service Actual End Date DEC 15 0 CRMS4_SRVC_ACT_TO_TSTMP
SPLA_PLANFR Service Planned From Date DEC 15 0 CRMS4_SPLA_PLANFR_TSTMP
SPLA_PLANTO Service Planned To Date DEC 15 0 CRMS4_SPLA_PLANTO_TSTMP
ITEM_GUID GUID of a CRM Order Object RAW 16 0 CRMT_OBJECT_GUID
CREATED_AT_I Created At DEC 15 0 CRMS4_CREATED_AT
CREATED_BY_I User that Created the Transaction CHAR 12 0 CRMT_CREATED_BY
CHANGED_AT_I Changed At DEC 15 0 CRMS4_CHANGED_AT
CHANGED_BY_I Transaction Last Changed By CHAR 12 0 CRMT_CHANGED_BY
OBJTYPE_I CRM Item Object Type CHAR 10 0 CRMC_SUBOB_CAT_I CRMT_SWO_OBJTYP_PROCESS_ITM_DB
HEADER_GUID GUID of a CRM Order Object RAW 16 0 CRMT_OBJECT_GUID
PARENT GUID of a CRM Order Object RAW 16 0 CRMT_OBJECT_GUID
ALTERNATIVE GUID of a CRM Order Object RAW 16 0 CRMT_OBJECT_GUID
PRODUCT Internal Unique ID of Product RAW 16 0 CRMT_PRODUCT_GUID_DB
ORDERED_PROD Product Name Entered CHAR 54 0 CRMT_ORDERED_PROD_DB
PARTNER_PROD Product Number of Business Partner CHAR 40 0 CRMT_ITEM_DESCR_PARTNER
DESCRIPTION_I Product Description CHAR 40 0 CRMT_PRSHTEXTX_DB
ITM_LANGUAGE Short Text Language for an Item LANG 1 0 CRMT_ITEM_LANGU
NUMBER_EXT External Item Number NUMC 10 0 CRMT_ITEM_NO_EXT
ITM_TYPE Item Category CHAR 4 0 CRMC_ITEM_TYPE CRMT_ITEM_TYPE_DB
ORDER_DATE Posting Date DEC 15 0 CRMT_ORDER_DATE
ITM_USAGE Usage of Higher-Level Item CHAR 2 0 CRMT_ITEM_USAGE
ITM_TYPE_USAGE Item Category Usage CHAR 4 0 CRMC_IT_TYPE_US CRMT_IT_TYPE_USAGE
PRODUCT_KIND Product Technical Type CHAR 1 0 CRMT_PRODUCT_KIND
REVACC_REFID Revenue Accounting Reference ID CHAR 30 0 CRMT_REVACC_REFID
REVACC_REFTYPE Revenue Accounting Reference Type CHAR 3 0 CRMT_REVACC_REFTYPE
REVACC_RELEVANT_TYPE Revenue Accounting Type CHAR 1 0 CRMT_REVACC_RELEVANT_TYPE
Not relevant for Revenue Accounting
X Relevant for Revenue Accounting
Y Relevant for Revenue Accounting due to Operational Load
PRODUCT_ID Product Number CHAR 40 0 PRODUCTNUMBER
ITEM_GUID_CHAR 32 Character CRM Object GUID (Converted) CHAR 32 0 CRMT_OBJECT_GUID32
PROFIT_CENTER Profit Center CHAR 10 0 PRCTR
PROFIT_CENTER_ORIGIN Profit Center Source Indicator CHAR 1 0 CRMS4_SRVC_PROFIT_CNTR_ORIGIN
A Determined Automatically
C Manually Entered/Selected
KOKRS Controlling Area CHAR 4 0 * KOKRS
PROFIT_DETERMINE_DATE Date DATS 8 0 DATUM
REFBUSSOLNORD Reference Solution Order ID CHAR 10 0 CRMS4_REF_SOLO_OBJECT_ID
REFBUSSOLNORDITM Item Number in Referenced Solution Order NUMC 6 0 CRMS4_REF_SOLO_NUMBER_INT
SUBSCRPNBILLGCYCLE Billing Cycle CHAR 4 0 CRMS4_SUBSCRPN_BILLG_CYCLE
1001 Monthly on First Day of Month
1002 Monthly on Reference Date
1003 Quarterly on First Day of Quarter
1004 Quarterly on Reference Date
1005 Half-Yearly on First Day of Half-Year
1006 Half-Yearly on Reference Date
1007 Yearly on January 1st
1008 Yearly on Reference Date
MIDBILLCYCEXPRTNALLWD Allow Mid-Bill-Cycle Expiration CHAR 1 0 CRMS4_MIDBILL_CYC_EXPRTN_ALLWD
Not Allowed
X Allowed
DEFAULT_TERMS_OVRWRT Overwrite Default Terms CHAR 1 0 CRMS4_OVRWRT_DEFAULT_TERMS_DB
Not Maintained
N No
Y Yes
PROJ_ORG_ID Service Organization (Project) CHAR 5 0 * CRMS4_PROJ_ORG_ID
COST_CENTER Cost Center CHAR 10 0 * KOSTL
DIS_CHANNEL Distribution Channel CHAR 2 0 TVTW CRMT_DISTRIBUTION_CHANNEL
DIVISION Division CHAR 2 0 TSPA CRMT_DIVISION
SERVICE_ORG_ORI Origin Indicator: Service Organization CHAR 1 0 CRMT_SERVICE_ORG_ORIGIN
SERVICE_ORGR_ORI Origin Indicator: Service Scenario Organizational Unit CHAR 1 0 CRMT_SERVICE_ORG_RESP_ORIGIN
SALES_ORG_ORI Origin Indicator: Sales Organization CHAR 1 0 CRMT_SALES_ORG_ORIGIN
DIS_CHANNEL_ORI Origin Indicator: Distribution Channel CHAR 1 0 CRMT_DIS_CHANNEL_ORIGIN
SALES_OFF_ORI Origin Indicator: Sales Office CHAR 1 0 CRMT_SALES_OFFICE_ORIGIN
SALES_GROUP_ORI Origin Indicator: Sales Group CHAR 1 0 CRMT_SALES_GROUP_ORIGIN
SALES_ORGR_ORI Origin Indicator: Sales Scenario Organizational Unit CHAR 1 0 CRMT_SALES_ORG_RESP_ORIGIN
DIVISION_ORI Origin Flag: Division CHAR 1 0 CRMT_DIVISION_ORIGIN
SALES_ORG Sales Organization ID CHAR 14 0 CRMT_SALES_ORG
SALES_OFFICE Sales Office CHAR 14 0 CRMT_SALES_OFFICE
SALES_GROUP Sales Group CHAR 14 0 CRMT_SALES_GROUP
SALES_ORG_RESP Organizational Unit (Sales) CHAR 14 0 CRMT_SALES_ORG_RESP
SERVICE_ORG Service Organization CHAR 14 0 CRMT_SERVICE_ORG
SERVICE_ORG_RESP Organizational Unit (Service) CHAR 14 0 CRMT_SERVICE_ORG_RESP
SALES_ORG_SD Sales Organization CHAR 4 0 VKORG
SALES_OFFICE_SD Sales office CHAR 4 0 * VKBUR
SALES_GROUP_SD Sales group CHAR 3 0 * VKGRP
ENTERPRISE_SERVICE_ORG Enterprise Service Organization CHAR 4 0 CRMS4_ENTERPRISE_SERVICE_ORG
SERVICE_TEAM_RM Service Team (Responsibility Management) NUMC 8 0 * CRMS4_SERVICE_TEAM_RM
SERVICE_TEAM_RM_ORI Origin Indicator: Service Team CHAR 1 0 CRMS4_SERVICE_TEAM_RM_ORIGIN
A Determined automatically
B Inherited
C Manually entered/selected
D Corrected based on exec. service employee
SOLD_TO_PARTY Sold-To Party CHAR 10 0 BUT000 CRMT_SOLD_TO_PART
SOLD_TO_REGION Region (State, Province, County) CHAR 3 0 T005S CRMT_REGION
SOLD_TO_COUNTRY Country/Region CHAR 3 0 T005 CRMT_COUNTRY
SHIP_TO_PARTY Ship-To Party CHAR 10 0 BUT000 CRMT_SHIP_TO_PART
BILL_TO_PARTY Bill-To Party CHAR 10 0 BUT000 CRMT_BILL_TO_PART
PAYER Payer CHAR 10 0 BUT000 CRMT_RP_PAYER
PERSON_RESP Employee Responsible CHAR 10 0 BUT000 CRMT_PERSON_RESP
CONTACT_PERSON Customer Contact Person CHAR 10 0 BUT000 CRMT_CONTACT_PERSON
RESP_GROUP Responsible Group CHAR 10 0 BUT000 CRMT_RESPONSIBLE_GROUP
SERVICE_TEAM Service Team CHAR 10 0 BUT000 CRMT_SERVICE_TEAM
SERVICE_EMPLOYEE Executing Service Employee CHAR 10 0 BUT000 CRMT_SERVICE_EMPLOYEE
EXCHG_TYPE Exchange Rate Type CHAR 4 0 TCURV CRMT_EXCHG_TYPE
EXCHG_DATE Exchange Rate Date DATS 8 0 CRMT_EXCHG_DATE
TAXJURCODE Tax Jurisdiction Code (Structure for tax calculation) CHAR 15 0 TTXJ CRMT_TAXJURCODE
CUST_PRIC_PROC Customer Pricing Procedure CHAR 2 0 TVKD CRMT_CUST_PRIC_PROC
REF_CURRENCY Reference Currency CUKY 5 0 TCURC CRMT_REF_CURRENCY
CURRENCY Currency CUKY 5 0 TCURC CRMT_CURRENCY
PRICE_DATE Pricing Date DATS 8 0 CRMT_PRICE_DATE
PMNTTRMS Terms of Payment CHAR 4 0 T052 CRMT_PMNTTRMS
PRICE_GRP Customer Price Group CHAR 2 0 T188 CRMT_PRICE_GRP
CUST_GROUP Customer Group CHAR 2 0 T151 CRMT_CUST_GROUP
EXCHG_RATE Exchange Rate DEC 9 5 CRMT_EXCHG_RATE
TAX_DEST_CTY Tax Destination Country/Region CHAR 3 0 T005 CRMT_TAX_DEST_CTY
TAX_DEST_REG Region (State, Province, County) CHAR 3 0 T005S CRMT_REGION
VAT_REG_NO Sales tax registration number CHAR 20 0 CRMT_VAT_REG_NO
AC_INDICATOR Accounting Indicator CHAR 2 0 TBMOT CRMT_AC_INDICATOR
CUSTOMER_TYPE Business Partner Type CHAR 4 0 TB004 CRMT_CUSTOMER_TYPE
PAYMENT_METHOD Payment Method CHAR 1 0 * CRMT_BUAG_PAYMETH
PRICE_LIST Price List Type CHAR 2 0 CRMT_PRICE_LIST
PRICING_CONTROL Pricing Control CHAR 1 0 CRMS4_PRICING_CONTROL
Standard
A Free of charge
NET_VALUE_MAN_I Total Expected Net Value Products in Document Currency CURR 15 2 CRMT_NET_VALUE_MAN
COST_AMOUNT_MAN Total Expected Cost Amount in Document Currency CURR 15 2 CRMT_COST_AMOUNT_MAN
STATISTICAL Statistical values CHAR 1 0 CRMT_STATISTICAL
PRC_INDICATOR Pricing indicator CHAR 1 0 CRMT_PRICING_INDICATOR
NET_VALUE_I Net Value CURR 15 2 CRMT_NET_VALUE
NET_PRICE_I Net Price CURR 15 2 CRMT_NET_PRICE
TAX_AMOUNT_I Tax amount in document currency CURR 15 2 CRMT_TAX_AMOUNT
FREIGHT_I Shipment costs in document currency CURR 15 2 CRMT_FREIGHT
GROSS_VALUE_I Gross Order Value in PO Currency CURR 15 2 CRMT_GROSS_VALUE
NET_WO_FREIGHT_I Item Net Value Exclusive Shipment CURR 15 2 PRCT_NET_VALUE_WITHOUT_FREIGHT
SUBTOTAL1 Subtotal 1 from pricing procedure for condition CURR 15 2 CRMT_SUBTOTAL1
SUBTOTAL2 Subtotal 2 from pricing procedure for condition CURR 15 2 CRMT_SUBTOTAL2
SUBTOTAL3 Subtotal 3 from pricing procedure for condition CURR 15 2 CRMT_SUBTOTAL3
SUBTOTAL4 Subtotal 4 from pricing procedure for condition CURR 15 2 CRMT_SUBTOTAL4
SUBTOTAL5 Subtotal 5 from pricing procedure for condition CURR 15 2 CRMT_SUBTOTAL5
SUBTOTAL6 Subtotal 6 from pricing procedure for condition CURR 15 2 CRMT_SUBTOTAL6
CREDIT_INDICATOR Credit Debit Indicator CHAR 1 0 CRMT_CREDIT_INDICATOR
Debit
X Credit
NETPR_PRIC_UNIT Condition Pricing Unit DEC 5 0 PRCT_COND_PRICING_UNIT
NETPR_UOM Condition Unit UNIT 3 0 T006 PRCT_COND_UOM
TOTAL_DISCOUNT_I Price Determination: Condition Value CURR 15 2 PRCT_COND_VALUE
RECURRING_CHARGE Periodically charged values CURR 15 2 CRMT_RECURRING_CHARGE
RECURRING_TAX Periodically charged taxes CURR 15 2 CRMT_RECURRING_TAX
RECURRING_GROSS Periodically charged values including taxes CURR 15 2 CRMT_RECURRING_GROSS
REC_DURATION Duration of a recurrence period DEC 13 0 CRMT_REC_DURATION
REC_TIME_UNIT Time unit of a recurrence period CHAR 12 0 TIMECUUT CRMT_REC_TIME_UNIT
REC_MAIN_ITM_CUM Cumulation of recurring charges on main item level CHAR 1 0 CRMT_REC_MAIN_ITEM_CUM
TARGET_VALUE Target Value CURR 15 2 CRMS4_TARGET_VALUE
PRICE_SOURCE Source of price in service confirmation CHAR 15 0 PRICE_SOURCE
GROSS_WEIGHT_I Gross Weight QUAN 15 3 CRMT_GROSS_WEIGHT
NET_WEIGHT_I Net Weight QUAN 15 3 CRMT_NET_WEIGHT
WEIGHT_UNIT_I Weight Unit UNIT 3 0 T006 COMT_WEIGHT_UNIT
VOLUME_I Volume Occupied by the Product per Volume Unit QUAN 15 3 CRMT_VOLUME
VOLUME_UNIT_I Unit for the Volume of a Product UNIT 3 0 T006 COMT_VOLUME_UNIT
PRICE_PRODUCT Pricing Reference Product Globally Unique Identifier RAW 16 0 CRMT_PRICE_PRODUCT
PROCESS_QTY_NUM Numerator (factor) for conversion trans. quantity in BME INT4 10 0 CRMT_PROCESS_QTY_NUM
PROCESS_QTY_DEN Denominator (factor) for conversion trans. quantity in BME INT4 10 0 CRMT_PROCESS_QTY_DEN
EXPONENT10 10 Exponent for Quantity Conversion INT2 5 0 CRMT_EXPONENT10
PROCESS_QTY_UNIT Unit of Measure in Which the Product Is Sold UNIT 3 0 T006 CRMT_PROCESS_QTY_UNIT
COMM_GROUP Commission Group CHAR 2 0 * CRMT_COMM_GROUP
REBATE_GROUP Volume Rebate Group CHAR 2 0 * CRMT_REBATE_GROUP
CASH_DISC Specifies Whether a Cash Discount Can Be Given for the Prod. CHAR 1 0 CRMT_CASH_DISC
PROD_PR_GROUP Material Price Group CHAR 2 0 T178 KONDM
PRC_GROUP1 Material Group 1 CHAR 3 0 TVM1 MVGR1
PRC_GROUP2 Material Group 2 CHAR 3 0 TVM2 MVGR2
PRC_GROUP3 Material Group 3 CHAR 3 0 TVM3 MVGR3
PRC_GROUP4 Material Group 4 CHAR 3 0 TVM4 MVGR4
PRC_GROUP5 Material Group 5 CHAR 3 0 TVM5 MVGR5
PROD_HIERARCHY Product Category CHAR 20 0 CRMT_PROD_HIERARCHY
BASE_QTY_UNIT Base Unit of Measure of Product UNIT 3 0 T006 COMT_PRODUCT_BASE_UOM
PLANT Plant CHAR 4 0 T001W WERKS_D
REGION Region (State, Province, County) CHAR 3 0 T005S CRMT_REGION
INDUSTRY Industry Sector CHAR 4 0 T016 CRMT_INDUSTRY
CUST_GROUP1 Customer Group 1 CHAR 3 0 TVV1 CRMT_CUST_GROUP1
CUST_GROUP2 Customer Group 2 CHAR 3 0 TVV2 CRMT_CUST_GROUP2
CUST_GROUP3 Customer Group 3 CHAR 3 0 TVV3 CRMT_CUST_GROUP3
CUST_GROUP4 Customer Group 4 CHAR 3 0 TVV4 CRMT_CUST_GROUP4
CUST_GROUP5 Customer Group 5 CHAR 3 0 TVV5 CRMT_CUST_GROUP5
PO_NUMBER_SOLD Sold-To Party's External Reference Number CHAR 35 0 CRMT_PO_NUMBER_SOLD
PO_DATE_SOLD Reference Document Date DATS 8 0 CRMT_PO_DATE_SOLD
YOUR_REF_SOLD Sold-to Party Reference CHAR 12 0 CRMT_YOUR_REFERENCE_SOLD
PO_NUMBER_SHIP Ship-To Party's External Reference Number CHAR 35 0 CRMT_PO_NUMBER_SHIP
PO_DATE_SHIP Ship-To Party's Reference Document Date DATS 8 0 CRMT_PO_DATE_SHIP
YOUR_REF_SHIP Ship-To Party Reference CHAR 12 0 CRMT_YOUR_REFERENCE_SHIP
USAGE_TYPE Usage Indicator CHAR 3 0 TVLV CRMT_USAGE
SUBMISSION Collective Number for Quotations CHAR 10 0 CRMT_SUBMISSION
REJECTION Cancellation Reason Code CHAR 2 0 TVAG CRMT_REJECTION_CODE
PROBABILITY Order Probability NUMC 3 0 CRMT_ORDER_PROBABILITY
DATE_QTY_FIXED Fixed Date and Quantity CHAR 1 0 CRMT_DATE_QTY_FIXED
ORIG_ORDER_QTY CRM: Original Order Quantity (Unrounded Cumulated qty.) QUAN 13 3 CRMT_QTY_ORIG_ORDER
ORDER_QTY CRM: Order Quantity QUAN 13 3 CRMT_QTY_ORDER
CONFIRMED_QTY CRM: Confirmed Quantity QUAN 13 3 CRMT_QTY_CONFIRMED
LATEST_CONF_DATE Latest Confirmation Date for an Item DEC 15 0 CRMS4_LATEST_CONF_DATE
DLV_GROUP_DATE Delivery Group Date DEC 15 0 CRMT_DLV_GROUP_DATE
LATEST_REQ_DATE Latest Requested Date for an Item DEC 15 0 CRMS4_LATEST_REQ_DATE
FIRST_REQ_DATE First Requested Delivery Date for an Item DEC 15 0 CRMS4_FIRST_REQ_DATE
FIRST_CONF_DATE First Confirmed Delivery Date for Item DEC 15 0 CRMS4_FIRST_CONF_DATE
DISPO_FLG Relevant for Resource Planning CHAR 1 0 CRMT_SRV_DISPO_FLG
CONFIRM_RELEVANT Relevant for Confirmation CHAR 1 0 CRMT_CONFIRM_RELEVANT
SRV_CONF_TIME Confirmed Duration QUAN 7 2 CRMT_SRV_CONF_DURATION
SRV_CONF_TUNIT Time Unit for Confirmed Duration UNIT 3 0 CRMT_SRV_CONF_TIME_UNIT
SERVICE_TYPE Service Type CHAR 4 0 * CRMT_SERVICE_TYPE
VALUATION_TYPE Valuation Type CHAR 6 0 * CRMT_VALUATION_TYPE
SRV_ESCAL Response Profile CHAR 10 0 * CRMT_SRV_ESCAL
SRV_SERWI Service Profile CHAR 10 0 * CRMT_SRV_SERWI
SRV_RULE_ID Internal Identification of Rules of Periodic Appointments CHAR 25 0 SC_RULEID
SRCL_SERVICE_PROFILE Processing Times: Service Profile CHAR 10 0 * CRMT_SRCL_SRVPRF
SRCL_RESPONSE_PROFILE Processing Time: Response Profile CHAR 10 0 * CRMT_SRCL_RSPRF
DURATION Duration QUAN 13 3 CRMT_SRV_DURATION
DURATION_UNIT Unit for Duration of Work UNIT 3 0 CRMT_SRV_DURATION_UOM
SRV_ESCAL_CHANGED Single-Character Flag CHAR 1 0 CHAR1
SRV_SERWI_CHANGED Single-Character Flag CHAR 1 0 CHAR1
WARRANTY_ID Master warranty number CHAR 20 0 * MGANR
OVERTIME_CAT Overtime Category CHAR 4 0 * CATS_OVERTIME_CATEGORY
SRV_RENDERED_DATE Service Rendered Date DATS 8 0 CRMS4_RENDER_DATE
ITEM_PRIORITY Activity Priority NUMC 1 0 * CRMT_PRIORITY
INCOTERMS1 Incoterms (Part 1) CHAR 3 0 TINC CRMT_INCOTERMS1
INCOTERMS2 Incoterms (Part 2) CHAR 28 0 CRMT_INCOTERMS2
SHIP_COND Shipping Conditions CHAR 2 0 TVSB CRMT_SHIP_COND
DELI_UNLIM_TOL Indicator: Unlimited Overdelivery Allowed CHAR 1 0 CRMT_DELI_UNLIM_TOL
OVER_DLV_TOL Overdelivery Tolerance Limit DEC 3 1 CRMT_OVER_DLV_TOL
UNDER_DLV_TOL Underdelivery Tolerance Limit DEC 3 1 CRMT_UNDER_DLV_TOL
DLV_PRIO Delivery Priority NUMC 2 0 TPRIO CRMT_DLV_PRIO
ORDERCOMBIND Indicator: Order Combination CHAR 1 0 CRMT_ORDERCOMBIND
PART_DLV Delivery Control CHAR 1 0 CRMT_PART_DLV
DLV_GROUP Delivery Group (Items are Delivered Together) NUMC 3 0 CRMT_DLV_GROUP
DELIVERY_BLOCK Business Partner: Delivery Block Reason CHAR 2 0 TVLS CRMT_BUS_DEL_BLOCK_REASON
PART_DLV_ITM Delivery Control (Item) CHAR 1 0 CRMT_PART_DLV_ITM
STAT_LIFECYCLE Life Cycle Status CHAR 4 0 CRMS4_STAT_LIFECYCLE
A Open
B In Process
C Completed
D Released
STAT_RELEASED Release Status CHAR 1 0 CRMS4_STAT_RELEASED
Not released
X Released
STAT_QUOTATION Quotation Status CHAR 1 0 CRMS4_STAT_QUOTATION
Order/Contract
X Quotation
STAT_ERROR Error Status CHAR 1 0 CRMS4_STAT_ERROR
No Errors
X Contains Errors
STAT_DELIVERY Delivery Status CHAR 1 0 CRMS4_STAT_DELIVERY
Not relevant
A Not delivered
B Partially delivered
C Delivered
STAT_GOODS_ISSUE Goods Issue Status CHAR 1 0 CRMS4_STAT_GOODS_ISSUE
Not relevant
A Goods not issued
B Goods partially issued
C Goods issued
STAT_BILLING Billing Status CHAR 1 0 CRMS4_STAT_BILLING
Not relevant
A Not billed
B Partially billed
C Billed
STAT_CANCELLED Cancellation Status CHAR 1 0 CRMS4_STAT_CANCELLED
Not cancelled
X Cancelled
STAT_OPEN Status "Open" CHAR 1 0 CRMS4_STAT_OPEN
Completed
X Open
STAT_MAINTENANCE Maintenance Status CHAR 2 0 CRMS4_STAT_MAINTENANCE
Pending
02 In Planning
04 In Execution
06 Execution Completed
07 Cancelled
STAT_TRANSFER Transfer Status CHAR 1 0 CRMS4_STAT_TRANSFER
B Transfer started
E Transfer failed
N Data exchange manager not yet called
S Transfer ok
STAT_CHKLST_EXEC Execution Status of Checklist Item CHAR 1 0 CRMS4_STAT_CHKLST_EXEC
A Not to be executed
B Execution in progress
C Executed
STAT_ACTIVATION Activation Status of Subscription Order/Contract CHAR 1 0 CRMS4_STAT_ACTIVATION
A Not Active
B Contract Accepted
C In Activation
D Activation Failed
E Technically Active
STAT_CONT_TS Status of Contract Time Slice CHAR 1 0 CRMS4_STAT_CONT_TS
N Not Active
Y Last Contract Time Slice
STAT_ACCEPTED Acceptance Status CHAR 1 0 CRMS4_STAT_ACCEPTED
N Not Accepted
Y Accepted
STAT_FOR_BILLING Billing Release Status CHAR 1 0 CRMS4_STAT_FOR_BILLING
Items Pending Release
E Items Containing Errors
X Released for Billing
STAT_CREDIT Credit Status of Item CHAR 1 0 CRMS4_STAT_CREDIT_I
Not credit relevant
A Credit relevant, but credit check not executed
B Credit check OK
C Credit check not OK
D Credit released
CATLVLGUID01_01 Category GUID 1- schema 1 RAW 16 0 CRM_REP_CAT_GUID_LEV01_S1
CATLVLGUID02_01 Category GUID 2- schema 1 RAW 16 0 CRM_REP_CAT_GUID_LEV02_S1
CATLVLGUID03_01 Category GUID 3- schema 1 RAW 16 0 CRM_REP_CAT_GUID_LEV03_S1
CATLVLGUID04_01 Category GUID 4- schema 1 RAW 16 0 CRM_REP_CAT_GUID_LEV04_S1
CATLVLGUID05_01 Category GUID 5- schema 1 RAW 16 0 CRM_REP_CAT_GUID_LEV05_S1
CATLVLGUID06_01 Category GUID 6- schema 1 RAW 16 0 CRM_REP_CAT_GUID_LEV06_S1
CATLVLGUID07_01 Category GUID 7- schema 1 RAW 16 0 CRM_REP_CAT_GUID_LEV07_S1
CATLVLGUID08_01 Category GUID 8- schema 1 RAW 16 0 CRM_REP_CAT_GUID_LEV08_S1
CATLVLGUID09_01 Category GUID 9- schema 1 RAW 16 0 CRM_REP_CAT_GUID_LEV09_S1
CATLVLGUID10_01 Category GUID 10- schema 1 RAW 16 0 CRM_REP_CAT_GUID_LEV10_S1
ASP_ID_01 Coherent Cat. - Aspect ID CHAR 40 0 CRMS4_ERMS_CAT_AS_ID
CAT_ID_01 Coherent Cat. - Category ID CHAR 40 0 CRMS4_ERMS_CAT_CA_ID
CATLVLGUID01_02 Category GUID 1- schema 2 RAW 16 0 CRM_REP_CAT_GUID_LEV01_S2
CATLVLGUID02_02 Category GUID 2- schema 2 RAW 16 0 CRM_REP_CAT_GUID_LEV02_S2
CATLVLGUID03_02 Category GUID 3- schema 2 RAW 16 0 CRM_REP_CAT_GUID_LEV03_S2
CATLVLGUID04_02 Category GUID 4- schema 2 RAW 16 0 CRM_REP_CAT_GUID_LEV04_S2
CATLVLGUID05_02 Category GUID 5- schema 2 RAW 16 0 CRM_REP_CAT_GUID_LEV05_S2
CATLVLGUID06_02 Category GUID 6- schema 2 RAW 16 0 CRM_REP_CAT_GUID_LEV06_S2
CATLVLGUID07_02 Category GUID 7- schema 2 RAW 16 0 CRM_REP_CAT_GUID_LEV07_S2
CATLVLGUID08_02 Category GUID 8- schema 2 RAW 16 0 CRM_REP_CAT_GUID_LEV08_S2
CATLVLGUID09_02 Category GUID 9- schema 2 RAW 16 0 CRM_REP_CAT_GUID_LEV09_S2
CATLVLGUID10_02 Category GUID 10- schema 2 RAW 16 0 CRM_REP_CAT_GUID_LEV10_S2
ASP_ID_02 Coherent Cat. - Aspect ID CHAR 40 0 CRMS4_ERMS_CAT_AS_ID
CAT_ID_02 Coherent Cat. - Category ID CHAR 40 0 CRMS4_ERMS_CAT_CA_ID
PRIORITY Activity Priority NUMC 1 0 SCPRIO CRMT_PRIORITY
PROCESS_TYPE Business Transaction Type CHAR 4 0 CRMC_PROC_TYPE CRMT_PROCESS_TYPE_DB
POSTING_DATE Posting Date for a Business Transaction DATS 8 0 CRMT_POSTING_DATE
DESCRIPTION_H Transaction Description CHAR 40 0 CRMT_PROCESS_DESCRIPTION
DESCR_LANGUAGE Language Key of Description LANG 1 0 T002 CRMT_PROCESS_DESCRIPTION_LANGU
TEMPLATE_TYPE Template Type of CRM Transaction CHAR 1 0 CRMT_TEMPLATE_TYPE_DB
CREATED_AT_H Created At (Output in User Time Zone) DEC 15 0 COMT_CREATED_AT_USR
CREATED_BY_H User that Created the Transaction CHAR 12 0 CRMT_CREATED_BY
CHANGED_AT_H Changed At (Output in User Time Zone) DEC 15 0 COMT_CHANGED_AT_USR
CHANGED_BY_H Transaction Last Changed By CHAR 12 0 CRMT_CHANGED_BY
BTX_CLASS CRM Business Transaction Classification CHAR 1 0 CRMC_TRANS_CLASS CRMT_TRANSACTION_CLASSIFICATN
AUTH_SCOPE Authorization Scope NUMC 6 0 CRMC_AUTH_SCP CRM_AUTH_SCOPE
ARCHIVING_FLAG Indicator Whether the Business Transaction Can Be Archived CHAR 1 0 CRMT_ARCHIVING_FLAG
SERV_I_DUMMY_PS Single-Character Flag CHAR 1 0 CHAR1
ITEM_NO_APPT Shortened Item Number in Document NUMC 6 0 CRMS4_NUMBER_INT
ITEM_NO_PARTNER Shortened Item Number in Document NUMC 6 0 CRMS4_NUMBER_INT
ITEM_NO_QUALIF Shortened Item Number in Document NUMC 6 0 CRMS4_NUMBER_INT
ITEM_NO_REFOBJ Shortened Item Number in Document NUMC 6 0 CRMS4_NUMBER_INT
ITEM_NO_SUBJECT Shortened Item Number in Document NUMC 6 0 CRMS4_NUMBER_INT
ITEM_NO_SURVEY Shortened Item Number in Document NUMC 6 0 CRMS4_NUMBER_INT
ITEM_NO_BILLPLAN Shortened Item Number in Document NUMC 6 0 CRMS4_NUMBER_INT
ITEM_NO_PAYPLAN Shortened Item Number in Document NUMC 6 0 CRMS4_NUMBER_INT
PROD_SEL_TYPE Product Selection Type CHAR 1 0 IST_SELECTION_TYPE
A Accessories
C Combined Rate Plan
I Sales Item/ One-time Fee
M Main Rate Plan
N Nested Sales Package
R Rate Plan Option
S Sales Package
CI_CONTRACT_ID IS-T Contract Number CHAR 20 0 IST_EXT_REF
CI_CONTRACT_ITEM Contract Item Identifier RAW 16 0 CRMT_IST_CONT_ITEM_ID
CI_BILLING_CYCLE Billing Cycle CHAR 4 0 TFK2607 CRMT_IST_BC
BTMF_PROCESS Process of Maint. FW CHAR 32 0 IST_PROCESS
BTMF_PROCESS_TYPE Process Type CHAR 4 0 IST_ITEM_PROCESS
SC_GROUP Sol. Conf. Group CHAR 20 0 IST_SC_GROUP
SC_DOC_GUID SC: Doc. GUID CHAR 32 0 IST_SC_DOCUMENT_ID
SC_AUTHOR_INFO SC: Author Inform. CHAR 1 0 IST_SC_AUTHOR
D User deleted
G Item belongs to a manually de-selected group
M Manual instance
S User selected
SC_INTERLINKAGE_GUID Internal, Unique ID of a Relationship RAW 16 0 COMT_IL_ILGUID
SC_OPT_INDICATOR Solution Configurator Optional/Mandatory Indicator CHAR 1 0 CRMS4_SOM_OPT_INDICATOR
0 Not Deletable
1 Deletable
CCM_VERSION Version NUMC 4 0 CRM_IST_CCM_VERSION
RATING_AREA Rating Area ID CHAR 4 0 * CRM_RAT_AREA
CI_PARTNER_RULE Partner Settlement Rule CHAR 4 0 TFKPS_RULE CRMT_ISX_PARTNER_SETTL_RULE
CI_BILLING_PLAN_CYCLE Billing Plan Cycle CHAR 4 0 * CRMS4_BILLING_PLAN_CYCLE
CONTRACT_CHANGE_REASON Contract Change Reason CHAR 2 0 CRMT_IST_CONT_CHANGE_REASON
CC_ACCOUNT_SPLIT Split Subscriber Account for SAP CC CHAR 1 0 CRMS4_SOM_CC_ACCOUNT_SPLIT
No Subscriber Account Split
X Subscriber Account Split
MA_HEAD_OBJID Transaction ID CHAR 10 0 CRMT_OBJECT_ID_DB
FIX_CONFIG Indicator for Fixing Product Configuration CHAR 1 0 CRMT_ISX_PRVMA_FIX_CONFIG
Not Fixed
A Fixed
MA_ITEM_OBJID Shortened Item Number in Document NUMC 6 0 CRMS4_NUMBER_INT
MA_ROOT_OBJID Shortened Item Number in Document NUMC 6 0 CRMS4_NUMBER_INT
POOL_AGR_REF Reference to Sharing Contract CHAR 20 0 CRM_POOL_AGREEMENT
MA_SHARE_REF Sharing Order/Contract: Reference to Master Agreement RAW 16 0 CRMT_ISX_MA_POOL_REF
MA_SHARE_REF_PROD_ID Sharing Order/Contract: Reference to Master Agreement Prod. CHAR 40 0 CRMT_ISX_MA_SHARE_REF_PROD_ID
SHARING_GROUP_ID Sharing Group ID CHAR 10 0 CRMS4_SOM_SHARING_GROUP_ID
LOCK_REASON Lock Reason CHAR 8 0 * IST_LOCK_REASON
AUTO_RENEW_INDICATOR Auto-Renewal Indicator CHAR 1 0 CRMS4_AUTO_RENEW_INDICATOR
CHANGEPROCESSGROUP BTMF Process Group CHAR 32 0 CRMS4_BTMF_PROCESS_GROUP
PHASE_INDICATOR Phase Indicator CHAR 1 0 CRMS4_PHASE_INDICATOR
SUCCESSOR_OF Shortened Item Number in Document NUMC 6 0 CRMS4_NUMBER_INT
CONT_REF_ITEM Shortened Item Number in Document NUMC 6 0 CRMS4_NUMBER_INT
CONT_REF Transaction ID CHAR 10 0 CRMT_OBJECT_ID
INT_OBJ_NO Configuration (Internal Object Number) NUMC 18 0 CRMT_INT_OBJ_NO
EXIST_VCKEY Indicator Variant Key Available for Item CHAR 1 0 CRMT_EXIST_VCKEY
ROOT_CONFIG Root Configuration Indicator CHAR 1 0 CRMT_ROOT_CONFIG
BILLPLAN_TYPE Billing Plan Type CHAR 2 0 CRMC_BILP_TYPE CRMT_BILLPLAN_TYPE
RULE_HORIZON Rule for Determining Horizon in Billing Plan RAW 16 0 TIMERULEH CRMT_RULE_HORIZON
BILLPLAN_START_DATE Start Date of Billing Plan DEC 15 0 CRMT_START_DATE
RULE_START_DATE Rule for Determining Billing Plan Start Date RAW 16 0 TIMERULEH CRMT_RULE_START_DATE
BILLPLAN_END_DATE End Date of Billing Plan DEC 15 0 CRMT_END_DATE
RULE_END_DATE Rule for Determining Billing Plan End Date RAW 16 0 TIMERULEH CRMT_RULE_END_DATE
BILLPLAN_DATE_FROM Dates From DEC 15 0 CRMT_DATE_FROM
RULE_DATE_FROM Rule for Determining Dates from RAW 16 0 TIMERULEH CRMT_RULE_DATE_FROM
BILLPLAN_DATE_TO Dates To DEC 15 0 CRMT_DATE_TO
RULE_DATE_TO Rule for Determining Dates To RAW 16 0 TIMERULEH CRMT_RULE_DATE_TO
BILLPLAN_TIMEZONE Time Zone of Billing Plan Set CHAR 6 0 TTZZ CRMT_BILLING_TIMEZONE
BILLPLAN_D_RULE_PERIOD_DATE Rule for Determining the Period Date RAW 16 0 TIMERULEH CRMT_RULE_PERIOD_DATE
BILLPLAN_D_RULE_SETTL_FROM Rule for Determining Start of Settlement Period RAW 16 0 TIMERULEH CRMT_RULE_SETTL_FROM
BILLPLAN_D_RULE_SETTL_TO Rule for Determining End of Settlement Period RAW 16 0 TIMERULEH CRMT_RULE_SETTL_TO
BILLPLAN_D_RULE_BILL_DATE Rule for Determining the Next Billing Date RAW 16 0 TIMERULEH CRMT_RULE_BILL_DATE
BILLPLAN_D_RULE_PRICE_DATE Rule for Determining the Pricing Date CHAR 1 0 CRMS4_RULE_PRICE_DATE
Item Pricing Date
A Billing Date in Billing Request Line
B Settlement Start Date in Billing Request Line
C Settlement End Date in Billing Request Line
BILLPLAN_D_RULE_INVCR_DATE Rule for Determining Next Billing Document Creation Date RAW 16 0 TIMERULEH CRMT_RULE_INVCR_DATE
BILLPLAN_D_TIMEZONE Time Zone of Billing Plan Set CHAR 6 0 TTZZ CRMT_BILLING_TIMEZONE
CASHFLOW_TYPE Flow Category CHAR 4 0 CRMT_CASHFLOW_TYPE
NO_BILLITEMS Generate Flag for No Billing Request Items CHAR 1 0 CRMT_NO_BILLITEMS
BILLPLAN_LINE_ID ID of Billing Plan Line CHAR 2 0 CRMC_BILP_TYPL CRMT_BILLPLAN_LINE_ID
BILLINGPLANISFINALIZED Billing Plan Is Finalized CHAR 1 0 CRMS4_BILLINGPLAN_IS_FINALIZED
CANCPROC Cancellation Procedure CHAR 4 0 CRMC_CANCPROC CRMT_CANC_PROCEDURE
CANCPARTY Cancelling Party CHAR 4 0 CRMC_PARTY CRMT_CANC_PARTY
CANC_REASON CRM Service : Reason for Cancellation CHAR 4 0 CRMC_CANCREASON CRMT_SRV_CANCEL_REASON
REF_INHOUSE_REPAIR Reference In-House Repair CHAR 10 0 CRMS4_REF_INHOUSE_REPAIR
REF_INHOUSE_REPAIR_ITEM Reference In-House Repair Item NUMC 6 0 CRMS4_REF_INHOUSE_REPAIR_ITEM
HAS_REF_INHOUSE_REPAIR Reference to In-House Repair Exists CHAR 1 0 CRMS4_HAS_REF_INHOUSE_REPAIR

CRMS4D_SERV_I foreign key relationships

Table Field Check Table Check Field
0 CRMS4D_SERV_I AC_INDICATOR TBMOT Accounting indicators MANDT
0 CRMS4D_SERV_I AC_INDICATOR TBMOT Accounting indicators BEMOT
1 CRMS4D_SERV_I AC_OBJECT_TYPE CRMC_AC_ASSIGN Settlement Account Assignment - Customizing CLIENT
1 CRMS4D_SERV_I AC_OBJECT_TYPE CRMC_AC_ASSIGN Settlement Account Assignment - Customizing AC_OBJECT_TYPE
0 CRMS4D_SERV_I APRV_PROCEDURE CRMC_APRV_PROC Define Approval Procedure CLIENT
1 CRMS4D_SERV_I AUTH_SCOPE CRMC_AUTH_SCP Authorization Scope CLIENT
1 CRMS4D_SERV_I AUTH_SCOPE CRMC_AUTH_SCP Authorization Scope AUTH_DOM
1 CRMS4D_SERV_I AUTH_SCOPE CRMC_AUTH_SCP Authorization Scope AUTH_SCOPE
0 CRMS4D_SERV_I BASE_QTY_UNIT T006 Units of Measurement MANDT
0 CRMS4D_SERV_I BASE_QTY_UNIT T006 Units of Measurement MSEHI
1 CRMS4D_SERV_I BILLING_BLOCK TVFS Billing: Reasons for Blocking FAKSP
0 CRMS4D_SERV_I BILLING_TIMEZONE TTZZ Time zones TZONE
1 CRMS4D_SERV_I BILLPLAN_D_RULE_BILL_DATE TIMERULEH Date Rules (Header) RULE_ID
0 CRMS4D_SERV_I BILLPLAN_D_RULE_INVCR_DATE TIMERULEH Date Rules (Header) RULE_ID
1 CRMS4D_SERV_I BILLPLAN_D_RULE_PERIOD_DATE TIMERULEH Date Rules (Header) RULE_ID
0 CRMS4D_SERV_I BILLPLAN_D_RULE_SETTL_FROM TIMERULEH Date Rules (Header) RULE_ID
1 CRMS4D_SERV_I BILLPLAN_D_RULE_SETTL_TO TIMERULEH Date Rules (Header) RULE_ID
0 CRMS4D_SERV_I BILLPLAN_D_TIMEZONE TTZZ Time zones TZONE
1 CRMS4D_SERV_I BILLPLAN_LINE_ID CRMC_BILP_TYPL Billing Plan Lines BILLPLAN_TYPE
1 CRMS4D_SERV_I BILLPLAN_LINE_ID CRMC_BILP_TYPL Billing Plan Lines BILLPLAN_LINE_ID
0 CRMS4D_SERV_I BILLPLAN_TIMEZONE TTZZ Time zones TZONE
1 CRMS4D_SERV_I BILLPLAN_TYPE CRMC_BILP_TYPE Billing Plan Type CLIENT
1 CRMS4D_SERV_I BILLPLAN_TYPE CRMC_BILP_TYPE Billing Plan Type BILLPLAN_TYPE
0 CRMS4D_SERV_I BILL_TO_PARTY BUT000 BP: General data I PARTNER
1 CRMS4D_SERV_I BTX_CLASS CRMC_TRANS_CLASS Business Transaction Classification OBJECT_TYPE
1 CRMS4D_SERV_I BTX_CLASS CRMC_TRANS_CLASS Business Transaction Classification BTX_CLASS
0 CRMS4D_SERV_I CANCPARTY CRMC_PARTY Cancelling party CLIENT
1 CRMS4D_SERV_I CANCPROC CRMC_CANCPROC Cancellation Procedure CLIENT
0 CRMS4D_SERV_I CANC_REASON CRMC_CANCREASON Cancellation Reason CLIENT
1 CRMS4D_SERV_I CHKL_STEP_ID CRMC_CHKLST_ST Define Checklist Step CLIENT
1 CRMS4D_SERV_I CHKL_STEP_ID CRMC_CHKLST_ST Define Checklist Step STEP_ID
0 CRMS4D_SERV_I CI_BILLING_CYCLE TFK2607 Billing Cycles CYCLE
1 CRMS4D_SERV_I CI_PARTNER_RULE TFKPS_RULE Partner Settlement Rule MANDT
1 CRMS4D_SERV_I CI_PARTNER_RULE TFKPS_RULE Partner Settlement Rule PTSRL
0 CRMS4D_SERV_I CLIENT T000 Clients MANDT
1 CRMS4D_SERV_I CONTACT_PERSON BUT000 BP: General data I PARTNER
0 CRMS4D_SERV_I CONTRACT_ACCOUNT FKKVK Contract Account Header VKONT
1 CRMS4D_SERV_I CURRENCY TCURC Currency Codes MANDT
1 CRMS4D_SERV_I CURRENCY TCURC Currency Codes WAERS
0 CRMS4D_SERV_I CUSTOMER_TYPE TB004 BP types BPKIND
1 CRMS4D_SERV_I CUST_GROUP T151 Customers: Customer Groups MANDT
1 CRMS4D_SERV_I CUST_GROUP T151 Customers: Customer Groups KDGRP
0 CRMS4D_SERV_I CUST_GROUP1 TVV1 Customer Group 1 MANDT
0 CRMS4D_SERV_I CUST_GROUP1 TVV1 Customer Group 1 KVGR1
1 CRMS4D_SERV_I CUST_GROUP2 TVV2 Customer Group 2 MANDT
1 CRMS4D_SERV_I CUST_GROUP2 TVV2 Customer Group 2 KVGR2
0 CRMS4D_SERV_I CUST_GROUP3 TVV3 Customer Group 3 KVGR3
1 CRMS4D_SERV_I CUST_GROUP4 TVV4 Customer Group 4 MANDT
1 CRMS4D_SERV_I CUST_GROUP4 TVV4 Customer Group 4 KVGR4
0 CRMS4D_SERV_I CUST_GROUP5 TVV5 Customer Group 5 MANDT
0 CRMS4D_SERV_I CUST_GROUP5 TVV5 Customer Group 5 KVGR5
1 CRMS4D_SERV_I CUST_PRIC_PROC TVKD Customer classification for pricing procedure determination MANDT
1 CRMS4D_SERV_I CUST_PRIC_PROC TVKD Customer classification for pricing procedure determination KALKS
0 CRMS4D_SERV_I DELIVERY_BLOCK TVLS Deliveries: Blocking Reasons/Criteria MANDT
0 CRMS4D_SERV_I DELIVERY_BLOCK TVLS Deliveries: Blocking Reasons/Criteria LIFSP
1 CRMS4D_SERV_I DESCR_LANGUAGE T002 Language Keys (Component BC-I18) SPRAS
0 CRMS4D_SERV_I DIS_CHANNEL TVTW Organizational Unit: Distribution Channels MANDT
0 CRMS4D_SERV_I DIS_CHANNEL TVTW Organizational Unit: Distribution Channels VTWEG
1 CRMS4D_SERV_I DIVISION TSPA Organizational Unit: Sales Divisions MANDT
1 CRMS4D_SERV_I DIVISION TSPA Organizational Unit: Sales Divisions SPART
0 CRMS4D_SERV_I DLV_PRIO TPRIO Customers: Delivery Priorities LPRIO
1 CRMS4D_SERV_I EXCHG_TYPE TCURV Exchange rate types for currency translation MANDT
1 CRMS4D_SERV_I EXCHG_TYPE TCURV Exchange rate types for currency translation KURST
0 CRMS4D_SERV_I INCOTERMS1 TINC Customers: Incoterms INCO1
1 CRMS4D_SERV_I INDUSTRY T016 Industries BRSCH
0 CRMS4D_SERV_I KIND_BILL_DATE SCAPPTTYPE Appointment Type CLIENT
0 CRMS4D_SERV_I KIND_BILL_DATE SCAPPTTYPE Appointment Type APPT_TYPE
1 CRMS4D_SERV_I KIND_DATE_FROM SCAPPTTYPE Appointment Type CLIENT
1 CRMS4D_SERV_I KIND_DATE_FROM SCAPPTTYPE Appointment Type APPT_TYPE
0 CRMS4D_SERV_I KIND_DATE_TO SCAPPTTYPE Appointment Type CLIENT
0 CRMS4D_SERV_I KIND_DATE_TO SCAPPTTYPE Appointment Type APPT_TYPE
1 CRMS4D_SERV_I KIND_END_DATE SCAPPTTYPE Appointment Type CLIENT
1 CRMS4D_SERV_I KIND_END_DATE SCAPPTTYPE Appointment Type APPT_TYPE
0 CRMS4D_SERV_I KIND_INVCR_DATE SCAPPTTYPE Appointment Type CLIENT
0 CRMS4D_SERV_I KIND_INVCR_DATE SCAPPTTYPE Appointment Type APPT_TYPE
1 CRMS4D_SERV_I KIND_PERIOD_DATE SCAPPTTYPE Appointment Type CLIENT
1 CRMS4D_SERV_I KIND_PERIOD_DATE SCAPPTTYPE Appointment Type APPT_TYPE
0 CRMS4D_SERV_I KIND_SETTL_FROM SCAPPTTYPE Appointment Type CLIENT
0 CRMS4D_SERV_I KIND_SETTL_FROM SCAPPTTYPE Appointment Type APPT_TYPE
1 CRMS4D_SERV_I KIND_SETTL_TO SCAPPTTYPE Appointment Type CLIENT
1 CRMS4D_SERV_I KIND_SETTL_TO SCAPPTTYPE Appointment Type APPT_TYPE
0 CRMS4D_SERV_I KIND_START_DATE SCAPPTTYPE Appointment Type CLIENT
0 CRMS4D_SERV_I KIND_START_DATE SCAPPTTYPE Appointment Type APPT_TYPE
1 CRMS4D_SERV_I KIND_VALUE_DATE SCAPPTTYPE Appointment Type CLIENT
1 CRMS4D_SERV_I KIND_VALUE_DATE SCAPPTTYPE Appointment Type APPT_TYPE
0 CRMS4D_SERV_I NETPR_UOM T006 Units of Measurement MANDT
1 CRMS4D_SERV_I PAYER BUT000 BP: General data I PARTNER
0 CRMS4D_SERV_I PERSON_RESP BUT000 BP: General data I PARTNER
1 CRMS4D_SERV_I PLANT T001W Plants/Branches MANDT
1 CRMS4D_SERV_I PLANT T001W Plants/Branches WERKS
0 CRMS4D_SERV_I PMNTTRMS T052 Terms of Payment MANDT
0 CRMS4D_SERV_I PMNTTRMS T052 Terms of Payment ZTERM
0 CRMS4D_SERV_I PMNTTRMS T052 Terms of Payment ZTAGG
1 CRMS4D_SERV_I PRC_GROUP1 TVM1 Material Pricing Group 1 MVGR1
0 CRMS4D_SERV_I PRC_GROUP2 TVM2 Material Pricing Group 2 MVGR2
1 CRMS4D_SERV_I PRC_GROUP3 TVM3 Material Pricing Group 3 MVGR3
0 CRMS4D_SERV_I PRC_GROUP4 TVM4 Material Pricing Group 4 MANDT
0 CRMS4D_SERV_I PRC_GROUP4 TVM4 Material Pricing Group 4 MVGR4
1 CRMS4D_SERV_I PRC_GROUP5 TVM5 Material Pricing Group 5 MANDT
1 CRMS4D_SERV_I PRC_GROUP5 TVM5 Material Pricing Group 5 MVGR5
0 CRMS4D_SERV_I PRICE_GRP T188 Conditions: Groups for Customer Classifications MANDT
0 CRMS4D_SERV_I PRICE_GRP T188 Conditions: Groups for Customer Classifications KONDA
1 CRMS4D_SERV_I PRIORITY SCPRIO Priorities CLIENT
1 CRMS4D_SERV_I PRIORITY SCPRIO Priorities PRIORITY
0 CRMS4D_SERV_I PROCESS_QTY_UNIT T006 Units of Measurement MANDT
0 CRMS4D_SERV_I PROCESS_QTY_UNIT T006 Units of Measurement MSEHI
1 CRMS4D_SERV_I PROD_PR_GROUP T178 Conditions: Groups for Materials MANDT
1 CRMS4D_SERV_I PROD_PR_GROUP T178 Conditions: Groups for Materials KONDM
0 CRMS4D_SERV_I REC_TIME_UNIT TIMECUUT Symbolic Names for Time Durations CLIENT
0 CRMS4D_SERV_I REC_TIME_UNIT TIMECUUT Symbolic Names for Time Durations NAME_UNIT
1 CRMS4D_SERV_I REF_CURRENCY TCURC Currency Codes MANDT
1 CRMS4D_SERV_I REF_CURRENCY TCURC Currency Codes WAERS
0 CRMS4D_SERV_I REGION T005S Taxes: Region (Province) Key LAND1
1 CRMS4D_SERV_I REJECTION TVAG Sales Documents: Rejection Reasons MANDT
1 CRMS4D_SERV_I REJECTION TVAG Sales Documents: Rejection Reasons ABGRU
0 CRMS4D_SERV_I RESP_GROUP BUT000 BP: General data I PARTNER
1 CRMS4D_SERV_I RULE_BILL_DATE TIMERULEH Date Rules (Header) RULE_ID
0 CRMS4D_SERV_I RULE_DATE_FROM TIMERULEH Date Rules (Header) RULE_ID
1 CRMS4D_SERV_I RULE_DATE_TO TIMERULEH Date Rules (Header) RULE_ID
0 CRMS4D_SERV_I RULE_END_DATE TIMERULEH Date Rules (Header) RULE_ID
1 CRMS4D_SERV_I RULE_HORIZON TIMERULEH Date Rules (Header) RULE_ID
0 CRMS4D_SERV_I RULE_INVCR_DATE TIMERULEH Date Rules (Header) RULE_ID
1 CRMS4D_SERV_I RULE_PERIOD_DATE TIMERULEH Date Rules (Header) RULE_ID
0 CRMS4D_SERV_I RULE_SETTL_FROM TIMERULEH Date Rules (Header) RULE_ID
1 CRMS4D_SERV_I RULE_SETTL_TO TIMERULEH Date Rules (Header) RULE_ID
0 CRMS4D_SERV_I RULE_START_DATE TIMERULEH Date Rules (Header) RULE_ID
1 CRMS4D_SERV_I RULE_VALUE_DATE TIMERULEH Date Rules (Header) RULE_ID
0 CRMS4D_SERV_I SERVICE_EMPLOYEE BUT000 BP: General data I PARTNER
1 CRMS4D_SERV_I SERVICE_TEAM BUT000 BP: General data I PARTNER
0 CRMS4D_SERV_I SHIP_COND TVSB Shipping Conditions MANDT
0 CRMS4D_SERV_I SHIP_COND TVSB Shipping Conditions VSBED
1 CRMS4D_SERV_I SHIP_TO_PARTY BUT000 BP: General data I PARTNER
0 CRMS4D_SERV_I SOLD_TO_COUNTRY T005 Countries MANDT
0 CRMS4D_SERV_I SOLD_TO_COUNTRY T005 Countries LAND1
1 CRMS4D_SERV_I SOLD_TO_PARTY BUT000 BP: General data I PARTNER
0 CRMS4D_SERV_I SOLD_TO_REGION T005S Taxes: Region (Province) Key LAND1
1 CRMS4D_SERV_I TAXJURCODE TTXJ Check Table for Tax Jurisdiction MANDT
1 CRMS4D_SERV_I TAXJURCODE TTXJ Check Table for Tax Jurisdiction KALSM
0 CRMS4D_SERV_I TAX_DEST_CTY T005 Countries MANDT
0 CRMS4D_SERV_I TAX_DEST_CTY T005 Countries LAND1
1 CRMS4D_SERV_I TAX_DEST_REG T005S Taxes: Region (Province) Key LAND1
0 CRMS4D_SERV_I USAGE_TYPE TVLV Check table for release orders: Usage ID ABRVW
1 CRMS4D_SERV_I VOLUME_UNIT_I T006 Units of Measurement MANDT
0 CRMS4D_SERV_I WEIGHT_UNIT_I T006 Units of Measurement MANDT