Sunday, May 19, 2024

SAP Table AD01DLILTEXT – Long text for dynamic items

AD01DLILTEXT is a standard SAP table in SAP ECC (or) S/4HANA which stores Long text for dynamic items data. There are total 4 fields in AD01DLILTEXT table.This blog post provides key technical details of SAP table AD01DLILTEXT, including its availability across SAP S/4HANA versions and the list of CDS views for AD01DLILTEXT table in SAP.

SAP HANA Table Type Column Store
Buffering Permission Buffering not allowed
Buffering Type No buffering
Package DI Processor (Resource-Related Billing/Sales Pricing) (AD01)
Technical Component Revenues and Earnings (PS-REV)

SAP AD01DLILTEXT Table Fields

The following is the list of fields that are available in SAP AD01DLILTEXT table. The key fields of the table are highlighted in color.

Field Description Data Element Domain Check Table Data Type
CLIENT Client MANDT MANDT CLNT (3)
DLINR Number of the Dynamic Item AD01DLINR AD01DLINR AD01DLI NUMC (20)
LANGU Language Key LANGU SPRAS LANG (1)
LONGTEXT Data element for dynamic item long text DLILTEXT DLILTEXT CHAR (300)

Availability

The SAP table AD01DLILTEXT is available within SAP S/4HANA On-premise and SAP S/4HANA Cloud systems depending on the version and release level.

SAP S/4HANA Version Available?
1909 Yes
2020 Yes
2021 Yes
2022 Yes
2023 Yes

CDS Views for AD01DLILTEXT table

The following is the list of AD01DLILTEXT CDS views, which can also be used instead of AD01DLILTEXT table based on your business requirements.

CDS View CDS View Type Description
I_RRBDYNAMICITEMLONGTEXT BASIC RRB Dynamic Item ΓÇô Text
C_RRBDYNAMICITEMFLOW CONSUMPTION Dynamic Item Flow With Characteristics
C_RRBSALESPRICINGDYNAMICITEM CONSUMPTION Resource Related Billing Dynamic Items
C_RRBWRITTENOFFDYNAMICITEM CONSUMPTION Written Off Dynamic Item
P_RRBDYNAMICITEMFLOW01 CONSUMPTION Dynamic Item Flow With Characteristics Helper View 1
P_RRBDYNAMICITEMFLOW02 CONSUMPTION Dynamic Item Flow With Characteristics Helper View 2