R_FrtCostAllocDocVH

DDL: R_FRTCOSTALLOCDOCVH Type: view_entity COMPOSITE
16 Fields 1 Data Sources

Freight Cost Allocation Document

R_FrtCostAllocDocVH is a Composite CDS View that provides data about "Freight Cost Allocation Document" in SAP S/4HANA. It reads from 1 data source (R_FrtCostAllocDoc) and exposes 16 fields with key field FreightCostAllocationDocument.

Data Sources (1)

SourceAliasJoin Type
R_FrtCostAllocDoc R_FrtCostAllocDoc from

Annotations (15)

NameValueLevelField
EndUserText.label Freight Cost Allocation Document view
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.representativeKey FreightCostAllocationDocument view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
Analytics.internalName #LOCAL view
UI.headerInfo.typeName Freight Cost Allocation Document view
UI.headerInfo.typeNamePlural Freight Cost Allocation Documents view
Search.searchable true view
Metadata.ignorePropagatedAnnotations true view
Consumption.ranked true view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY FreightCostAllocationDocument FreightCostAllocationDocument Freight Cost Allocation Document
SettlmtDocType SettlmtDocType Settlement Document Type
SettlmtDocTypeDesc
FrtCostAllocAcctgTransfSts FrtCostAllocAcctgTransfSts Posting Status
FrtCostAllocAcctgTransfStsName
FrtCostAllocBusProcCat FrtCostAllocBusProcCat Use Case Type
FrtCostAllocBusProcCatName
CompanyCode CompanyCode Receiver Company Code
PurchasingOrganization PurchasingOrganization Purchasing Organization
PurchasingGroup PurchasingGroup Purchasing Group
SalesOrganization SalesOrganization Sales Organization
DistributionChannel DistributionChannel RefDistCh-Cust/Mat.
Division Division Internal Division ID
_SettlmtDocType _SettlmtDocType
_FrtCostAllocAcctgTransfSts _FrtCostAllocAcctgTransfSts
_FrtCostAllocBusProcCat _FrtCostAllocBusProcCat

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 R_FrtCostAllocDocVH.
-- 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 R_FrtCostAllocDocVH AS
SELECT
  FreightCostAllocationDocument,
  SettlmtDocType,
  _SettlmtDocType._Text[1: Language = $session.system_language].SettlmtDocTypeDesc AS SettlmtDocTypeDesc,
  FrtCostAllocAcctgTransfSts,
  _FrtCostAllocAcctgTransfSts._Text[1: Language = $session.system_language].FrtCostAllocAcctgTransfStsName AS FrtCostAllocAcctgTransfStsName,
  FrtCostAllocBusProcCat,
  _FrtCostAllocBusProcCat._Text[1: Language = $session.system_language].FrtCostAllocBusProcCatName AS FrtCostAllocBusProcCatName,
  CompanyCode,
  PurchasingOrganization,
  PurchasingGroup,
  SalesOrganization,
  DistributionChannel,
  Division
FROM R_FrtCostAllocDoc
;

Learn More