/1BEA/CRMB_BDI SAP (Billing Item of application CRMB) Table details

Dictionary Type: Table
Description: Billing Item of application CRMB




ABAP Code to SELECT data from /1BEA/CRMB_BDI
Related tables to /1BEA/CRMB_BDI
Access table /1BEA/CRMB_BDI




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

/1BEA/CRMB_BDI is a standard SAP Table which is used to store Billing Item of application CRMB data and is available within R/3 SAP systems depending on the version and release level.

The /1BEA/CRMB_BDI table consists of various fields, each holding specific information or linking keys about Billing Item of application CRMB data available in SAP. These include CLIENT (Client), BDI_GUID (GUID of Billing Item), BDH_GUID (Unique Internal ID of a Billing Header), INDICATOR_IC (Indicator for Intercompany Billing).. 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: Cannot Be Enhanced


SAP /1BEA/CRMB_BDI 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
BDI_GUIDGUID of Billing Item BEA_BDI_GUIDRAW16SYSUUID
BDH_GUIDUnique Internal ID of a Billing Header BEA_BDH_GUIDRAW16SYSUUID
INDICATOR_ICIndicator for Intercompany Billing BEA_INDICATOR_ICCHAR1BEA_INDICATOR_IC
PARSET_GUIDPartner Set GUID; GUID Fld.in CRMD_PARTNER(CRMT_OBJECT_GUID) BEA_PARSET_GUIDRAW16SYSUUID
PRICING_STATUSPricing Status BEA_PRICING_STATUSCHAR1BEA_PRICING_STATUS
TEXT_ERRORText Processing Status BEA_TEXT_ERRORCHAR1BEA_TEXT_ERROR
ITEMNO_EXTBilling Item (External Identifier) BEA_ITEMNO_EXTNUMC10NUMC10
REVERSALReversal Indicator BEA_REVERSALCHAR1BEA_REVERSAL
IS_REVERSEDFlag: Billing Item Is Offset BEA_IS_REVERSEDCHAR1BEA_IS_REVERSED
ITEM_CATEGORYItem Category in Billing BEA_ITEM_CATEGORYCHAR4Assigned to domainBEA_ITEM_CATEGORYBEAC_ITC
ITEM_TYPEBilling Document Item Type BEA_ITEM_TYPECHAR1BEA_ITEM_TYPE
SRVDOC_SOURCEOrigin of Price Document BEA_SRVDOC_SOURCECHAR1BEA_SRVDOC_SOURCE
CREATION_CODECreation Code BEA_CREATION_CODECHAR1BEA_CREATION_CODE
NET_VALUENet Value in Document Currency BEA_NET_VALUECURR15(2) WERTV8
TAX_VALUETax Amount in Document Currency BEA_TAX_VALUECURR15(2) WERTV8
GROSS_VALUEGross Value in Document Currency BEA_GROSS_VALUECURR15(2) WERTV8
DOC_CURRENCYDocument Currency BEA_DOC_CURRENCYCUKY5Assigned to domainWAERSFWS
EXCHANGE_RATEExchange Rate BEA_EXCHANGE_RATEDEC9(5) EXCRTBEA_EXCHANGE_RATE
EXCHANGE_DATEConversion Date BEA_EXCHANGE_DATEDATS8SYDATS
BASE_TIMEZONETime Zone for Time-Dependent Conditions PRCT_BASE_TIMEZONECHAR6Assigned to domainTZNZONE
BASE_TIME_FROMStart:Calculation Typ MNOP(for Time-Dependent Conditions) PRCT_BASE_TIME_FROMDEC15TSTPSBCOS_TSTMP
BASE_TIME_TOEnd: Calculation Type MNOP (Time-Dependent Conditions) PRCT_BASE_TIME_TODEC15TSTPSBCOS_TSTMP
BUSINESSSCENARIOBusiness Scenario BEA_BUSINESS_SCENARIOCHAR1BEA_BUSINESS_SCENARIO
DIS_CHANNELDistribution Channel CRMT_DISTRIBUTION_CHANNELCHAR2Assigned to domainCRM_DISTRIBUTION_CHANNELCRM_ORGMAN_DIS_CHANNEL
DIVISIONDivision CRMT_DIVISIONCHAR2Assigned to domainCRM_DIVISIONCRM_DIVISION
DIVISION_HHeader Division BEA_DIVISION_HCHAR2BEA_DIVISION
GROSS_WEIGHTGross Weight CRMT_GROSS_WEIGHTQUAN15(3) MENG15
LOGSYSLogical System CRMT_LOGSYSCHAR10Assigned to domainALPHALOGSYS
NET_VALUE_MANTotal Expected Net Value Products in Document Currency CRMT_NET_VALUE_MANCURR15(2) WERTV8
NET_WEIGHTNet Weight CRMT_NET_WEIGHTQUAN15(3) MENG15
OBJTYPEObject Type BEA_OBJTYPECHAR10BEA_OBJTYPE
PARENT_ITEMNOHigher-Level Billing Item BEA_PARENT_ITEMNONUMC10NUMC10
PRC_INDICATORPricing indicator CRMT_PRICING_INDICATORCHAR1CRM_PRICING_INDICATOR
PRICING_DATEPricing Date CRMT_PRICE_DATEDATS8CRM_PRICE_DATE
PROC_QTY_DENDenominator (factor) for conversion trans. quantity in BME CRMT_PROCESS_QTY_DENINT410CRM_PROCESS_QTY_DEN
PROC_QTY_EXP1010 Exponent for Quantity Conversion CRMT_EXPONENT10INT25CRM_EXPONENT10
PROC_QTY_NUMNumerator (factor) for conversion trans. quantity in BME CRMT_PROCESS_QTY_NUMINT410CRM_PROCESS_QTY_NUM
PRODUCTInternal Unique ID of Product COMT_PRODUCT_GUIDRAW16SYSUUID
PRODUCT_DESCRProduct Description COMT_PRSHTEXTXCHAR40PRSHTEXT40
QTY_UNITUnit of Measure in Which the Product Is Sold CRMT_PROCESS_QTY_UNITUNIT3Assigned to domainCUNITMEINS
QUANTITYQuantity BEA_QUANTITYQUAN13(3) MENGV13
RENDERED_DATEDate of Services Rendered BEA_RENDERED_DATEDATS8SYDATS
SALES_ORGSales Organization CRMT_SALES_ORGCHAR14HROBJEC_14CRM_ORGMAN_SALES_ORG
SERVICE_ORGService Organization CRMT_SERVICE_ORGCHAR14HROBJEC_14CRM_ORGMAN_SERVICE_ORG
SERVICE_TYPEService Type CRMT_SERVICE_TYPECHAR4Assigned to domainCRMT_SERVICE_TYPE
SRC_GUIDGUID of a CRM Order Object CRMT_OBJECT_GUIDRAW16SYSUUID
SRC_HEADNOSource Application Document Number BEA_SRC_HEADNOCHAR10ALPHABEA_SRC_HEADNO_EXTBEA_SRC_HEADNO
SRC_ITEMNOItem Number in Document CRMT_ITEM_NONUMC10CRM_ITEM_NO
SRC_ITEM_TYPEItem Category CRMT_ITEM_TYPECHAR4Assigned to domainCRM_ITEM_TYPECRM_ITEM_TYPE
SRC_PROCESS_TYPEBusiness Transaction Type CRMT_PROCESS_TYPECHAR4Assigned to domainCRM_PROCESS_TYPECRM_PROCESS_TYPECRM_PROCESS_TYPE
TAX_DEST_COUNTRYTax Destination Country CRMT_TAX_DEST_CTYCHAR3Assigned to domainLAND1
VALUATION_TYPEValuation Type CRMT_VALUATION_TYPECHAR6Assigned to domainCRMT_VALUATION_TYPE
VENDORBusiness Partner GUID BU_PARTNER_GUIDRAW16SYSUUID
WEIGHT_UNITWeight Unit COMT_WEIGHT_UNITUNIT3Assigned to domainCUNITMEINS

Key field Non-key field



How do I retrieve data from SAP table /1BEA/CRMB_BDI using ABAP code

The following ABAP code Example will allow you to do a basic selection on /1BEA/CRMB_BDI to SELECT all data from the table
DATA: WA_/1BEA/CRMB_BDI TYPE /1BEA/CRMB_BDI.

SELECT SINGLE *
FROM /1BEA/CRMB_BDI
INTO CORRESPONDING FIELDS OF WA_/1BEA/CRMB_BDI
WHERE...

How to access SAP table /1BEA/CRMB_BDI

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