C_CATransfRecdToRACondition

DDL: C_CATRANSFRECDTORACONDITION Type: view_entity CONSUMPTION
120 Fields 1 Data Sources

Transfer Record Conditions

C_CATransfRecdToRACondition is a Consumption CDS View that provides data about "Transfer Record Conditions" in SAP S/4HANA. It reads from 1 data source (I_CATransfRecdToRACondition) and exposes 120 fields with key fields CARevenueAcctgDocumentItem, CARevenueAcctgConditionUUID.

Data Sources (1)

SourceAliasJoin Type
I_CATransfRecdToRACondition I_CATransfRecdToRACondition projection

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Transfer Record Conditions view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
Metadata.allowExtensions true view
VDM.viewType #CONSUMPTION view

Fields (120)

KeyFieldSource TableSource FieldDescription
KEY CARevenueAcctgDocumentItem CARevenueAcctgDocumentItem
KEY CARevenueAcctgConditionUUID CARevenueAcctgConditionUUID Waste Partner UUID
RevnAcctgSenderComponent RevnAcctgSenderComponent Sender Component
RASndgCompLogicalSystem RASndgCompLogicalSystem Source System
RASndgCompDocumentItemType RASndgCompDocumentItemType
RASndgCompDocumentItem RASndgCompDocumentItem
RAItemCreationDateTime RAItemCreationDateTime
CARevenueAccountingServiceType CARevenueAccountingServiceType Service Type
CARevnAcctgServiceTypeTextlocalized
ConditionType ConditionType Condition type
ConditionTypeNamelocalized
RAProfitAndLossAccount RAProfitAndLossAccount
RevnAcctgPostgAmtInSlsDocCrcy RevnAcctgPostgAmtInSlsDocCrcy
SalesDocumentCurrency SalesDocumentCurrency Currency
RevnAcctgPostgAmtInCoCodeCrcy RevnAcctgPostgAmtInCoCodeCrcy
CompanyCodeCurrency CompanyCodeCurrency Local Currency
RevnAcctgPostgAmtInAddlCrcy1 RevnAcctgPostgAmtInAddlCrcy1
AdditionalCurrency1 AdditionalCurrency1 Local curr. 2
RevnAcctgPostgAmtInAddlCrcy2 RevnAcctgPostgAmtInAddlCrcy2
AdditionalCurrency2 AdditionalCurrency2 Local curr. 3
RAConditionItemIsMainCondition RAConditionItemIsMainCondition Main Cond. Type
RevnAcctgConditionCategory RevnAcctgConditionCategory
RevnAcctgConditionCategoryNamelocalized
CATransfRecdToRAChangeCode CATransfRecdToRAChangeCode Change Indicator
CATransfRecdToRAChangeCodeTextlocalized
ProfitLostAccountIsDtmndByRA ProfitLostAccountIsDtmndByRA
RAConditionItemIsStatistical RAConditionItemIsStatistical
RevnAcctgOperationalDocument _CATransfRecdToRA RevnAcctgOperationalDocument
RAOperationalDocumentItem _CATransfRecdToRA RAOperationalDocumentItem
RADocumentCreationDate _CATransfRecdToRA RADocumentCreationDate
RADocumentCreationTime _CATransfRecdToRA RADocumentCreationTime
CASendingDate _CATransfRecdToRA CASendingDate
CASendingTime _CATransfRecdToRA CASendingTime
CASendingDateTime _CATransfRecdToRA CASendingDateTime
Customer _CATransfRecdToRA Customer Sold-to Party
BusinessPartner _CATransfRecdToRA BusinessPartner Issuing Authority
ContractAccount _CATransfRecdToRA ContractAccount Contract Acct
CAContract _CATransfRecdToRA CAContract Contract
CAProviderContractItemNumber _CATransfRecdToRA CAProviderContractItemNumber Contract Item
CASubApplication _CATransfRecdToRA CASubApplication Subapplication
CompanyCode _CATransfRecdToRA CompanyCode Receiver Company Code
AmountInTransactionCurrency _CATransfRecdToRA AmountInTransactionCurrency Pt Crcy Amt
TransactionCurrency _CATransfRecdToRA TransactionCurrency Transaction Currency
CARevenueAcctgQuantity _CATransfRecdToRA CARevenueAcctgQuantity
CARevenueAcctgQuantityUnit _CATransfRecdToRA CARevenueAcctgQuantityUnit
RAItemQuantityIsRelevant _CATransfRecdToRA RAItemQuantityIsRelevant
RAOriginalDocItemSenderComp _CATransfRecdToRA RAOriginalDocItemSenderComp
RAOriginalDocItemLogicalSystem _CATransfRecdToRA RAOriginalDocItemLogicalSystem
RAOriginalDocItemType _CATransfRecdToRA RAOriginalDocItemType OrigItemType
RAOriginalDocItemID _CATransfRecdToRA RAOriginalDocItemID OriginalItemID
RAInvoiceDueDate _CATransfRecdToRA RAInvoiceDueDate
RAInvoiceType _CATransfRecdToRA RAInvoiceType
RAInvoiceCategory _CATransfRecdToRA RAInvoiceCategory
PerfOblgnIsFinallyInvoiced _CATransfRecdToRA PerfOblgnIsFinallyInvoiced Final Invoice
CAInvoicingDocument _CATransfRecdToRA CAInvoicingDocument Invoic. Doc.
CAInvcgRevenueGrouping _CATransfRecdToRA CAInvcgRevenueGrouping Revenue Group
PostingDate _CATransfRecdToRA PostingDate Posting Date for GR
RAFulfillmentEventDate _CATransfRecdToRA RAFulfillmentEventDate
RAFulfillmentEventTime _CATransfRecdToRA RAFulfillmentEventTime
PerfOblgnEventType _CATransfRecdToRA PerfOblgnEventType Event Type
IsReversed _CATransfRecdToRA IsReversed Reversed?
IsMarkedForDeletion _CATransfRecdToRA IsMarkedForDeletion Purch.org. data
AbsoluteExchangeRate _CATransfRecdToRA AbsoluteExchangeRate Absolute Exchange Rate
ExchRateIsIndirectQuotation _CATransfRecdToRA ExchRateIsIndirectQuotation Exchange Rate Is Indirect Quotation
AddlCrcy1AbsoluteExchangeRate _CATransfRecdToRA AddlCrcy1AbsoluteExchangeRate
AddlCrcy1ExchRateIsIndrctQtan _CATransfRecdToRA AddlCrcy1ExchRateIsIndrctQtan
AddlCrcy2AbsoluteExchangeRate _CATransfRecdToRA AddlCrcy2AbsoluteExchangeRate
AddlCrcy2ExchRateIsIndrctQtan _CATransfRecdToRA AddlCrcy2ExchRateIsIndrctQtan
CARevenueAccountingRefType _CATransfRecdToRA CARevenueAccountingRefType
RevenueAccountingReference _CATransfRecdToRA RevenueAccountingReference
BusinessArea _CATransfRecdToRA BusinessArea Business Area
ProfitCenter _CATransfRecdToRA ProfitCenter Profit Center
Segment _CATransfRecdToRA Segment Segment number
PerformanceObligationStartDate _CATransfRecdToRA PerformanceObligationStartDate Start Date
PerformanceObligationEndDate _CATransfRecdToRA PerformanceObligationEndDate End Date
RAHigherDocItemSenderComp _CATransfRecdToRA RAHigherDocItemSenderComp
RAHigherDocItemLogicalSystem _CATransfRecdToRA RAHigherDocItemLogicalSystem
RAHigherDocItemType _CATransfRecdToRA RAHigherDocItemType
RAHigherDocItemID _CATransfRecdToRA RAHigherDocItemID
RevnAcctgSalesOrganization _CATransfRecdToRA RevnAcctgSalesOrganization Sales Org.
PerfObligationInceptionDate _CATransfRecdToRA PerfObligationInceptionDate
RAInvoiceAmountIsRelevant _CATransfRecdToRA RAInvoiceAmountIsRelevant
PerfObligationChangeReason _CATransfRecdToRA PerfObligationChangeReason
CAProduct _CATransfRecdToRA CAProduct
CASalesPackageProduct _CATransfRecdToRA CASalesPackageProduct
Division _CATransfRecdToRA Division Internal Division ID
DistributionChannel _CATransfRecdToRA DistributionChannel RefDistCh-Cust/Mat.
QuantityAndPriceIsDtmndByRA _CATransfRecdToRA QuantityAndPriceIsDtmndByRA
CASubAreaForParallelization _CATransfRecdToRA CASubAreaForParallelization Subarea
ReceivableAccountIsDtmndByRA _CATransfRecdToRA ReceivableAccountIsDtmndByRA
AccountAssignmentIsDtmndByRA _CATransfRecdToRA AccountAssignmentIsDtmndByRA
RevnAcctgReceivablesAccount _CATransfRecdToRA RevnAcctgReceivablesAccount
RAItemType _CATransfRecdToRA RAItemType
CARevenueAcctgMigrationPackage _CATransfRecdToRA CARevenueAcctgMigrationPackage
RADocItemIsCreatedByInitLoad _CATransfRecdToRA RADocItemIsCreatedByInitLoad
RAPerfOblgnFinalizationDate _CATransfRecdToRA RAPerfOblgnFinalizationDate Finalizat. Date
RAPredecessorDocItemSenderComp _CATransfRecdToRA RAPredecessorDocItemSenderComp
RAPredecessorDocItemLgclSystem _CATransfRecdToRA RAPredecessorDocItemLgclSystem
RAPredecessorDocItemType _CATransfRecdToRA RAPredecessorDocItemType
RAPredecessorDocItemID _CATransfRecdToRA RAPredecessorDocItemID
CACrtnMethOfTransfRecordsToRA _CATransfRecdToRA CACrtnMethOfTransfRecordsToRA
RevnAcctgContrChangeEffctvDate _CATransfRecdToRA RevnAcctgContrChangeEffctvDate
PerfOblgnHasAssetImpairment _CATransfRecdToRA PerfOblgnHasAssetImpairment
CASubscriptionChargeType _CATransfRecdToRA CASubscriptionChargeType
OrderID _CATransfRecdToRA OrderID Order ID
WBSElementInternalID _CATransfRecdToRA WBSElementInternalID WBS Internal ID
SoldProduct _CATransfRecdToRA SoldProduct Product Sold
PrvdrContrItmIsRlvtForPrfSgDrv _CATransfRecdToRA PrvdrContrItmIsRlvtForPrfSgDrv
CABillgPlnNumber _CATransfRecdToRA CABillgPlnNumber Billing Plan
_RevnAcctgSenderComponent _RevnAcctgSenderComponent
_RASndgCompLogicalSystem _RASndgCompLogicalSystem
_RASndgCompDocumentItemType _RASndgCompDocumentItemType
_CARevnAcctgServiceType _CARevnAcctgServiceType
_ConditionType _ConditionType
_SalesDocumentCurrency _SalesDocumentCurrency
_CompanyCodeCurrency _CompanyCodeCurrency
_AdditionalCurrency1 _AdditionalCurrency1
_AdditionalCurrency2 _AdditionalCurrency2
_RevnAcctgConditionCategory _RevnAcctgConditionCategory
_CATransfRecdToRAChangeCode _CATransfRecdToRAChangeCode

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_CATransfRecdToRACondition.
-- 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_CATransfRecdToRACondition AS
SELECT
  CARevenueAcctgDocumentItem,
  CARevenueAcctgConditionUUID,
  RevnAcctgSenderComponent,
  RASndgCompLogicalSystem,
  RASndgCompDocumentItemType,
  RASndgCompDocumentItem,
  RAItemCreationDateTime,
  CARevenueAccountingServiceType,
  _CARevnAcctgServiceType._CARevnAcctgServiceTypeText.CARevnAcctgServiceTypeText : localized AS CARevnAcctgServiceTypeTextlocalized,
  ConditionType,
  _ConditionType._Text.ConditionTypeName : localized AS ConditionTypeNamelocalized,
  RAProfitAndLossAccount,
  RevnAcctgPostgAmtInSlsDocCrcy,
  SalesDocumentCurrency,
  RevnAcctgPostgAmtInCoCodeCrcy,
  CompanyCodeCurrency,
  RevnAcctgPostgAmtInAddlCrcy1,
  AdditionalCurrency1,
  RevnAcctgPostgAmtInAddlCrcy2,
  AdditionalCurrency2,
  RAConditionItemIsMainCondition,
  RevnAcctgConditionCategory,
  _RevnAcctgConditionCategory._Text.RevnAcctgConditionCategoryName : localized AS RevnAcctgConditionCategoryNamelocalized,
  CATransfRecdToRAChangeCode,
  _CATransfRecdToRAChangeCode._CATransfRecdToRAChangeCodeT.CATransfRecdToRAChangeCodeText : localized AS CATransfRecdToRAChangeCodeTextlocalized,
  ProfitLostAccountIsDtmndByRA,
  RAConditionItemIsStatistical,
  _CATransfRecdToRA.RevnAcctgOperationalDocument AS RevnAcctgOperationalDocument,
  _CATransfRecdToRA.RAOperationalDocumentItem AS RAOperationalDocumentItem,
  _CATransfRecdToRA.RADocumentCreationDate AS RADocumentCreationDate,
  _CATransfRecdToRA.RADocumentCreationTime AS RADocumentCreationTime,
  _CATransfRecdToRA.CASendingDate AS CASendingDate,
  _CATransfRecdToRA.CASendingTime AS CASendingTime,
  _CATransfRecdToRA.CASendingDateTime AS CASendingDateTime,
  _CATransfRecdToRA.Customer AS Customer,
  _CATransfRecdToRA.BusinessPartner AS BusinessPartner,
  _CATransfRecdToRA.ContractAccount AS ContractAccount,
  _CATransfRecdToRA.CAContract AS CAContract,
  _CATransfRecdToRA.CAProviderContractItemNumber AS CAProviderContractItemNumber,
  _CATransfRecdToRA.CASubApplication AS CASubApplication,
  _CATransfRecdToRA.CompanyCode AS CompanyCode,
  _CATransfRecdToRA.AmountInTransactionCurrency AS AmountInTransactionCurrency,
  _CATransfRecdToRA.TransactionCurrency AS TransactionCurrency,
  _CATransfRecdToRA.CARevenueAcctgQuantity AS CARevenueAcctgQuantity,
  _CATransfRecdToRA.CARevenueAcctgQuantityUnit AS CARevenueAcctgQuantityUnit,
  _CATransfRecdToRA.RAItemQuantityIsRelevant AS RAItemQuantityIsRelevant,
  _CATransfRecdToRA.RAOriginalDocItemSenderComp AS RAOriginalDocItemSenderComp,
  _CATransfRecdToRA.RAOriginalDocItemLogicalSystem AS RAOriginalDocItemLogicalSystem,
  _CATransfRecdToRA.RAOriginalDocItemType AS RAOriginalDocItemType,
  _CATransfRecdToRA.RAOriginalDocItemID AS RAOriginalDocItemID,
  _CATransfRecdToRA.RAInvoiceDueDate AS RAInvoiceDueDate,
  _CATransfRecdToRA.RAInvoiceType AS RAInvoiceType,
  _CATransfRecdToRA.RAInvoiceCategory AS RAInvoiceCategory,
  _CATransfRecdToRA.PerfOblgnIsFinallyInvoiced AS PerfOblgnIsFinallyInvoiced,
  _CATransfRecdToRA.CAInvoicingDocument AS CAInvoicingDocument,
  _CATransfRecdToRA.CAInvcgRevenueGrouping AS CAInvcgRevenueGrouping,
  _CATransfRecdToRA.PostingDate AS PostingDate,
  _CATransfRecdToRA.RAFulfillmentEventDate AS RAFulfillmentEventDate,
  _CATransfRecdToRA.RAFulfillmentEventTime AS RAFulfillmentEventTime,
  _CATransfRecdToRA.PerfOblgnEventType AS PerfOblgnEventType,
  _CATransfRecdToRA.IsReversed AS IsReversed,
  _CATransfRecdToRA.IsMarkedForDeletion AS IsMarkedForDeletion,
  _CATransfRecdToRA.AbsoluteExchangeRate AS AbsoluteExchangeRate,
  _CATransfRecdToRA.ExchRateIsIndirectQuotation AS ExchRateIsIndirectQuotation,
  _CATransfRecdToRA.AddlCrcy1AbsoluteExchangeRate AS AddlCrcy1AbsoluteExchangeRate,
  _CATransfRecdToRA.AddlCrcy1ExchRateIsIndrctQtan AS AddlCrcy1ExchRateIsIndrctQtan,
  _CATransfRecdToRA.AddlCrcy2AbsoluteExchangeRate AS AddlCrcy2AbsoluteExchangeRate,
  _CATransfRecdToRA.AddlCrcy2ExchRateIsIndrctQtan AS AddlCrcy2ExchRateIsIndrctQtan,
  _CATransfRecdToRA.CARevenueAccountingRefType AS CARevenueAccountingRefType,
  _CATransfRecdToRA.RevenueAccountingReference AS RevenueAccountingReference,
  _CATransfRecdToRA.BusinessArea AS BusinessArea,
  _CATransfRecdToRA.ProfitCenter AS ProfitCenter,
  _CATransfRecdToRA.Segment AS Segment,
  _CATransfRecdToRA.PerformanceObligationStartDate AS PerformanceObligationStartDate,
  _CATransfRecdToRA.PerformanceObligationEndDate AS PerformanceObligationEndDate,
  _CATransfRecdToRA.RAHigherDocItemSenderComp AS RAHigherDocItemSenderComp,
  _CATransfRecdToRA.RAHigherDocItemLogicalSystem AS RAHigherDocItemLogicalSystem,
  _CATransfRecdToRA.RAHigherDocItemType AS RAHigherDocItemType,
  _CATransfRecdToRA.RAHigherDocItemID AS RAHigherDocItemID,
  _CATransfRecdToRA.RevnAcctgSalesOrganization AS RevnAcctgSalesOrganization,
  _CATransfRecdToRA.PerfObligationInceptionDate AS PerfObligationInceptionDate,
  _CATransfRecdToRA.RAInvoiceAmountIsRelevant AS RAInvoiceAmountIsRelevant,
  _CATransfRecdToRA.PerfObligationChangeReason AS PerfObligationChangeReason,
  _CATransfRecdToRA.CAProduct AS CAProduct,
  _CATransfRecdToRA.CASalesPackageProduct AS CASalesPackageProduct,
  _CATransfRecdToRA.Division AS Division,
  _CATransfRecdToRA.DistributionChannel AS DistributionChannel,
  _CATransfRecdToRA.QuantityAndPriceIsDtmndByRA AS QuantityAndPriceIsDtmndByRA,
  _CATransfRecdToRA.CASubAreaForParallelization AS CASubAreaForParallelization,
  _CATransfRecdToRA.ReceivableAccountIsDtmndByRA AS ReceivableAccountIsDtmndByRA,
  _CATransfRecdToRA.AccountAssignmentIsDtmndByRA AS AccountAssignmentIsDtmndByRA,
  _CATransfRecdToRA.RevnAcctgReceivablesAccount AS RevnAcctgReceivablesAccount,
  _CATransfRecdToRA.RAItemType AS RAItemType,
  _CATransfRecdToRA.CARevenueAcctgMigrationPackage AS CARevenueAcctgMigrationPackage,
  _CATransfRecdToRA.RADocItemIsCreatedByInitLoad AS RADocItemIsCreatedByInitLoad,
  _CATransfRecdToRA.RAPerfOblgnFinalizationDate AS RAPerfOblgnFinalizationDate,
  _CATransfRecdToRA.RAPredecessorDocItemSenderComp AS RAPredecessorDocItemSenderComp,
  _CATransfRecdToRA.RAPredecessorDocItemLgclSystem AS RAPredecessorDocItemLgclSystem,
  _CATransfRecdToRA.RAPredecessorDocItemType AS RAPredecessorDocItemType,
  _CATransfRecdToRA.RAPredecessorDocItemID AS RAPredecessorDocItemID,
  _CATransfRecdToRA.CACrtnMethOfTransfRecordsToRA AS CACrtnMethOfTransfRecordsToRA,
  _CATransfRecdToRA.RevnAcctgContrChangeEffctvDate AS RevnAcctgContrChangeEffctvDate,
  _CATransfRecdToRA.PerfOblgnHasAssetImpairment AS PerfOblgnHasAssetImpairment,
  _CATransfRecdToRA.CASubscriptionChargeType AS CASubscriptionChargeType,
  _CATransfRecdToRA.OrderID AS OrderID,
  _CATransfRecdToRA.WBSElementInternalID AS WBSElementInternalID,
  _CATransfRecdToRA.SoldProduct AS SoldProduct,
  _CATransfRecdToRA.PrvdrContrItmIsRlvtForPrfSgDrv AS PrvdrContrItmIsRlvtForPrfSgDrv,
  _CATransfRecdToRA.CABillgPlnNumber AS CABillgPlnNumber
FROM I_CATransfRecdToRACondition
;

Learn More