/1BEA/IPMI_DLI SAP (Billing Due List Item of application IPMI) Table details
Description: Billing Due List Item of application IPMI
Related tables to /1BEA/IPMI_DLI
Access table /1BEA/IPMI_DLI
Table field list including key, data, relationships and ABAP select examples
/1BEA/IPMI_DLI is a standard SAP Table which is used to store Billing Due List Item of application IPMI data and is available within R/3 SAP systems depending on the version and release level.
The /1BEA/IPMI_DLI table consists of various fields, each holding specific information or linking keys about Billing Due List Item of application IPMI data available in SAP. These include CLIENT (Client), DLI_GUID (GUID of a Billing Due List (BDL) Item), ARCHIVABLE (IPM: Item Archivability According to Application Logic), IAT_STATUS (Status of Transfer to R/3 Controlling).. 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/IPMI_DLI 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 |
CLIENT | Client | MANDT | CLNT | 3 | Assigned to domain | MANDT | |||
DLI_GUID | GUID of a Billing Due List (BDL) Item | BEA_DLI_GUID | RAW | 16 | SYSUUID | ||||
ARCHIVABLE | IPM: Item Archivability According to Application Logic | CRMT_IPM_BEA_ARCHIVABLE | CHAR | 1 | CRMT_IPM_BEA_ARCHIVABLE | ||||
IAT_STATUS | Status of Transfer to R/3 Controlling | BEA_IAT_STATUS | CHAR | 1 | BEA_IAT_STATUS | ||||
PARSET_GUID | Partner Set GUID; GUID Fld.in CRMD_PARTNER(CRMT_OBJECT_GUID) | BEA_PARSET_GUID | RAW | 16 | SYSUUID | ||||
PRIDOC_GUID | ID of Pricing Document | BEA_PRIDOC_GUID | RAW | 16 | SYSUUID | ||||
INDICATOR_IC | Indicator for Intercompany Billing | BEA_INDICATOR_IC | CHAR | 1 | BEA_INDICATOR_IC | ||||
BDI_GUID | GUID of Billing Item | BEA_BDI_GUID | RAW | 16 | SYSUUID | ||||
ITEM_CATEGORY | Item Category in Billing | BEA_ITEM_CATEGORY | CHAR | 4 | Assigned to domain | BEA_ITEM_CATEGORY | BEAC_ITC | ||
ITEM_TYPE | Billing Document Item Type | BEA_ITEM_TYPE | CHAR | 1 | BEA_ITEM_TYPE | ||||
BILL_TYPE | Billing Type | BEA_BILL_TYPE | CHAR | 4 | Assigned to domain | BEA_BILL_TYPE | BEAC_BTY | ||
BILL_CATEGORY | Billing Document Category | BEA_BILL_CATEGORY | CHAR | 1 | Assigned to domain | BEA_BILL_CATEGORY | BEAC_BCA | ||
BILL_ORG | Billing Unit | BEA_BILL_ORG | CHAR | 10 | Assigned to domain | ALPHA | BU_PARTNER | BPA | BEAC_BILL_ORG |
BILL_DATE | Billing Date | BEA_BILL_DATE | DATS | 8 | SYDATS | ||||
BILL_RELEVANCE | Billing Relevance | BEA_BILL_RELEVANCE | CHAR | 1 | BEA_BILL_RELEVANCE | ||||
SRVDOC_SOURCE | Origin of Price Document | BEA_SRVDOC_SOURCE | CHAR | 1 | BEA_SRVDOC_SOURCE | ||||
INCOMP_ID | Incompleteness: Billing Due List | BEA_INCOMP_ID | CHAR | 1 | BEA_INCOMP_ID | ||||
PAYER | Payer | BEA_PAYER | CHAR | 10 | Assigned to domain | ALPHA | BU_PARTNER | BUPA | |
TERMS_OF_PAYMENT | Terms of Payment | BEA_TERMS_OF_PAYMENT | CHAR | 4 | Assigned to domain | CRM_PMNTTRMS | |||
BILL_STATUS | Billing Status | BEA_BILL_STATUS | CHAR | 1 | BEA_BILL_STATUS | ||||
BILL_BLOCK | Billing Block | BEA_BILL_BLOCK | CHAR | 1 | BEA_BILL_BLOCK | ||||
MAINT_DATE | Processing Date | BEA_MAINT_DATE | DATS | 8 | SYDATS | ||||
MAINT_TIME | Processing Time | BEA_MAINT_TIME | TIMS | 6 | SYTIME | ||||
MAINT_USER | Created/Last Changed By | BEA_MAINT_USER | CHAR | 12 | USERNAME | USER_ADDR | |||
ACE_REL | Relevant for Accrual Engine | BEA_ACE_REL | CHAR | 1 | BEA_BOOLEAN | ||||
ADD_CRITERIA | Specific Splitting Criterion | BEA_ADD_CRITERIA | CHAR | 32 | BEA_ADD_CRITERIA | ||||
BASE_TIMEZONE | Time Zone for Time-Dependent Conditions | PRCT_BASE_TIMEZONE | CHAR | 6 | Assigned to domain | TZNZONE | |||
BASE_TIME_FROM | Start:Calculation Typ MNOP(for Time-Dependent Conditions) | PRCT_BASE_TIME_FROM | DEC | 15 | TSTPS | BCOS_TSTMP | |||
BASE_TIME_TO | End: Calculation Type MNOP (Time-Dependent Conditions) | PRCT_BASE_TIME_TO | DEC | 15 | TSTPS | BCOS_TSTMP | |||
BUSINESSSCENARIO | Business Scenario | BEA_BUSINESS_SCENARIO | CHAR | 1 | BEA_BUSINESS_SCENARIO | ||||
DG_ITEMNO | Difference Group Number | CRMT_IPM_BEA_DG_ITEMNO | NUMC | 10 | CRM_IPM_BEA_ITEMNO | ||||
DIFFIRREL | IPM: Indicator: Billing Due List Item Not Rel.to Diff.Cal. | CRMT_IPM_BEA_DIFFREL | CHAR | 1 | XFELD | ||||
DIRECT_BILLING | Direct Billing of a Billing Due List Item | BEA_DIRECT_BILLING | CHAR | 1 | BEA_DIRECT_BILLING | ||||
DIS_CHANNEL | Distribution Channel | CRMT_DISTRIBUTION_CHANNEL | CHAR | 2 | Assigned to domain | CRM_DISTRIBUTION_CHANNEL | CRM_ORGMAN_DIS_CHANNEL | ||
DIVISION | Division | CRMT_DIVISION | CHAR | 2 | Assigned to domain | CRM_DIVISION | CRM_DIVISION | ||
DIVISION_H | Header Division | BEA_DIVISION_H | CHAR | 2 | BEA_DIVISION | ||||
DOC_CURRENCY | Currency | CRMT_CURRENCY | CUKY | 5 | Assigned to domain | WAERS | FWS | ||
EXCHANGE_DATE | Exchange Rate Date | CRMT_EXCHG_DATE | DATS | 8 | CRM_EXCHG_DATE | ||||
EXCHANGE_RATE | Exchange Rate | CRMT_EXCHG_RATE | DEC | 9(5) | EXCRT | CRM_EXCHG_RATE | |||
EXCHANGE_TYPE | Exchange Rate Type | CRMT_EXCHG_TYPE | CHAR | 4 | Assigned to domain | KURST | |||
GROSS_WEIGHT | Gross Weight | CRMT_GROSS_WEIGHT | QUAN | 15(3) | MENG15 | ||||
INCOTERMS1 | Incoterms (Part 1) | CRMT_INCOTERMS1 | CHAR | 3 | Assigned to domain | CRM_INCOTERMS1 | |||
INCOTERMS2 | Incoterms (Part 2) | CRMT_INCOTERMS2 | CHAR | 28 | CRM_INCOTERMS2 | ||||
INVCR_DATE | Billing Doc. Creation Date | BEA_INVCR_DATE | DATS | 8 | SYDATS | ||||
LOGSYS | Logical System | CRMT_LOGSYS | CHAR | 10 | Assigned to domain | ALPHA | LOGSYS | ||
NET_VALUE | Net Value | CRMT_NET_VALUE | CURR | 15(2) | WERTV8 | ||||
NET_VALUE_MAN | Total Expected Net Value Products in Document Currency | CRMT_NET_VALUE_MAN | CURR | 15(2) | WERTV8 | ||||
NET_WEIGHT | Net Weight | CRMT_NET_WEIGHT | QUAN | 15(3) | MENG15 | ||||
OBJTYPE | Object Type | BEA_OBJTYPE | CHAR | 10 | BEA_OBJTYPE | ||||
PARENT_ITEMNO | Higher-Level Billing Item | BEA_PARENT_ITEMNO | NUMC | 10 | NUMC10 | ||||
PAYMENT_METHOD | Payment Method | DZLSCH | CHAR | 1 | Assigned to domain | ZLSCH | |||
PRC_INDICATOR | Pricing indicator | CRMT_PRICING_INDICATOR | CHAR | 1 | CRM_PRICING_INDICATOR | ||||
PRICING_DATE | Pricing Date | CRMT_PRICE_DATE | DATS | 8 | CRM_PRICE_DATE | ||||
PROC_QTY_DEN | Denominator (factor) for conversion trans. quantity in BME | CRMT_PROCESS_QTY_DEN | INT4 | 10 | CRM_PROCESS_QTY_DEN | ||||
PROC_QTY_EXP10 | 10 Exponent for Quantity Conversion | CRMT_EXPONENT10 | INT2 | 5 | CRM_EXPONENT10 | ||||
PROC_QTY_NUM | Numerator (factor) for conversion trans. quantity in BME | CRMT_PROCESS_QTY_NUM | INT4 | 10 | CRM_PROCESS_QTY_NUM | ||||
PRODUCT | Internal Unique ID of Product | COMT_PRODUCT_GUID | RAW | 16 | SYSUUID | ||||
PRODUCT_DESCR | Product Description | COMT_PRSHTEXTX | CHAR | 40 | PRSHTEXT40 | ||||
P_LOGSYS | Logical System | CRMT_LOGSYS | CHAR | 10 | Assigned to domain | ALPHA | LOGSYS | ||
P_OBJTYPE | Object Type | BEA_OBJTYPE | CHAR | 10 | BEA_OBJTYPE | ||||
P_SRC_HEADNO | Preceding Document Number | BEA_P_SRC_HEADNO | CHAR | 10 | ALPHA | BEA_SRC_HEADNO_EXT | BEA_P_SRC_HEADNO | ||
P_SRC_ITEMNO | Item Number in Document | CRMT_ITEM_NO | NUMC | 10 | CRM_ITEM_NO | ||||
QTY_UNIT | Unit of Measure in Which the Product Is Sold | CRMT_PROCESS_QTY_UNIT | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
QUANTITY | Quantity | BEA_QUANTITY | QUAN | 13(3) | MENGV13 | ||||
REFERENCE_NO | Reference Number | BEA_REFERENCE_NO | CHAR | 30 | CHAR30 | ||||
REF_CURRENCY | Reference Currency | CRMT_REF_CURRENCY | CUKY | 5 | Assigned to domain | WAERS | |||
RENDERED_DATE | Date of Services Rendered | BEA_RENDERED_DATE | DATS | 8 | SYDATS | ||||
SALES_ORG | Sales Organization | CRMT_SALES_ORG | CHAR | 14 | HROBJEC_14 | CRM_ORGMAN_SALES_ORG | |||
SERVICE_ORG | Service Organization | CRMT_SERVICE_ORG | CHAR | 14 | HROBJEC_14 | CRM_ORGMAN_SERVICE_ORG | |||
SERVICE_TYPE | Service Type | CRMT_SERVICE_TYPE | CHAR | 4 | Assigned to domain | CRMT_SERVICE_TYPE | |||
SOLD_TO_PARTY | Sold-To Party ID | CRMT_SOLD_TO_PARTY_ID | CHAR | 10 | Assigned to domain | ALPHA | BU_PARTNER | BUPA | |
SRC_BILL_BLOCK | Blocking Reason for Billing Block | BEA_BILLING_BLOCK | CHAR | 2 | BEA_BILLING_BLOCK | ||||
SRC_DATE | Local Date | SYSTDATLO | DATS | 8 | SYDATS | ||||
SRC_GUID | GUID of a CRM Order Object | CRMT_OBJECT_GUID | RAW | 16 | SYSUUID | ||||
SRC_HEADER_GUID | GUID of a CRM Order Object | CRMT_OBJECT_GUID | RAW | 16 | SYSUUID | ||||
SRC_HEADNO | Source Application Document Number | BEA_SRC_HEADNO | CHAR | 10 | ALPHA | BEA_SRC_HEADNO_EXT | BEA_SRC_HEADNO | ||
SRC_ITEMNO | Item Number in Document | CRMT_ITEM_NO | NUMC | 10 | CRM_ITEM_NO | ||||
SRC_ITEM_TYPE | Item Category | CRMT_ITEM_TYPE | CHAR | 4 | Assigned to domain | CRM_ITEM_TYPE | CRM_ITEM_TYPE | ||
SRC_ORIGIN | Origin of Data to Be Billed | BEA_SRC_ORIGIN | CHAR | 1 | BEA_SRC_ORIGIN | ||||
SRC_PARENT_GUID | GUID of a CRM Order Object | CRMT_OBJECT_GUID | RAW | 16 | SYSUUID | ||||
SRC_PARENT_ITNO | Item Number in Document | CRMT_ITEM_NO | NUMC | 10 | CRM_ITEM_NO | ||||
SRC_PRC_GUID | GUID of a CRM Order Object | CRMT_OBJECT_GUID | RAW | 16 | SYSUUID | ||||
SRC_PROCESS_TYPE | Business Transaction Type | CRMT_PROCESS_TYPE | CHAR | 4 | Assigned to domain | CRM_PROCESS_TYPE | CRM_PROCESS_TYPE | CRM_PROCESS_TYPE | |
SRC_REJECT | Rejection Indicator | BEA_REJECT | CHAR | 1 | BEA_REJECT | ||||
SRC_USER | User Name | SYUNAME | CHAR | 12 | SYCHAR12 | ||||
TAX_DEST_COUNTRY | Tax Destination Country | CRMT_TAX_DEST_CTY | CHAR | 3 | Assigned to domain | LAND1 | |||
TRANSFER_DATE | Value Date | BEA_TRANSFER_DATE | DATS | 8 | SYDATS | ||||
UPDG_ITEMNO | Update Groups Number | CRMT_IPM_BEA_UPDG_ITEMNO | NUMC | 10 | CRM_IPM_BEA_ITEMNO | ||||
VALUATION_TYPE | Valuation Type | CRMT_VALUATION_TYPE | CHAR | 6 | Assigned to domain | CRMT_VALUATION_TYPE | |||
VENDOR | Business Partner GUID | BU_PARTNER_GUID | RAW | 16 | SYSUUID | ||||
WEIGHT_UNIT | Weight Unit | COMT_WEIGHT_UNIT | UNIT | 3 | Assigned to domain | CUNIT | MEINS |
Key field | Non-key field |
How do I retrieve data from SAP table /1BEA/IPMI_DLI using ABAP code
The following ABAP code Example will allow you to do a basic selection on /1BEA/IPMI_DLI to SELECT all data from the tableDATA: WA_/1BEA/IPMI_DLI TYPE /1BEA/IPMI_DLI.
SELECT SINGLE *
FROM /1BEA/IPMI_DLI
INTO CORRESPONDING FIELDS OF WA_/1BEA/IPMI_DLI
WHERE...
How to access SAP table /1BEA/IPMI_DLI
Within an ECC or HANA version of SAP you can also view further information about /1BEA/IPMI_DLI and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects