I_FrtCostAllocDocTP

DDL: I_FRTCOSTALLOCDOCTP Type: view_entity TRANSACTIONAL
42 Fields 1 Data Sources

Freight Cost Allocation Document - TP

I_FrtCostAllocDocTP is a Transactional CDS View that provides data about "Freight Cost Allocation Document - TP" in SAP S/4HANA. It reads from 1 data source (R_FrtCostAllocDocTP) and exposes 42 fields with key field FreightCostAllocationDocument.

Data Sources (1)

SourceAliasJoin Type
R_FrtCostAllocDocTP R_FrtCostAllocDocTP projection

Annotations (14)

NameValueLevelField
EndUserText.label Freight Cost Allocation Document - TP view
AccessControl.authorizationCheck #MANDATORY view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.sapObjectNodeType.name FreightCostAllocationDocument view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.modelingPattern #TRANSACTIONAL_INTERFACE view
AbapCatalog.extensibility.extensible true view
AbapCatalog.extensibility.elementSuffix SMH view
AbapCatalog.extensibility.quota.maximumFields 204 view
AbapCatalog.extensibility.quota.maximumBytes 4080 view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
VDM.viewType #TRANSACTIONAL view

Fields (42)

KeyFieldSource TableSource FieldDescription
KEY FreightCostAllocationDocument FreightCostAllocationDocument Freight Cost Allocation Document
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
DocumentDate DocumentDate Journal Entry Date
DocumentReferenceID DocumentReferenceID Reference
AssignmentReference AssignmentReference Assignment Reference
SettlmtApplSts SettlmtApplSts Appl. Status
SettlmtApplStsGrp SettlmtApplStsGrp Status Group
PricingProcedure PricingProcedure Procedure
PricingDocument PricingDocument Document Condition
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
SalesOffice SalesOffice Sales Office
SalesGroup SalesGroup Sales Group
CreatedByUser CreatedByUser User Name
CreationDate CreationDate Time Stamp
CreationTime CreationTime Time of Change
LastChangeDate LastChangeDate Time Stamp
FrtCostAllocDocCurrency FrtCostAllocDocCurrency Document Currency
ExchangeRate ExchangeRate Exchange rate
ExchangeRateType ExchangeRateType Exch. Rate Type
ExchangeRateIsFixed ExchangeRateIsFixed Fixed Exch.Rate
ExchangeRateDate ExchangeRateDate Translatn Date
FrtCostAllocDocTotGrossAmount FrtCostAllocDocTotGrossAmount Gross Amount
FrtCostAllocDocTotalNetAmount FrtCostAllocDocTotalNetAmount Net Amount
FrtCostAllocDocIsReversed FrtCostAllocDocIsReversed Document is Reversed
RvsdFrtCostAllocDoc RvsdFrtCostAllocDoc Reversed Document
FrtCostAllocDocActivityReason FrtCostAllocDocActivityReason Header Document Creation Activity Reason
SettlmtClassificationCat SettlmtClassificationCat Classification Cat.
FiscalPeriod FiscalPeriod Tax period
FrtCostAllocDocIncmpltnsRsn FrtCostAllocDocIncmpltnsRsn Incomplete Rsn
FrtCostAllocBusProcCat FrtCostAllocBusProcCat Use Case Type
JournalEntryCreationDate JournalEntryCreationDate Journal Entry Creation Date
JournalEntryCreationTime JournalEntryCreationTime Journal Entry Creation Time

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_FrtCostAllocDocTP.
-- 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_FrtCostAllocDocTP 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_FrtCostAllocDocTP
;

Learn More