CRMS4D_SERV_H
Header of service transactions
CRMS4D_SERV_H is an SAP database table in S/4HANA. Header of service transactions. It contains 291 fields. 8 CDS views read from this table.
CDS Views using this table (8)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| CRMS4_IU_I_USO | view_entity | inner | Utilities Service Order | |
| CRMS4_IU_I_USR | view_entity | inner | Utilities Service Request | |
| CRMS4_SERV_H_SEARCH | view | from | Service Header | |
| E_ServiceDocument | view | from | EXTENSION | Service Document Extension |
| FINOC_RULE_SRV_BASE | view_entity | inner | Orgl Change-Rule: Service Doc Item Base | |
| I_BusSolutionQuotationText | view | inner | BASIC | Solution Quotation Text |
| I_ServiceDocument | view | from | BASIC | Service Transaction |
| I_SubscriptionContractText | view_entity | inner | BASIC | Subscription Contract Text |
Fields (291)
| 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 | |||
| category | CRMT_ACTIVITY_CATEGORY | Category | ||||
| priority | CRMT_PRIORITY | Priority | ||||
| 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 | ||||
| gross_weight_h | CRMT_GROSS_WEIGHT_CUM | Gross Weight | ||||
| net_weight_h | CRMT_NET_WEIGHT_CUM | Net Weight | ||||
| weight_unit_h | COMT_WEIGHT_UNIT | Unit of Weight | ||||
| volume_h | CRMT_VOLUME_CUM | Volume | ||||
| volume_unit_h | COMT_VOLUME_UNIT | Volume Unit | ||||
| gross_value_h | CRMT_GROSS_VALUE_CUM | Gross Value | ||||
| net_value_h | CRMT_NET_VALUE_CUM | Net Value | ||||
| net_value_man_h | CRMT_NET_VALUE_MAN_CUM | Exp.Prod.Value | ||||
| tax_amount_h | CRMT_TAX_AMOUNT_CUM | Tax Amount | ||||
| freight_h | CRMT_FREIGHT_CUM | Shipment Costs | ||||
| net_wo_freight_h | CRMT_NET_WO_FREIGHT_CUM | Net w/out freight | ||||
| number_items | CRMT_NUMBER_ITEMS | Number of items | ||||
| 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 | ||||
| due_on | CRMS4_DUE_ON | Due Date | ||||
| sc_earliest_start_date | CRMS4_SC_EARLIEST_START_TSTMP | Earliest Start Date | ||||
| sc_latest_end_date | CRMS4_SC_LATEST_END_TSTMP | Latest End Date | ||||
| header_guid | CRMT_OBJECT_GUID | Object GUID | ||||
| 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 | CRMS4_CREATED_AT | Created On | ||||
| created_by_h | CRMT_CREATED_BY | Created By | ||||
| changed_at_h | CRMS4_CHANGED_AT | Changed On | ||||
| changed_by_h | CRMT_CHANGED_BY | Changed By | ||||
| head_changed_at | CRMT_CHANGED_AT | Changed On | ||||
| btx_class | CRMT_TRANSACTION_CLASSIFICATN | Trans.Classification | ||||
| auth_scope | CRM_AUTH_SCOPE | Authorization Scope | ||||
| archiving_flag | CRMT_ARCHIVING_FLAG | Can Be Archived | ||||
| object_id_ok | CRMT_OBJECT_ID_OK | ID Valid | ||||
| verify_date | CRMT_VERIFY_DATE | Verify Date | ||||
| pricing_document | KNUMV | Doc. Condition | ||||
| pricing_procedure | KALSM_D | Procedure | ||||
| header_guid_char | CRMT_OBJECT_GUID32 | Object GUID | ||||
| refbussolnord | CRMS4_REF_SOLO_OBJECT_ID | Ref. Soltn Order ID | ||||
| is_maintenance_order | CRMT_BOOLEAN | Flag | ||||
| sdm_status_dura | CRMS4_SDM_STATUS_DURA | Duration Flag | ||||
| 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 | ||||
| ic_bd_ccode | CRM_IC_BD_CCODE | ComCode | ||||
| ic_bd_logsys | CRM_IC_BD_LOGSYS | Logsys | ||||
| 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. | ||||
| inbox_assigned_to | CRMT_PERSON_RESP | Employee Resp. | ||||
| inbox_group_assigned | CRMT_RESPONSIBLE_GROUP | Responsible Group | ||||
| inbox_account | CRMT_SALESPARTNER | Sales Partners | ||||
| inbox_contact_person | CRMT_CONTACT_PERSON | Contact Pers. | ||||
| payplan_type | COMT_PAYPLAN_TYPE | PaymtPlanType | ||||
| 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. | ||||
| 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 | ||||
| req_dlv_date_h | CRMT_REQ_DLV_DATE | Rqstd Deliv. Date | ||||
| req_timezone_h | CRMT_REQ_DATE_TIMEZONE | Time Zone | ||||
| rule_req_date_h | CRMT_RULE_REQ_DATE | Rule ReqDelDate | ||||
| templ_searchterm | CRMT_TSRV_SERVICE_ID | Search Term | ||||
| 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 | ||||
| rec_priority | CRMT_SRQM_REC_PRIORITY | Recommended Priority | ||||
| urgency | CRMT_SRQM_URGENCY | Urgency | ||||
| impact | CRMT_SRQM_IMPACT | Impact | ||||
| escalation | CRMT_SRQM_ESCALATION | Escalation Level | ||||
| change_category | CRMT_SRQM_CHANGE_CAT | Change Category | ||||
| risk | CRMT_SRQM_RISK | Risk | ||||
| problem_category | CRMT_SRQM_PROBLEM_CATEGORY | Problem Category | ||||
| is_updated | CRMT_BOOLEAN | Flag | ||||
| last_updated_at | CRMT_SRQM_LAST_UPDATED_AT | Last Updated On | ||||
| chklst_id | CRMT_SRQM_CHKLST_ID | Checklist ID | ||||
| wp_fixval | CRMT_SRQM_WP_FIXVAL | Ranking Fix Val | ||||
| 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_archivable | CRMS4_STAT_ARCHIVABLE | Archivable | ||||
| stat_archived | CRMS4_STAT_ARCHIVED | Archived | ||||
| inbox_status | CRMT_AUI_STATUS | Status | ||||
| stat_final_conf | CRMS4_STAT_FINAL_CONF | Final Confirmation | ||||
| stat_for_billing | CRMS4_STAT_FOR_BILLING_HEADER | Rlsd f Bllg | ||||
| stat_rejection | CRMT_REJECTION_STATUS | Rejection Stat. | ||||
| stat_bsln_cost_postg | CRMS4_STAT_BSLN_COST_POSTG_H | BsLn Cost Calc HStat | ||||
| stat_cont_cost_calc | CRMS4_STAT_BSLN_COST_POSTG_H | BsLn Cost Calc HStat | ||||
| stat_ico | CRMS4_STAT_ICO | ICO processing stat | ||||
| stat_business_completed | CRMS4_STAT_BUSINESS_COMPLETED | Business Completed | ||||
| 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 | ||||
| serv_h_dummy_ps | CHAR1 | Single-Character Flag | ||||
| 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 | ||||
| stat_contract_cancelled | CRMS4_STAT_CONTRACT_CANCELLED | Contract Cancelled | ||||
| stat_credit | CRMS4_STAT_CREDIT_H | Header Credit Status | ||||
| 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.
-- Header 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_H (
CLIENT, -- Client [MANDT]
OBJTYPE_H, -- Trans. Cat. [CRMT_SUBOBJECT_CATEGORY_DB]
OBJECT_ID, -- Transaction ID [CRMT_OBJECT_ID_DB]
CATEGORY, -- Category [CRMT_ACTIVITY_CATEGORY]
PRIORITY, -- Priority [CRMT_PRIORITY]
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]
GROSS_WEIGHT_H, -- Gross Weight [CRMT_GROSS_WEIGHT_CUM]
NET_WEIGHT_H, -- Net Weight [CRMT_NET_WEIGHT_CUM]
WEIGHT_UNIT_H, -- Unit of Weight [COMT_WEIGHT_UNIT]
VOLUME_H, -- Volume [CRMT_VOLUME_CUM]
VOLUME_UNIT_H, -- Volume Unit [COMT_VOLUME_UNIT]
GROSS_VALUE_H, -- Gross Value [CRMT_GROSS_VALUE_CUM]
NET_VALUE_H, -- Net Value [CRMT_NET_VALUE_CUM]
NET_VALUE_MAN_H, -- Exp.Prod.Value [CRMT_NET_VALUE_MAN_CUM]
TAX_AMOUNT_H, -- Tax Amount [CRMT_TAX_AMOUNT_CUM]
FREIGHT_H, -- Shipment Costs [CRMT_FREIGHT_CUM]
NET_WO_FREIGHT_H, -- Net w/out freight [CRMT_NET_WO_FREIGHT_CUM]
NUMBER_ITEMS, -- Number of items [CRMT_NUMBER_ITEMS]
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]
DUE_ON, -- Due Date [CRMS4_DUE_ON]
SC_EARLIEST_START_DATE, -- Earliest Start Date [CRMS4_SC_EARLIEST_START_TSTMP]
SC_LATEST_END_DATE, -- Latest End Date [CRMS4_SC_LATEST_END_TSTMP]
HEADER_GUID, -- Object GUID [CRMT_OBJECT_GUID]
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 On [CRMS4_CREATED_AT]
CREATED_BY_H, -- Created By [CRMT_CREATED_BY]
CHANGED_AT_H, -- Changed On [CRMS4_CHANGED_AT]
CHANGED_BY_H, -- Changed By [CRMT_CHANGED_BY]
HEAD_CHANGED_AT, -- Changed On [CRMT_CHANGED_AT]
BTX_CLASS, -- Trans.Classification [CRMT_TRANSACTION_CLASSIFICATN]
AUTH_SCOPE, -- Authorization Scope [CRM_AUTH_SCOPE]
ARCHIVING_FLAG, -- Can Be Archived [CRMT_ARCHIVING_FLAG]
OBJECT_ID_OK, -- ID Valid [CRMT_OBJECT_ID_OK]
VERIFY_DATE, -- Verify Date [CRMT_VERIFY_DATE]
PRICING_DOCUMENT, -- Doc. Condition [KNUMV]
PRICING_PROCEDURE, -- Procedure [KALSM_D]
HEADER_GUID_CHAR, -- Object GUID [CRMT_OBJECT_GUID32]
REFBUSSOLNORD, -- Ref. Soltn Order ID [CRMS4_REF_SOLO_OBJECT_ID]
IS_MAINTENANCE_ORDER, -- Flag [CRMT_BOOLEAN]
SDM_STATUS_DURA, -- Duration Flag [CRMS4_SDM_STATUS_DURA]
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]
IC_BD_CCODE, -- ComCode [CRM_IC_BD_CCODE]
IC_BD_LOGSYS, -- Logsys [CRM_IC_BD_LOGSYS]
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]
INBOX_ASSIGNED_TO, -- Employee Resp. [CRMT_PERSON_RESP]
INBOX_GROUP_ASSIGNED, -- Responsible Group [CRMT_RESPONSIBLE_GROUP]
INBOX_ACCOUNT, -- Sales Partners [CRMT_SALESPARTNER]
INBOX_CONTACT_PERSON, -- Contact Pers. [CRMT_CONTACT_PERSON]
PAYPLAN_TYPE, -- PaymtPlanType [COMT_PAYPLAN_TYPE]
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]
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]
REQ_DLV_DATE_H, -- Rqstd Deliv. Date [CRMT_REQ_DLV_DATE]
REQ_TIMEZONE_H, -- Time Zone [CRMT_REQ_DATE_TIMEZONE]
RULE_REQ_DATE_H, -- Rule ReqDelDate [CRMT_RULE_REQ_DATE]
TEMPL_SEARCHTERM, -- Search Term [CRMT_TSRV_SERVICE_ID]
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]
REC_PRIORITY, -- Recommended Priority [CRMT_SRQM_REC_PRIORITY]
URGENCY, -- Urgency [CRMT_SRQM_URGENCY]
IMPACT, -- Impact [CRMT_SRQM_IMPACT]
ESCALATION, -- Escalation Level [CRMT_SRQM_ESCALATION]
CHANGE_CATEGORY, -- Change Category [CRMT_SRQM_CHANGE_CAT]
RISK, -- Risk [CRMT_SRQM_RISK]
PROBLEM_CATEGORY, -- Problem Category [CRMT_SRQM_PROBLEM_CATEGORY]
IS_UPDATED, -- Flag [CRMT_BOOLEAN]
LAST_UPDATED_AT, -- Last Updated On [CRMT_SRQM_LAST_UPDATED_AT]
CHKLST_ID, -- Checklist ID [CRMT_SRQM_CHKLST_ID]
WP_FIXVAL, -- Ranking Fix Val [CRMT_SRQM_WP_FIXVAL]
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_ARCHIVABLE, -- Archivable [CRMS4_STAT_ARCHIVABLE]
STAT_ARCHIVED, -- Archived [CRMS4_STAT_ARCHIVED]
INBOX_STATUS, -- Status [CRMT_AUI_STATUS]
STAT_FINAL_CONF, -- Final Confirmation [CRMS4_STAT_FINAL_CONF]
STAT_FOR_BILLING, -- Rlsd f Bllg [CRMS4_STAT_FOR_BILLING_HEADER]
STAT_REJECTION, -- Rejection Stat. [CRMT_REJECTION_STATUS]
STAT_BSLN_COST_POSTG, -- BsLn Cost Calc HStat [CRMS4_STAT_BSLN_COST_POSTG_H]
STAT_CONT_COST_CALC, -- BsLn Cost Calc HStat [CRMS4_STAT_BSLN_COST_POSTG_H]
STAT_ICO, -- ICO processing stat [CRMS4_STAT_ICO]
STAT_BUSINESS_COMPLETED, -- Business Completed [CRMS4_STAT_BUSINESS_COMPLETED]
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]
SERV_H_DUMMY_PS, -- Single-Character Flag [CHAR1]
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]
STAT_CONTRACT_CANCELLED, -- Contract Cancelled [CRMS4_STAT_CONTRACT_CANCELLED]
STAT_CREDIT, -- Header Credit Status [CRMS4_STAT_CREDIT_H]
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)
);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