What is C_MngFrtCostAllocDocItem in SAP S/4HANA?

C_MngFrtCostAllocDocItem is a consumption CDS view in SAP S/4HANA. Manage Freight Cost Allocation Documents It contains 125 fields.

Which tables does C_MngFrtCostAllocDocItem read from?

C_MngFrtCostAllocDocItem reads data from: R_FrtCostAllocItmTP.

What VDM layer is C_MngFrtCostAllocDocItem?

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

C_MngFrtCostAllocDocItem

DDL: C_MNGFRTCOSTALLOCDOCITEM Type: view_entity CONSUMPTION Package: WLF_UI_FCADOC_F5514

125 Fields 1 Data Sources 1 Associations 2 OData Services

Manage Freight Cost Allocation Documents

C_MngFrtCostAllocDocItem is a Consumption CDS View that provides data about "Manage Freight Cost Allocation Documents" in SAP S/4HANA. It reads from 1 data source (R_FrtCostAllocItmTP) and exposes 125 fields with key fields FreightCostAllocationDocument, FrtCostAllocDocumentItem. It has 1 association to related views. It is exposed through 2 OData services (ASQL_F5514, UI_LO_SETMAN_FCADOC_MNG). Part of development package WLF_UI_FCADOC_F5514.

Data Sources (1)

Source	Alias	Join Type
R_FrtCostAllocItmTP	R_FrtCostAllocItmTP	projection

Associations (1)

Cardinality	Target	Alias	Condition
[0..*]	C_FrtCostAlcItmPrcgElmnt_F5514	_FrtCostAllocItmPrcgElmnt	`$projection.FreightCostAllocationDocument = _FrtCostAllocItmPrcgElmnt.FreightCostAllocationDocument and $projection.FrtCostAllocDocumentItem = _FrtCostAllocItmPrcgElmnt.FrtCostAllocDocumentItem`

Annotations (13)

Name	Value	Level
EndUserText.label	Manage Freight Cost Allocation Documents	view
AccessControl.authorizationCheck	#MANDATORY	view
AccessControl.personalData.blocking	#NOT_REQUIRED	view
Metadata.allowExtensions	true	view
VDM.viewType	#CONSUMPTION	view
VDM.lifecycle.contract.type	#NONE	view
AbapCatalog.extensibility.extensible	true	view
AbapCatalog.extensibility.elementSuffix	SMI	view
AbapCatalog.extensibility.quota.maximumFields	404	view
AbapCatalog.extensibility.quota.maximumBytes	24080	view
ObjectModel.usageType.serviceQuality	#C	view
ObjectModel.usageType.dataClass	#MIXED	view
ObjectModel.usageType.sizeCategory	#XXL	view

OData Services (2)

Service	Binding	Version	Contract	Release
ASQL_F5514	ASQL_F5514		C2	NOT_RELEASED
UI_LO_SETMAN_FCADOC_MNG	UI_LO_SETMAN_FCADOC_MNG	V4	C1	NOT_TO_BE_RELEASED_STABLE

Fields (125)

Key	Field	Source Table	Source Field	Description
KEY	FreightCostAllocationDocument		FreightCostAllocationDocument	Freight Cost Allocation Document
KEY	FrtCostAllocDocumentItem		FrtCostAllocDocumentItem	Item
	FrtCostAllocDocCurrency		FrtCostAllocDocCurrency	Document Currency
	PricingDocument		PricingDocument	Document Condition
	Product		Product	Product Sold
	FrtCostAllocDocItemText		FrtCostAllocDocItemText	Short Text
	ProductGroup		ProductGroup	Product Sold Group
	ProductGroupNamelocalized
	Plant		Plant	Valuation Area
	PlantName	_Plant	PlantName	Plant Name
	InventoryValuationType		InventoryValuationType	Valuation Type
	PricingDate		PricingDate	Pricing Date
	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
	FrtCostAllocItemGrossAmount		FrtCostAllocItemGrossAmount	Gross Amount of Item
	FrtCostAllocItemNetAmount		FrtCostAllocItemNetAmount	Net Amount of Item
	FrtCostAllocSubtotal1Amount		FrtCostAllocSubtotal1Amount	Subtotal 1 Amount
	FrtCostAllocSubtotal2Amount		FrtCostAllocSubtotal2Amount	Subtotal 2 Amount
	FrtCostAllocSubtotal3Amount		FrtCostAllocSubtotal3Amount	Subtotal 3 Amount
	FrtCostAllocSubtotal4Amount		FrtCostAllocSubtotal4Amount	Subtotal 4 Amount
	FrtCostAllocSubtotal5Amount		FrtCostAllocSubtotal5Amount	Subtotal 5 Amount
	FrtCostAllocSubtotal6Amount		FrtCostAllocSubtotal6Amount	Subtotal 6 Amount
	FrtCostAllocEffctvItemAmount		FrtCostAllocEffctvItemAmount	Effective Amnt
	FrtCostAllocItmStstclPrpty		FrtCostAllocItmStstclPrpty	Statistical Prpty
	SettlmtItmStatisticalPrptyNamelocalized
	CreatedByUser		CreatedByUser	User Name
	CreatedByUserFullName	_CreatedByUser	UserDescription	Full Name
	CreationDate		CreationDate	Time Stamp
	CreationTime		CreationTime	Time of Change
	SettlmtSourceDoc		SettlmtSourceDoc	Source Doc.
	SettlmtSourceDocItem		SettlmtSourceDocItem	Item of the Source Document
	SettlmtSourceDocCat		SettlmtSourceDocCat	SourceDocCat
	FrtCostAllocItmActivityReason		FrtCostAllocItmActivityReason	Activity Reason
	SettlmtActivityReasonDesclocalized
	BusinessArea		BusinessArea	Business Area
	BusinessAreaNamelocalized
	CostCenter		CostCenter	Cost Center
	CostCenterDescriptionlocalized
	ProfitCenter		ProfitCenter	Profit Center
	ProfitCenterLongNamelocalized
	WBSElementInternalID		WBSElementInternalID	WBS Internal ID
	WBSDescription	_WBSElementBasicData	WBSDescription	WBS Element Name
	FreightCostAllocationOrder		FreightCostAllocationOrder	Order
	FreightCostAllocationOrderName	_FreightCostAllocationOrder	InternalOrderDescription	Description
	PrcDetnIsIncmplt		PrcDetnIsIncmplt	Price Determination Is Incomplete
	SettlmtPrecdgDoc		SettlmtPrecdgDoc	Pre. Document
	SettlmtPrecdgDocItem		SettlmtPrecdgDocItem	Item of Preceding Document
	SettlmtPrecdgDocCat		SettlmtPrecdgDocCat	PreDocCat
	FrtCostAllocDocItmCat		FrtCostAllocDocItmCat	Item Category
	SettlmtMgmtDocItemCatNamelocalized
	ServicesRenderedDate		ServicesRenderedDate	Services Rendered Date
	CompanyCode		CompanyCode	Receiver Company Code
	CompanyCodeName	_CompanyCode	CompanyCodeName	Company Name
	GLAccount		GLAccount	General Ledger
	GLAccountLongNamelocalized
	FiscalYear		FiscalYear	G/L Fiscal Year
	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
	FrtCostAllocRefDoc		FrtCostAllocRefDoc	Settlmt. Ref. Doc.
	FrtCostAllocRefDocCat		FrtCostAllocRefDocCat	SettlmtRefDocCat
	FrtCostAllocAddlRefDoc		FrtCostAllocAddlRefDoc	SettlmtAddlRefDoc
	FrtCostAllocAddlRefDocCat		FrtCostAllocAddlRefDocCat	SettlmtAddlRefDocCat
	SettlmtDocType	_FrtCostAllocDoc	SettlmtDocType	Settlement Document Type
	ApplElmntBehaviorGrp	_FrtCostAllocDoc	ApplElmntBehaviorGrp	Element Behavior Group
	virtualUICT_ProductHierarchyboolean
	virtualUICT_HDR_STATUSboolean
	virtualUICT_HDR_PROD_DESCboolean
	virtualUICT_HDR_NETAMTboolean
	virtualUICT_COLL_GENERALINFOboolean
	virtualUICT_FLDGRP_BASICDATAboolean
	virtualUICT_COLL_SETTLMTDATAboolean
	virtualUICT_FLDGRP_PRODUCTDATAboolean
	virtualUICT_FLDGRP_VOLWEIGHTboolean
	virtualUICT_COLL_ACCOUNTINGboolean
	virtualUICT_COLL_REFDOCboolean
	virtualUICT_FLDGRP_FRGHT_SET_DOCboolean
	virtualUICT_FLDGRP_FRGHT_ORDRboolean
	virtualUICT_FLDGRP_FRGHT_BOOKboolean
	virtualUICT_LNITM_PRCG_ELMNTboolean
	_FrtCostAllocDocCurrency		_FrtCostAllocDocCurrency
	_Product		_Product
	_ProductText		_ProductText
	_InventoryValuationType		_InventoryValuationType
	_SettlmtQuantityUnit		_SettlmtQuantityUnit
	_NetPriceQuantityUnit		_NetPriceQuantityUnit
	_BaseUnit		_BaseUnit
	_ItemVolumeUnit		_ItemVolumeUnit
	_ItemWeightUnit		_ItemWeightUnit
	_FrtCostAllocItmStstclPrpty		_FrtCostAllocItmStstclPrpty
	_CreatedByUser		_CreatedByUser
	_SettlmtSourceDocCat		_SettlmtSourceDocCat
	_FrtCostAllocItmActivityReason		_FrtCostAllocItmActivityReason
	_BusinessArea		_BusinessArea
	_BusinessAreaText		_BusinessAreaText
	_WBSElementBasicData		_WBSElementBasicData
	_FreightCostAllocationOrder		_FreightCostAllocationOrder
	_SettlmtPrecdgDocCat		_SettlmtPrecdgDocCat
	_FrtCostAllocDocItmCat		_FrtCostAllocDocItmCat
	_CompanyCode		_CompanyCode
	_GLAccountInCompanyCode		_GLAccountInCompanyCode
	_FrtCostAllocRefDocCat		_FrtCostAllocRefDocCat
	_FrtCostAllocAddlRefDocCat		_FrtCostAllocAddlRefDocCat
	_SalesSpcfcProductGroup1		_SalesSpcfcProductGroup1
	_SalesSpcfcProductGroup2		_SalesSpcfcProductGroup2
	_SalesSpcfcProductGroup3		_SalesSpcfcProductGroup3
	_SalesSpcfcProductGroup4		_SalesSpcfcProductGroup4
	_SalesSpcfcProductGroup5		_SalesSpcfcProductGroup5
	_FrtCostAllocItmPrcgElmnt		_FrtCostAllocItmPrcgElmnt

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_MngFrtCostAllocDocItem.
-- 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_MngFrtCostAllocDocItem AS
SELECT
  FreightCostAllocationDocument,
  FrtCostAllocDocumentItem,
  FrtCostAllocDocCurrency,
  PricingDocument,
  Product,
  FrtCostAllocDocItemText,
  ProductGroup,
  _ProductGroup._ProductGroupText.ProductGroupName : localized AS ProductGroupNamelocalized,
  Plant,
  _Plant.PlantName AS PlantName,
  InventoryValuationType,
  PricingDate,
  SettlmtQuantity,
  SettlmtQuantityUnit,
  NetPriceAmount,
  NetPriceQuantity,
  NetPriceQuantityUnit,
  SettlmtToBaseQuantityNmrtr,
  SettlmtToBaseQuantityDnmntr,
  SettlmtToNetPriceQtyNmrtr,
  SettlmtToNetPriceQtyDnmntr,
  BaseUnit,
  ItemNetWeight,
  ItemGrossWeight,
  ItemWeightUnit,
  ItemVolume,
  ItemVolumeUnit,
  FrtCostAllocItemGrossAmount,
  FrtCostAllocItemNetAmount,
  FrtCostAllocSubtotal1Amount,
  FrtCostAllocSubtotal2Amount,
  FrtCostAllocSubtotal3Amount,
  FrtCostAllocSubtotal4Amount,
  FrtCostAllocSubtotal5Amount,
  FrtCostAllocSubtotal6Amount,
  FrtCostAllocEffctvItemAmount,
  FrtCostAllocItmStstclPrpty,
  _FrtCostAllocItmStstclPrpty._Text.SettlmtItmStatisticalPrptyName : localized AS SettlmtItmStatisticalPrptyNamelocalized,
  CreatedByUser,
  _CreatedByUser.UserDescription AS CreatedByUserFullName,
  CreationDate,
  CreationTime,
  SettlmtSourceDoc,
  SettlmtSourceDocItem,
  SettlmtSourceDocCat,
  FrtCostAllocItmActivityReason,
  _FrtCostAllocItmActivityReason._Text.SettlmtActivityReasonDesc : localized AS SettlmtActivityReasonDesclocalized,
  BusinessArea,
  _BusinessArea._Text.BusinessAreaName : localized AS BusinessAreaNamelocalized,
  CostCenter,
  _CostCenter._Text.CostCenterDescription : localized AS CostCenterDescriptionlocalized,
  ProfitCenter,
  _ProfitCenter._Text.ProfitCenterLongName : localized AS ProfitCenterLongNamelocalized,
  WBSElementInternalID,
  _WBSElementBasicData.WBSDescription AS WBSDescription,
  FreightCostAllocationOrder,
  _FreightCostAllocationOrder.InternalOrderDescription AS FreightCostAllocationOrderName,
  PrcDetnIsIncmplt,
  SettlmtPrecdgDoc,
  SettlmtPrecdgDocItem,
  SettlmtPrecdgDocCat,
  FrtCostAllocDocItmCat,
  _FrtCostAllocDocItmCat._Text.SettlmtMgmtDocItemCatName : localized AS SettlmtMgmtDocItemCatNamelocalized,
  ServicesRenderedDate,
  CompanyCode,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  GLAccount,
  _GLAccountInCompanyCode._Text.GLAccountLongName : localized AS GLAccountLongNamelocalized,
  FiscalYear,
  ProductHierarchy,
  SalesSpcfcProductGroup1,
  SalesSpcfcProductGroup2,
  SalesSpcfcProductGroup3,
  SalesSpcfcProductGroup4,
  SalesSpcfcProductGroup5,
  FrtCostAllocRefDoc,
  FrtCostAllocRefDocCat,
  FrtCostAllocAddlRefDoc,
  FrtCostAllocAddlRefDocCat,
  _FrtCostAllocDoc.SettlmtDocType AS SettlmtDocType,
  _FrtCostAllocDoc.ApplElmntBehaviorGrp AS ApplElmntBehaviorGrp,
  virtual UICT_ProductHierarchy : boolean AS virtualUICT_ProductHierarchyboolean,
  virtual UICT_HDR_STATUS : boolean AS virtualUICT_HDR_STATUSboolean,
  virtual UICT_HDR_PROD_DESC : boolean AS virtualUICT_HDR_PROD_DESCboolean,
  virtual UICT_HDR_NETAMT : boolean AS virtualUICT_HDR_NETAMTboolean,
  virtual UICT_COLL_GENERALINFO : boolean AS virtualUICT_COLL_GENERALINFOboolean,
  virtual UICT_FLDGRP_BASICDATA : boolean AS virtualUICT_FLDGRP_BASICDATAboolean,
  virtual UICT_COLL_SETTLMTDATA : boolean AS virtualUICT_COLL_SETTLMTDATAboolean,
  virtual UICT_FLDGRP_PRODUCTDATA : boolean AS virtualUICT_FLDGRP_PRODUCTDATAboolean,
  virtual UICT_FLDGRP_VOLWEIGHT : boolean AS virtualUICT_FLDGRP_VOLWEIGHTboolean,
  virtual UICT_COLL_ACCOUNTING : boolean AS virtualUICT_COLL_ACCOUNTINGboolean,
  virtual UICT_COLL_REFDOC : boolean AS virtualUICT_COLL_REFDOCboolean,
  virtual UICT_FLDGRP_FRGHT_SET_DOC : boolean AS virtualUICT_FLDGRP_FRGHT_SET_DOCboolean,
  virtual UICT_FLDGRP_FRGHT_ORDR : boolean AS virtualUICT_FLDGRP_FRGHT_ORDRboolean,
  virtual UICT_FLDGRP_FRGHT_BOOK : boolean AS virtualUICT_FLDGRP_FRGHT_BOOKboolean,
  virtual UICT_LNITM_PRCG_ELMNT : boolean AS virtualUICT_LNITM_PRCG_ELMNTboolean
FROM R_FrtCostAllocItmTP
LEFT OUTER JOIN C_FrtCostAlcItmPrcgElmnt_F5514 AS _FrtCostAllocItmPrcgElmnt ON FreightCostAllocationDocument = _FrtCostAllocItmPrcgElmnt.FreightCostAllocationDocument AND FrtCostAllocDocumentItem = _FrtCostAllocItmPrcgElmnt.FrtCostAllocDocumentItem  -- association [0..*]
;

Depth:

C_MngFrtCostAllocDocItem view_entity

R_FrtCostAllocItmTP view_entity