What is C_ExpnSettlmtItemOutputForm in SAP S/4HANA?

C_ExpnSettlmtItemOutputForm is a consumption CDS view in SAP S/4HANA. Expense Settlement Item Output Form It contains 140 fields.

Which tables does C_ExpnSettlmtItemOutputForm read from?

C_ExpnSettlmtItemOutputForm reads data from: R_ExpnSettlmtItem.

What VDM layer is C_ExpnSettlmtItemOutputForm?

C_ExpnSettlmtItemOutputForm is classified as a Consumption view optimized for specific business scenarios and reporting.

C_ExpnSettlmtItemOutputForm

DDL: C_EXPNSETTLMTITEMOUTPUTFORM Type: view CONSUMPTION

140 Fields 1 Data Sources 15 Associations

Expense Settlement Item Output Form

C_ExpnSettlmtItemOutputForm is a Consumption CDS View that provides data about "Expense Settlement Item Output Form" in SAP S/4HANA. It reads from 1 data source (R_ExpnSettlmtItem) and exposes 140 fields with key fields ExpnSettlmt, ExpnSettlmtItem. It has 15 associations to related views.

Data Sources (1)

Source	Alias	Join Type
R_ExpnSettlmtItem	R_ExpnSettlmtItem	from

Associations (15)

Cardinality	Target	Alias	Condition
[1..1]	C_ExpnSettlmtOutputForm	_ExpnSettlmt	`$projection.ExpnSettlmt = _ExpnSettlmt.ExpnSettlmt`
[0..*]	I_ExpnSettlmtItemPlainLongText	_ExpnSettlmtItemPlainLongText	`$projection.ExpnSettlmt = _ExpnSettlmtItemPlainLongText.ExpnSettlmt and $projection.ExpnSettlmtItem = _ExpnSettlmtItemPlainLongText.ExpnSettlmtItem`
[0..*]	I_ExpnSettlmtItemPartner	_ExpnSettlmtItemPartner	`$projection.ExpnSettlmt = _ExpnSettlmtItemPartner.ExpnSettlmt and $projection.ExpnSettlmtItem = _ExpnSettlmtItemPartner.ExpnSettlmtItem`
[0..1]	I_SettlmtItmStatisticalPrpty	_SettlmtItmStatisticalPrpty	`$projection.SettlmtItmStatisticalPrpty = _SettlmtItmStatisticalPrpty.SettlmtItmStatisticalPrpty`
[0..1]	I_SettlmtActivityReasonCode	_SettlmtItemActivityReason	`$projection.SettlmtItemActivityReason = _SettlmtItemActivityReason.SettlmtActivityReason`
[0..*]	I_ExpnSettlmtItmPrcgElmnt	_ExpnSettlmtItmPrcgElmnt	`$projection.ExpnSettlmt = _ExpnSettlmtItmPrcgElmnt.ExpnSettlmt and $projection.ExpnSettlmtItem = _ExpnSettlmtItmPrcgElmnt.ExpnSettlmtItem`
[0..1]	I_SettlmtMgmtDocItemCancld	_ExpnSettlmtItmCancld	`$projection.ExpnSettlmtItmCancld = _ExpnSettlmtItmCancld.SettlmtMgmtDocItemCancld`
[0..1]	C_ExpnSettlmtItemOutputForm	_HigherLevelItem	`$projection.ExpnSettlmt = _HigherLevelItem.ExpnSettlmt and $projection.HigherLevelItem = _HigherLevelItem.ExpnSettlmtItem`
[0..1]	I_BusinessArea	_CustSettlmtBusinessArea	`$projection.CustSettlmtBusinessArea = _CustSettlmtBusinessArea.BusinessArea`
[0..1]	I_ControllingArea	_CustSettlmtControllingArea	`$projection.CustSettlmtControllingArea = _CustSettlmtControllingArea.ControllingArea`
[0..1]	I_CostCenter	_CustSettlmtCostCenter	`$projection.CustSettlmtCostCenter = _CustSettlmtCostCenter.CostCenter and $projection.CustSettlmtControllingArea = _CustSettlmtCostCenter.ControllingArea and _CustSettlmtCostCenter.ValidityEndDate >= $projection.CreationDate and _CustSettlmtCostCenter.ValidityStartDate <= $projection.CreationDate`
[0..1]	I_ProfitCenter	_CustSettlmtProfitCenter	`$projection.CustSettlmtProfitCenter = _CustSettlmtProfitCenter.ProfitCenter and $projection.CustSettlmtControllingArea = _CustSettlmtProfitCenter.ControllingArea and _CustSettlmtProfitCenter.ValidityEndDate >= $projection.CreationDate and _CustSettlmtProfitCenter.ValidityStartDate <= $projection.CreationDate`
[0..1]	I_InternalOrder	_SettlmtMgmtOrder	`$projection.SettlmtMgmtOrder = _SettlmtMgmtOrder.InternalOrder`
[0..1]	I_WBSElementBasicData	_CustSettlmtWBSElmntBasicData	`$projection.CustSettlmtWBSElmntInternalID = _CustSettlmtWBSElmntBasicData.WBSElementInternalID`
[1..1]	E_SettlmtMgmtDocItem	_Extension	`$projection.ExpnSettlmt = _Extension.SettlmtMgmtDoc and $projection.ExpnSettlmtItem = _Extension.SettlmtMgmtDocItem`

Annotations (15)

Name	Value	Level
AbapCatalog.sqlViewName	CWLFEXPNSMTITMOF	view
AbapCatalog.compiler.compareFilter	true	view
AbapCatalog.preserveKey	true	view
EndUserText.label	Expense Settlement Item Output Form	view
AccessControl.authorizationCheck	#MANDATORY	view
ObjectModel.representativeKey	ExpnSettlmtItem	view
ObjectModel.usageType.serviceQuality	#B	view
ObjectModel.usageType.dataClass	#TRANSACTIONAL	view
ObjectModel.usageType.sizeCategory	#XXL	view
ClientHandling.type	#INHERITED	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
VDM.viewType	#CONSUMPTION	view
VDM.lifecycle.contract.type	#NONE	view
Metadata.ignorePropagatedAnnotations	true	view
Metadata.allowExtensions	false	view

Fields (140)

Key	Field	Source Field	Description
KEY	ExpnSettlmt	ExpnSettlmt
KEY	ExpnSettlmtItem	ExpnSettlmtItem	Item
	ExpnSettlmtCurrency	ExpnSettlmtCurrency	Doc. Currency
	CustomerPricingDocument	PricingDocument	Document Condition
	Product	Product	Product Sold
	ProductGroup	ProductGroup	Product Sold Group
	Plant	Plant	Valuation Area
	InventoryValuationType	InventoryValuationType	Valuation Type
	PricingDate	PricingDate	Pricing Date
	CustomerTaxCode	TaxCode	Tax Code
	TaxCountry	TaxCountry	Tax Ctry/Reg.
	TaxJurisdiction	TaxJurisdiction	Tax Jurisdiction
	SettlmtQuantity	SettlmtQuantity	SettlmtQuantity
	SettlmtQuantityUnit	SettlmtQuantityUnit	Settlement Unit
	NetPriceAmount	NetPriceAmount	Net Price
	NetPriceQuantity	NetPriceQuantity	Price Unit
	NetPriceQuantityUnit	NetPriceQuantityUnit	SettlmtPrcUnit
	SettlmtToBaseQuantityNmrtr	SettlmtToBaseQuantityNmrtr	Numerator Settlement UoM to Base UoM
	SettlmtToBaseQuantityDnmntr	SettlmtToBaseQuantityDnmntr	Denominator Settlement UoM to Base UoM
	SettlmtToNetPriceQtyNmrtr	SettlmtToNetPriceQtyNmrtr	Numerator: Sett. UoM to Sett. Price UoM
	SettlmtToNetPriceQtyDnmntr	SettlmtToNetPriceQtyDnmntr	Denominator: Sett. UoM to Sett. PriceUoM
	BaseUnit	BaseUnit	Unit of Measure
	ItemNetWeight	ItemNetWeight	Net Weight
	ItemGrossWeight	ItemGrossWeight	Gross Weight
	ItemWeightUnit	ItemWeightUnit	Unit of Weight
	ItemVolume	ItemVolume	Volume
	ItemVolumeUnit	ItemVolumeUnit	Volume Unit
	ProductPurchasePointsQtyUnit	ProductPurchasePointsQtyUnit	Points Unit
	ProductPurchasePointsQty	ProductPurchasePointsQty	Points
	CustomerItemGrossAmount	ExpnSettlmtItemGrossAmount
	CustomerItemNetAmount	ExpenseSettlementItemNetAmount
	CustomerItemTaxAmount	ExpenseSettlementItemTaxAmount
	CustomerSubtotal1Amount	ExpnSettlmtSubtotal1Amount
	CustomerSubtotal2Amount	ExpnSettlmtSubtotal2Amount
	CustomerSubtotal3Amount	ExpnSettlmtSubtotal3Amount
	CustomerSubtotal4Amount	ExpnSettlmtSubtotal4Amount
	CustomerSubtotal5Amount	ExpnSettlmtSubtotal5Amount
	CustomerSubtotal6Amount	ExpnSettlmtSubtotal6Amount
	CustomerRebateBasisAmount	ExpnSettlmtRebateBasisAmount
	CustomerEffectiveItemAmount	ExpnSettlmtEffectiveItemAmount	Supplier Effective Item Amount
	CustItmEligibleAmtForCshDisc	CustItmEligibleAmtForCshDisc	Cash Disc. Base
	NonDeductibleInputTaxAmount	NonDeductibleInputTaxAmount	Non-deductible
	SettlmtItmStatisticalPrpty	ExpnSettlmtItmStstclPrpty	Statistical Prpty
	CashDiscountIsDeductible	CashDiscountIsDeductible	Cash Discount
	CreatedByUser	CreatedByUser	User Name
	CreationDate	CreationDate	Time Stamp
	CreationTime	CreationTime	Time of Change
	SettlmtSourceDoc	SettlmtSourceDoc	Source Doc.
	SettlmtSourceDocItem	SettlmtSourceDocItem	Item of the Source Document
	SettlmtSourceDocCat	SettlmtSourceDocCat	SourceDocCat
	SettlmtSourceDocFiscalYear	SettlmtSourceDocFiscalYear	Fiscal Year of Source Document
	SettlmtItemActivityReason	ExpnSettlmtItemActivityReason	Activity Reason
	ExpnSettlmtItemText	ExpnSettlmtItemText
	CustSettlmtBusinessArea	BusinessArea	Business Area
	CustSettlmtControllingArea	ControllingArea	Controlling Area
	CustSettlmtCostCenter	CostCenter	Cost Center
	CustSettlmtProfitCenter	ProfitCenter	Profit Center
	CustSettlmtWBSElmntInternalID	WBSElementInternalID	WBS Internal ID
	SettlmtMgmtOrder	ExpenseSettlementOrder
	IncotermsVersion	IncotermsVersion	Inco. Version
	IncotermsClassification	IncotermsClassification	Incoterms
	IncotermsTransferLocation	IncotermsTransferLocation	Incoterms 2
	IncotermsLocation1	IncotermsLocation1	Inco. Location1
	IncotermsLocation2	IncotermsLocation2	Inco. Location2
	Batch	Batch	Lot No.
	PrcDetnIsIncmplt	PrcDetnIsIncmplt	Price Determination Is Incomplete
	SettlmtPrecdgDoc	SettlmtPrecdgDoc	Pre. Document
	SettlmtPrecdgDocItem	SettlmtPrecdgDocItem	Item of Preceding Document
	SettlmtPrecdgDocCat	SettlmtPrecdgDocCat	PreDocCat
	SettlmtPrecdgDocFiscalYear	SettlmtPrecdgDocFiscalYear	Fiscal Year of Preceding Document
	ExpnSettlmtItmCat	ExpnSettlmtItmCat
	SettlmtItemReltdTrdgContr	SettlmtItemReltdTrdgContr
	SettlmtItemReltdTrdgContrItem	SettlmtItemReltdTrdgContrItem
	ExpnSettlmtItemStatus	ExpnSettlmtItemStatus
	ExpnSettlmtItmCancld	ExpenseSettlementItemReversed
	ServicesRenderedDate	ServicesRenderedDate	Services Rendered Date
	SettlementFiscalYear	SettlementFiscalYear	Fiscal Year of Settlement
	HigherLevelItem	HigherLevelItem	Higher-Lev.Item
	LowerLevelItemExists	LowerLevelItemExists	Subitems
	ItemDistributionStatus	ItemDistributionStatus	Distributn Status
	SettlmtRefDoc	SettlmtRefDoc	Settlmt. Ref. Doc.
	SettlmtRefDocFiscalYear	SettlmtRefDocFiscalYear	Year of Reference Document
	SettlmtRefDocLogicalSyst	SettlmtRefDocLogicalSyst	SM Ref Log Sys
	SettlmtRefDocItem	SettlmtRefDocItem	SettlmtRefDocItem
	SettlmtRefDocCat	SettlmtRefDocCat	SettlmtRefDocCat
	ItemIntrastatRelevance	ItemIntrastatRelevance	Item Intrastat Relevance
	SettlmtAddlRefDoc	SettlmtAddlRefDoc	SettlmtAddlRefDoc
	SettlmtAddlRefDocFiscalYear	SettlmtAddlRefDocFiscalYear	Year of Additional Reference Document
	SettlmtAddlRefDocLogicalSyst	SettlmtAddlRefDocLogicalSyst	SM Addl Ref Log Sys
	SettlmtAddlRefDocItem	SettlmtAddlRefDocItem	SettlmtAddlRefDocItm
	SettlmtAddlRefDocCat	SettlmtAddlRefDocCat	SettlmtAddlRefDocCat
	CustomerSettlmtRecipient	CustomerSettlmtRecipient	Cust Settlmt Recpnt
	ProductHierarchy	ProductHierarchy	Prod.hierarchy
	SalesSpcfcProductGroup1	SalesSpcfcProductGroup1	Sales-Specific Product Group 1
	SalesSpcfcProductGroup2	SalesSpcfcProductGroup2	Sales-Specific Product Group 2
	SalesSpcfcProductGroup3	SalesSpcfcProductGroup3	Sales-Specific Product Group 3
	SalesSpcfcProductGroup4	SalesSpcfcProductGroup4	Sales-Specific Product Group 4
	SalesSpcfcProductGroup5	SalesSpcfcProductGroup5	Sales-Specific Product Group 5
	_ExpnSettlmt	_ExpnSettlmt
	_ExpnSettlmtItemPlainLongText	_ExpnSettlmtItemPlainLongText
	_ExpnSettlmtItemPartner	_ExpnSettlmtItemPartner
	_SettlmtItmStatisticalPrpty	_SettlmtItmStatisticalPrpty
	_SettlmtItemActivityReason	_SettlmtItemActivityReason
	_ExpnSettlmtItmPrcgElmnt	_ExpnSettlmtItmPrcgElmnt
	_ExpnSettlmtCurrency	_ExpnSettlmtCurrency
	_Product	_Product
	_Plant	_Plant
	_InventoryValuationType	_InventoryValuationType
	_SettlmtQuantityUnit	_SettlmtQuantityUnit
	_NetPriceQuantityUnit	_NetPriceQuantityUnit
	_BaseUnit	_BaseUnit
	_ItemWeightUnit	_ItemWeightUnit
	_ItemVolumeUnit	_ItemVolumeUnit
	_ProductPurchasePointsQtyUnit	_ProductPurchasePointsQtyUnit
	_SettlmtSourceDocCat	_SettlmtSourceDocCat
	_CustSettlmtBusinessArea	_CustSettlmtBusinessArea
	_CustSettlmtControllingArea	_CustSettlmtControllingArea
	_CustSettlmtCostCenter	_CustSettlmtCostCenter
	_CustSettlmtProfitCenter	_CustSettlmtProfitCenter
	_CustSettlmtWBSElmntBasicData	_CustSettlmtWBSElmntBasicData
	_SettlmtMgmtOrder	_SettlmtMgmtOrder
	_IncotermsVersion	_IncotermsVersion
	_IncotermsClassification	_IncotermsClassification
	_SettlmtPrecdgDocCat	_SettlmtPrecdgDocCat
	_ExpnSettlmtItmCat	_ExpnSettlmtItmCat
	_ExpnSettlmtItemStatus	_ExpnSettlmtItemStatus
	_ExpnSettlmtItmCancld	_ExpnSettlmtItmCancld
	_HigherLevelItem	_HigherLevelItem
	_ItemDistributionStatus	_ItemDistributionStatus
	_SettlmtRefDocLogicalSyst	_SettlmtRefDocLogicalSyst
	_SettlmtRefDocCat	_SettlmtRefDocCat
	_ItemIntrastatRelevance	_ItemIntrastatRelevance
	_SettlmtAddlRefDocLogicalSyst	_SettlmtAddlRefDocLogicalSyst
	_SettlmtAddlRefDocCat	_SettlmtAddlRefDocCat
	_CustomerSettlmtRecipient	_CustomerSettlmtRecipient
	_SalesSpcfcProductGroup1	_SalesSpcfcProductGroup1
	_SalesSpcfcProductGroup2	_SalesSpcfcProductGroup2
	_SalesSpcfcProductGroup3	_SalesSpcfcProductGroup3
	_SalesSpcfcProductGroup4	_SalesSpcfcProductGroup4
	_SalesSpcfcProductGroup5	_SalesSpcfcProductGroup5

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 C_ExpnSettlmtItemOutputForm.
-- 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 C_ExpnSettlmtItemOutputForm AS
SELECT
  ExpnSettlmt,
  ExpnSettlmtItem,
  ExpnSettlmtCurrency,
  PricingDocument AS CustomerPricingDocument,
  Product,
  ProductGroup,
  Plant,
  InventoryValuationType,
  PricingDate,
  TaxCode AS CustomerTaxCode,
  TaxCountry,
  TaxJurisdiction,
  SettlmtQuantity,
  SettlmtQuantityUnit,
  NetPriceAmount,
  NetPriceQuantity,
  NetPriceQuantityUnit,
  SettlmtToBaseQuantityNmrtr,
  SettlmtToBaseQuantityDnmntr,
  SettlmtToNetPriceQtyNmrtr,
  SettlmtToNetPriceQtyDnmntr,
  BaseUnit,
  ItemNetWeight,
  ItemGrossWeight,
  ItemWeightUnit,
  ItemVolume,
  ItemVolumeUnit,
  ProductPurchasePointsQtyUnit,
  ProductPurchasePointsQty,
  ExpnSettlmtItemGrossAmount AS CustomerItemGrossAmount,
  ExpenseSettlementItemNetAmount AS CustomerItemNetAmount,
  ExpenseSettlementItemTaxAmount AS CustomerItemTaxAmount,
  ExpnSettlmtSubtotal1Amount AS CustomerSubtotal1Amount,
  ExpnSettlmtSubtotal2Amount AS CustomerSubtotal2Amount,
  ExpnSettlmtSubtotal3Amount AS CustomerSubtotal3Amount,
  ExpnSettlmtSubtotal4Amount AS CustomerSubtotal4Amount,
  ExpnSettlmtSubtotal5Amount AS CustomerSubtotal5Amount,
  ExpnSettlmtSubtotal6Amount AS CustomerSubtotal6Amount,
  ExpnSettlmtRebateBasisAmount AS CustomerRebateBasisAmount,
  ExpnSettlmtEffectiveItemAmount AS CustomerEffectiveItemAmount,
  CustItmEligibleAmtForCshDisc,
  NonDeductibleInputTaxAmount,
  ExpnSettlmtItmStstclPrpty AS SettlmtItmStatisticalPrpty,
  CashDiscountIsDeductible,
  CreatedByUser,
  CreationDate,
  CreationTime,
  SettlmtSourceDoc,
  SettlmtSourceDocItem,
  SettlmtSourceDocCat,
  SettlmtSourceDocFiscalYear,
  ExpnSettlmtItemActivityReason AS SettlmtItemActivityReason,
  ExpnSettlmtItemText,
  BusinessArea AS CustSettlmtBusinessArea,
  ControllingArea AS CustSettlmtControllingArea,
  CostCenter AS CustSettlmtCostCenter,
  ProfitCenter AS CustSettlmtProfitCenter,
  WBSElementInternalID AS CustSettlmtWBSElmntInternalID,
  ExpenseSettlementOrder AS SettlmtMgmtOrder,
  IncotermsVersion,
  IncotermsClassification,
  IncotermsTransferLocation,
  IncotermsLocation1,
  IncotermsLocation2,
  Batch,
  PrcDetnIsIncmplt,
  SettlmtPrecdgDoc,
  SettlmtPrecdgDocItem,
  SettlmtPrecdgDocCat,
  SettlmtPrecdgDocFiscalYear,
  ExpnSettlmtItmCat,
  SettlmtItemReltdTrdgContr,
  SettlmtItemReltdTrdgContrItem,
  ExpnSettlmtItemStatus,
  ExpenseSettlementItemReversed AS ExpnSettlmtItmCancld,
  ServicesRenderedDate,
  SettlementFiscalYear,
  HigherLevelItem,
  LowerLevelItemExists,
  ItemDistributionStatus,
  SettlmtRefDoc,
  SettlmtRefDocFiscalYear,
  SettlmtRefDocLogicalSyst,
  SettlmtRefDocItem,
  SettlmtRefDocCat,
  ItemIntrastatRelevance,
  SettlmtAddlRefDoc,
  SettlmtAddlRefDocFiscalYear,
  SettlmtAddlRefDocLogicalSyst,
  SettlmtAddlRefDocItem,
  SettlmtAddlRefDocCat,
  CustomerSettlmtRecipient,
  ProductHierarchy,
  SalesSpcfcProductGroup1,
  SalesSpcfcProductGroup2,
  SalesSpcfcProductGroup3,
  SalesSpcfcProductGroup4,
  SalesSpcfcProductGroup5
FROM R_ExpnSettlmtItem
LEFT OUTER JOIN C_ExpnSettlmtOutputForm AS _ExpnSettlmt ON ExpnSettlmt = _ExpnSettlmt.ExpnSettlmt  -- association [1..1]
LEFT OUTER JOIN I_ExpnSettlmtItemPlainLongText AS _ExpnSettlmtItemPlainLongText ON ExpnSettlmt = _ExpnSettlmtItemPlainLongText.ExpnSettlmt AND ExpnSettlmtItem = _ExpnSettlmtItemPlainLongText.ExpnSettlmtItem  -- association [0..*]
LEFT OUTER JOIN I_ExpnSettlmtItemPartner AS _ExpnSettlmtItemPartner ON ExpnSettlmt = _ExpnSettlmtItemPartner.ExpnSettlmt AND ExpnSettlmtItem = _ExpnSettlmtItemPartner.ExpnSettlmtItem  -- association [0..*]
LEFT OUTER JOIN I_SettlmtItmStatisticalPrpty AS _SettlmtItmStatisticalPrpty ON SettlmtItmStatisticalPrpty = _SettlmtItmStatisticalPrpty.SettlmtItmStatisticalPrpty  -- association [0..1]
LEFT OUTER JOIN I_SettlmtActivityReasonCode AS _SettlmtItemActivityReason ON SettlmtItemActivityReason = _SettlmtItemActivityReason.SettlmtActivityReason  -- association [0..1]
LEFT OUTER JOIN I_ExpnSettlmtItmPrcgElmnt AS _ExpnSettlmtItmPrcgElmnt ON ExpnSettlmt = _ExpnSettlmtItmPrcgElmnt.ExpnSettlmt AND ExpnSettlmtItem = _ExpnSettlmtItmPrcgElmnt.ExpnSettlmtItem  -- association [0..*]
LEFT OUTER JOIN I_SettlmtMgmtDocItemCancld AS _ExpnSettlmtItmCancld ON ExpnSettlmtItmCancld = _ExpnSettlmtItmCancld.SettlmtMgmtDocItemCancld  -- association [0..1]
LEFT OUTER JOIN C_ExpnSettlmtItemOutputForm AS _HigherLevelItem ON ExpnSettlmt = _HigherLevelItem.ExpnSettlmt AND HigherLevelItem = _HigherLevelItem.ExpnSettlmtItem  -- association [0..1]
LEFT OUTER JOIN I_BusinessArea AS _CustSettlmtBusinessArea ON CustSettlmtBusinessArea = _CustSettlmtBusinessArea.BusinessArea  -- association [0..1]
LEFT OUTER JOIN I_ControllingArea AS _CustSettlmtControllingArea ON CustSettlmtControllingArea = _CustSettlmtControllingArea.ControllingArea  -- association [0..1]
LEFT OUTER JOIN I_CostCenter AS _CustSettlmtCostCenter ON CustSettlmtCostCenter = _CustSettlmtCostCenter.CostCenter AND CustSettlmtControllingArea = _CustSettlmtCostCenter.ControllingArea AND _CustSettlmtCostCenter.ValidityEndDate >= CreationDate AND _CustSettlmtCostCenter.ValidityStartDate <= CreationDate  -- association [0..1]
LEFT OUTER JOIN I_ProfitCenter AS _CustSettlmtProfitCenter ON CustSettlmtProfitCenter = _CustSettlmtProfitCenter.ProfitCenter AND CustSettlmtControllingArea = _CustSettlmtProfitCenter.ControllingArea AND _CustSettlmtProfitCenter.ValidityEndDate >= CreationDate AND _CustSettlmtProfitCenter.ValidityStartDate <= CreationDate  -- association [0..1]
LEFT OUTER JOIN I_InternalOrder AS _SettlmtMgmtOrder ON SettlmtMgmtOrder = _SettlmtMgmtOrder.InternalOrder  -- association [0..1]
LEFT OUTER JOIN I_WBSElementBasicData AS _CustSettlmtWBSElmntBasicData ON CustSettlmtWBSElmntInternalID = _CustSettlmtWBSElmntBasicData.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN E_SettlmtMgmtDocItem AS _Extension ON ExpnSettlmt = _Extension.SettlmtMgmtDoc AND ExpnSettlmtItem = _Extension.SettlmtMgmtDocItem  -- association [1..1]
;

Depth:

C_ExpnSettlmtItemOutputForm view

R_ExpnSettlmtItem view