R_FrtCostAllocItmTP

DDL: R_FRTCOSTALLOCITMTP Type: view_entity TRANSACTIONAL Package: WLF_BO_TP_FCADOC
134 Fields 1 Data Sources 2 Associations

Frt Cost Allocation Document Item - TP

R_FrtCostAllocItmTP is a Transactional CDS View that provides data about "Frt Cost Allocation Document Item - TP" in SAP S/4HANA. It reads from 1 data source (R_FrtCostAllocItm) and exposes 134 fields with key fields FreightCostAllocationDocument, FrtCostAllocDocumentItem. It has 2 associations to related views. Part of development package WLF_BO_TP_FCADOC.

Data Sources (1)

SourceAliasJoin Type
R_FrtCostAllocItm R_FrtCostAllocItm from

Associations (2)

CardinalityTargetAliasCondition
[1..1] E_SettlmtMgmtDocItem _Extension $projection.FreightCostAllocationDocument = _Extension.SettlmtMgmtDoc and $projection.FrtCostAllocDocumentItem = _Extension.SettlmtMgmtDocItem
[0..*] R_FrtCostAllocItmPrcgElmntTP _FrtCostAllocItmPrcgElmnt

Annotations (17)

NameValueLevelField
EndUserText.label Frt Cost Allocation Document Item - TP view
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.sapObjectNodeType.name FrtCostAllocDocumentItem view
ObjectModel.representativeKey FrtCostAllocDocumentItem view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #XXL view
AbapCatalog.extensibility.extensible true view
AbapCatalog.extensibility.elementSuffix SMI view
AbapCatalog.extensibility.quota.maximumFields 204 view
AbapCatalog.extensibility.quota.maximumBytes 4080 view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
Analytics.dataExtraction.enabled false view
Analytics.internalName #LOCAL view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions false view

Fields (134)

KeyFieldSource TableSource FieldDescription
KEY FreightCostAllocationDocument FreightCostAllocationDocument Freight Cost Allocation Document
KEY FrtCostAllocDocumentItem FrtCostAllocDocumentItem Item
FrtCostAllocDocCurrency FrtCostAllocDocCurrency Document Currency
PricingDocument PricingDocument Document Condition
Product Product Product Sold
ProductGroup ProductGroup Product Sold Group
Plant Plant Valuation Area
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
ProductPurchasePointsQtyUnit ProductPurchasePointsQtyUnit Points Unit
ProductPurchasePointsQty ProductPurchasePointsQty Points
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
CreatedByUser CreatedByUser User Name
CreationDate CreationDate Time Stamp
CreationTime CreationTime Time of Change
SettlmtSourceDoc SettlmtSourceDoc Source Doc.
SettlmtSourceDocItem SettlmtSourceDocItem Item of the Source Document
SettlmtSourceDocCat SettlmtSourceDocCat SourceDocCat
SettlmtSourceDocFiscalYear SettlmtSourceDocFiscalYear Fiscal Year of Source Document
FrtCostAllocItmActivityReason FrtCostAllocItmActivityReason Activity Reason
FrtCostAllocDocItemText FrtCostAllocDocItemText Short Text
SupplierProductID SupplierProductID Supp. Mat. No.
BusinessArea BusinessArea Business Area
ControllingArea ControllingArea Controlling Area
CostCenter CostCenter Cost Center
ProfitCenter ProfitCenter Profit Center
WBSElementInternalID WBSElementInternalID WBS Internal ID
IncotermsVersion IncotermsVersion Inco. Version
IncotermsClassification IncotermsClassification Incoterms
IncotermsTransferLocation IncotermsTransferLocation Incoterms 2
IncotermsLocation1 IncotermsLocation1 Inco. Location1
IncotermsLocation2 IncotermsLocation2 Inco. Location2
Batch Batch Lot No.
PrcDetnIsIncmplt PrcDetnIsIncmplt Price Determination Is Incomplete
SettlmtPrecdgDoc SettlmtPrecdgDoc Pre. Document
SettlmtPrecdgDocItem SettlmtPrecdgDocItem Item of Preceding Document
SettlmtPrecdgDocCat SettlmtPrecdgDocCat PreDocCat
SettlmtPrecdgDocFiscalYear SettlmtPrecdgDocFiscalYear Fiscal Year of Preceding Document
FrtCostAllocDocItmCat FrtCostAllocDocItmCat Item Category
SettlmtItemReltdPurgDoc SettlmtItemReltdPurgDoc ItmRelatedPurgDoc
SettlmtItemReltdPurgDocItem SettlmtItemReltdPurgDocItem ItmRelatedPurgDocItm
SettlmtItemReltdBillgDoc SettlmtItemReltdBillgDoc ItmRelatedBillingDoc
SettlmtItemReltdBillgDocItem SettlmtItemReltdBillgDocItem ItmReltdBillgDocItm
FreightCostAllocationOrder FreightCostAllocationOrder Order
ServicesRenderedDate ServicesRenderedDate Services Rendered Date
CompanyCode CompanyCode Receiver Company Code
GLAccount GLAccount General Ledger
FiscalYear FiscalYear G/L Fiscal Year
FrtCostAllocRefDocType FrtCostAllocRefDocType Settlement Reference Document Type
FrtCostAllocRefDoc FrtCostAllocRefDoc Settlmt. Ref. Doc.
FrtCostAllocRefDocFsclYr FrtCostAllocRefDocFsclYr Year of Reference Document
FrtCostAllocRefDocLgclSyst FrtCostAllocRefDocLgclSyst SM Ref Log Sys
FrtCostAllocRefDocCompanyCode FrtCostAllocRefDocCompanyCode Ref. Company Code
FrtCostAllocRefDocItem FrtCostAllocRefDocItem SettlmtRefDocItem
FrtCostAllocRefDocCat FrtCostAllocRefDocCat SettlmtRefDocCat
FrtCostAllocAddlRefDocType FrtCostAllocAddlRefDocType Additional Reference Doc Type in Settlmt
FrtCostAllocAddlRefDoc FrtCostAllocAddlRefDoc SettlmtAddlRefDoc
FrtCostAllocAddlRefDocFsclYr FrtCostAllocAddlRefDocFsclYr Year of Additional Reference Document
FrtCostAllocAddlRefLgclSyst FrtCostAllocAddlRefLgclSyst SM Addl Ref Log Sys
FrtCostAllocAddlRefDocItem FrtCostAllocAddlRefDocItem SettlmtAddlRefDocItm
FrtCostAllocAddlRefDocCat FrtCostAllocAddlRefDocCat SettlmtAddlRefDocCat
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
_FrtCostAllocDoc _FrtCostAllocDoc
_FrtCostAllocItmPrcgElmnt _FrtCostAllocItmPrcgElmnt
_FrtCostAllocDocCurrency _FrtCostAllocDocCurrency
_Product _Product
_ProductText _ProductText
_ProductGroup _ProductGroup
_Plant _Plant
_InventoryValuationType _InventoryValuationType
_SettlmtQuantityUnit _SettlmtQuantityUnit
_NetPriceQuantityUnit _NetPriceQuantityUnit
_BaseUnit _BaseUnit
_ItemWeightUnit _ItemWeightUnit
_ItemVolumeUnit _ItemVolumeUnit
_ProductPurchasePointsQtyUnit _ProductPurchasePointsQtyUnit
_FrtCostAllocItmStstclPrpty _FrtCostAllocItmStstclPrpty
_CreatedByUser _CreatedByUser
_SettlmtSourceDocCat _SettlmtSourceDocCat
_FrtCostAllocItmActivityReason _FrtCostAllocItmActivityReason
_BusinessArea _BusinessArea
_BusinessAreaText _BusinessAreaText
_ControllingArea _ControllingArea
_CostCenter _CostCenter
_ProfitCenter _ProfitCenter
_WBSElementBasicData _WBSElementBasicData
_IncotermsVersion _IncotermsVersion
_IncotermsClassification _IncotermsClassification
_SettlmtPrecdgDocCat _SettlmtPrecdgDocCat
_FrtCostAllocDocItmCat _FrtCostAllocDocItmCat
_SettlmtItemReltdPurgDoc _SettlmtItemReltdPurgDoc
_SettlmtItemReltdBillgDoc _SettlmtItemReltdBillgDoc
_FreightCostAllocationOrder _FreightCostAllocationOrder
_CompanyCode _CompanyCode
_GLAccountInCompanyCode _GLAccountInCompanyCode
_FrtCostAllocRefDocLgclSyst _FrtCostAllocRefDocLgclSyst
_FrtCostAllocRefDocCompanyCode _FrtCostAllocRefDocCompanyCode
_FrtCostAllocRefDocCat _FrtCostAllocRefDocCat
_FrtCostAllocAddlRefLgclSyst _FrtCostAllocAddlRefLgclSyst
_FrtCostAllocAddlRefDocCat _FrtCostAllocAddlRefDocCat
_SalesSpcfcProductGroup1 _SalesSpcfcProductGroup1
_SalesSpcfcProductGroup2 _SalesSpcfcProductGroup2
_SalesSpcfcProductGroup3 _SalesSpcfcProductGroup3
_SalesSpcfcProductGroup4 _SalesSpcfcProductGroup4
_SalesSpcfcProductGroup5 _SalesSpcfcProductGroup5

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_FrtCostAllocItmTP.
-- 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_FrtCostAllocItmTP AS
SELECT
  FreightCostAllocationDocument,
  FrtCostAllocDocumentItem,
  FrtCostAllocDocCurrency,
  PricingDocument,
  Product,
  ProductGroup,
  Plant,
  InventoryValuationType,
  PricingDate,
  SettlmtQuantity,
  SettlmtQuantityUnit,
  NetPriceAmount,
  NetPriceQuantity,
  NetPriceQuantityUnit,
  SettlmtToBaseQuantityNmrtr,
  SettlmtToBaseQuantityDnmntr,
  SettlmtToNetPriceQtyNmrtr,
  SettlmtToNetPriceQtyDnmntr,
  BaseUnit,
  ItemNetWeight,
  ItemGrossWeight,
  ItemWeightUnit,
  ItemVolume,
  ItemVolumeUnit,
  ProductPurchasePointsQtyUnit,
  ProductPurchasePointsQty,
  FrtCostAllocItemGrossAmount,
  FrtCostAllocItemNetAmount,
  FrtCostAllocSubtotal1Amount,
  FrtCostAllocSubtotal2Amount,
  FrtCostAllocSubtotal3Amount,
  FrtCostAllocSubtotal4Amount,
  FrtCostAllocSubtotal5Amount,
  FrtCostAllocSubtotal6Amount,
  FrtCostAllocEffctvItemAmount,
  FrtCostAllocItmStstclPrpty,
  CreatedByUser,
  CreationDate,
  CreationTime,
  SettlmtSourceDoc,
  SettlmtSourceDocItem,
  SettlmtSourceDocCat,
  SettlmtSourceDocFiscalYear,
  FrtCostAllocItmActivityReason,
  FrtCostAllocDocItemText,
  SupplierProductID,
  BusinessArea,
  ControllingArea,
  CostCenter,
  ProfitCenter,
  WBSElementInternalID,
  IncotermsVersion,
  IncotermsClassification,
  IncotermsTransferLocation,
  IncotermsLocation1,
  IncotermsLocation2,
  Batch,
  PrcDetnIsIncmplt,
  SettlmtPrecdgDoc,
  SettlmtPrecdgDocItem,
  SettlmtPrecdgDocCat,
  SettlmtPrecdgDocFiscalYear,
  FrtCostAllocDocItmCat,
  SettlmtItemReltdPurgDoc,
  SettlmtItemReltdPurgDocItem,
  SettlmtItemReltdBillgDoc,
  SettlmtItemReltdBillgDocItem,
  FreightCostAllocationOrder,
  ServicesRenderedDate,
  CompanyCode,
  GLAccount,
  FiscalYear,
  FrtCostAllocRefDocType,
  FrtCostAllocRefDoc,
  FrtCostAllocRefDocFsclYr,
  FrtCostAllocRefDocLgclSyst,
  FrtCostAllocRefDocCompanyCode,
  FrtCostAllocRefDocItem,
  FrtCostAllocRefDocCat,
  FrtCostAllocAddlRefDocType,
  FrtCostAllocAddlRefDoc,
  FrtCostAllocAddlRefDocFsclYr,
  FrtCostAllocAddlRefLgclSyst,
  FrtCostAllocAddlRefDocItem,
  FrtCostAllocAddlRefDocCat,
  ProductHierarchy,
  SalesSpcfcProductGroup1,
  SalesSpcfcProductGroup2,
  SalesSpcfcProductGroup3,
  SalesSpcfcProductGroup4,
  SalesSpcfcProductGroup5
FROM R_FrtCostAllocItm
LEFT OUTER JOIN E_SettlmtMgmtDocItem AS _Extension ON FreightCostAllocationDocument = _Extension.SettlmtMgmtDoc AND FrtCostAllocDocumentItem = _Extension.SettlmtMgmtDocItem  -- association [1..1]
LEFT OUTER JOIN R_FrtCostAllocItmPrcgElmntTP AS _FrtCostAllocItmPrcgElmnt ON /* condition not available in parsed metadata */  -- association [0..*]
;

Learn More