BBPD_CMS_DOC SAP (CMS Documents) Table details

Dictionary Type: Table
Description: CMS Documents




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




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

BBPD_CMS_DOC is a standard SAP Table which is used to store CMS Documents data and is available within R/3 SAP systems depending on the version and release level.

The BBPD_CMS_DOC table consists of various fields, each holding specific information or linking keys about CMS Documents data available in SAP. These include GUID (CMS Document GUID), VERSION (Legal Document Version), ID (CMS Document ID), NAME (CMS Document Name).. 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 (Deep)


SAP BBPD_CMS_DOC 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
MANDTClient MANDTCLNT3Assigned to domainMANDT
GUIDCMS Document GUID BBP_CMS_DOC_GUIDRAW16SYSUUID
VERSIONLegal Document Version BBP_CMS_DOC_VERSIONNUMC3BBP_CMS_DOC_VERSION
IDCMS Document ID BBP_CMS_DOC_IDCHAR10BBP_CMS_DOC_ID
NAMECMS Document Name BBP_CMS_DOC_NAMECHAR40BBP_CMS_DOC_NAME
NAME_SCMS Document Name BBP_CMS_DOC_NAMECHAR40BBP_CMS_DOC_NAME
CATEGORYCMS Category BBP_CMS_CATEGORYCHAR4BBP_CMS_CATEGORYBBP_CMS_CATEGORY
DOC_TYPECMS Document Type BBP_CMS_DOC_TYPECHAR2BBP_CMS_DOC_TYPE
DESCRIPTIONCMS Document Description BBP_CMS_DOC_DESCRIPTIONCHAR125BBP_CMS_DOC_DESCRIPTION
DESCRIPTION_SCMS Document Description BBP_CMS_DOC_DESCRIPTIONCHAR125BBP_CMS_DOC_DESCRIPTION
CONTRACT_TYPEContract type BBP_CMS_CONTRACT_TYPECHAR4BBP_CMS_CONTRACT_TYPE
PUR_ORGPurchasing Organization BBP_CMS_DOC_PORGCHAR14BBP_CMS_DOC_PORG
PUR_GRPPurchasing Group BBP_CMS_DOC_PGRPCHAR14BBP_CMS_DOC_PGRP
STATUSSystem status J_ISTATCHAR5Assigned to domainJ_ISTAT
DOC_MODEDocument Mode BBP_CMS_DOC_MODECHAR2BBP_CMS_DOC_MODE
PREVIOUS_GUIDCMS Document GUID BBP_CMS_DOC_GUIDRAW16SYSUUID
NEXT_GUIDCMS Document GUID BBP_CMS_DOC_GUIDRAW16SYSUUID
AMENDMENT_GUIDCMS Document GUID BBP_CMS_DOC_GUIDRAW16SYSUUID
CONFIDENTIALCheckbox XFELDCHAR1XFELD
CREATED_ONTime Stamp BBP_CMS_TSTMPDEC15BBP_CMS_TSTMP
CREATED_BYUser Name SYUNAMECHAR12SYCHAR12
CHANGED_ONTime Stamp BBP_CMS_TSTMPDEC15BBP_CMS_TSTMP
CHANGED_BYUser Name SYUNAMECHAR12SYCHAR12
CHECKED_OUT_ONTime Stamp BBP_CMS_TSTMPDEC15BBP_CMS_TSTMP
CHECKED_OUT_BYUser Name SYUNAMECHAR12SYCHAR12
CHECKED_OUTCheckbox XFELDCHAR1XFELD
COLLAB_INTCheckbox XFELDCHAR1XFELD
COLLAB_EXTCheckbox XFELDCHAR1XFELD
OC_IDCMS Document ID BBP_CMS_DOC_IDCHAR10BBP_CMS_DOC_ID
START_DATEDate BBP_CMS_DOC_DATEDATS8DATUM
END_DATEDate BBP_CMS_DOC_DATEDATS8DATUM
VENDOR_NOBusiness Partner Number BU_PARTNERCHAR10Assigned to domainALPHABU_PARTNERBPABUPA
RESP_EMPLBusiness Partner Number BU_PARTNERCHAR10Assigned to domainALPHABU_PARTNERBPABUPA
NOT_ITEM_RELVCheckbox XFELDCHAR1XFELD
NOT_OC_RELVCheckbox XFELDCHAR1XFELD
DATE_FORMATDate format XUDATFMCHAR1XUDATFM
DEC_FORMATDecimal Format XUDCPFMCHAR1XUDCPFM
OC_TA_TYPEBusiness Transaction Type CRMT_PROCESS_TYPE_DBCHAR4Assigned to domainCRM_PROCESS_TYPE
INTENDED_USECMS Document Description BBP_CMS_DOC_DESCRIPTIONCHAR125BBP_CMS_DOC_DESCRIPTION
SOURCE_IDCMS Document ID BBP_CMS_DOC_IDCHAR10BBP_CMS_DOC_ID
DOCIDKM Document ID BBP_CMS_KMIDCHAR122CHAR122

Key field Non-key field



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

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

SELECT SINGLE *
FROM BBPD_CMS_DOC
INTO CORRESPONDING FIELDS OF WA_BBPD_CMS_DOC
WHERE...

How to access SAP table BBPD_CMS_DOC

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