CRMS4D_SERV_I
Items of service transactions
CRMS4D_SERV_I is an SAP database table in S/4HANA. Items of service transactions. It contains 443 fields. 9 CDS views read from this table.
CDS Views using this table (9)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| CRMS4_SERV_I_SEARCH | view | from | Service Items | |
| CRMS4_SERV_UUID_CHAR | view_entity | from | Srv Trans Item and Header GUID Character | |
| CRMS4V_SDM_CRMS4D_SERV_H_IHRID | view | left_outer | ||
| E_ServiceDocumentItem | view | from | EXTENSION | Service Document Item Extension |
| I_BusSolnQuotationItemText | view | inner | BASIC | Solution Quotation Item Text |
| I_PrftCtrToServiceDocumentItem | view_entity | inner | BASIC | Assgmt of PrftCtr to Service Doc Item |
| I_ServiceDocumentItem | view | from | BASIC | Service Transaction Item |
| I_SubscrpnContrItmText | view_entity | inner | BASIC | Subscription Contract Item Text |
| P_SubscriptionContractItem | view_entity | from | BASIC | Subscription Contract Item |
Fields (443)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | client | MANDT | Client | |||
| KEY | objtype_h | CRMT_SUBOBJECT_CATEGORY_DB | Trans. Cat. | |||
| KEY | object_id | CRMT_OBJECT_ID_DB | Transaction ID | |||
| KEY | number_int | CRMS4_NUMBER_INT | Item Number in Doc. | |||
| ac_object_type | CRMT_AC_OBJECT_TYPE | Acct Assgt Obj.Type | ||||
| ac_assignment | CRMT_AC_ASSIGN | Sett.Account Assgmnt | ||||
| ac_percentage | CRMT_AC_COST_PERCENTAGE | Percent. of Costs | ||||
| aprv_activated | CRMT_BOOLEAN | Flag | ||||
| aprv_procedure | CRMT_APPROVAL_PROCEDURE | Approval Procedure | ||||
| change_allowed | CRMT_BOOLEAN | Flag | ||||
| period_date | CRMT_PERIOD_DATE | Period date | ||||
| rule_period_date | CRMT_RULE_PERIOD_DATE | Rule PeriodDate | ||||
| settl_from | CRMT_SETTL_FROM | SettlementStart | ||||
| rule_settl_from | CRMT_RULE_SETTL_FROM | Determine SePer | ||||
| settl_to | CRMT_SETTL_TO | Settlement End | ||||
| rule_settl_to | CRMT_RULE_SETTL_TO | Settlement end | ||||
| bill_date | CRMS4_BILL_DATE_TSTMP | Billing Date | ||||
| rule_bill_date | CRMT_RULE_BILL_DATE | Rule BillDate | ||||
| invcr_date | CRMS4_INVCR_DATE_TSTMP | Billing Date | ||||
| rule_invcr_date | CRMT_RULE_INVCR_DATE | Rule: BillDoc | ||||
| value_date | CRMT_VALUE_DATE | Fixed Value Dat | ||||
| rule_value_date | CRMT_RULE_VALUE_DATE | Value Date Rule | ||||
| billing_timezone | CRMT_BILLING_TIMEZONE | Time zone | ||||
| billing_block | CRMT_BUS_BILL_BLOCK_REASON | Bill Block Reason | ||||
| sepa_on | CRMT_SEPA_ON | SEPA Relevant | ||||
| mandate_id | CRMT_MANDATE_ID | Mandate ID | ||||
| kind_period_date | TIMENAEVEN | Date type | ||||
| kind_settl_from | TIMENAEVEN | Date type | ||||
| kind_settl_to | TIMENAEVEN | Date type | ||||
| kind_bill_date | TIMENAEVEN | Date type | ||||
| kind_invcr_date | TIMENAEVEN | Date type | ||||
| kind_value_date | TIMENAEVEN | Date type | ||||
| kind_start_date | TIMENAEVEN | Date type | ||||
| kind_end_date | TIMENAEVEN | Date type | ||||
| kind_date_from | TIMENAEVEN | Date type | ||||
| kind_date_to | TIMENAEVEN | Date type | ||||
| contract_account | VKONT_KK | Contract Acct | ||||
| dip_profile | AD01PROFNR | DIP Profile | ||||
| results_analysis_key | ABGR_SCHL_APPL | RA Key | ||||
| billing_relevance | CRMS4_BILLING_RELEVANCE | Bill. Relevance | ||||
| wbs_element | PS_S4_PSPNR | WBS Internal ID | ||||
| chkl_step_group | CHKLST_STEP_GRP_GUID | Step Group GUID | ||||
| chkl_step_id | CHKLST_STEP_ID | Checklist Step ID | ||||
| chkl_step_no | CHKLST_STEP_NO | Checklist Step No. | ||||
| chkl_option_id | CHKLST_OPTION_ID | Checklist Option ID | ||||
| chkl_prev_group | CHKLST_PREV_GRP_GUID | Prev. Group GUID | ||||
| chkl_prev_no | CHKLST_PREV_GRP_NO | Prev. Group No. | ||||
| chkl_trigger_id | CHKLST_TRIGGER_ID | Trigger ID | ||||
| gi_quantity | CRMS4_GI_QUANTITY | Goods Issue Quantity | ||||
| gi_value | CRMS4_GI_VALUE | Goods Issue Value | ||||
| ordered_quantity | CRMS4_ORD_QUANTITY | Ordered Quantity | ||||
| billed_value | CRMS4_INV_VALUE | Invoice Value | ||||
| billed_quantity | CRMS4_INV_QUANTITY | Invoiced Quantity | ||||
| dlv_quantity | CRMS4_DLV_QUANTITY | Delivered Quantity | ||||
| released_quantity | CRMS4_RLSD_QUANTITY | Released Quantity | ||||
| released_value | CRMS4_RLSD_VALUE | Released Value | ||||
| valid_from | CRMT_VALID_FROM | Valid from | ||||
| valid_to | CRMT_VALID_TO | Valid to | ||||
| quot_start | CRMS4_QUOT_START_DATE | Quot: Valid from Dat | ||||
| quot_end | CRMS4_QUOT_END_DATE | Quot: Valid to Date | ||||
| srv_cust_beg | CRMS4_SRV_CUST_BEG_TSTMP | Service Req. Start | ||||
| srv_cust_end | CRMS4_SRV_CUST_END_TSTMP | Service Request Due | ||||
| srq_work_dura | CRMS4_SRQ_WORK_DURA | Work Duration of ST | ||||
| srq_work_unit | CRMS4_SRQ_WORK_UNIT | Work Drtn Unit ST | ||||
| srq_tot_dura | CRMS4_SRQ_TOT_DURA | Total Duration of ST | ||||
| srq_tot_unit | CRMS4_SRQ_TOT_UNIT | Total Drtn Unit ST | ||||
| contstart | CRMS4_CONT_START | Contract Start Date | ||||
| contend | CRMS4_CONT_END | Contract End Date | ||||
| cont_start_ts | CRMS4_CONT_START_TS_DATE | Start of Contract TS | ||||
| cont_end_ts | CRMS4_CONT_END_TS_DATE | End of Contract TS | ||||
| srv_rfirst | CRMS4_SRV_RFIRST | First Response By | ||||
| srv_rready | CRMS4_SRV_RREADY | Due By | ||||
| srv_close | CRMS4_SRV_CLOSE | Closing Date | ||||
| auto_renew_period | CRMS4_AUTO_RENEW_PERIOD_DURA | Renewal Period | ||||
| auto_renew_period_unit | CRMS4_AUTO_RENEW_PERIOD_UNIT | AR Period UOM | ||||
| auto_renew_exten | CRMS4_AUTO_RENEW_EXTEN_DURA | Contract Extension | ||||
| auto_renew_exten_unit | CRMS4_AUTO_RENEW_EXTEN_UNIT | Contract Extsn UOM | ||||
| auto_renew_start | CRMS4_AUTO_RENEW_START_DATE | Auto Renewal Start | ||||
| srq_work_dura_2 | CRMS4_SRQ_WORK_DURA_2 | Work Duration of ST | ||||
| srq_tot_dura_2 | CRMS4_SRQ_TOT_DURA_2 | Total Duration of ST | ||||
| grace_period | CRMS4_GRACE_PERIOD | Grace Period | ||||
| grace_period_unit | CRMS4_GRACE_PERIOD_UNIT | Unit of Grace Period | ||||
| grace_period_end | CRMS4_GRACE_PERIOD_TO | Grce End Date | ||||
| biz_valid_start | CRMS4_SOM_BIZ_VALID_FROM | Start of Bus Valdty | ||||
| biz_valid_end | CRMS4_SOM_BIZ_VALID_TO | End of Bus Valdty | ||||
| srvc_actual | CRMS4_SRVC_ACTUAL_TSTMP | Service Actual Start | ||||
| srvc_act_to | CRMS4_SRVC_ACT_TO_TSTMP | Service Actual End | ||||
| spla_planfr | CRMS4_SPLA_PLANFR_TSTMP | Service Planned From | ||||
| spla_planto | CRMS4_SPLA_PLANTO_TSTMP | Service Planned To | ||||
| item_guid | CRMT_OBJECT_GUID | Object GUID | ||||
| created_at_i | CRMS4_CREATED_AT | Created On | ||||
| created_by_i | CRMT_CREATED_BY | Created By | ||||
| changed_at_i | CRMS4_CHANGED_AT | Changed On | ||||
| changed_by_i | CRMT_CHANGED_BY | Changed By | ||||
| objtype_i | CRMT_SWO_OBJTYP_PROCESS_ITM_DB | Object Type | ||||
| header_guid | CRMT_OBJECT_GUID | Object GUID | ||||
| parent | CRMT_OBJECT_GUID | Object GUID | ||||
| alternative | CRMT_OBJECT_GUID | Object GUID | ||||
| product | CRMT_PRODUCT_GUID_DB | Product GUID | ||||
| ordered_prod | CRMT_ORDERED_PROD_DB | Product | ||||
| partner_prod | CRMT_ITEM_DESCR_PARTNER | Partner Product | ||||
| description_i | CRMT_PRSHTEXTX_DB | Short Text | ||||
| itm_language | CRMT_ITEM_LANGU | Language | ||||
| number_ext | CRMT_ITEM_NO_EXT | Ext. Item No. | ||||
| itm_type | CRMT_ITEM_TYPE_DB | Item Category | ||||
| order_date | CRMT_ORDER_DATE | Posting Date | ||||
| itm_usage | CRMT_ITEM_USAGE | Usage HL Item | ||||
| itm_type_usage | CRMT_IT_TYPE_USAGE | Item Cat. Usage | ||||
| product_kind | CRMT_PRODUCT_KIND | Prod. Tech. Typ | ||||
| revacc_refid | CRMT_REVACC_REFID | RA Reference ID | ||||
| revacc_reftype | CRMT_REVACC_REFTYPE | RA Reference Type | ||||
| revacc_relevant_type | CRMT_REVACC_RELEVANT_TYPE | Type | ||||
| product_id | PRODUCTNUMBER | Product | ||||
| item_guid_char | CRMT_OBJECT_GUID32 | Object GUID | ||||
| profit_center | PRCTR | Profit Center | ||||
| profit_center_origin | CRMS4_SRVC_PROFIT_CNTR_ORIGIN | Profit Center Source Indicator | ||||
| kokrs | KOKRS | CO Area | ||||
| profit_determine_date | DATUM | Date | ||||
| refbussolnord | CRMS4_REF_SOLO_OBJECT_ID | Ref. Soltn Order ID | ||||
| refbussolnorditm | CRMS4_REF_SOLO_NUMBER_INT | Ref. Item Number | ||||
| subscrpnbillgcycle | CRMS4_SUBSCRPN_BILLG_CYCLE | Billing Cycle | ||||
| midbillcycexprtnallwd | CRMS4_MIDBILL_CYC_EXPRTN_ALLWD | Mid Cyc Exprtn Allwd | ||||
| default_terms_ovrwrt | CRMS4_OVRWRT_DEFAULT_TERMS_DB | Ovrwrt Default Terms | ||||
| proj_org_id | CRMS4_PROJ_ORG_ID | Service Org. | ||||
| cost_center | KOSTL | Cost Center | ||||
| is_unplanned_item | CRMS4_IS_UNPLANNED_ITEM | Unplanned Item | ||||
| ref_srvc_ord_item_uuid | CRMS4_REF_SRVC_ORD_ITEM_UUID | Ref Srv Item GUID | ||||
| main_item_bundle_type | CRMS4_MAIN_ITEM_STRUC_PRVDR | Structure Provider of Main Item | ||||
| dis_channel | CRMT_DISTRIBUTION_CHANNEL | Distribution Channel | ||||
| division | CRMT_DIVISION | Division | ||||
| service_org_ori | CRMT_SERVICE_ORG_ORIGIN | Origin srvc. org. | ||||
| service_orgr_ori | CRMT_SERVICE_ORG_RESP_ORIGIN | Origin Sales Org. | ||||
| sales_org_ori | CRMT_SALES_ORG_ORIGIN | Origin sales org. | ||||
| dis_channel_ori | CRMT_DIS_CHANNEL_ORIGIN | Origin: Distr. chnl | ||||
| sales_off_ori | CRMT_SALES_OFFICE_ORIGIN | Origin: Sales office | ||||
| sales_group_ori | CRMT_SALES_GROUP_ORIGIN | Origin: Sales group | ||||
| sales_orgr_ori | CRMT_SALES_ORG_RESP_ORIGIN | Origin SOrg | ||||
| division_ori | CRMT_DIVISION_ORIGIN | Origin: Division | ||||
| sales_org | CRMT_SALES_ORG | Sales Org. ID | ||||
| sales_office | CRMT_SALES_OFFICE | Sales Office | ||||
| sales_group | CRMT_SALES_GROUP | Sales Group | ||||
| sales_org_resp | CRMT_SALES_ORG_RESP | Org. Unit (Sales) | ||||
| service_org | CRMT_SERVICE_ORG | Service Organization | ||||
| service_org_resp | CRMT_SERVICE_ORG_RESP | OU (Service) | ||||
| sales_org_sd | VKORG | Sales Org. | ||||
| sales_office_sd | VKBUR | Sales Office | ||||
| sales_group_sd | VKGRP | Sales Group | ||||
| enterprise_service_org | CRMS4_ENTERPRISE_SERVICE_ORG | Ent. Service Org. | ||||
| service_team_rm | CRMS4_SERVICE_TEAM_RM | Service Team | ||||
| service_team_rm_ori | CRMS4_SERVICE_TEAM_RM_ORIGIN | Origin Service Team | ||||
| planning_plant | IWERK | Planning Plant | ||||
| work_center_object_id | LGWID | Work Center | ||||
| sold_to_party | CRMT_SOLD_TO_PART | Customer | ||||
| sold_to_region | CRMT_REGION | Region | ||||
| sold_to_country | CRMT_COUNTRY | Country/Region | ||||
| ship_to_party | CRMT_SHIP_TO_PART | Ship-To Party | ||||
| bill_to_party | CRMT_BILL_TO_PART | Bill-To Party | ||||
| payer | CRMT_RP_PAYER | Payer | ||||
| person_resp | CRMT_PERSON_RESP | Employee Resp. | ||||
| contact_person | CRMT_CONTACT_PERSON | Contact Pers. | ||||
| resp_group | CRMT_RESPONSIBLE_GROUP | Responsible Group | ||||
| service_team | CRMT_SERVICE_TEAM | Service Team | ||||
| service_employee | CRMT_SERVICE_EMPLOYEE | Exec.Service Emp. | ||||
| exchg_type | CRMT_EXCHG_TYPE | Exch. Rate Type | ||||
| exchg_date | CRMT_EXCHG_DATE | Exch. Rate Date | ||||
| taxjurcode | CRMT_TAXJURCODE | Jurisdict.Code | ||||
| cust_pric_proc | CRMT_CUST_PRIC_PROC | Cust.Pric.Proc. | ||||
| ref_currency | CRMT_REF_CURRENCY | Ref. Currency | ||||
| currency | CRMT_CURRENCY | Currency | ||||
| price_date | CRMT_PRICE_DATE | Pricing Date | ||||
| pmnttrms | CRMT_PMNTTRMS | Terms of Paymnt | ||||
| price_grp | CRMT_PRICE_GRP | Price Group | ||||
| cust_group | CRMT_CUST_GROUP | Customer Group | ||||
| exchg_rate | CRMT_EXCHG_RATE | Exchange Rate | ||||
| tax_dest_cty | CRMT_TAX_DEST_CTY | Dest.Ctry/Reg. | ||||
| tax_dest_reg | CRMT_REGION | Region | ||||
| vat_reg_no | CRMT_VAT_REG_NO | Sales tax no. | ||||
| ac_indicator | CRMT_AC_INDICATOR | Account. Indic. | ||||
| customer_type | CRMT_CUSTOMER_TYPE | Part. Type | ||||
| payment_method | CRMT_BUAG_PAYMETH | Payment Method | ||||
| price_list | CRMT_PRICE_LIST | Price List | ||||
| pricing_control | CRMS4_PRICING_CONTROL | Pricing Control | ||||
| taxk1 | TAXK1_AK | Alt.Tax Class. | ||||
| net_value_man_i | CRMT_NET_VALUE_MAN | Exp.Total Value | ||||
| cost_amount_man | CRMT_COST_AMOUNT_MAN | Exp. Total Cost | ||||
| statistical | CRMT_STATISTICAL | Statist.value | ||||
| prc_indicator | CRMT_PRICING_INDICATOR | Pric. indicat. | ||||
| net_value_i | CRMT_NET_VALUE | Net Value | ||||
| net_price_i | CRMT_NET_PRICE | Net price | ||||
| tax_amount_i | CRMT_TAX_AMOUNT | Tax amount | ||||
| freight_i | CRMT_FREIGHT | Shipment costs | ||||
| gross_value_i | CRMT_GROSS_VALUE | Gross Value | ||||
| net_wo_freight_i | PRCT_NET_VALUE_WITHOUT_FREIGHT | Net value | ||||
| subtotal1 | CRMT_SUBTOTAL1 | Subtotal 1 | ||||
| subtotal2 | CRMT_SUBTOTAL2 | Subtotal 2 | ||||
| subtotal3 | CRMT_SUBTOTAL3 | Subtotal 3 | ||||
| subtotal4 | CRMT_SUBTOTAL4 | Subtotal 4 | ||||
| subtotal5 | CRMT_SUBTOTAL5 | Subtotal 5 | ||||
| subtotal6 | CRMT_SUBTOTAL6 | Subtotal 6 | ||||
| credit_indicator | CRMT_CREDIT_INDICATOR | Credit | ||||
| netpr_pric_unit | PRCT_COND_PRICING_UNIT | Price Unit | ||||
| netpr_uom | PRCT_COND_UOM | Condition Unit | ||||
| total_discount_i | PRCT_COND_VALUE | Condition Value | ||||
| recurring_charge | CRMT_RECURRING_CHARGE | Recur Charge | ||||
| recurring_tax | CRMT_RECURRING_TAX | Recu tax | ||||
| recurring_gross | CRMT_RECURRING_GROSS | Rec.Charg.incl.tax | ||||
| rec_duration | CRMT_REC_DURATION | Recur. Dura. | ||||
| rec_time_unit | CRMT_REC_TIME_UNIT | Recu.Time U. | ||||
| rec_main_itm_cum | CRMT_REC_MAIN_ITEM_CUM | M.Item.Rec. | ||||
| target_value | CRMS4_TARGET_VALUE | Target Value | ||||
| price_source | PRICE_SOURCE | Price source | ||||
| tax_depart_cty | CRMT_TAX_DEPART_CTY | Dept. Country | ||||
| tax_depart_reg | CRMT_TAX_DEPART_REG | Depart. Region | ||||
| determ_cost_control | CRMS4_DETERM_COST_CONTROL | Determine Cost | ||||
| gross_weight_i | CRMT_GROSS_WEIGHT | Gross Weight | ||||
| net_weight_i | CRMT_NET_WEIGHT | Net Weight | ||||
| weight_unit_i | COMT_WEIGHT_UNIT | Unit of Weight | ||||
| volume_i | CRMT_VOLUME | Volume | ||||
| volume_unit_i | COMT_VOLUME_UNIT | Volume Unit | ||||
| price_product | CRMT_PRICE_PRODUCT | PricingRefProd. | ||||
| process_qty_num | CRMT_PROCESS_QTY_NUM | Numerator | ||||
| process_qty_den | CRMT_PROCESS_QTY_DEN | Denominator | ||||
| exponent10 | CRMT_EXPONENT10 | Exponent | ||||
| process_qty_unit | CRMT_PROCESS_QTY_UNIT | Sales Unit | ||||
| comm_group | CRMT_COMM_GROUP | Commission Grp | ||||
| rebate_group | CRMT_REBATE_GROUP | Vol. Rebate Grp | ||||
| cash_disc | CRMT_CASH_DISC | Qual.for Cash Discnt | ||||
| prod_pr_group | KONDM | Mat. Price Grp | ||||
| prc_group1 | MVGR1 | MaterialGroup 1 | ||||
| prc_group2 | MVGR2 | MaterialGroup 2 | ||||
| prc_group3 | MVGR3 | MaterialGroup 3 | ||||
| prc_group4 | MVGR4 | MaterialGroup 4 | ||||
| prc_group5 | MVGR5 | MaterialGroup 5 | ||||
| prod_hierarchy | CRMT_PROD_HIERARCHY | Product Cat. | ||||
| base_qty_unit | COMT_PRODUCT_BASE_UOM | BUoM | ||||
| plant | WERKS_D | Plant | ||||
| batch | CHARG_D | Batch | ||||
| region | CRMT_REGION | Region | ||||
| industry | CRMT_INDUSTRY | Industry Sector | ||||
| cust_group1 | CRMT_CUST_GROUP1 | Customer Grp 1 | ||||
| cust_group2 | CRMT_CUST_GROUP2 | Customer Grp 2 | ||||
| cust_group3 | CRMT_CUST_GROUP3 | Customer Grp 3 | ||||
| cust_group4 | CRMT_CUST_GROUP4 | Customer Grp 4 | ||||
| cust_group5 | CRMT_CUST_GROUP5 | Customer Grp 5 | ||||
| po_number_sold | CRMT_PO_NUMBER_SOLD | Ext. Reference | ||||
| po_date_sold | CRMT_PO_DATE_SOLD | Reference Date | ||||
| your_ref_sold | CRMT_YOUR_REFERENCE_SOLD | Your Reference | ||||
| po_number_ship | CRMT_PO_NUMBER_SHIP | Ext. Reference | ||||
| po_date_ship | CRMT_PO_DATE_SHIP | Reference Doc SH | ||||
| your_ref_ship | CRMT_YOUR_REFERENCE_SHIP | Your Reference | ||||
| usage_type | CRMT_USAGE | Usage | ||||
| submission | CRMT_SUBMISSION | Collective No. | ||||
| rejection | CRMT_REJECTION_CODE | Cancel Rsn Code | ||||
| probability | CRMT_ORDER_PROBABILITY | Probability % | ||||
| date_qty_fixed | CRMT_DATE_QTY_FIXED | Fixed Date/Qty | ||||
| orig_order_qty | CRMT_QTY_ORIG_ORDER | Org. Order Quantity | ||||
| order_qty | CRMT_QTY_ORDER | Order Quantity | ||||
| confirmed_qty | CRMT_QTY_CONFIRMED | Confirmed Qty | ||||
| latest_conf_date | CRMS4_LATEST_CONF_DATE | Latest Cnfrmtn Date | ||||
| dlv_group_date | CRMT_DLV_GROUP_DATE | Deliv. Grp Date | ||||
| latest_req_date | CRMS4_LATEST_REQ_DATE | Latest Rqstd Date | ||||
| first_req_date | CRMS4_FIRST_REQ_DATE | First Rqstd Dlv Date | ||||
| first_conf_date | CRMS4_FIRST_CONF_DATE | First Cnfmd Dvl Date | ||||
| dispo_flg | CRMT_SRV_DISPO_FLG | Resrce Planning | ||||
| confirm_relevant | CRMT_CONFIRM_RELEVANT | Confirmation | ||||
| srv_conf_time | CRMT_SRV_CONF_DURATION | Actual Duration | ||||
| srv_conf_tunit | CRMT_SRV_CONF_TIME_UNIT | Time Unit | ||||
| service_type | CRMT_SERVICE_TYPE | Service Type | ||||
| valuation_type | CRMT_VALUATION_TYPE | Valuation Type | ||||
| srv_escal | CRMT_SRV_ESCAL | Response Prof. | ||||
| srv_serwi | CRMT_SRV_SERWI | Service Profile | ||||
| srv_rule_id | SC_RULEID | Rule ID | ||||
| srcl_service_profile | CRMT_SRCL_SRVPRF | Service Profile | ||||
| srcl_response_profile | CRMT_SRCL_RSPRF | Response Profile | ||||
| duration | CRMT_SRV_DURATION | Duration | ||||
| duration_unit | CRMT_SRV_DURATION_UOM | Unit | ||||
| srv_escal_changed | CHAR1 | Single-Character Flag | ||||
| srv_serwi_changed | CHAR1 | Single-Character Flag | ||||
| warranty_id | MGANR | Master warranty | ||||
| overtime_cat | CATS_OVERTIME_CATEGORY | Overtime Category | ||||
| srv_rendered_date | CRMS4_RENDER_DATE | Serv. Rendered Date | ||||
| item_priority | CRMT_PRIORITY | Priority | ||||
| receiving_sales_org | VKORG | Sales Org. | ||||
| ico_ref_item_no | CRMS4_NUMBER_INT | Item Number in Doc. | ||||
| referencemaintenanceitem | WAPOS | MaintItem | ||||
| maintenanceitemdescription | POSTXT | MaintItem text | ||||
| maintitemserviceordertype | CRMT_PROCESS_TYPE | Transaction Type | ||||
| maintitemserviceordertemplate | CRMT_OBJECT_ID_DB | Transaction ID | ||||
| incoterms1 | CRMT_INCOTERMS1 | Incoterms | ||||
| incoterms2 | CRMT_INCOTERMS2 | Incoterms | ||||
| ship_cond | CRMT_SHIP_COND | Shipping Cond. | ||||
| deli_unlim_tol | CRMT_DELI_UNLIM_TOL | Unlimited Tol. | ||||
| over_dlv_tol | CRMT_OVER_DLV_TOL | Overdeliv. Tol | ||||
| under_dlv_tol | CRMT_UNDER_DLV_TOL | Underdeliv. Tol | ||||
| dlv_prio | CRMT_DLV_PRIO | Deliv. Priority | ||||
| ordercombind | CRMT_ORDERCOMBIND | Order Combin. | ||||
| part_dlv | CRMT_PART_DLV | DeliveryControl | ||||
| dlv_group | CRMT_DLV_GROUP | Delivery Group | ||||
| delivery_block | CRMT_BUS_DEL_BLOCK_REASON | Del. Block Reason | ||||
| part_dlv_itm | CRMT_PART_DLV_ITM | Del. Control Item | ||||
| stat_lifecycle | CRMS4_STAT_LIFECYCLE | Life Cycle Status | ||||
| stat_released | CRMS4_STAT_RELEASED | Release Status | ||||
| stat_quotation | CRMS4_STAT_QUOTATION | Quotation Status | ||||
| stat_error | CRMS4_STAT_ERROR | Error Status | ||||
| stat_delivery | CRMS4_STAT_DELIVERY | Delivery Status | ||||
| stat_goods_issue | CRMS4_STAT_GOODS_ISSUE | Goods Issue Status | ||||
| stat_billing | CRMS4_STAT_BILLING | Billing Status | ||||
| stat_cancelled | CRMS4_STAT_CANCELLED | Cancellation Status | ||||
| stat_open | CRMS4_STAT_OPEN | Open | ||||
| stat_maintenance | CRMS4_STAT_MAINTENANCE | Execution Status | ||||
| stat_transfer | CRMS4_STAT_TRANSFER | Transfer Status | ||||
| stat_chklst_exec | CRMS4_STAT_CHKLST_EXEC | Execution Status | ||||
| stat_activation | CRMS4_STAT_ACTIVATION | Activation Status | ||||
| stat_cont_ts | CRMS4_STAT_CONT_TS | Time Slice Status | ||||
| stat_accepted | CRMS4_STAT_ACCEPTED | Acceptance Status | ||||
| stat_for_billing | CRMS4_STAT_FOR_BILLING | Billing Release Stat | ||||
| stat_credit | CRMS4_STAT_CREDIT_I | Item Credit Status | ||||
| stat_bsln_cost_postg | CRMS4_STAT_BSLN_COST_POSTG | BsLn Cost Calc Stat | ||||
| stat_cont_cost_calc | CRMS4_STAT_CONT_COST_CALC | Ongoing Calc Stat | ||||
| stat_withdrawn | CRMS4_STAT_WITHDRAWN | Withdrawal Status | ||||
| catlvlguid01_01 | CRM_REP_CAT_GUID_LEV01_S1 | Cat. 01-S1 | ||||
| catlvlguid02_01 | CRM_REP_CAT_GUID_LEV02_S1 | Cat. 02-S1 | ||||
| catlvlguid03_01 | CRM_REP_CAT_GUID_LEV03_S1 | Cat. 03-S1 | ||||
| catlvlguid04_01 | CRM_REP_CAT_GUID_LEV04_S1 | Cat. 04-S1 | ||||
| catlvlguid05_01 | CRM_REP_CAT_GUID_LEV05_S1 | Cat. 05-S1 | ||||
| catlvlguid06_01 | CRM_REP_CAT_GUID_LEV06_S1 | Cat. 06-S1 | ||||
| catlvlguid07_01 | CRM_REP_CAT_GUID_LEV07_S1 | Cat. 07-S1 | ||||
| catlvlguid08_01 | CRM_REP_CAT_GUID_LEV08_S1 | Cat. 08-S1 | ||||
| catlvlguid09_01 | CRM_REP_CAT_GUID_LEV09_S1 | Cat. 09-S1 | ||||
| catlvlguid10_01 | CRM_REP_CAT_GUID_LEV10_S1 | Cat. 10-S1 | ||||
| asp_id_01 | CRMS4_ERMS_CAT_AS_ID | Schema ID | ||||
| cat_id_01 | CRMS4_ERMS_CAT_CA_ID | Category ID | ||||
| catlvlguid01_02 | CRM_REP_CAT_GUID_LEV01_S2 | Cat. 01-S2 | ||||
| catlvlguid02_02 | CRM_REP_CAT_GUID_LEV02_S2 | Cat. 02-S2 | ||||
| catlvlguid03_02 | CRM_REP_CAT_GUID_LEV03_S2 | Cat. 03-S2 | ||||
| catlvlguid04_02 | CRM_REP_CAT_GUID_LEV04_S2 | Cat. 04-S2 | ||||
| catlvlguid05_02 | CRM_REP_CAT_GUID_LEV05_S2 | Cat. 05-S2 | ||||
| catlvlguid06_02 | CRM_REP_CAT_GUID_LEV06_S2 | Cat. 06-S2 | ||||
| catlvlguid07_02 | CRM_REP_CAT_GUID_LEV07_S2 | Cat. 07-S2 | ||||
| catlvlguid08_02 | CRM_REP_CAT_GUID_LEV08_S2 | Cat. 08-S2 | ||||
| catlvlguid09_02 | CRM_REP_CAT_GUID_LEV09_S2 | Cat. 09-S2 | ||||
| catlvlguid10_02 | CRM_REP_CAT_GUID_LEV10_S2 | Cat. 10-S2 | ||||
| asp_id_02 | CRMS4_ERMS_CAT_AS_ID | Schema ID | ||||
| cat_id_02 | CRMS4_ERMS_CAT_CA_ID | Category ID | ||||
| priority | CRMT_PRIORITY | Priority | ||||
| process_type | CRMT_PROCESS_TYPE_DB | Transaction Type | ||||
| posting_date | CRMT_POSTING_DATE | Posting Date | ||||
| description_h | CRMT_PROCESS_DESCRIPTION | Description | ||||
| descr_language | CRMT_PROCESS_DESCRIPTION_LANGU | Language | ||||
| template_type | CRMT_TEMPLATE_TYPE_DB | Templ. Type | ||||
| created_at_h | COMT_CREATED_AT_USR | Created At | ||||
| created_by_h | CRMT_CREATED_BY | Created By | ||||
| changed_at_h | COMT_CHANGED_AT_USR | Changed On | ||||
| changed_by_h | CRMT_CHANGED_BY | Changed By | ||||
| btx_class | CRMT_TRANSACTION_CLASSIFICATN | Trans.Classification | ||||
| auth_scope | CRM_AUTH_SCOPE | Authorization Scope | ||||
| archiving_flag | CRMT_ARCHIVING_FLAG | Can Be Archived | ||||
| serv_i_dummy_ps | CHAR1 | Single-Character Flag | ||||
| item_no_appt | CRMS4_NUMBER_INT | Item Number in Doc. | ||||
| item_no_partner | CRMS4_NUMBER_INT | Item Number in Doc. | ||||
| item_no_qualif | CRMS4_NUMBER_INT | Item Number in Doc. | ||||
| item_no_refobj | CRMS4_NUMBER_INT | Item Number in Doc. | ||||
| item_no_subject | CRMS4_NUMBER_INT | Item Number in Doc. | ||||
| item_no_survey | CRMS4_NUMBER_INT | Item Number in Doc. | ||||
| item_no_billplan | CRMS4_NUMBER_INT | Item Number in Doc. | ||||
| item_no_payplan | CRMS4_NUMBER_INT | Item Number in Doc. | ||||
| ref_guid_appt | CRMT_OBJECT_GUID | Object GUID | ||||
| prod_sel_type | IST_SELECTION_TYPE | Prod.Selection Type | ||||
| ci_contract_id | IST_EXT_REF | Contract Number | ||||
| ci_contract_item | CRMT_IST_CONT_ITEM_ID | Contract Item ID | ||||
| ci_billing_cycle | CRMT_IST_BC | Billing Cycle | ||||
| btmf_process | IST_PROCESS | Process of Maint. FW | ||||
| btmf_process_type | IST_ITEM_PROCESS | Process Type | ||||
| sc_group | IST_SC_GROUP | Sol. Conf. Group | ||||
| sc_doc_guid | IST_SC_DOCUMENT_ID | SC: Doc. GUID | ||||
| sc_author_info | IST_SC_AUTHOR | SC: Author Inform. | ||||
| sc_interlinkage_guid | COMT_IL_ILGUID | Relationship GUID | ||||
| sc_opt_indicator | CRMS4_SOM_OPT_INDICATOR | SC opt indicator | ||||
| ccm_version | CRM_IST_CCM_VERSION | Version | ||||
| rating_area | CRM_RAT_AREA | Rating Area ID | ||||
| ci_partner_rule | CRMT_ISX_PARTNER_SETTL_RULE | Settlement Rule | ||||
| ci_billing_plan_cycle | CRMS4_BILLING_PLAN_CYCLE | Billing Plan Cycle | ||||
| contract_change_reason | CRMT_IST_CONT_CHANGE_REASON | Change Reason | ||||
| cc_account_split | CRMS4_SOM_CC_ACCOUNT_SPLIT | Account Split | ||||
| ma_head_objid | CRMT_OBJECT_ID_DB | Transaction ID | ||||
| fix_config | CRMT_ISX_PRVMA_FIX_CONFIG | Configuration | ||||
| ma_item_objid | CRMS4_NUMBER_INT | Item Number in Doc. | ||||
| ma_root_objid | CRMS4_NUMBER_INT | Item Number in Doc. | ||||
| pool_agr_ref | CRM_POOL_AGREEMENT | Sharing Contract | ||||
| ma_share_ref | CRMT_ISX_MA_POOL_REF | MA MainItem Ref | ||||
| ma_share_ref_prod_id | CRMT_ISX_MA_SHARE_REF_PROD_ID | Custom Product ID | ||||
| sharing_group_id | CRMS4_SOM_SHARING_GROUP_ID | Sharing Group ID | ||||
| lock_reason | IST_LOCK_REASON | Lock Reason | ||||
| auto_renew_indicator | CRMS4_AUTO_RENEW_INDICATOR | Enable Auto-Renewal | ||||
| changeprocessgroup | CRMS4_BTMF_PROCESS_GROUP | BTMF Process Group | ||||
| phase_indicator | CRMS4_PHASE_INDICATOR | Phase Indicator | ||||
| successor_of | CRMS4_NUMBER_INT | Item Number in Doc. | ||||
| cont_ref_item | CRMS4_NUMBER_INT | Item Number in Doc. | ||||
| cont_ref | CRMT_OBJECT_ID | ID | ||||
| subscriptioncontractexternalid | IST_EXT_REF | Contract Number | ||||
| withdrawal_reason | CRMS4_SOM_WITHDRAWAL_REASON | Withdrawal Reason | ||||
| refund_code | CRMS4_SOM_REFUND_CODE | Refund Code | ||||
| int_obj_no | CRMT_INT_OBJ_NO | Int. object no. | ||||
| exist_vckey | CRMT_EXIST_VCKEY | IndicVariantKey | ||||
| root_config | CRMT_ROOT_CONFIG | RtCnfIndic | ||||
| bom_category | STLTY | BOM category | ||||
| bill_of_material | STNUM | BOM | ||||
| bom_item_node_number | STLKN | Item node | ||||
| bom_item_counter | CIM_COUNT | Counter | ||||
| bom_usage | STLAN | Usage | ||||
| bom_item_number | SPOSN | Item | ||||
| bom_base_quantity_next_level | CS_E_XBMNG | BasQty (Nxt Lv) | ||||
| bom_itm_fix_qty | FMNGE | Fixed Quantity | ||||
| bom_comp_qty | CRMT_COMP_QTY | Com qty | ||||
| bom_comp_qty_unit | CRMT_COMP_QTY_UNIT | Component U/M | ||||
| billplan_type | CRMT_BILLPLAN_TYPE | BillingPlanType | ||||
| rule_horizon | CRMT_RULE_HORIZON | Horizon | ||||
| billplan_start_date | CRMT_START_DATE | Start date | ||||
| rule_start_date | CRMT_RULE_START_DATE | DeterStartDate | ||||
| billplan_end_date | CRMT_END_DATE | End Date | ||||
| rule_end_date | CRMT_RULE_END_DATE | DeterminEndDate | ||||
| billplan_date_from | CRMT_DATE_FROM | Dates from | ||||
| rule_date_from | CRMT_RULE_DATE_FROM | DetermineDateFr | ||||
| billplan_date_to | CRMT_DATE_TO | Dates to | ||||
| rule_date_to | CRMT_RULE_DATE_TO | DetermineDateTo | ||||
| billplan_timezone | CRMT_BILLING_TIMEZONE | Time zone | ||||
| billplan_d_rule_period_date | CRMT_RULE_PERIOD_DATE | Rule PeriodDate | ||||
| billplan_d_rule_settl_from | CRMT_RULE_SETTL_FROM | Determine SePer | ||||
| billplan_d_rule_settl_to | CRMT_RULE_SETTL_TO | Settlement end | ||||
| billplan_d_rule_bill_date | CRMT_RULE_BILL_DATE | Rule BillDate | ||||
| billplan_d_rule_price_date | CRMS4_RULE_PRICE_DATE | Price Date Rule | ||||
| billplan_d_rule_invcr_date | CRMT_RULE_INVCR_DATE | Rule: BillDoc | ||||
| billplan_d_timezone | CRMT_BILLING_TIMEZONE | Time zone | ||||
| cashflow_type | CRMT_CASHFLOW_TYPE | Flow Category | ||||
| no_billitems | CRMT_NO_BILLITEMS | No Bill Request Itms | ||||
| billplan_line_id | CRMT_BILLPLAN_LINE_ID | BillPlan Line ID | ||||
| billingplanisfinalized | CRMS4_BILLINGPLAN_IS_FINALIZED | Bill.Plan Finalized | ||||
| cancproc | CRMT_CANC_PROCEDURE | Cancellation | ||||
| cancparty | CRMT_CANC_PARTY | Cancelling Party | ||||
| canc_reason | CRMT_SRV_CANCEL_REASON | Cancell.Reason | ||||
| ref_inhouse_repair | CRMS4_REF_INHOUSE_REPAIR | In-House Repair | ||||
| ref_inhouse_repair_item | CRMS4_REF_INHOUSE_REPAIR_ITEM | Ref. Repair Object | ||||
| has_ref_inhouse_repair | CRMS4_HAS_REF_INHOUSE_REPAIR | Reference Exists |
Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.
-- Items of service transactions
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CRMS4D_SERV_I (
CLIENT, -- Client [MANDT]
OBJTYPE_H, -- Trans. Cat. [CRMT_SUBOBJECT_CATEGORY_DB]
OBJECT_ID, -- Transaction ID [CRMT_OBJECT_ID_DB]
NUMBER_INT, -- Item Number in Doc. [CRMS4_NUMBER_INT]
AC_OBJECT_TYPE, -- Acct Assgt Obj.Type [CRMT_AC_OBJECT_TYPE]
AC_ASSIGNMENT, -- Sett.Account Assgmnt [CRMT_AC_ASSIGN]
AC_PERCENTAGE, -- Percent. of Costs [CRMT_AC_COST_PERCENTAGE]
APRV_ACTIVATED, -- Flag [CRMT_BOOLEAN]
APRV_PROCEDURE, -- Approval Procedure [CRMT_APPROVAL_PROCEDURE]
CHANGE_ALLOWED, -- Flag [CRMT_BOOLEAN]
PERIOD_DATE, -- Period date [CRMT_PERIOD_DATE]
RULE_PERIOD_DATE, -- Rule PeriodDate [CRMT_RULE_PERIOD_DATE]
SETTL_FROM, -- SettlementStart [CRMT_SETTL_FROM]
RULE_SETTL_FROM, -- Determine SePer [CRMT_RULE_SETTL_FROM]
SETTL_TO, -- Settlement End [CRMT_SETTL_TO]
RULE_SETTL_TO, -- Settlement end [CRMT_RULE_SETTL_TO]
BILL_DATE, -- Billing Date [CRMS4_BILL_DATE_TSTMP]
RULE_BILL_DATE, -- Rule BillDate [CRMT_RULE_BILL_DATE]
INVCR_DATE, -- Billing Date [CRMS4_INVCR_DATE_TSTMP]
RULE_INVCR_DATE, -- Rule: BillDoc [CRMT_RULE_INVCR_DATE]
VALUE_DATE, -- Fixed Value Dat [CRMT_VALUE_DATE]
RULE_VALUE_DATE, -- Value Date Rule [CRMT_RULE_VALUE_DATE]
BILLING_TIMEZONE, -- Time zone [CRMT_BILLING_TIMEZONE]
BILLING_BLOCK, -- Bill Block Reason [CRMT_BUS_BILL_BLOCK_REASON]
SEPA_ON, -- SEPA Relevant [CRMT_SEPA_ON]
MANDATE_ID, -- Mandate ID [CRMT_MANDATE_ID]
KIND_PERIOD_DATE, -- Date type [TIMENAEVEN]
KIND_SETTL_FROM, -- Date type [TIMENAEVEN]
KIND_SETTL_TO, -- Date type [TIMENAEVEN]
KIND_BILL_DATE, -- Date type [TIMENAEVEN]
KIND_INVCR_DATE, -- Date type [TIMENAEVEN]
KIND_VALUE_DATE, -- Date type [TIMENAEVEN]
KIND_START_DATE, -- Date type [TIMENAEVEN]
KIND_END_DATE, -- Date type [TIMENAEVEN]
KIND_DATE_FROM, -- Date type [TIMENAEVEN]
KIND_DATE_TO, -- Date type [TIMENAEVEN]
CONTRACT_ACCOUNT, -- Contract Acct [VKONT_KK]
DIP_PROFILE, -- DIP Profile [AD01PROFNR]
RESULTS_ANALYSIS_KEY, -- RA Key [ABGR_SCHL_APPL]
BILLING_RELEVANCE, -- Bill. Relevance [CRMS4_BILLING_RELEVANCE]
WBS_ELEMENT, -- WBS Internal ID [PS_S4_PSPNR]
CHKL_STEP_GROUP, -- Step Group GUID [CHKLST_STEP_GRP_GUID]
CHKL_STEP_ID, -- Checklist Step ID [CHKLST_STEP_ID]
CHKL_STEP_NO, -- Checklist Step No. [CHKLST_STEP_NO]
CHKL_OPTION_ID, -- Checklist Option ID [CHKLST_OPTION_ID]
CHKL_PREV_GROUP, -- Prev. Group GUID [CHKLST_PREV_GRP_GUID]
CHKL_PREV_NO, -- Prev. Group No. [CHKLST_PREV_GRP_NO]
CHKL_TRIGGER_ID, -- Trigger ID [CHKLST_TRIGGER_ID]
GI_QUANTITY, -- Goods Issue Quantity [CRMS4_GI_QUANTITY]
GI_VALUE, -- Goods Issue Value [CRMS4_GI_VALUE]
ORDERED_QUANTITY, -- Ordered Quantity [CRMS4_ORD_QUANTITY]
BILLED_VALUE, -- Invoice Value [CRMS4_INV_VALUE]
BILLED_QUANTITY, -- Invoiced Quantity [CRMS4_INV_QUANTITY]
DLV_QUANTITY, -- Delivered Quantity [CRMS4_DLV_QUANTITY]
RELEASED_QUANTITY, -- Released Quantity [CRMS4_RLSD_QUANTITY]
RELEASED_VALUE, -- Released Value [CRMS4_RLSD_VALUE]
VALID_FROM, -- Valid from [CRMT_VALID_FROM]
VALID_TO, -- Valid to [CRMT_VALID_TO]
QUOT_START, -- Quot: Valid from Dat [CRMS4_QUOT_START_DATE]
QUOT_END, -- Quot: Valid to Date [CRMS4_QUOT_END_DATE]
SRV_CUST_BEG, -- Service Req. Start [CRMS4_SRV_CUST_BEG_TSTMP]
SRV_CUST_END, -- Service Request Due [CRMS4_SRV_CUST_END_TSTMP]
SRQ_WORK_DURA, -- Work Duration of ST [CRMS4_SRQ_WORK_DURA]
SRQ_WORK_UNIT, -- Work Drtn Unit ST [CRMS4_SRQ_WORK_UNIT]
SRQ_TOT_DURA, -- Total Duration of ST [CRMS4_SRQ_TOT_DURA]
SRQ_TOT_UNIT, -- Total Drtn Unit ST [CRMS4_SRQ_TOT_UNIT]
CONTSTART, -- Contract Start Date [CRMS4_CONT_START]
CONTEND, -- Contract End Date [CRMS4_CONT_END]
CONT_START_TS, -- Start of Contract TS [CRMS4_CONT_START_TS_DATE]
CONT_END_TS, -- End of Contract TS [CRMS4_CONT_END_TS_DATE]
SRV_RFIRST, -- First Response By [CRMS4_SRV_RFIRST]
SRV_RREADY, -- Due By [CRMS4_SRV_RREADY]
SRV_CLOSE, -- Closing Date [CRMS4_SRV_CLOSE]
AUTO_RENEW_PERIOD, -- Renewal Period [CRMS4_AUTO_RENEW_PERIOD_DURA]
AUTO_RENEW_PERIOD_UNIT, -- AR Period UOM [CRMS4_AUTO_RENEW_PERIOD_UNIT]
AUTO_RENEW_EXTEN, -- Contract Extension [CRMS4_AUTO_RENEW_EXTEN_DURA]
AUTO_RENEW_EXTEN_UNIT, -- Contract Extsn UOM [CRMS4_AUTO_RENEW_EXTEN_UNIT]
AUTO_RENEW_START, -- Auto Renewal Start [CRMS4_AUTO_RENEW_START_DATE]
SRQ_WORK_DURA_2, -- Work Duration of ST [CRMS4_SRQ_WORK_DURA_2]
SRQ_TOT_DURA_2, -- Total Duration of ST [CRMS4_SRQ_TOT_DURA_2]
GRACE_PERIOD, -- Grace Period [CRMS4_GRACE_PERIOD]
GRACE_PERIOD_UNIT, -- Unit of Grace Period [CRMS4_GRACE_PERIOD_UNIT]
GRACE_PERIOD_END, -- Grce End Date [CRMS4_GRACE_PERIOD_TO]
BIZ_VALID_START, -- Start of Bus Valdty [CRMS4_SOM_BIZ_VALID_FROM]
BIZ_VALID_END, -- End of Bus Valdty [CRMS4_SOM_BIZ_VALID_TO]
SRVC_ACTUAL, -- Service Actual Start [CRMS4_SRVC_ACTUAL_TSTMP]
SRVC_ACT_TO, -- Service Actual End [CRMS4_SRVC_ACT_TO_TSTMP]
SPLA_PLANFR, -- Service Planned From [CRMS4_SPLA_PLANFR_TSTMP]
SPLA_PLANTO, -- Service Planned To [CRMS4_SPLA_PLANTO_TSTMP]
ITEM_GUID, -- Object GUID [CRMT_OBJECT_GUID]
CREATED_AT_I, -- Created On [CRMS4_CREATED_AT]
CREATED_BY_I, -- Created By [CRMT_CREATED_BY]
CHANGED_AT_I, -- Changed On [CRMS4_CHANGED_AT]
CHANGED_BY_I, -- Changed By [CRMT_CHANGED_BY]
OBJTYPE_I, -- Object Type [CRMT_SWO_OBJTYP_PROCESS_ITM_DB]
HEADER_GUID, -- Object GUID [CRMT_OBJECT_GUID]
PARENT, -- Object GUID [CRMT_OBJECT_GUID]
ALTERNATIVE, -- Object GUID [CRMT_OBJECT_GUID]
PRODUCT, -- Product GUID [CRMT_PRODUCT_GUID_DB]
ORDERED_PROD, -- Product [CRMT_ORDERED_PROD_DB]
PARTNER_PROD, -- Partner Product [CRMT_ITEM_DESCR_PARTNER]
DESCRIPTION_I, -- Short Text [CRMT_PRSHTEXTX_DB]
ITM_LANGUAGE, -- Language [CRMT_ITEM_LANGU]
NUMBER_EXT, -- Ext. Item No. [CRMT_ITEM_NO_EXT]
ITM_TYPE, -- Item Category [CRMT_ITEM_TYPE_DB]
ORDER_DATE, -- Posting Date [CRMT_ORDER_DATE]
ITM_USAGE, -- Usage HL Item [CRMT_ITEM_USAGE]
ITM_TYPE_USAGE, -- Item Cat. Usage [CRMT_IT_TYPE_USAGE]
PRODUCT_KIND, -- Prod. Tech. Typ [CRMT_PRODUCT_KIND]
REVACC_REFID, -- RA Reference ID [CRMT_REVACC_REFID]
REVACC_REFTYPE, -- RA Reference Type [CRMT_REVACC_REFTYPE]
REVACC_RELEVANT_TYPE, -- Type [CRMT_REVACC_RELEVANT_TYPE]
PRODUCT_ID, -- Product [PRODUCTNUMBER]
ITEM_GUID_CHAR, -- Object GUID [CRMT_OBJECT_GUID32]
PROFIT_CENTER, -- Profit Center [PRCTR]
PROFIT_CENTER_ORIGIN, -- Profit Center Source Indicator [CRMS4_SRVC_PROFIT_CNTR_ORIGIN]
KOKRS, -- CO Area [KOKRS]
PROFIT_DETERMINE_DATE, -- Date [DATUM]
REFBUSSOLNORD, -- Ref. Soltn Order ID [CRMS4_REF_SOLO_OBJECT_ID]
REFBUSSOLNORDITM, -- Ref. Item Number [CRMS4_REF_SOLO_NUMBER_INT]
SUBSCRPNBILLGCYCLE, -- Billing Cycle [CRMS4_SUBSCRPN_BILLG_CYCLE]
MIDBILLCYCEXPRTNALLWD, -- Mid Cyc Exprtn Allwd [CRMS4_MIDBILL_CYC_EXPRTN_ALLWD]
DEFAULT_TERMS_OVRWRT, -- Ovrwrt Default Terms [CRMS4_OVRWRT_DEFAULT_TERMS_DB]
PROJ_ORG_ID, -- Service Org. [CRMS4_PROJ_ORG_ID]
COST_CENTER, -- Cost Center [KOSTL]
IS_UNPLANNED_ITEM, -- Unplanned Item [CRMS4_IS_UNPLANNED_ITEM]
REF_SRVC_ORD_ITEM_UUID, -- Ref Srv Item GUID [CRMS4_REF_SRVC_ORD_ITEM_UUID]
MAIN_ITEM_BUNDLE_TYPE, -- Structure Provider of Main Item [CRMS4_MAIN_ITEM_STRUC_PRVDR]
DIS_CHANNEL, -- Distribution Channel [CRMT_DISTRIBUTION_CHANNEL]
DIVISION, -- Division [CRMT_DIVISION]
SERVICE_ORG_ORI, -- Origin srvc. org. [CRMT_SERVICE_ORG_ORIGIN]
SERVICE_ORGR_ORI, -- Origin Sales Org. [CRMT_SERVICE_ORG_RESP_ORIGIN]
SALES_ORG_ORI, -- Origin sales org. [CRMT_SALES_ORG_ORIGIN]
DIS_CHANNEL_ORI, -- Origin: Distr. chnl [CRMT_DIS_CHANNEL_ORIGIN]
SALES_OFF_ORI, -- Origin: Sales office [CRMT_SALES_OFFICE_ORIGIN]
SALES_GROUP_ORI, -- Origin: Sales group [CRMT_SALES_GROUP_ORIGIN]
SALES_ORGR_ORI, -- Origin SOrg [CRMT_SALES_ORG_RESP_ORIGIN]
DIVISION_ORI, -- Origin: Division [CRMT_DIVISION_ORIGIN]
SALES_ORG, -- Sales Org. ID [CRMT_SALES_ORG]
SALES_OFFICE, -- Sales Office [CRMT_SALES_OFFICE]
SALES_GROUP, -- Sales Group [CRMT_SALES_GROUP]
SALES_ORG_RESP, -- Org. Unit (Sales) [CRMT_SALES_ORG_RESP]
SERVICE_ORG, -- Service Organization [CRMT_SERVICE_ORG]
SERVICE_ORG_RESP, -- OU (Service) [CRMT_SERVICE_ORG_RESP]
SALES_ORG_SD, -- Sales Org. [VKORG]
SALES_OFFICE_SD, -- Sales Office [VKBUR]
SALES_GROUP_SD, -- Sales Group [VKGRP]
ENTERPRISE_SERVICE_ORG, -- Ent. Service Org. [CRMS4_ENTERPRISE_SERVICE_ORG]
SERVICE_TEAM_RM, -- Service Team [CRMS4_SERVICE_TEAM_RM]
SERVICE_TEAM_RM_ORI, -- Origin Service Team [CRMS4_SERVICE_TEAM_RM_ORIGIN]
PLANNING_PLANT, -- Planning Plant [IWERK]
WORK_CENTER_OBJECT_ID, -- Work Center [LGWID]
SOLD_TO_PARTY, -- Customer [CRMT_SOLD_TO_PART]
SOLD_TO_REGION, -- Region [CRMT_REGION]
SOLD_TO_COUNTRY, -- Country/Region [CRMT_COUNTRY]
SHIP_TO_PARTY, -- Ship-To Party [CRMT_SHIP_TO_PART]
BILL_TO_PARTY, -- Bill-To Party [CRMT_BILL_TO_PART]
PAYER, -- Payer [CRMT_RP_PAYER]
PERSON_RESP, -- Employee Resp. [CRMT_PERSON_RESP]
CONTACT_PERSON, -- Contact Pers. [CRMT_CONTACT_PERSON]
RESP_GROUP, -- Responsible Group [CRMT_RESPONSIBLE_GROUP]
SERVICE_TEAM, -- Service Team [CRMT_SERVICE_TEAM]
SERVICE_EMPLOYEE, -- Exec.Service Emp. [CRMT_SERVICE_EMPLOYEE]
EXCHG_TYPE, -- Exch. Rate Type [CRMT_EXCHG_TYPE]
EXCHG_DATE, -- Exch. Rate Date [CRMT_EXCHG_DATE]
TAXJURCODE, -- Jurisdict.Code [CRMT_TAXJURCODE]
CUST_PRIC_PROC, -- Cust.Pric.Proc. [CRMT_CUST_PRIC_PROC]
REF_CURRENCY, -- Ref. Currency [CRMT_REF_CURRENCY]
CURRENCY, -- Currency [CRMT_CURRENCY]
PRICE_DATE, -- Pricing Date [CRMT_PRICE_DATE]
PMNTTRMS, -- Terms of Paymnt [CRMT_PMNTTRMS]
PRICE_GRP, -- Price Group [CRMT_PRICE_GRP]
CUST_GROUP, -- Customer Group [CRMT_CUST_GROUP]
EXCHG_RATE, -- Exchange Rate [CRMT_EXCHG_RATE]
TAX_DEST_CTY, -- Dest.Ctry/Reg. [CRMT_TAX_DEST_CTY]
TAX_DEST_REG, -- Region [CRMT_REGION]
VAT_REG_NO, -- Sales tax no. [CRMT_VAT_REG_NO]
AC_INDICATOR, -- Account. Indic. [CRMT_AC_INDICATOR]
CUSTOMER_TYPE, -- Part. Type [CRMT_CUSTOMER_TYPE]
PAYMENT_METHOD, -- Payment Method [CRMT_BUAG_PAYMETH]
PRICE_LIST, -- Price List [CRMT_PRICE_LIST]
PRICING_CONTROL, -- Pricing Control [CRMS4_PRICING_CONTROL]
TAXK1, -- Alt.Tax Class. [TAXK1_AK]
NET_VALUE_MAN_I, -- Exp.Total Value [CRMT_NET_VALUE_MAN]
COST_AMOUNT_MAN, -- Exp. Total Cost [CRMT_COST_AMOUNT_MAN]
STATISTICAL, -- Statist.value [CRMT_STATISTICAL]
PRC_INDICATOR, -- Pric. indicat. [CRMT_PRICING_INDICATOR]
NET_VALUE_I, -- Net Value [CRMT_NET_VALUE]
NET_PRICE_I, -- Net price [CRMT_NET_PRICE]
TAX_AMOUNT_I, -- Tax amount [CRMT_TAX_AMOUNT]
FREIGHT_I, -- Shipment costs [CRMT_FREIGHT]
GROSS_VALUE_I, -- Gross Value [CRMT_GROSS_VALUE]
NET_WO_FREIGHT_I, -- Net value [PRCT_NET_VALUE_WITHOUT_FREIGHT]
SUBTOTAL1, -- Subtotal 1 [CRMT_SUBTOTAL1]
SUBTOTAL2, -- Subtotal 2 [CRMT_SUBTOTAL2]
SUBTOTAL3, -- Subtotal 3 [CRMT_SUBTOTAL3]
SUBTOTAL4, -- Subtotal 4 [CRMT_SUBTOTAL4]
SUBTOTAL5, -- Subtotal 5 [CRMT_SUBTOTAL5]
SUBTOTAL6, -- Subtotal 6 [CRMT_SUBTOTAL6]
CREDIT_INDICATOR, -- Credit [CRMT_CREDIT_INDICATOR]
NETPR_PRIC_UNIT, -- Price Unit [PRCT_COND_PRICING_UNIT]
NETPR_UOM, -- Condition Unit [PRCT_COND_UOM]
TOTAL_DISCOUNT_I, -- Condition Value [PRCT_COND_VALUE]
RECURRING_CHARGE, -- Recur Charge [CRMT_RECURRING_CHARGE]
RECURRING_TAX, -- Recu tax [CRMT_RECURRING_TAX]
RECURRING_GROSS, -- Rec.Charg.incl.tax [CRMT_RECURRING_GROSS]
REC_DURATION, -- Recur. Dura. [CRMT_REC_DURATION]
REC_TIME_UNIT, -- Recu.Time U. [CRMT_REC_TIME_UNIT]
REC_MAIN_ITM_CUM, -- M.Item.Rec. [CRMT_REC_MAIN_ITEM_CUM]
TARGET_VALUE, -- Target Value [CRMS4_TARGET_VALUE]
PRICE_SOURCE, -- Price source [PRICE_SOURCE]
TAX_DEPART_CTY, -- Dept. Country [CRMT_TAX_DEPART_CTY]
TAX_DEPART_REG, -- Depart. Region [CRMT_TAX_DEPART_REG]
DETERM_COST_CONTROL, -- Determine Cost [CRMS4_DETERM_COST_CONTROL]
GROSS_WEIGHT_I, -- Gross Weight [CRMT_GROSS_WEIGHT]
NET_WEIGHT_I, -- Net Weight [CRMT_NET_WEIGHT]
WEIGHT_UNIT_I, -- Unit of Weight [COMT_WEIGHT_UNIT]
VOLUME_I, -- Volume [CRMT_VOLUME]
VOLUME_UNIT_I, -- Volume Unit [COMT_VOLUME_UNIT]
PRICE_PRODUCT, -- PricingRefProd. [CRMT_PRICE_PRODUCT]
PROCESS_QTY_NUM, -- Numerator [CRMT_PROCESS_QTY_NUM]
PROCESS_QTY_DEN, -- Denominator [CRMT_PROCESS_QTY_DEN]
EXPONENT10, -- Exponent [CRMT_EXPONENT10]
PROCESS_QTY_UNIT, -- Sales Unit [CRMT_PROCESS_QTY_UNIT]
COMM_GROUP, -- Commission Grp [CRMT_COMM_GROUP]
REBATE_GROUP, -- Vol. Rebate Grp [CRMT_REBATE_GROUP]
CASH_DISC, -- Qual.for Cash Discnt [CRMT_CASH_DISC]
PROD_PR_GROUP, -- Mat. Price Grp [KONDM]
PRC_GROUP1, -- MaterialGroup 1 [MVGR1]
PRC_GROUP2, -- MaterialGroup 2 [MVGR2]
PRC_GROUP3, -- MaterialGroup 3 [MVGR3]
PRC_GROUP4, -- MaterialGroup 4 [MVGR4]
PRC_GROUP5, -- MaterialGroup 5 [MVGR5]
PROD_HIERARCHY, -- Product Cat. [CRMT_PROD_HIERARCHY]
BASE_QTY_UNIT, -- BUoM [COMT_PRODUCT_BASE_UOM]
PLANT, -- Plant [WERKS_D]
BATCH, -- Batch [CHARG_D]
REGION, -- Region [CRMT_REGION]
INDUSTRY, -- Industry Sector [CRMT_INDUSTRY]
CUST_GROUP1, -- Customer Grp 1 [CRMT_CUST_GROUP1]
CUST_GROUP2, -- Customer Grp 2 [CRMT_CUST_GROUP2]
CUST_GROUP3, -- Customer Grp 3 [CRMT_CUST_GROUP3]
CUST_GROUP4, -- Customer Grp 4 [CRMT_CUST_GROUP4]
CUST_GROUP5, -- Customer Grp 5 [CRMT_CUST_GROUP5]
PO_NUMBER_SOLD, -- Ext. Reference [CRMT_PO_NUMBER_SOLD]
PO_DATE_SOLD, -- Reference Date [CRMT_PO_DATE_SOLD]
YOUR_REF_SOLD, -- Your Reference [CRMT_YOUR_REFERENCE_SOLD]
PO_NUMBER_SHIP, -- Ext. Reference [CRMT_PO_NUMBER_SHIP]
PO_DATE_SHIP, -- Reference Doc SH [CRMT_PO_DATE_SHIP]
YOUR_REF_SHIP, -- Your Reference [CRMT_YOUR_REFERENCE_SHIP]
USAGE_TYPE, -- Usage [CRMT_USAGE]
SUBMISSION, -- Collective No. [CRMT_SUBMISSION]
REJECTION, -- Cancel Rsn Code [CRMT_REJECTION_CODE]
PROBABILITY, -- Probability % [CRMT_ORDER_PROBABILITY]
DATE_QTY_FIXED, -- Fixed Date/Qty [CRMT_DATE_QTY_FIXED]
ORIG_ORDER_QTY, -- Org. Order Quantity [CRMT_QTY_ORIG_ORDER]
ORDER_QTY, -- Order Quantity [CRMT_QTY_ORDER]
CONFIRMED_QTY, -- Confirmed Qty [CRMT_QTY_CONFIRMED]
LATEST_CONF_DATE, -- Latest Cnfrmtn Date [CRMS4_LATEST_CONF_DATE]
DLV_GROUP_DATE, -- Deliv. Grp Date [CRMT_DLV_GROUP_DATE]
LATEST_REQ_DATE, -- Latest Rqstd Date [CRMS4_LATEST_REQ_DATE]
FIRST_REQ_DATE, -- First Rqstd Dlv Date [CRMS4_FIRST_REQ_DATE]
FIRST_CONF_DATE, -- First Cnfmd Dvl Date [CRMS4_FIRST_CONF_DATE]
DISPO_FLG, -- Resrce Planning [CRMT_SRV_DISPO_FLG]
CONFIRM_RELEVANT, -- Confirmation [CRMT_CONFIRM_RELEVANT]
SRV_CONF_TIME, -- Actual Duration [CRMT_SRV_CONF_DURATION]
SRV_CONF_TUNIT, -- Time Unit [CRMT_SRV_CONF_TIME_UNIT]
SERVICE_TYPE, -- Service Type [CRMT_SERVICE_TYPE]
VALUATION_TYPE, -- Valuation Type [CRMT_VALUATION_TYPE]
SRV_ESCAL, -- Response Prof. [CRMT_SRV_ESCAL]
SRV_SERWI, -- Service Profile [CRMT_SRV_SERWI]
SRV_RULE_ID, -- Rule ID [SC_RULEID]
SRCL_SERVICE_PROFILE, -- Service Profile [CRMT_SRCL_SRVPRF]
SRCL_RESPONSE_PROFILE, -- Response Profile [CRMT_SRCL_RSPRF]
DURATION, -- Duration [CRMT_SRV_DURATION]
DURATION_UNIT, -- Unit [CRMT_SRV_DURATION_UOM]
SRV_ESCAL_CHANGED, -- Single-Character Flag [CHAR1]
SRV_SERWI_CHANGED, -- Single-Character Flag [CHAR1]
WARRANTY_ID, -- Master warranty [MGANR]
OVERTIME_CAT, -- Overtime Category [CATS_OVERTIME_CATEGORY]
SRV_RENDERED_DATE, -- Serv. Rendered Date [CRMS4_RENDER_DATE]
ITEM_PRIORITY, -- Priority [CRMT_PRIORITY]
RECEIVING_SALES_ORG, -- Sales Org. [VKORG]
ICO_REF_ITEM_NO, -- Item Number in Doc. [CRMS4_NUMBER_INT]
REFERENCEMAINTENANCEITEM, -- MaintItem [WAPOS]
MAINTENANCEITEMDESCRIPTION, -- MaintItem text [POSTXT]
MAINTITEMSERVICEORDERTYPE, -- Transaction Type [CRMT_PROCESS_TYPE]
MAINTITEMSERVICEORDERTEMPLATE, -- Transaction ID [CRMT_OBJECT_ID_DB]
INCOTERMS1, -- Incoterms [CRMT_INCOTERMS1]
INCOTERMS2, -- Incoterms [CRMT_INCOTERMS2]
SHIP_COND, -- Shipping Cond. [CRMT_SHIP_COND]
DELI_UNLIM_TOL, -- Unlimited Tol. [CRMT_DELI_UNLIM_TOL]
OVER_DLV_TOL, -- Overdeliv. Tol [CRMT_OVER_DLV_TOL]
UNDER_DLV_TOL, -- Underdeliv. Tol [CRMT_UNDER_DLV_TOL]
DLV_PRIO, -- Deliv. Priority [CRMT_DLV_PRIO]
ORDERCOMBIND, -- Order Combin. [CRMT_ORDERCOMBIND]
PART_DLV, -- DeliveryControl [CRMT_PART_DLV]
DLV_GROUP, -- Delivery Group [CRMT_DLV_GROUP]
DELIVERY_BLOCK, -- Del. Block Reason [CRMT_BUS_DEL_BLOCK_REASON]
PART_DLV_ITM, -- Del. Control Item [CRMT_PART_DLV_ITM]
STAT_LIFECYCLE, -- Life Cycle Status [CRMS4_STAT_LIFECYCLE]
STAT_RELEASED, -- Release Status [CRMS4_STAT_RELEASED]
STAT_QUOTATION, -- Quotation Status [CRMS4_STAT_QUOTATION]
STAT_ERROR, -- Error Status [CRMS4_STAT_ERROR]
STAT_DELIVERY, -- Delivery Status [CRMS4_STAT_DELIVERY]
STAT_GOODS_ISSUE, -- Goods Issue Status [CRMS4_STAT_GOODS_ISSUE]
STAT_BILLING, -- Billing Status [CRMS4_STAT_BILLING]
STAT_CANCELLED, -- Cancellation Status [CRMS4_STAT_CANCELLED]
STAT_OPEN, -- Open [CRMS4_STAT_OPEN]
STAT_MAINTENANCE, -- Execution Status [CRMS4_STAT_MAINTENANCE]
STAT_TRANSFER, -- Transfer Status [CRMS4_STAT_TRANSFER]
STAT_CHKLST_EXEC, -- Execution Status [CRMS4_STAT_CHKLST_EXEC]
STAT_ACTIVATION, -- Activation Status [CRMS4_STAT_ACTIVATION]
STAT_CONT_TS, -- Time Slice Status [CRMS4_STAT_CONT_TS]
STAT_ACCEPTED, -- Acceptance Status [CRMS4_STAT_ACCEPTED]
STAT_FOR_BILLING, -- Billing Release Stat [CRMS4_STAT_FOR_BILLING]
STAT_CREDIT, -- Item Credit Status [CRMS4_STAT_CREDIT_I]
STAT_BSLN_COST_POSTG, -- BsLn Cost Calc Stat [CRMS4_STAT_BSLN_COST_POSTG]
STAT_CONT_COST_CALC, -- Ongoing Calc Stat [CRMS4_STAT_CONT_COST_CALC]
STAT_WITHDRAWN, -- Withdrawal Status [CRMS4_STAT_WITHDRAWN]
CATLVLGUID01_01, -- Cat. 01-S1 [CRM_REP_CAT_GUID_LEV01_S1]
CATLVLGUID02_01, -- Cat. 02-S1 [CRM_REP_CAT_GUID_LEV02_S1]
CATLVLGUID03_01, -- Cat. 03-S1 [CRM_REP_CAT_GUID_LEV03_S1]
CATLVLGUID04_01, -- Cat. 04-S1 [CRM_REP_CAT_GUID_LEV04_S1]
CATLVLGUID05_01, -- Cat. 05-S1 [CRM_REP_CAT_GUID_LEV05_S1]
CATLVLGUID06_01, -- Cat. 06-S1 [CRM_REP_CAT_GUID_LEV06_S1]
CATLVLGUID07_01, -- Cat. 07-S1 [CRM_REP_CAT_GUID_LEV07_S1]
CATLVLGUID08_01, -- Cat. 08-S1 [CRM_REP_CAT_GUID_LEV08_S1]
CATLVLGUID09_01, -- Cat. 09-S1 [CRM_REP_CAT_GUID_LEV09_S1]
CATLVLGUID10_01, -- Cat. 10-S1 [CRM_REP_CAT_GUID_LEV10_S1]
ASP_ID_01, -- Schema ID [CRMS4_ERMS_CAT_AS_ID]
CAT_ID_01, -- Category ID [CRMS4_ERMS_CAT_CA_ID]
CATLVLGUID01_02, -- Cat. 01-S2 [CRM_REP_CAT_GUID_LEV01_S2]
CATLVLGUID02_02, -- Cat. 02-S2 [CRM_REP_CAT_GUID_LEV02_S2]
CATLVLGUID03_02, -- Cat. 03-S2 [CRM_REP_CAT_GUID_LEV03_S2]
CATLVLGUID04_02, -- Cat. 04-S2 [CRM_REP_CAT_GUID_LEV04_S2]
CATLVLGUID05_02, -- Cat. 05-S2 [CRM_REP_CAT_GUID_LEV05_S2]
CATLVLGUID06_02, -- Cat. 06-S2 [CRM_REP_CAT_GUID_LEV06_S2]
CATLVLGUID07_02, -- Cat. 07-S2 [CRM_REP_CAT_GUID_LEV07_S2]
CATLVLGUID08_02, -- Cat. 08-S2 [CRM_REP_CAT_GUID_LEV08_S2]
CATLVLGUID09_02, -- Cat. 09-S2 [CRM_REP_CAT_GUID_LEV09_S2]
CATLVLGUID10_02, -- Cat. 10-S2 [CRM_REP_CAT_GUID_LEV10_S2]
ASP_ID_02, -- Schema ID [CRMS4_ERMS_CAT_AS_ID]
CAT_ID_02, -- Category ID [CRMS4_ERMS_CAT_CA_ID]
PRIORITY, -- Priority [CRMT_PRIORITY]
PROCESS_TYPE, -- Transaction Type [CRMT_PROCESS_TYPE_DB]
POSTING_DATE, -- Posting Date [CRMT_POSTING_DATE]
DESCRIPTION_H, -- Description [CRMT_PROCESS_DESCRIPTION]
DESCR_LANGUAGE, -- Language [CRMT_PROCESS_DESCRIPTION_LANGU]
TEMPLATE_TYPE, -- Templ. Type [CRMT_TEMPLATE_TYPE_DB]
CREATED_AT_H, -- Created At [COMT_CREATED_AT_USR]
CREATED_BY_H, -- Created By [CRMT_CREATED_BY]
CHANGED_AT_H, -- Changed On [COMT_CHANGED_AT_USR]
CHANGED_BY_H, -- Changed By [CRMT_CHANGED_BY]
BTX_CLASS, -- Trans.Classification [CRMT_TRANSACTION_CLASSIFICATN]
AUTH_SCOPE, -- Authorization Scope [CRM_AUTH_SCOPE]
ARCHIVING_FLAG, -- Can Be Archived [CRMT_ARCHIVING_FLAG]
SERV_I_DUMMY_PS, -- Single-Character Flag [CHAR1]
ITEM_NO_APPT, -- Item Number in Doc. [CRMS4_NUMBER_INT]
ITEM_NO_PARTNER, -- Item Number in Doc. [CRMS4_NUMBER_INT]
ITEM_NO_QUALIF, -- Item Number in Doc. [CRMS4_NUMBER_INT]
ITEM_NO_REFOBJ, -- Item Number in Doc. [CRMS4_NUMBER_INT]
ITEM_NO_SUBJECT, -- Item Number in Doc. [CRMS4_NUMBER_INT]
ITEM_NO_SURVEY, -- Item Number in Doc. [CRMS4_NUMBER_INT]
ITEM_NO_BILLPLAN, -- Item Number in Doc. [CRMS4_NUMBER_INT]
ITEM_NO_PAYPLAN, -- Item Number in Doc. [CRMS4_NUMBER_INT]
REF_GUID_APPT, -- Object GUID [CRMT_OBJECT_GUID]
PROD_SEL_TYPE, -- Prod.Selection Type [IST_SELECTION_TYPE]
CI_CONTRACT_ID, -- Contract Number [IST_EXT_REF]
CI_CONTRACT_ITEM, -- Contract Item ID [CRMT_IST_CONT_ITEM_ID]
CI_BILLING_CYCLE, -- Billing Cycle [CRMT_IST_BC]
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_AUTHOR_INFO, -- SC: Author Inform. [IST_SC_AUTHOR]
SC_INTERLINKAGE_GUID, -- Relationship GUID [COMT_IL_ILGUID]
SC_OPT_INDICATOR, -- SC opt indicator [CRMS4_SOM_OPT_INDICATOR]
CCM_VERSION, -- Version [CRM_IST_CCM_VERSION]
RATING_AREA, -- Rating Area ID [CRM_RAT_AREA]
CI_PARTNER_RULE, -- Settlement Rule [CRMT_ISX_PARTNER_SETTL_RULE]
CI_BILLING_PLAN_CYCLE, -- Billing Plan Cycle [CRMS4_BILLING_PLAN_CYCLE]
CONTRACT_CHANGE_REASON, -- Change Reason [CRMT_IST_CONT_CHANGE_REASON]
CC_ACCOUNT_SPLIT, -- Account Split [CRMS4_SOM_CC_ACCOUNT_SPLIT]
MA_HEAD_OBJID, -- Transaction ID [CRMT_OBJECT_ID_DB]
FIX_CONFIG, -- Configuration [CRMT_ISX_PRVMA_FIX_CONFIG]
MA_ITEM_OBJID, -- Item Number in Doc. [CRMS4_NUMBER_INT]
MA_ROOT_OBJID, -- Item Number in Doc. [CRMS4_NUMBER_INT]
POOL_AGR_REF, -- Sharing Contract [CRM_POOL_AGREEMENT]
MA_SHARE_REF, -- MA MainItem Ref [CRMT_ISX_MA_POOL_REF]
MA_SHARE_REF_PROD_ID, -- Custom Product ID [CRMT_ISX_MA_SHARE_REF_PROD_ID]
SHARING_GROUP_ID, -- Sharing Group ID [CRMS4_SOM_SHARING_GROUP_ID]
LOCK_REASON, -- Lock Reason [IST_LOCK_REASON]
AUTO_RENEW_INDICATOR, -- Enable Auto-Renewal [CRMS4_AUTO_RENEW_INDICATOR]
CHANGEPROCESSGROUP, -- BTMF Process Group [CRMS4_BTMF_PROCESS_GROUP]
PHASE_INDICATOR, -- Phase Indicator [CRMS4_PHASE_INDICATOR]
SUCCESSOR_OF, -- Item Number in Doc. [CRMS4_NUMBER_INT]
CONT_REF_ITEM, -- Item Number in Doc. [CRMS4_NUMBER_INT]
CONT_REF, -- ID [CRMT_OBJECT_ID]
SUBSCRIPTIONCONTRACTEXTERNALID, -- Contract Number [IST_EXT_REF]
WITHDRAWAL_REASON, -- Withdrawal Reason [CRMS4_SOM_WITHDRAWAL_REASON]
REFUND_CODE, -- Refund Code [CRMS4_SOM_REFUND_CODE]
INT_OBJ_NO, -- Int. object no. [CRMT_INT_OBJ_NO]
EXIST_VCKEY, -- IndicVariantKey [CRMT_EXIST_VCKEY]
ROOT_CONFIG, -- RtCnfIndic [CRMT_ROOT_CONFIG]
BOM_CATEGORY, -- BOM category [STLTY]
BILL_OF_MATERIAL, -- BOM [STNUM]
BOM_ITEM_NODE_NUMBER, -- Item node [STLKN]
BOM_ITEM_COUNTER, -- Counter [CIM_COUNT]
BOM_USAGE, -- Usage [STLAN]
BOM_ITEM_NUMBER, -- Item [SPOSN]
BOM_BASE_QUANTITY_NEXT_LEVEL, -- BasQty (Nxt Lv) [CS_E_XBMNG]
BOM_ITM_FIX_QTY, -- Fixed Quantity [FMNGE]
BOM_COMP_QTY, -- Com qty [CRMT_COMP_QTY]
BOM_COMP_QTY_UNIT, -- Component U/M [CRMT_COMP_QTY_UNIT]
BILLPLAN_TYPE, -- BillingPlanType [CRMT_BILLPLAN_TYPE]
RULE_HORIZON, -- Horizon [CRMT_RULE_HORIZON]
BILLPLAN_START_DATE, -- Start date [CRMT_START_DATE]
RULE_START_DATE, -- DeterStartDate [CRMT_RULE_START_DATE]
BILLPLAN_END_DATE, -- End Date [CRMT_END_DATE]
RULE_END_DATE, -- DeterminEndDate [CRMT_RULE_END_DATE]
BILLPLAN_DATE_FROM, -- Dates from [CRMT_DATE_FROM]
RULE_DATE_FROM, -- DetermineDateFr [CRMT_RULE_DATE_FROM]
BILLPLAN_DATE_TO, -- Dates to [CRMT_DATE_TO]
RULE_DATE_TO, -- DetermineDateTo [CRMT_RULE_DATE_TO]
BILLPLAN_TIMEZONE, -- Time zone [CRMT_BILLING_TIMEZONE]
BILLPLAN_D_RULE_PERIOD_DATE, -- Rule PeriodDate [CRMT_RULE_PERIOD_DATE]
BILLPLAN_D_RULE_SETTL_FROM, -- Determine SePer [CRMT_RULE_SETTL_FROM]
BILLPLAN_D_RULE_SETTL_TO, -- Settlement end [CRMT_RULE_SETTL_TO]
BILLPLAN_D_RULE_BILL_DATE, -- Rule BillDate [CRMT_RULE_BILL_DATE]
BILLPLAN_D_RULE_PRICE_DATE, -- Price Date Rule [CRMS4_RULE_PRICE_DATE]
BILLPLAN_D_RULE_INVCR_DATE, -- Rule: BillDoc [CRMT_RULE_INVCR_DATE]
BILLPLAN_D_TIMEZONE, -- Time zone [CRMT_BILLING_TIMEZONE]
CASHFLOW_TYPE, -- Flow Category [CRMT_CASHFLOW_TYPE]
NO_BILLITEMS, -- No Bill Request Itms [CRMT_NO_BILLITEMS]
BILLPLAN_LINE_ID, -- BillPlan Line ID [CRMT_BILLPLAN_LINE_ID]
BILLINGPLANISFINALIZED, -- Bill.Plan Finalized [CRMS4_BILLINGPLAN_IS_FINALIZED]
CANCPROC, -- Cancellation [CRMT_CANC_PROCEDURE]
CANCPARTY, -- Cancelling Party [CRMT_CANC_PARTY]
CANC_REASON, -- Cancell.Reason [CRMT_SRV_CANCEL_REASON]
REF_INHOUSE_REPAIR, -- In-House Repair [CRMS4_REF_INHOUSE_REPAIR]
REF_INHOUSE_REPAIR_ITEM, -- Ref. Repair Object [CRMS4_REF_INHOUSE_REPAIR_ITEM]
HAS_REF_INHOUSE_REPAIR, -- Reference Exists [CRMS4_HAS_REF_INHOUSE_REPAIR]
PRIMARY KEY (CLIENT, OBJTYPE_H, OBJECT_ID, NUMBER_INT)
);Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA