Home SAP Development ABAP Coding SAP Fiori SAP Training SAP Tables SAP Objects...

CRMT_SALES_DB_WRK SAP (Sales Set: Workarea for Database Buffer) Structure details

Dictionary Type: Structure
Description: Sales Set: Workarea for Database Buffer

ABAP Code to SELECT data from CRMT_SALES_DB_WRK
Related tables to CRMT_SALES_DB_WRK
Access table CRMT_SALES_DB_WRK

Table Field Attributes
Data Element Attributes
Domain Attributes
SAP Tables
Best ABAP Books

Structure field list including key, data, relationships and ABAP select examples

CRMT_SALES_DB_WRK is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Sales Set: Workarea for Database Buffer" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_CRMT_SALES_DB_WRK TYPE CRMT_SALES_DB_WRK.

The CRMT_SALES_DB_WRK table consists of various fields, each holding specific information or linking keys about Sales Set: Workarea for Database Buffer data available in SAP. These include CLIENT (Client), GUID (GUID of a CRM Order Object), PO_NUMBER_UC (Sold-to Party's External Reference No. (in Capital Letters)), REGION (Region (State, Province, County)).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)

SAP CRMT_SALES_DB_WRK structure fields - Full list of fields found in SAP data dictionary

Field	Description	Data Element	Data Type	length (Dec)	Check table	Conversion Routine	Domain Name	MemoryID	SHLP
CLIENT	Client	MANDT	CLNT	3	Assigned to domain		MANDT
GUID	GUID of a CRM Order Object	CRMT_OBJECT_GUID	RAW	16			SYSUUID
PO_NUMBER_UC	Sold-to Party's External Reference No. (in Capital Letters)	CRMT_PO_NUMBER_UC	CHAR	35			CHAR35
REGION	Region (State, Province, County)	CRMT_REGION	CHAR	3	Assigned to domain		REGIO
INDUSTRY	Industry Sector	CRMT_INDUSTRY	CHAR	4	Assigned to domain		CRM_INDUSTRY
PCAT_HDR_GUID	Product Catalog GUID (Header)	COMT_PCAT_HDR_GUID	RAW	16			SYSUUID
PCAT_VRT_GUID	Product Catalog Variant GUID	COMT_PCAT_VRT_GUID	RAW	16			SYSUUID
PCAT_CTY_GUID	GUID of a Product Catalog Area	COMT_PCAT_CTY_GUID	RAW	16			SYSUUID
CUST_GROUP1	Customer Group 1	CRMT_CUST_GROUP1	CHAR	3	CRMC_CUSTGRP1		CRM_CUST_GROUP1
CUST_GROUP2	Customer Group 2	CRMT_CUST_GROUP2	CHAR	3	CRMC_CUSTGRP2		CRM_CUST_GROUP2
CUST_GROUP3	Dishonour Reason	CRMT_CUST_GROUP3	CHAR	3	CRMC_CUSTGRP3		CRM_CUST_GROUP3
CUST_GROUP4	Customer Group 4	CRMT_CUST_GROUP4	CHAR	3	CRMC_CUSTGRP4		CRM_CUST_GROUP4
CUST_GROUP5	Customer Group 5	CRMT_CUST_GROUP5	CHAR	3	CRMC_CUSTGRP5		CRM_CUST_GROUP5
PO_NUMBER_SOLD	Sold-To Party's External Reference Number	CRMT_PO_NUMBER_SOLD	CHAR	35			TEXT35
PO_DATE_SOLD	Reference Document Date	CRMT_PO_DATE_SOLD	DATS	8			DATUM
YOUR_REF_SOLD	Sold-to Party Reference	CRMT_YOUR_REFERENCE_SOLD	CHAR	12			TEXT12
PO_NUMBER_SHIP	Ship-To Party's External Reference Number	CRMT_PO_NUMBER_SHIP	CHAR	35			TEXT35
PO_DATE_SHIP	Ship-To Party's Reference Document Date	CRMT_PO_DATE_SHIP	DATS	8			DATUM
YOUR_REF_SHIP	Ship-To Party Reference	CRMT_YOUR_REFERENCE_SHIP	CHAR	12			TEXT12
USAGE_TYPE	Usage Indicator	CRMT_USAGE	CHAR	3	CRMC_USAGE		CRM_USAGE
SUBMISSION	Collective Number for Quotations	CRMT_SUBMISSION	CHAR	10			TEXT10
REJECTION	Cancellation Reason Code	CRMT_REJECTION_CODE	CHAR	2	CRMC_REJECTION		CRM_REJECTION_CODE
PROBABILITY	Order Probability	CRMT_ORDER_PROBABILITY	NUMC	3			CRM_PROBABILITY
DATE_QTY_FIXED	Fixed Date and Quantity	CRMT_DATE_QTY_FIXED	CHAR	1			CRM_BOOLEAN
REQ_DLV_DATE	Requested Delivery Date Header	CRMT_REQ_DLV_DATE	DEC	15		TSTPS	BCOS_TSTMP
REQ_TIMEZONE	Time Zone Requested Delivery Date Header	CRMT_REQ_DATE_TIMEZONE	CHAR	6	Assigned to domain		TZNZONE
RULE_REQ_DATE	Rule Reqested Delivery Date Header	CRMT_RULE_REQ_DATE	RAW	16	Assigned to domain		TIMERULEID
ROUNDING	Round Requirement Quantity	CRMT_ROUNDING	CHAR	1			CRM_ROUNDING
PAR_ATP_SSTOCK	Parameter-Dependent ATP Safety Stock	CRMT_PAR_ATP_SSTOCK	CHAR	1			CRM_PAR_ATP_SSTOCK
CONF_RULE	Confirmation Rule	CRMT_CONF_RULE	CHAR	1			CRM_CONF_RULE
SUBST_EXCL	Rule Criterion 1	CRMT_ATP_SUBST_EXCL	CHAR	2	CRMC_SUBST_EXCL		CRM_ATP_SUBST_EXCL
SEARCH_PATTERN	Rule Criterion 2	CRMT_SEARCH_PATTERN	CHAR	10	CRMC_ATP_SEARCH		CRM_SEARCH_PATTERN
REASSIGN_ABILITY	Reassignment of Order Confirmations	CRMT_REASSIGN_ABILITY	CHAR	1			CRM_REASSIGN_ABILITY
ABNORMAL_DEMAND	Abnormal Demand	CRMT_ABNORMAL_DEMAND	CHAR	1			CRM_ABNORMAL_DEMAND
NOREC_FLAG	Entry does not Exist in Database	CRMT_NOREC	CHAR	1			CRM_BOOLEAN

Key field

Non-key field

How do I retrieve data from SAP structure CRMT_SALES_DB_WRK using ABAP code?

As CRMT_SALES_DB_WRK is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on CRMT_SALES_DB_WRK as there is no data to select.

How to access SAP table CRMT_SALES_DB_WRK

Within an ECC or HANA version of SAP you can also view further information about CRMT_SALES_DB_WRK and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).

Search for further information about these or an SAP related objects

Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!