What is C_FrtCostAllocDocItemMonitor in SAP S/4HANA?

C_FrtCostAllocDocItemMonitor is a consumption CDS view in SAP S/4HANA. Monitor Freight Cost Allocation Doc Itms It contains 155 fields.

Which tables does C_FrtCostAllocDocItemMonitor read from?

C_FrtCostAllocDocItemMonitor reads data from: R_FrtCostAllocItm.

What VDM layer is C_FrtCostAllocDocItemMonitor?

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

C_FrtCostAllocDocItemMonitor

DDL: C_FRTCOSTALLOCDOCITEMMONITOR Type: view CONSUMPTION

155 Fields 1 Data Sources 2 Associations

Monitor Freight Cost Allocation Doc Itms

C_FrtCostAllocDocItemMonitor is a Consumption CDS View that provides data about "Monitor Freight Cost Allocation Doc Itms" in SAP S/4HANA. It reads from 1 data source (R_FrtCostAllocItm) and exposes 155 fields with key fields FreightCostAllocationDocument, FrtCostAllocDocumentItem. It has 2 associations to related views.

Data Sources (1)

Source	Alias	Join Type
R_FrtCostAllocItm	FrtCostAllocItm	from

Associations (2)

Cardinality	Target	Alias	Condition
[0..1]	I_CalendarDate	_CalendarDate	`$projection.PostingDate = _CalendarDate.CalendarDate`
[0..1]	I_User	_FrtCostAlcItmCreatedByUser	`$projection.FrtCostAlcItmCreatedByUser = _FrtCostAlcItmCreatedByUser.UserID`

Annotations (12)

Name	Value	Level
AbapCatalog.sqlViewName	CWLFFCADOCITMMON	view
AbapCatalog.compiler.compareFilter	true	view
AbapCatalog.preserveKey	true	view
VDM.viewType	#CONSUMPTION	view
ObjectModel.usageType.dataClass	#MIXED	view
ObjectModel.usageType.serviceQuality	#C	view
ObjectModel.usageType.sizeCategory	#XXL	view
ClientHandling.type	#INHERITED	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
AccessControl.authorizationCheck	#MANDATORY	view
EndUserText.label	Monitor Freight Cost Allocation Doc Itms	view
Metadata.allowExtensions	false	view

Fields (155)

Key	Field	Source Table	Source Field	Description
KEY	FreightCostAllocationDocument	R_FrtCostAllocItm	FreightCostAllocationDocument	Freight Cost Allocation Document
KEY	FrtCostAllocDocumentItem	R_FrtCostAllocItm	FrtCostAllocDocumentItem	Item
	SettlmtDocType	FrtCostAllocDoc	SettlmtDocType	Settlement Document Type
	SettlmtDocCat	FrtCostAllocDoc	SettlmtDocCat	Settlement Document Category
	SettlmtProcessType	FrtCostAllocDoc	SettlmtProcessType	Settlement Process Type
	SettlmtProcessCat	FrtCostAllocDoc	SettlmtProcessCat	Settlement Process Category
	PostingDate	FrtCostAllocDoc	PostingDate	Posting Date for GR
	FrtCostAllocAcctgTransfSts	FrtCostAllocDoc	FrtCostAllocAcctgTransfSts	Posting Status
	DocumentDate	FrtCostAllocDoc	DocumentDate	Journal Entry Date
	DocumentReferenceID	FrtCostAllocDoc	DocumentReferenceID	Reference
	AssignmentReference	FrtCostAllocDoc	AssignmentReference	Assignment Reference
	SettlmtApplSts	FrtCostAllocDoc	SettlmtApplSts	Appl. Status
	SettlmtApplStsGrp	FrtCostAllocDoc	SettlmtApplStsGrp	Status Group
	CompanyCode	R_FrtCostAllocItm	CompanyCode	Receiver Company Code
	PurchasingOrganization	FrtCostAllocDoc	PurchasingOrganization	Purchasing Organization
	PurchasingGroup	FrtCostAllocDoc	PurchasingGroup	Purchasing Group
	SalesOrganization	FrtCostAllocDoc	SalesOrganization	Sales Organization
	DistributionChannel	FrtCostAllocDoc	DistributionChannel	RefDistCh-Cust/Mat.
	Division	FrtCostAllocDoc	Division	Internal Division ID
	SalesOffice	FrtCostAllocDoc	SalesOffice	Sales Office
	SalesGroup	FrtCostAllocDoc	SalesGroup	Sales Group
	FrtCostAllocDocCurrency	FrtCostAllocDoc	FrtCostAllocDocCurrency	Document Currency
	ExchangeRate	FrtCostAllocDoc	ExchangeRate	Exchange rate
	ExchangeRateType	FrtCostAllocDoc	ExchangeRateType	Exch. Rate Type
	ExchangeRateIsFixed	FrtCostAllocDoc	ExchangeRateIsFixed	Fixed Exch.Rate
	ExchangeRateDate	FrtCostAllocDoc	ExchangeRateDate	Translatn Date
	FrtCostAllocDocTotGrossAmount	FrtCostAllocDoc	FrtCostAllocDocTotGrossAmount	Gross Amount
	FrtCostAllocDocTotalNetAmount	FrtCostAllocDoc	FrtCostAllocDocTotalNetAmount	Net Amount
	FrtCostAllocDocIsReversed	FrtCostAllocDoc	FrtCostAllocDocIsReversed	Document is Reversed
	RvsdFrtCostAllocDoc	FrtCostAllocDoc	RvsdFrtCostAllocDoc	Reversed Document
	FrtCostAllocDocActivityReason	FrtCostAllocDoc	FrtCostAllocDocActivityReason	Header Document Creation Activity Reason
	SettlmtClassificationCat	FrtCostAllocDoc	SettlmtClassificationCat	Classification Cat.
	FiscalPeriod	FrtCostAllocDoc	FiscalPeriod	Tax period
	FrtCostAllocDocIncmpltnsRsn	FrtCostAllocDoc	FrtCostAllocDocIncmpltnsRsn	Incomplete Rsn
	SettlmtRptgDisplayVariant
	FrtCostAllocBusProcCat	FrtCostAllocDoc	FrtCostAllocBusProcCat	Use Case Type
	FrtCostAllocAdjmtCat	FrtCostAllocDoc	FrtCostAllocAdjmtCat	Adjustment Category
	FrtCostAllocDocChangeState	FrtCostAllocDoc	FrtCostAllocDocChangeState	Change State
	CreationDate	FrtCostAllocDoc	CreationDate	Time Stamp
	CreatedByUser	FrtCostAllocDoc	CreatedByUser	User Name
	CreationTime	FrtCostAllocDoc	CreationTime	Time of Change
	LastChangeDate	FrtCostAllocDoc	LastChangeDate	Time Stamp
	FreightOrder
	FreightBooking
	Product	R_FrtCostAllocItm	Product	Product Sold
	FrtCostAllocDocItemText	R_FrtCostAllocItm	FrtCostAllocDocItemText	Short Text
	ProductGroup	R_FrtCostAllocItm	ProductGroup	Product Sold Group
	Plant	R_FrtCostAllocItm	Plant	Valuation Area
	InventoryValuationType	R_FrtCostAllocItm	InventoryValuationType	Valuation Type
	PricingDate	R_FrtCostAllocItm	PricingDate	Pricing Date
	SettlmtQuantity	R_FrtCostAllocItm	SettlmtQuantity	SettlmtQuantity
	SettlmtQuantityUnit	R_FrtCostAllocItm	SettlmtQuantityUnit	Settlement Unit
	NetPriceQuantity	R_FrtCostAllocItm	NetPriceQuantity	Price Unit
	NetPriceQuantityUnit	R_FrtCostAllocItm	NetPriceQuantityUnit	SettlmtPrcUnit
	SettlmtToBaseQuantityNmrtr	R_FrtCostAllocItm	SettlmtToBaseQuantityNmrtr	Numerator Settlement UoM to Base UoM
	SettlmtToBaseQuantityDnmntr	R_FrtCostAllocItm	SettlmtToBaseQuantityDnmntr	Denominator Settlement UoM to Base UoM
	SettlmtToNetPriceQtyNmrtr	R_FrtCostAllocItm	SettlmtToNetPriceQtyNmrtr	Numerator: Sett. UoM to Sett. Price UoM
	SettlmtToNetPriceQtyDnmntr	R_FrtCostAllocItm	SettlmtToNetPriceQtyDnmntr	Denominator: Sett. UoM to Sett. PriceUoM
	BaseUnit	R_FrtCostAllocItm	BaseUnit	Unit of Measure
	ItemNetWeight	R_FrtCostAllocItm	ItemNetWeight	Net Weight
	ItemGrossWeight	R_FrtCostAllocItm	ItemGrossWeight	Gross Weight
	ItemWeightUnit	R_FrtCostAllocItm	ItemWeightUnit	Unit of Weight
	ItemVolume	R_FrtCostAllocItm	ItemVolume	Volume
	ItemVolumeUnit	R_FrtCostAllocItm	ItemVolumeUnit	Volume Unit
	FrtCostAllocItmStstclPrpty	R_FrtCostAllocItm	FrtCostAllocItmStstclPrpty	Statistical Prpty
	SettlmtSourceDoc	R_FrtCostAllocItm	SettlmtSourceDoc	Source Doc.
	SettlmtSourceDocItem	R_FrtCostAllocItm	SettlmtSourceDocItem	Item of the Source Document
	SettlmtSourceDocCat	R_FrtCostAllocItm	SettlmtSourceDocCat	SourceDocCat
	FrtCostAllocItmActivityReason	R_FrtCostAllocItm	FrtCostAllocItmActivityReason	Activity Reason
	BusinessArea	R_FrtCostAllocItm	BusinessArea	Business Area
	ControllingArea	R_FrtCostAllocItm	ControllingArea	Controlling Area
	CostCenter	R_FrtCostAllocItm	CostCenter	Cost Center
	ProfitCenter	R_FrtCostAllocItm	ProfitCenter	Profit Center
	WBSElementInternalID	R_FrtCostAllocItm	WBSElementInternalID	WBS Internal ID
	PrcDetnIsIncmplt	R_FrtCostAllocItm	PrcDetnIsIncmplt	Price Determination Is Incomplete
	SettlmtPrecdgDoc	R_FrtCostAllocItm	SettlmtPrecdgDoc	Pre. Document
	SettlmtPrecdgDocItem	R_FrtCostAllocItm	SettlmtPrecdgDocItem	Item of Preceding Document
	SettlmtPrecdgDocCat	R_FrtCostAllocItm	SettlmtPrecdgDocCat	PreDocCat
	FrtCostAllocDocItmCat	R_FrtCostAllocItm	FrtCostAllocDocItmCat	Item Category
	FreightCostAllocationOrder	R_FrtCostAllocItm	FreightCostAllocationOrder	Order
	ServicesRenderedDate	R_FrtCostAllocItm	ServicesRenderedDate	Services Rendered Date
	GLAccount	R_FrtCostAllocItm	GLAccount	General Ledger
	FiscalYear	R_FrtCostAllocItm	FiscalYear	G/L Fiscal Year
	SalesSpcfcProductGroup1	R_FrtCostAllocItm	SalesSpcfcProductGroup1	Sales-Specific Product Group 1
	SalesSpcfcProductGroup2	R_FrtCostAllocItm	SalesSpcfcProductGroup2	Sales-Specific Product Group 2
	SalesSpcfcProductGroup3	R_FrtCostAllocItm	SalesSpcfcProductGroup3	Sales-Specific Product Group 3
	SalesSpcfcProductGroup4	R_FrtCostAllocItm	SalesSpcfcProductGroup4	Sales-Specific Product Group 4
	SalesSpcfcProductGroup5	R_FrtCostAllocItm	SalesSpcfcProductGroup5	Sales-Specific Product Group 5
	FrtCostAlcItmCreationTime
	FrtCostAlcItmLastChangeDate
	FrtCostAlcItmCreatedByUser
	FrtCostAlcItmCreationDate
	CalendarYear	_CalendarDate	CalendarYear	Year
	CalendarQuarter	_CalendarDate	CalendarQuarter	Calendar Quarter
	_DistributionChannel	FrtCostAllocDoc	_DistributionChannel
	_Division	FrtCostAllocDoc	_Division
	_ExchangeRateType	FrtCostAllocDoc	_ExchangeRateType
	_FrtCostAllocAcctgTransfSts	FrtCostAllocDoc	_FrtCostAllocAcctgTransfSts
	_FrtCostAllocBusProcCat	FrtCostAllocDoc	_FrtCostAllocBusProcCat
	_FrtCostAllocDocActivityReason	FrtCostAllocDoc	_FrtCostAllocDocActivityReason
	_FrtCostAllocDocCurrency	FrtCostAllocDoc	_FrtCostAllocDocCurrency
	_FrtCostAllocDocIncmpltnsRsn	FrtCostAllocDoc	_FrtCostAllocDocIncmpltnsRsn
	_PurchasingOrganization	FrtCostAllocDoc	_PurchasingOrganization
	_PurchasingGroup	FrtCostAllocDoc	_PurchasingGroup
	_RvsdFrtCostAllocDoc	FrtCostAllocDoc	_RvsdFrtCostAllocDoc
	_SalesGroup	FrtCostAllocDoc	_SalesGroup
	_SalesOffice	FrtCostAllocDoc	_SalesOffice
	_SalesOrganization	FrtCostAllocDoc	_SalesOrganization
	_SettlmtApplSts	FrtCostAllocDoc	_SettlmtApplSts
	_SettlmtApplStsGrp	FrtCostAllocDoc	_SettlmtApplStsGrp
	_SettlmtApplStsGrpStsAssgmt	FrtCostAllocDoc	_SettlmtApplStsGrpStsAssgmt
	_SettlmtClassificationCat	FrtCostAllocDoc	_SettlmtClassificationCat
	_SettlmtDocCat	FrtCostAllocDoc	_SettlmtDocCat
	_SettlmtProcessCat	FrtCostAllocDoc	_SettlmtProcessCat
	_SettlmtProcessType	FrtCostAllocDoc	_SettlmtProcessType
	_SettlmtDocType	FrtCostAllocDoc	_SettlmtDocType
	_CreatedByUser	FrtCostAllocDoc	_CreatedByUser
	_FrtCostAllocAdjmtCat	FrtCostAllocDoc	_FrtCostAllocAdjmtCat
	_CompanyCode	R_FrtCostAllocItm	_CompanyCode
	_BaseUnit	R_FrtCostAllocItm	_BaseUnit
	_BusinessArea	R_FrtCostAllocItm	_BusinessArea
	_BusinessAreaText	R_FrtCostAllocItm	_BusinessAreaText
	_ControllingArea	R_FrtCostAllocItm	_ControllingArea
	_FreightCostAllocationOrder	R_FrtCostAllocItm	_FreightCostAllocationOrder
	_FrtCostAllocDoc	R_FrtCostAllocItm	_FrtCostAllocDoc
	_FrtCostAllocDocItmCat	R_FrtCostAllocItm	_FrtCostAllocDocItmCat
	_FrtCostAllocItmActivityReason	R_FrtCostAllocItm	_FrtCostAllocItmActivityReason
	_FrtCostAllocRefFreightOrder	R_FrtCostAllocItm	_FrtCostAllocRefFreightOrder
	_FrtCostAllocRefFrtBooking	R_FrtCostAllocItm	_FrtCostAllocRefFrtBooking
	_FrtCostAllocItmPrcgElmnt	R_FrtCostAllocItm	_FrtCostAllocItmPrcgElmnt
	_FrtCostAllocItmStstclPrpty	R_FrtCostAllocItm	_FrtCostAllocItmStstclPrpty
	_InventoryValuationType	R_FrtCostAllocItm	_InventoryValuationType
	_ItemVolumeUnit	R_FrtCostAllocItm	_ItemVolumeUnit
	_ItemWeightUnit	R_FrtCostAllocItm	_ItemWeightUnit
	_NetPriceQuantityUnit	R_FrtCostAllocItm	_NetPriceQuantityUnit
	_Plant	R_FrtCostAllocItm	_Plant
	_Product	R_FrtCostAllocItm	_Product
	_ProductGroup	R_FrtCostAllocItm	_ProductGroup
	_ProductText	R_FrtCostAllocItm	_ProductText
	_SalesSpcfcProductGroup1	R_FrtCostAllocItm	_SalesSpcfcProductGroup1
	_SalesSpcfcProductGroup2	R_FrtCostAllocItm	_SalesSpcfcProductGroup2
	_SalesSpcfcProductGroup3	R_FrtCostAllocItm	_SalesSpcfcProductGroup3
	_SalesSpcfcProductGroup4	R_FrtCostAllocItm	_SalesSpcfcProductGroup4
	_SalesSpcfcProductGroup5	R_FrtCostAllocItm	_SalesSpcfcProductGroup5
	_SettlmtPrecdgDocCat	R_FrtCostAllocItm	_SettlmtPrecdgDocCat
	_SettlmtQuantityUnit	R_FrtCostAllocItm	_SettlmtQuantityUnit
	_SettlmtSourceDocCat	R_FrtCostAllocItm	_SettlmtSourceDocCat
	_WBSElementBasicData	R_FrtCostAllocItm	_WBSElementBasicData
	_GLAccountInCompanyCode	R_FrtCostAllocItm	_GLAccountInCompanyCode
	_CostCenter	R_FrtCostAllocItm	_CostCenter
	_ProfitCenter	R_FrtCostAllocItm	_ProfitCenter
	_FrtCostAlcItmCreatedByUser		_FrtCostAlcItmCreatedByUser
	_CalendarDate		_CalendarDate
	_CalendarYear	_CalendarDate	_CalendarYear
	_CalendarQuarter	_CalendarDate	_CalendarQuarter

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_FrtCostAllocDocItemMonitor.
-- 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_FrtCostAllocDocItemMonitor AS
SELECT
  FrtCostAllocItm.FreightCostAllocationDocument AS FreightCostAllocationDocument,
  FrtCostAllocItm.FrtCostAllocDocumentItem AS FrtCostAllocDocumentItem,
  FrtCostAllocDoc.SettlmtDocType AS SettlmtDocType,
  FrtCostAllocDoc.SettlmtDocCat AS SettlmtDocCat,
  FrtCostAllocDoc.SettlmtProcessType AS SettlmtProcessType,
  FrtCostAllocDoc.SettlmtProcessCat AS SettlmtProcessCat,
  FrtCostAllocDoc.PostingDate AS PostingDate,
  FrtCostAllocDoc.FrtCostAllocAcctgTransfSts AS FrtCostAllocAcctgTransfSts,
  FrtCostAllocDoc.DocumentDate AS DocumentDate,
  FrtCostAllocDoc.DocumentReferenceID AS DocumentReferenceID,
  FrtCostAllocDoc.AssignmentReference AS AssignmentReference,
  FrtCostAllocDoc.SettlmtApplSts AS SettlmtApplSts,
  FrtCostAllocDoc.SettlmtApplStsGrp AS SettlmtApplStsGrp,
  FrtCostAllocItm.CompanyCode AS CompanyCode,
  FrtCostAllocDoc.PurchasingOrganization AS PurchasingOrganization,
  FrtCostAllocDoc.PurchasingGroup AS PurchasingGroup,
  FrtCostAllocDoc.SalesOrganization AS SalesOrganization,
  FrtCostAllocDoc.DistributionChannel AS DistributionChannel,
  FrtCostAllocDoc.Division AS Division,
  FrtCostAllocDoc.SalesOffice AS SalesOffice,
  FrtCostAllocDoc.SalesGroup AS SalesGroup,
  FrtCostAllocDoc.FrtCostAllocDocCurrency AS FrtCostAllocDocCurrency,
  FrtCostAllocDoc.ExchangeRate AS ExchangeRate,
  FrtCostAllocDoc.ExchangeRateType AS ExchangeRateType,
  FrtCostAllocDoc.ExchangeRateIsFixed AS ExchangeRateIsFixed,
  FrtCostAllocDoc.ExchangeRateDate AS ExchangeRateDate,
  FrtCostAllocDoc.FrtCostAllocDocTotGrossAmount AS FrtCostAllocDocTotGrossAmount,
  FrtCostAllocDoc.FrtCostAllocDocTotalNetAmount AS FrtCostAllocDocTotalNetAmount,
  FrtCostAllocDoc.FrtCostAllocDocIsReversed AS FrtCostAllocDocIsReversed,
  FrtCostAllocDoc.RvsdFrtCostAllocDoc AS RvsdFrtCostAllocDoc,
  FrtCostAllocDoc.FrtCostAllocDocActivityReason AS FrtCostAllocDocActivityReason,
  FrtCostAllocDoc.SettlmtClassificationCat AS SettlmtClassificationCat,
  FrtCostAllocDoc.FiscalPeriod AS FiscalPeriod,
  FrtCostAllocDoc.FrtCostAllocDocIncmpltnsRsn AS FrtCostAllocDocIncmpltnsRsn,
  FrtCostAllocDoc._SettlmtDocType.SettlmtRptgDisplayVariant AS SettlmtRptgDisplayVariant,
  FrtCostAllocDoc.FrtCostAllocBusProcCat AS FrtCostAllocBusProcCat,
  FrtCostAllocDoc.FrtCostAllocAdjmtCat AS FrtCostAllocAdjmtCat,
  FrtCostAllocDoc.FrtCostAllocDocChangeState AS FrtCostAllocDocChangeState,
  FrtCostAllocDoc.CreationDate AS CreationDate,
  FrtCostAllocDoc.CreatedByUser AS CreatedByUser,
  FrtCostAllocDoc.CreationTime AS CreationTime,
  FrtCostAllocDoc.LastChangeDate AS LastChangeDate,
  FrtCostAllocItm._FrtCostAllocRefFreightOrder.FreightOrder AS FreightOrder,
  FrtCostAllocItm._FrtCostAllocRefFrtBooking.FreightBooking AS FreightBooking,
  FrtCostAllocItm.Product AS Product,
  FrtCostAllocItm.FrtCostAllocDocItemText AS FrtCostAllocDocItemText,
  FrtCostAllocItm.ProductGroup AS ProductGroup,
  FrtCostAllocItm.Plant AS Plant,
  FrtCostAllocItm.InventoryValuationType AS InventoryValuationType,
  FrtCostAllocItm.PricingDate AS PricingDate,
  FrtCostAllocItm.SettlmtQuantity AS SettlmtQuantity,
  FrtCostAllocItm.SettlmtQuantityUnit AS SettlmtQuantityUnit,
  FrtCostAllocItm.NetPriceQuantity AS NetPriceQuantity,
  FrtCostAllocItm.NetPriceQuantityUnit AS NetPriceQuantityUnit,
  FrtCostAllocItm.SettlmtToBaseQuantityNmrtr AS SettlmtToBaseQuantityNmrtr,
  FrtCostAllocItm.SettlmtToBaseQuantityDnmntr AS SettlmtToBaseQuantityDnmntr,
  FrtCostAllocItm.SettlmtToNetPriceQtyNmrtr AS SettlmtToNetPriceQtyNmrtr,
  FrtCostAllocItm.SettlmtToNetPriceQtyDnmntr AS SettlmtToNetPriceQtyDnmntr,
  FrtCostAllocItm.BaseUnit AS BaseUnit,
  FrtCostAllocItm.ItemNetWeight AS ItemNetWeight,
  FrtCostAllocItm.ItemGrossWeight AS ItemGrossWeight,
  FrtCostAllocItm.ItemWeightUnit AS ItemWeightUnit,
  FrtCostAllocItm.ItemVolume AS ItemVolume,
  FrtCostAllocItm.ItemVolumeUnit AS ItemVolumeUnit,
  FrtCostAllocItm.FrtCostAllocItmStstclPrpty AS FrtCostAllocItmStstclPrpty,
  FrtCostAllocItm.SettlmtSourceDoc AS SettlmtSourceDoc,
  FrtCostAllocItm.SettlmtSourceDocItem AS SettlmtSourceDocItem,
  FrtCostAllocItm.SettlmtSourceDocCat AS SettlmtSourceDocCat,
  FrtCostAllocItm.FrtCostAllocItmActivityReason AS FrtCostAllocItmActivityReason,
  FrtCostAllocItm.BusinessArea AS BusinessArea,
  FrtCostAllocItm.ControllingArea AS ControllingArea,
  FrtCostAllocItm.CostCenter AS CostCenter,
  FrtCostAllocItm.ProfitCenter AS ProfitCenter,
  FrtCostAllocItm.WBSElementInternalID AS WBSElementInternalID,
  FrtCostAllocItm.PrcDetnIsIncmplt AS PrcDetnIsIncmplt,
  FrtCostAllocItm.SettlmtPrecdgDoc AS SettlmtPrecdgDoc,
  FrtCostAllocItm.SettlmtPrecdgDocItem AS SettlmtPrecdgDocItem,
  FrtCostAllocItm.SettlmtPrecdgDocCat AS SettlmtPrecdgDocCat,
  FrtCostAllocItm.FrtCostAllocDocItmCat AS FrtCostAllocDocItmCat,
  FrtCostAllocItm.FreightCostAllocationOrder AS FreightCostAllocationOrder,
  FrtCostAllocItm.ServicesRenderedDate AS ServicesRenderedDate,
  FrtCostAllocItm.GLAccount AS GLAccount,
  FrtCostAllocItm.FiscalYear AS FiscalYear,
  FrtCostAllocItm.SalesSpcfcProductGroup1 AS SalesSpcfcProductGroup1,
  FrtCostAllocItm.SalesSpcfcProductGroup2 AS SalesSpcfcProductGroup2,
  FrtCostAllocItm.SalesSpcfcProductGroup3 AS SalesSpcfcProductGroup3,
  FrtCostAllocItm.SalesSpcfcProductGroup4 AS SalesSpcfcProductGroup4,
  FrtCostAllocItm.SalesSpcfcProductGroup5 AS SalesSpcfcProductGroup5,
  cast( FrtCostAllocItm.CreationTime as wlf_itm_created_at preserving type ) AS FrtCostAlcItmCreationTime,
  cast( FrtCostAllocDoc.LastChangeDate as wlf_itm_changed_on preserving type ) AS FrtCostAlcItmLastChangeDate,
  cast( FrtCostAllocItm.CreatedByUser as wlf_itm_created_by preserving type ) AS FrtCostAlcItmCreatedByUser,
  cast( FrtCostAllocItm.CreationDate as wlf_itm_created_on preserving type ) AS FrtCostAlcItmCreationDate,
  _CalendarDate.CalendarYear AS CalendarYear,
  _CalendarDate.CalendarQuarter AS CalendarQuarter,
  FrtCostAllocDoc._DistributionChannel AS _DistributionChannel,
  FrtCostAllocDoc._Division AS _Division,
  FrtCostAllocDoc._ExchangeRateType AS _ExchangeRateType,
  FrtCostAllocDoc._FrtCostAllocAcctgTransfSts AS _FrtCostAllocAcctgTransfSts,
  FrtCostAllocDoc._FrtCostAllocBusProcCat AS _FrtCostAllocBusProcCat,
  FrtCostAllocDoc._FrtCostAllocDocActivityReason AS _FrtCostAllocDocActivityReason,
  FrtCostAllocDoc._FrtCostAllocDocCurrency AS _FrtCostAllocDocCurrency,
  FrtCostAllocDoc._FrtCostAllocDocIncmpltnsRsn AS _FrtCostAllocDocIncmpltnsRsn,
  FrtCostAllocDoc._PurchasingOrganization AS _PurchasingOrganization,
  FrtCostAllocDoc._PurchasingGroup AS _PurchasingGroup,
  FrtCostAllocDoc._RvsdFrtCostAllocDoc AS _RvsdFrtCostAllocDoc,
  FrtCostAllocDoc._SalesGroup AS _SalesGroup,
  FrtCostAllocDoc._SalesOffice AS _SalesOffice,
  FrtCostAllocDoc._SalesOrganization AS _SalesOrganization,
  FrtCostAllocDoc._SettlmtApplSts AS _SettlmtApplSts,
  FrtCostAllocDoc._SettlmtApplStsGrp AS _SettlmtApplStsGrp,
  FrtCostAllocDoc._SettlmtApplStsGrpStsAssgmt AS _SettlmtApplStsGrpStsAssgmt,
  FrtCostAllocDoc._SettlmtClassificationCat AS _SettlmtClassificationCat,
  FrtCostAllocDoc._SettlmtDocCat AS _SettlmtDocCat,
  FrtCostAllocDoc._SettlmtProcessCat AS _SettlmtProcessCat,
  FrtCostAllocDoc._SettlmtProcessType AS _SettlmtProcessType,
  FrtCostAllocDoc._SettlmtDocType AS _SettlmtDocType,
  FrtCostAllocDoc._CreatedByUser AS _CreatedByUser,
  FrtCostAllocDoc._FrtCostAllocAdjmtCat AS _FrtCostAllocAdjmtCat,
  FrtCostAllocItm._CompanyCode AS _CompanyCode,
  FrtCostAllocItm._BaseUnit AS _BaseUnit,
  FrtCostAllocItm._BusinessArea AS _BusinessArea,
  FrtCostAllocItm._BusinessAreaText AS _BusinessAreaText,
  FrtCostAllocItm._ControllingArea AS _ControllingArea,
  FrtCostAllocItm._FreightCostAllocationOrder AS _FreightCostAllocationOrder,
  FrtCostAllocItm._FrtCostAllocDoc AS _FrtCostAllocDoc,
  FrtCostAllocItm._FrtCostAllocDocItmCat AS _FrtCostAllocDocItmCat,
  FrtCostAllocItm._FrtCostAllocItmActivityReason AS _FrtCostAllocItmActivityReason,
  FrtCostAllocItm._FrtCostAllocRefFreightOrder AS _FrtCostAllocRefFreightOrder,
  FrtCostAllocItm._FrtCostAllocRefFrtBooking AS _FrtCostAllocRefFrtBooking,
  FrtCostAllocItm._FrtCostAllocItmPrcgElmnt AS _FrtCostAllocItmPrcgElmnt,
  FrtCostAllocItm._FrtCostAllocItmStstclPrpty AS _FrtCostAllocItmStstclPrpty,
  FrtCostAllocItm._InventoryValuationType AS _InventoryValuationType,
  FrtCostAllocItm._ItemVolumeUnit AS _ItemVolumeUnit,
  FrtCostAllocItm._ItemWeightUnit AS _ItemWeightUnit,
  FrtCostAllocItm._NetPriceQuantityUnit AS _NetPriceQuantityUnit,
  FrtCostAllocItm._Plant AS _Plant,
  FrtCostAllocItm._Product AS _Product,
  FrtCostAllocItm._ProductGroup AS _ProductGroup,
  FrtCostAllocItm._ProductText AS _ProductText,
  FrtCostAllocItm._SalesSpcfcProductGroup1 AS _SalesSpcfcProductGroup1,
  FrtCostAllocItm._SalesSpcfcProductGroup2 AS _SalesSpcfcProductGroup2,
  FrtCostAllocItm._SalesSpcfcProductGroup3 AS _SalesSpcfcProductGroup3,
  FrtCostAllocItm._SalesSpcfcProductGroup4 AS _SalesSpcfcProductGroup4,
  FrtCostAllocItm._SalesSpcfcProductGroup5 AS _SalesSpcfcProductGroup5,
  FrtCostAllocItm._SettlmtPrecdgDocCat AS _SettlmtPrecdgDocCat,
  FrtCostAllocItm._SettlmtQuantityUnit AS _SettlmtQuantityUnit,
  FrtCostAllocItm._SettlmtSourceDocCat AS _SettlmtSourceDocCat,
  FrtCostAllocItm._WBSElementBasicData AS _WBSElementBasicData,
  FrtCostAllocItm._GLAccountInCompanyCode AS _GLAccountInCompanyCode,
  FrtCostAllocItm._CostCenter AS _CostCenter,
  FrtCostAllocItm._ProfitCenter AS _ProfitCenter,
  _CalendarDate._CalendarYear AS _CalendarYear,
  _CalendarDate._CalendarQuarter AS _CalendarQuarter
FROM R_FrtCostAllocItm AS FrtCostAllocItm
LEFT OUTER JOIN I_CalendarDate AS _CalendarDate ON PostingDate = _CalendarDate.CalendarDate  -- association [0..1]
LEFT OUTER JOIN I_User AS _FrtCostAlcItmCreatedByUser ON FrtCostAlcItmCreatedByUser = _FrtCostAlcItmCreatedByUser.UserID  -- association [0..1]
;

Depth:

C_FrtCostAllocDocItemMonitor view

R_FrtCostAllocItm view

C_FrtCostAllocDocItem_F5513 view_entity