I_SettlmtAddlRefDocCat

DDL: I_SETTLMTADDLREFDOCCAT Type: view_entity BASIC
3 Fields 1 Data Sources 1 Associations

Additional Reference Document Category

I_SettlmtAddlRefDocCat is a Basic CDS View (Dimension) that provides data about "Additional Reference Document Category" in SAP S/4HANA. It reads from 1 data source (dd07l) and exposes 3 fields with key field SettlmtAddlRefDocCat. It has 1 association to related views.

SAP Help Documentation

CategorySettlement Management Document
Data CategoryDimension
StatusReleased
Purpose
This CDS view is used to select the additional reference document category. This CDS view provides the parameters for the domain WLF_REF_TYPE_2 with the following values: 01 Invoice 02 Invoice Reversal 03 Credit Memo 04 Credit Memo Reversal 05 Settlement Document List 06 Credit Memo List 07 Settlement Management Document with Journal Entry 10 Trading Contract 11 Settlement Management Document 12 Sales Order/Contract 13 Delivery 14 Billing Document 15 Inbound Delivery 16 Goods Receipt 17 Purchase Order/Contract 18 Shipment Document 19 Internal Order (CO) 20 Pro Forma Customer Sales Document 21 CRM Billing Document 22 Provider Contract 23 Convergent Invoicing 30 Incoming Invoice 31 Service Entry Sheet 60 Nomination 61 Nomination Item 70 Condition Contract 71 Claim Request Document 72 Claim Resolution Document 80 Freight Settlement 81 Freight Order 82 Internal Settlement Document 99 External Document

Prerequisites
There are no prerequisites.

Structure
Measures and attributes Some important measures and attributes are: Settlement Additional Reference Document Category ( SettlmtAddlRefDocCat )

View on SAP Help Portal →

Data Sources (1)

SourceAliasJoin Type
dd07l dd07l from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_SettlmtAddlRefDocCatText _Text

Annotations (17)

NameValueLevelField
EndUserText.label Additional Reference Document Category view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.representativeKey SettlmtAddlRefDocCat view
ObjectModel.modelingPattern #ANALYTICAL_DIMENSION view
ObjectModel.usageType.dataClass #META view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.resultSet.sizeCategory #XS view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
Search.searchable true view
Analytics.dataCategory #DIMENSION view
Analytics.dataExtraction.enabled false view
Analytics.internalName #LOCAL view
Analytics.technicalName IWLFADREFDOCCAT view
Metadata.ignorePropagatedAnnotations true view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY SettlmtAddlRefDocCat
DomainValue dd07l domvalue_l Lower Value
_Text _Text

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_SettlmtAddlRefDocCat.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW I_SettlmtAddlRefDocCat AS
SELECT
  cast( substring(dd07l.domvalue_l, 1, 2) as wlf_ref_type_2 preserving type ) AS SettlmtAddlRefDocCat,
  dd07l.domvalue_l AS DomainValue
FROM dd07l
LEFT OUTER JOIN I_SettlmtAddlRefDocCatText AS _Text ON /* condition not available in parsed metadata */  -- association [0..*]
;

Learn More