C_FrtCostAlcAcctgTransfStsKPI

DDL: C_FRTCOSTALCACCTGTRANSFSTSKPI Type: view_entity CONSUMPTION
21 Fields 1 Data Sources

Freight Cost Alloc Acctg Transf Sts KPI

C_FrtCostAlcAcctgTransfStsKPI is a Consumption CDS View that provides data about "Freight Cost Alloc Acctg Transf Sts KPI" in SAP S/4HANA. It reads from 1 data source (R_FrtCostAllocDoc) and exposes 21 fields with key field FreightCostAllocationDocument.

Data Sources (1)

SourceAliasJoin Type
R_FrtCostAllocDoc R_FrtCostAllocDoc from

Annotations (8)

NameValueLevelField
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #CONSUMPTION view
VDM.lifecycle.contract.type #NONE view
AccessControl.authorizationCheck #MANDATORY view
Metadata.allowExtensions true view
EndUserText.label Freight Cost Alloc Acctg Transf Sts KPI view

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY FreightCostAllocationDocument FreightCostAllocationDocument Freight Cost Allocation Document
FrtCostAllocAcctgTransfSts FrtCostAllocAcctgTransfSts Posting Status
FrtCostAllocAcctgTransfStsName
FrtCostAlcDocChartCtValue
SalesOrganization SalesOrganization Sales Organization
DistributionChannel DistributionChannel RefDistCh-Cust/Mat.
Division Division Internal Division ID
PurchasingOrganization PurchasingOrganization Purchasing Organization
PurchasingGroup PurchasingGroup Purchasing Group
CompanyCode CompanyCode Receiver Company Code
CompanyCodeName _CompanyCode CompanyCodeName Company Name
SettlmtDocType SettlmtDocType Settlement Document Type
SettlmtDocTypeDesc
_FrtCostAllocAcctgTransfSts _FrtCostAllocAcctgTransfSts
_SalesOrganization _SalesOrganization
_DistributionChannel _DistributionChannel
_Division _Division
_PurchasingOrganization _PurchasingOrganization
_PurchasingGroup _PurchasingGroup
_CompanyCode _CompanyCode
_SettlmtDocType _SettlmtDocType

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_FrtCostAlcAcctgTransfStsKPI.
-- 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_FrtCostAlcAcctgTransfStsKPI AS
SELECT
  FreightCostAllocationDocument,
  FrtCostAllocAcctgTransfSts,
  _FrtCostAllocAcctgTransfSts._Text[1: Language = $session.system_language].FrtCostAllocAcctgTransfStsName AS FrtCostAllocAcctgTransfStsName,
  cast( 1 as wlf_setdoc_chart_counter ) AS FrtCostAlcDocChartCtValue,
  SalesOrganization,
  DistributionChannel,
  Division,
  PurchasingOrganization,
  PurchasingGroup,
  CompanyCode,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  SettlmtDocType,
  _SettlmtDocType._Text[1: Language = $session.system_language].SettlmtDocTypeDesc AS SettlmtDocTypeDesc
FROM R_FrtCostAllocDoc
;

Learn More