Sunday, May 19, 2024

SAP Table ADTCF_DETAIL – ADTCF – User Profile Detail

ADTCF_DETAIL is a standard SAP table in SAP ECC (or) S/4HANA which stores ADTCF – User Profile Detail data. There are total 11 fields in ADTCF_DETAIL table.This blog post provides key technical details of SAP table ADTCF_DETAIL, including its availability across SAP S/4HANA versions and the list of CDS views for ADTCF_DETAIL table in SAP.

SAP HANA Table Type Column Store
Buffering Permission Buffering not allowed
Buffering Type No buffering
Package A&D: Tree Control Framework (AD_TCF)
Technical Component Aerospace & Defence Industry Solution (IS-AD)

SAP ADTCF_DETAIL Table Fields

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

Field Description Data Element Domain Check Table Data Type
MANDT Client MANDT MANDT * CLNT (3)
PROFILE_KEY ADTCF : Profile Key ADTCF_PROFILEKEY ADTCF_PROFILEKEY ADTCF_MASTER CHAR (10)
FIELD Progile Field ADTCF_FIELD ADTCF_FIELD CHAR (80)
LOCATION ADTCF: LOCATION ADTCF_LOCATION ADTCF_LOCATION CHAR (6)
SEQUENCE ADTCF : Sequence ADTCF_SEQUENCE ADTCF_SEQUENCE INT1 (3)
ICON Icon in text fields (substitute display, alias) ICON_D ICON ICON CHAR (4)
REF_TABLE ADTCF : Reference text Table ADTCF_REF_TABLE AS4TAB * CHAR (30)
REF_FIELD ADTCF : REF_FIELD ADTCF_REF_FIELD FDNAME * CHAR (30)
PROPERTY1 ADTCF : PROPERTY ADTCF_PROPERTY ADTCF_PROPERTY CHAR (80)
PROPERTY2 ADTCF : PROPERTY ADTCF_PROPERTY ADTCF_PROPERTY CHAR (80)
PROPERTY3 ADTCF : PROPERTY ADTCF_PROPERTY ADTCF_PROPERTY CHAR (80)

Availability

The SAP table ADTCF_DETAIL 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 ADTCF_DETAIL table

There are no CDS views available in the system. We’re updating the content all the time, so check back regularly.