CDBD_SALES SAP (Business transaction - sales - set) Table details

Dictionary Type: Table
Description: Business transaction - sales - set




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




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

CDBD_SALES is a standard SAP Table which is used to store Business transaction - sales - set data and is available within R/3 SAP systems depending on the version and release level.

The CDBD_SALES table consists of various fields, each holding specific information or linking keys about Business transaction - sales - set data available in SAP. These include SALES_GUID (Global Unique Identifier), ORDERADM_H_GUID (Global Unique Identifier), 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: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP CDBD_SALES table 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
CLIENTClient MANDTCLNT3Assigned to domainMANDT
SALES_GUIDGlobal Unique Identifier SMO_GUIDCHAR32SMO_GUID
ORDERADM_H_GUIDGlobal Unique Identifier SMO_GUIDCHAR32SMO_GUID
PO_NUMBER_UCSold-to Party's External Reference No. (in Capital Letters) CRMT_PO_NUMBER_UCCHAR35CHAR35
REGIONRegion (State, Province, County) CRMT_REGIONCHAR3Assigned to domainREGIO
INDUSTRYIndustry Sector CRMT_INDUSTRYCHAR4Assigned to domainCRM_INDUSTRY
PCAT_HDR_GUIDGlobal Unique Identifier SMO_GUIDCHAR32SMO_GUID
PCAT_VRT_GUIDGlobal Unique Identifier SMO_GUIDCHAR32SMO_GUID
PCAT_CTY_GUIDGlobal Unique Identifier SMO_GUIDCHAR32SMO_GUID
CUST_GROUP1Customer Group 1 CRMT_CUST_GROUP1CHAR3Assigned to domainCRM_CUST_GROUP1
CUST_GROUP2Customer Group 2 CRMT_CUST_GROUP2CHAR3Assigned to domainCRM_CUST_GROUP2
CUST_GROUP3Dishonour Reason CRMT_CUST_GROUP3CHAR3Assigned to domainCRM_CUST_GROUP3
CUST_GROUP4Customer Group 4 CRMT_CUST_GROUP4CHAR3Assigned to domainCRM_CUST_GROUP4
CUST_GROUP5Customer Group 5 CRMT_CUST_GROUP5CHAR3Assigned to domainCRM_CUST_GROUP5
PO_NUMBER_SOLDSold-To Party's External Reference Number CRMT_PO_NUMBER_SOLDCHAR35TEXT35
PO_DATE_SOLDReference Document Date CRMT_PO_DATE_SOLDDATS8DATUM
YOUR_REF_SOLDSold-to Party Reference CRMT_YOUR_REFERENCE_SOLDCHAR12TEXT12
PO_NUMBER_SHIPShip-To Party's External Reference Number CRMT_PO_NUMBER_SHIPCHAR35TEXT35
PO_DATE_SHIPShip-To Party's Reference Document Date CRMT_PO_DATE_SHIPDATS8DATUM
YOUR_REF_SHIPShip-To Party Reference CRMT_YOUR_REFERENCE_SHIPCHAR12TEXT12
USAGE_TYPEUsage Indicator CRMT_USAGECHAR3Assigned to domainCRM_USAGE
SUBMISSIONCollective Number for Quotations CRMT_SUBMISSIONCHAR10TEXT10
REJECTIONCancellation Reason Code CRMT_REJECTION_CODECHAR2Assigned to domainCRM_REJECTION_CODE
PROBABILITYOrder Probability CRMT_ORDER_PROBABILITYNUMC3CRM_PROBABILITY
DATE_QTY_FIXEDFixed Date and Quantity CRMT_DATE_QTY_FIXEDCHAR1CRM_BOOLEAN
REQ_DLV_DATERequested Delivery Date Header CRMT_REQ_DLV_DATEDEC15TSTPSBCOS_TSTMP
REQ_TIMEZONETime Zone Requested Delivery Date Header CRMT_REQ_DATE_TIMEZONECHAR6Assigned to domainTZNZONE
RULE_REQ_DATEGlobal Unique Identifier SMO_GUIDCHAR32SMO_GUID
REFGUIDGlobal Unique Identifier SMO_GUIDCHAR32SMO_GUID
REFKINDSource of a partner in a transaction CRMT_PARTNER_KIND_OF_ENTRYCHAR1CRM_PARTNER_KIND_OF_ENTRY
TR_USERTransaction User SMO_TR_USRCHAR32SMO_TR_USR
TR_IDTransaction Identifier SMO_TR_IDCHAR32SMO_TR_ID
TR_STATUSStatus of Transaction SMO_TR_STSCHAR4SMO_TR_STS
TIMESTAMPUTC Time Stamp in Short Form (YYYYMMDDhhmmss) TIMESTAMPDEC15TZNTSTMPS
DELETEDMobile Sales Deleted SMO_DELETDCHAR1SMO_DELETD
TR_ROOTIDIdentifier of BDoc Root object SMO_RTGUIDCHAR32SMO_GUID
SOURCESource of an object SMO_SOURCECHAR3SMO_SOURCE

Key field Non-key field



How do I retrieve data from SAP table CDBD_SALES using ABAP code

The following ABAP code Example will allow you to do a basic selection on CDBD_SALES to SELECT all data from the table
DATA: WA_CDBD_SALES TYPE CDBD_SALES.

SELECT SINGLE *
FROM CDBD_SALES
INTO CORRESPONDING FIELDS OF WA_CDBD_SALES
WHERE...

How to access SAP table CDBD_SALES

Within an ECC or HANA version of SAP you can also view further information about CDBD_SALES 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!