DD03L
Tabellenfelder
DD03L is an SAP database table in S/4HANA. Tabellenfelder. It contains 31 fields. 59 CDS views read from this table.
CDS Views using this table (59)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| /CFG/V_HASH_DAO | view | left_outer | CDS View for Hashing DAO | |
| /PF1/I_SLA_COND_CHAR | view_entity | left_outer | Condition Characteristics | |
| /PF1/P_PaytAgrmtFieldLabel | view_entity | from | Payment Agreement Field Label | |
| /PF1/P_SLAFieldLabel | view_entity | from | Service Level Agreement Field Label | |
| /PF1/P_StructureFieldDesc | view_entity | from | Descriptions for structure fields | |
| DBC2ABAP_PROC_PARM_COLS_ALL | view_entity | inner | Procedure param cols for SQL service | |
| ddcds_classic_tabl_first_field | view_entity | from | Classical Table: Position of first field | |
| FAC_DART_Z3_QUERY_FIELD | view | inner | Dart Z3 Field View | |
| FINS_DDIC_FIELD_LIST | view_entity | from | Fields & data elements of DDIC structure | |
| fiscds_trk_fld_text | view | from | Changed Field Name of Dcoument | |
| I_APJ_JOB_USR_HISTORY | view_entity | left_outer | Job User Change History | |
| I_APS_COM_STRUCTURE_COMPONENT | view_entity | from | DDIC Structure | |
| I_CAUploadTableFieldDefinition | view_entity | from | BASIC | Upload Tabellenfelder |
| I_CN_CADECustomArchiveValue | view | from | BASIC | Customize Archive Name for CADE |
| I_CnsldtnPstRlCndnCustField | view_entity | from | BASIC | Rule Conditions Custom Fields |
| I_CnsldtnPstRlFieldDataElement | view_entity | from | BASIC | Mapping Field to Data Element |
| I_CnsPstRlCnsUntCustFieldVH | view_entity | from | BASIC | Rule Consolidation Unit Custom Fields |
| I_DD_RUT_RC_OVERVIEW_LIST | view_entity | inner | ABAP Dictionary: List attr rel obj | |
| I_DDMaterialDocumentFieldName | view_entity | from | BASIC | Material Document Fields |
| I_DRFFilterObjectFieldName | view_entity | inner | BASIC | DRF Filter Object Fields |
| I_IHBAccountFieldLabel | view_entity | from | BASIC | IHB Account Field Label for CDocs |
| I_IHBMstrDataObjFieldLabel | view_entity | from | BASIC | IHB MD object Field Label for CDocs |
| I_JITSortVariantFields | view_entity | union_all | BASIC | List of valid Sort Fields |
| I_JITSortVariantFields | view_entity | from | BASIC | List of valid Sort Fields |
| I_JITVerificatPrflHdrObjectID | view_entity | from | BASIC | List of valid Header Object Identifiers |
| I_JITVerificatPrflHdrObjectID | view_entity | union_all | BASIC | List of valid Header Object Identifiers |
| I_JITVerificatPrflItmObjectID | view_entity | union_all | BASIC | List of valid Item Object Identifiers |
| I_JITVerificatPrflItmObjectID | view_entity | from | BASIC | List of valid Item Object Identifiers |
| I_MDChangeProcessModelField | view | left_outer | COMPOSITE | Process model field |
| I_MDChangeProcessModelFieldVH | view | inner | BASIC | Process model field value help |
| I_MDChgProcModelFieldExtension | view | from | BASIC | MD Model Field Ext |
| I_MDQltyBusRuleChkdFieldText | view_entity | inner | BASIC | Master Data Quality Checked Field Text |
| I_MDQltyModelFieldText | view | inner | BASIC | Text for Model Fields |
| I_PaymentRunPlanSelectionField | view | from | BASIC | Free Selection Field |
| I_ProcmtAutomnSAPObjFieldVH | view | inner | BASIC | Base view for SAP Object Type Field |
| I_RU_CashFlowParameter | view_entity | from | BASIC | Cash Flow Statement Parameter |
| I_RU_CashFlowParameterText | view_entity | from | BASIC | Cash Flow Statement Parameter - Text |
| I_SCBO_ASSOCIATION_CBO1 | view_entity | left_outer | Custom Business Objects: Associable CBO1 | |
| I_SCBO_ASSOCIATION_CBO2 | view_entity | left_outer | Custom Business Objects: Associable CBO2 | |
| I_SlsPricingConditionFieldText | view | from | BASIC | Sales Pricing Field Catalog - Text |
| I_UniversalAllocationFieldText | view_entity | from | BASIC | Allocation Field - Text |
| P_AccrEngineObjTypeParamField | view | from | BASIC | Accrual Engine Accrual Object Type Parameter Fields |
| P_Bomchangehistory | view | left_outer | COMPOSITE | Change History of BOM |
| P_BusEvtLogTableFieldDef | view_entity | from | BASIC | CDS View for DD03L entries |
| P_CITJournalEntryField | view | from | BASIC | CIT Journal Entry Field |
| P_CITJournalEntryFieldT | view | from | BASIC | CIT Journal Entry Field Text |
| P_CN_CADESubsidiaryAcctItmName | view | from | BASIC | CADE Subsidiary Accounting Item Name |
| P_DataElementText | view | from | BASIC | Data Element Texts |
| P_JOURNALENTRYFIELDTEXT | view | from | BASIC | JE Change History for field text |
| P_SAIS_DOBJ_FLD_F4 | view | union | Generic Audit Filter - Fields in Data Object | |
| P_XB_GeneralLedgerFieldsGroup | view_entity | from | BASIC | General Ledger Fields Group |
| P_XB_MaterialLedgerFieldsGroup | view_entity | from | BASIC | Material Ledger Fields Group |
| SAIS_DDIC_WUSL | view_entity | inner | Get User Authorization Change Documents | |
| SAIS_GET_DD03L_INTLEN | view | from | Get DDIC Column Length as INT4 value | |
| sdsh_cds_table_fields_info | view_entity | inner | Detailed Information about Table/View fields | |
| SMTR_TT_DBT_FIELD | view_entity | from | MTR Text Table: Database table field | |
| VC_INTEGRATION_DD04T | view | left_outer | Extraction for DD04T | |
| VC_INTEGRATION_DD07T_CPS | view | left_outer | Extraction view for DD07T filtered | |
| VFCLM_BAM_DDL_CDPOS | view | left_outer | Change Position |
Fields (31)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | tabname | tabname | Table Name | |||
| KEY | fieldname | fieldname | Field Name | |||
| KEY | as4local | as4local | Activation State | |||
| KEY | as4vers | as4vers | Version | |||
| KEY | position | tabfdpos | Table position | |||
| keyflag | keyflag | Key field | ||||
| mandatory | mandatory | Required Field | ||||
| rollname | rollname | Data Element | ||||
| checktable | checktable | Check table | ||||
| adminfield | adminfield | Admin. field | ||||
| inttype | inttype | ABAP type | ||||
| intlen | intlen | Internal Length | ||||
| reftable | reftable | Reference table | ||||
| precfield | precfield | Name of include | ||||
| reffield | reffield | Ref. field | ||||
| conrout | conrout | Check module | ||||
| notnull | notnull | NOT NULL forced | ||||
| datatype | datatype_d | Data Type | ||||
| leng | ddleng | No. of Characters | ||||
| decimals | decimals | Decimal Places | ||||
| domname | domname | Domain | ||||
| shlporigin | shlporigin | Origin | ||||
| tabletype | ddtabtype | Table | ||||
| depth | typedepth | Depth | ||||
| comptype | comptype | CompTyp | ||||
| reftype | ddreftype | Ref.Type (Coded) | ||||
| languflag | ddlanguflg | Text Lang. | ||||
| dbposition | tabfdpos | Table position | ||||
| anonymous | ddanonym | Anonymous | ||||
| outputstyle | outputstyle | Output | ||||
| srs_id | srs_id | SRS ID |
Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.
-- Tabellenfelder
-- Category TRANSPARENT · Delivery class W
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE DD03L (
TABNAME, -- Table Name [tabname]
FIELDNAME, -- Field Name [fieldname]
AS4LOCAL, -- Activation State [as4local]
AS4VERS, -- Version [as4vers]
POSITION, -- Table position [tabfdpos]
KEYFLAG, -- Key field [keyflag]
MANDATORY, -- Required Field [mandatory]
ROLLNAME, -- Data Element [rollname]
CHECKTABLE, -- Check table [checktable]
ADMINFIELD, -- Admin. field [adminfield]
INTTYPE, -- ABAP type [inttype]
INTLEN, -- Internal Length [intlen]
REFTABLE, -- Reference table [reftable]
PRECFIELD, -- Name of include [precfield]
REFFIELD, -- Ref. field [reffield]
CONROUT, -- Check module [conrout]
NOTNULL, -- NOT NULL forced [notnull]
DATATYPE, -- Data Type [datatype_d]
LENG, -- No. of Characters [ddleng]
DECIMALS, -- Decimal Places [decimals]
DOMNAME, -- Domain [domname]
SHLPORIGIN, -- Origin [shlporigin]
TABLETYPE, -- Table [ddtabtype]
DEPTH, -- Depth [typedepth]
COMPTYPE, -- CompTyp [comptype]
REFTYPE, -- Ref.Type (Coded) [ddreftype]
LANGUFLAG, -- Text Lang. [ddlanguflg]
DBPOSITION, -- Table position [tabfdpos]
ANONYMOUS, -- Anonymous [ddanonym]
OUTPUTSTYLE, -- Output [outputstyle]
SRS_ID, -- SRS ID [srs_id]
PRIMARY KEY (TABNAME, FIELDNAME, AS4LOCAL, AS4VERS, POSITION)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA