I_FrtCostAllocDoc

DDL: I_FRTCOSTALLOCDOC Type: view_entity COMPOSITE
68 Fields 1 Data Sources 9 Associations

Freight Cost Allocation Document

I_FrtCostAllocDoc (Composite)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

Sales

I_FrtCostAllocDoc 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 68 fields with key field FreightCostAllocationDocument. It has 9 associations to related views.

SAP Help Documentation

CategoryFreight Cost Allocation Document
Purpose
This CDS view is used to select information about the freight cost allocation documents. This CDS view provides the prerequisites to answer the following business questions: What freight costs are allocated from freight settlement documents? Are the allocated freight costs posted to Finance or to the Material Ledger? To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views .

Prerequisites
Authorizations Users who want to run reports using this CDS view must have the authorization to display the following data: Authorization object W_WBRK_FKA Authorization required for Settlement Document Type ( LFART ) Authorization object W_WBRK_ORG Authorization required for the following: Company Code ( BUKRS ) Purchasing Organization ( EKORG ) Purchasing Group ( EKGRP ) Sales Org Data ( VKORG ) Distribution Channel ( VTWEG ) Division ( SPART )

Structure
Important Fields Important fields in this view include the following: Field Name Description FreightCostAllocationDocument Freight Cost Allocation Document SettlmtDocType Settlement Document Type SettlmtProcessType Settlement Process Type FrtCostAllocBusProcCat Business Process Category for Freight Cost Allocation

View on SAP Help Portal →

SAP API Hub

StateC1
Line of BusinessSales
Application ComponentLO-AB
CapabilitiesData Source in SQL Select, Association Target for Defining CDS Entities, Data Source for Defining CDS Entities
PackageSales for SAP S/4HANA Cloud Private Edition
Description <p>This CDS view is used to select information about the freight cost allocation documents.</p> This CDS view provides the prerequisites to answer the following business questions:<ul> <li><p>What freight costs are allocated from freight settlement documents?</p></li> <li><p>Are the allocated freight costs posted to Finance or to the Material Ledger?</p></li> </ul> <p>To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views.</p>

Documentation

Data Sources (1)

SourceAliasJoin Type
R_FrtCostAllocDoc R_FrtCostAllocDoc from

Associations (9)

CardinalityTargetAliasCondition
[0..*] I_FrtCostAllocItm _FrtCostAllocItm $projection.FreightCostAllocationDocument = _FrtCostAllocItm.FreightCostAllocationDocument
[0..1] I_SettlmtDocType _SettlmtDocType $projection.SettlmtDocType = _SettlmtDocType.SettlmtDocType
[0..1] I_SettlmtProcessType _SettlmtProcessType $projection.SettlmtProcessType = _SettlmtProcessType.SettlmtProcessType
[0..1] I_SettlmtApplSts _SettlmtApplSts $projection.SettlmtApplSts = _SettlmtApplSts.SettlmtApplSts
[0..1] I_SettlmtApplStsGrp _SettlmtApplStsGrp $projection.SettlmtApplStsGrp = _SettlmtApplStsGrp.SettlmtApplStsGrp
[0..1] I_SettlmtApplStsGrpStsAssgmt _SettlmtApplStsGrpStsAssgmt $projection.SettlmtApplStsGrp = _SettlmtApplStsGrpStsAssgmt.SettlmtApplStsGrp and $projection.SettlmtApplSts = _SettlmtApplStsGrpStsAssgmt.SettlmtApplSts
[0..*] I_FrtCostAllocPrcgElmnt _FrtCostAllocPrcgElmnt $projection.FreightCostAllocationDocument = _FrtCostAllocPrcgElmnt.FreightCostAllocationDocument
[0..1] I_FrtCostAllocDoc _RvsdFrtCostAllocDoc $projection.RvsdFrtCostAllocDoc = _RvsdFrtCostAllocDoc.FreightCostAllocationDocument
[1..1] E_SettlmtMgmtDoc _Extension $projection.FreightCostAllocationDocument = _Extension.SettlmtMgmtDoc

Annotations (11)

NameValueLevelField
EndUserText.label Freight Cost Allocation Document view
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.representativeKey FreightCostAllocationDocument view
ObjectModel.modelingPattern #NONE view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XXL view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions false view

Fields (68)

KeyFieldSource TableSource FieldDescription
KEY FreightCostAllocationDocument FreightCostAllocationDocument Freight Cost Allocation Document Number
SettlmtDocType SettlmtDocType Settlement Document Type
SettlmtDocCat SettlmtDocCat Settlement Document Category
SettlmtProcessType SettlmtProcessType Settlement Process Type
SettlmtProcessCat SettlmtProcessCat Settlement Process Category
PostingDate PostingDate Posting Date for GR
FrtCostAllocAcctgTransfSts FrtCostAllocAcctgTransfSts Posting Status for Transfer to Financial Accounting
DocumentDate DocumentDate Document Date in Settlement Management Document
DocumentReferenceID DocumentReferenceID Reference Document Number
AssignmentReference AssignmentReference Assignment Reference
SettlmtApplSts SettlmtApplSts Application Status for a Settlement Management Document
SettlmtApplStsGrp SettlmtApplStsGrp Status Group for Settlement Management Documents
PricingProcedure PricingProcedure Pricing Procedure
PricingDocument PricingDocument Number of the Document Condition
CompanyCode CompanyCode Receiver Company Code
PurchasingOrganization PurchasingOrganization Purchasing Organization
PurchasingGroup PurchasingGroup Purchasing Group
SalesOrganization SalesOrganization Sales Organization
DistributionChannel DistributionChannel Distribution Channel
Division Division Internal Division ID
SalesOffice SalesOffice Sales Office
SalesGroup SalesGroup Sales Group
CreatedByUser CreatedByUser Name of User who Created the Document
CreationDate CreationDate Date of Document Creation
CreationTime CreationTime Time of Document Creation
LastChangeDate LastChangeDate Date of Last Document Change
FrtCostAllocDocCurrency FrtCostAllocDocCurrency Currency of Freight Cost Allocation Document
ExchangeRate ExchangeRate Conversion Rate (Not Converted)
ExchangeRateType ExchangeRateType Exchange Rate Type
ExchangeRateIsFixed ExchangeRateIsFixed Indicator for Fixed Exchange Rate
ExchangeRateDate ExchangeRateDate Exchange Rate Date
FrtCostAllocDocTotGrossAmount FrtCostAllocDocTotGrossAmount Gross Settlement Amount in Document Currency
FrtCostAllocDocTotalNetAmount FrtCostAllocDocTotalNetAmount Net Settlement Amount in Document Currency
FrtCostAllocDocIsReversed FrtCostAllocDocIsReversed Freight Cost Allocation Document is Reversed
RvsdFrtCostAllocDoc RvsdFrtCostAllocDoc Reversed Document
FrtCostAllocDocActivityReason FrtCostAllocDocActivityReason Header Activity Reason for Document Creation
SettlmtClassificationCat SettlmtClassificationCat Settlement Classification Category
FiscalPeriod FiscalPeriod Fiscal Period
FrtCostAllocDocIncmpltnsRsn FrtCostAllocDocIncmpltnsRsn Incompleteness Reason of Settlement Management Document
FrtCostAllocBusProcCat FrtCostAllocBusProcCat Use Case Type
JournalEntryCreationDate JournalEntryCreationDate Journal Entry Creation Date in UTC
JournalEntryCreationTime JournalEntryCreationTime Journal Entry Creation Time in UTC
_FrtCostAllocItm _FrtCostAllocItm
_FrtCostAllocPrcgElmnt _FrtCostAllocPrcgElmnt
_SettlmtDocType _SettlmtDocType
_SettlmtDocCat _SettlmtDocCat
_SettlmtProcessType _SettlmtProcessType
_SettlmtProcessCat _SettlmtProcessCat
_FrtCostAllocAcctgTransfSts _FrtCostAllocAcctgTransfSts
_SettlmtApplSts _SettlmtApplSts
_SettlmtApplStsGrp _SettlmtApplStsGrp
_SettlmtApplStsGrpStsAssgmt _SettlmtApplStsGrpStsAssgmt
_CompanyCode _CompanyCode
_PurchasingOrganization _PurchasingOrganization
_PurchasingGroup _PurchasingGroup
_SalesOrganization _SalesOrganization
_DistributionChannel _DistributionChannel
_Division _Division
_SalesOffice _SalesOffice
_SalesGroup _SalesGroup
_CreatedByUser _CreatedByUser
_FrtCostAllocDocCurrency _FrtCostAllocDocCurrency
_ExchangeRateType _ExchangeRateType
_RvsdFrtCostAllocDoc _RvsdFrtCostAllocDoc
_FrtCostAllocDocActivityReason _FrtCostAllocDocActivityReason
_SettlmtClassificationCat _SettlmtClassificationCat
_FrtCostAllocDocIncmpltnsRsn _FrtCostAllocDocIncmpltnsRsn
_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 I_FrtCostAllocDoc.
-- 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_FrtCostAllocDoc AS
SELECT
  FreightCostAllocationDocument,
  SettlmtDocType,
  SettlmtDocCat,
  SettlmtProcessType,
  SettlmtProcessCat,
  PostingDate,
  FrtCostAllocAcctgTransfSts,
  DocumentDate,
  DocumentReferenceID,
  AssignmentReference,
  SettlmtApplSts,
  SettlmtApplStsGrp,
  PricingProcedure,
  PricingDocument,
  CompanyCode,
  PurchasingOrganization,
  PurchasingGroup,
  SalesOrganization,
  DistributionChannel,
  Division,
  SalesOffice,
  SalesGroup,
  CreatedByUser,
  CreationDate,
  CreationTime,
  LastChangeDate,
  FrtCostAllocDocCurrency,
  ExchangeRate,
  ExchangeRateType,
  ExchangeRateIsFixed,
  ExchangeRateDate,
  FrtCostAllocDocTotGrossAmount,
  FrtCostAllocDocTotalNetAmount,
  FrtCostAllocDocIsReversed,
  RvsdFrtCostAllocDoc,
  FrtCostAllocDocActivityReason,
  SettlmtClassificationCat,
  FiscalPeriod,
  FrtCostAllocDocIncmpltnsRsn,
  FrtCostAllocBusProcCat,
  JournalEntryCreationDate,
  JournalEntryCreationTime
FROM R_FrtCostAllocDoc
LEFT OUTER JOIN I_FrtCostAllocItm AS _FrtCostAllocItm ON FreightCostAllocationDocument = _FrtCostAllocItm.FreightCostAllocationDocument  -- association [0..*]
LEFT OUTER JOIN I_SettlmtDocType AS _SettlmtDocType ON SettlmtDocType = _SettlmtDocType.SettlmtDocType  -- association [0..1]
LEFT OUTER JOIN I_SettlmtProcessType AS _SettlmtProcessType ON SettlmtProcessType = _SettlmtProcessType.SettlmtProcessType  -- association [0..1]
LEFT OUTER JOIN I_SettlmtApplSts AS _SettlmtApplSts ON SettlmtApplSts = _SettlmtApplSts.SettlmtApplSts  -- association [0..1]
LEFT OUTER JOIN I_SettlmtApplStsGrp AS _SettlmtApplStsGrp ON SettlmtApplStsGrp = _SettlmtApplStsGrp.SettlmtApplStsGrp  -- association [0..1]
LEFT OUTER JOIN I_SettlmtApplStsGrpStsAssgmt AS _SettlmtApplStsGrpStsAssgmt ON SettlmtApplStsGrp = _SettlmtApplStsGrpStsAssgmt.SettlmtApplStsGrp AND SettlmtApplSts = _SettlmtApplStsGrpStsAssgmt.SettlmtApplSts  -- association [0..1]
LEFT OUTER JOIN I_FrtCostAllocPrcgElmnt AS _FrtCostAllocPrcgElmnt ON FreightCostAllocationDocument = _FrtCostAllocPrcgElmnt.FreightCostAllocationDocument  -- association [0..*]
LEFT OUTER JOIN I_FrtCostAllocDoc AS _RvsdFrtCostAllocDoc ON RvsdFrtCostAllocDoc = _RvsdFrtCostAllocDoc.FreightCostAllocationDocument  -- association [0..1]
LEFT OUTER JOIN E_SettlmtMgmtDoc AS _Extension ON FreightCostAllocationDocument = _Extension.SettlmtMgmtDoc  -- association [1..1]
;

Learn More