R_CFinRpldPurgDocAcctAsgtTP_2

DDL: R_CFINRPLDPURGDOCACCTASGTTP_2 Type: view_entity TRANSACTIONAL
47 Fields 1 Data Sources 2 Associations

CFin Rpld PurgDoc AccountAssignment - TP

R_CFinRpldPurgDocAcctAsgtTP_2 is a Transactional CDS View that provides data about "CFin Rpld PurgDoc AccountAssignment - TP" in SAP S/4HANA. It reads from 1 data source (R_CFinRpldPurgDocAcctAssgmt) and exposes 47 fields with key field CFinRpldPurgDocAcctAssgmtUUID. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
R_CFinRpldPurgDocAcctAssgmt R_CFinRpldPurgDocAcctAssgmt from

Associations (2)

CardinalityTargetAliasCondition
[1..1] R_CFinRpldPurchasingDocTP_2 _CFinRpldPurchasingDoc $projection.CFinRpldPurchasingDocUUID = _CFinRpldPurchasingDoc.CFinRpldPurchasingDocUUID
[1..1] E_CFinRpldPurgDocAcctAssgmt _Extension $projection.CFinRpldPurgDocAcctAssgmtUUID = _Extension.CFinRpldPurgDocAcctAssgmtUUID

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label CFin Rpld PurgDoc AccountAssignment - TP view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view

Fields (47)

KeyFieldSource TableSource FieldDescription
KEY CFinRpldPurgDocAcctAssgmtUUID CFinRpldPurgDocAcctAssgmtUUID UUID
CFinRpldPurchasingDocUUID CFinRpldPurchasingDocUUID UUID
CFinRpldPurchasingDocItemUUID CFinRpldPurchasingDocItemUUID UUID
SourceSystemLogicalSystem SourceSystemLogicalSystem Sender Log Sys.
CFinRpldPurchasingDocument CFinRpldPurchasingDocument Purchasing Doc.
CFinRpldPurchasingDocumentItem CFinRpldPurchasingDocumentItem Item
CFinRpldPurgDocAcctAssgmt CFinRpldPurgDocAcctAssgmt
IsDeleted IsDeleted TRUE
Quantity Quantity Value
MultipleAcctAssgmtDistrPercent MultipleAcctAssgmtDistrPercent Distribution
PurgDocNetAmount PurgDocNetAmount Net Value
GLAccount GLAccount General Ledger
BusinessArea BusinessArea Business Area
CostCenter CostCenter Cost Center
CFinReplicatedSalesDocument CFinReplicatedSalesDocument Central Finance Repl. Sales Document
CFinRpldSalesDocumentItem CFinRpldSalesDocumentItem Central Finance Repl. Sales Doc. Item
CFinRpldSalesDocScheduleLine CFinRpldSalesDocScheduleLine Central Finance Repl. Schedule Line
MasterFixedAsset MasterFixedAsset Fixed Asset
FixedAsset FixedAsset Sub-number
OrderID OrderID Order ID
ControllingArea ControllingArea Controlling Area
WBSElementInternalID WBSElementInternalID WBS Internal ID
ProjectNetworkInternalID ProjectNetworkInternalID Plan No.f.Oper.
ProjectNetwork ProjectNetwork Order
REInternalFinNumber REInternalFinNumber Real Estate Key
NetworkActivityInternalID NetworkActivityInternalID Counter
CommitmentItemShortID CommitmentItemShortID Commitment Item Short ID
FundsCenter FundsCenter Funds Center
Fund Fund Sender Fund
FunctionalArea FunctionalArea Sendr Fctl Area
SettlementReferenceDate SettlementReferenceDate Reference date
NonDeductibleInputTaxAmount NonDeductibleInputTaxAmount Non-deductible
CostCtrActivityType CostCtrActivityType Activity Type
GrantID GrantID Sender Grant
BudgetPeriod BudgetPeriod Budget Period
QuantityAsFloatValue QuantityAsFloatValue Qty (FP Number)
PubSecSplitBatchNumberID PubSecSplitBatchNumberID Dist.Batch No.
USFedGovernmentUUID USFedGovernmentUUID US Govt
GoodsRecepientName GoodsRecepientName Recipient
CreationDate CreationDate Time Stamp
ProfitCenter ProfitCenter Profit Center
ProfitabilitySegment ProfitabilitySegment Profitability Segment
OperatingConcern OperatingConcern Operating concern
OrderQuantityUnit OrderQuantityUnit Sales Unit
DocumentCurrency DocumentCurrency Document Currency
_CFinRpldPurchasingDoc _CFinRpldPurchasingDoc
_CFinRpldPurgDocItem _CFinRpldPurgDocItem

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_CFinRpldPurgDocAcctAsgtTP_2.
-- 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_CFinRpldPurgDocAcctAsgtTP_2 AS
SELECT
  CFinRpldPurgDocAcctAssgmtUUID,
  CFinRpldPurchasingDocUUID,
  CFinRpldPurchasingDocItemUUID,
  SourceSystemLogicalSystem,
  CFinRpldPurchasingDocument,
  CFinRpldPurchasingDocumentItem,
  CFinRpldPurgDocAcctAssgmt,
  IsDeleted,
  Quantity,
  MultipleAcctAssgmtDistrPercent,
  PurgDocNetAmount,
  GLAccount,
  BusinessArea,
  CostCenter,
  CFinReplicatedSalesDocument,
  CFinRpldSalesDocumentItem,
  CFinRpldSalesDocScheduleLine,
  MasterFixedAsset,
  FixedAsset,
  OrderID,
  ControllingArea,
  WBSElementInternalID,
  ProjectNetworkInternalID,
  ProjectNetwork,
  REInternalFinNumber,
  NetworkActivityInternalID,
  CommitmentItemShortID,
  FundsCenter,
  Fund,
  FunctionalArea,
  SettlementReferenceDate,
  NonDeductibleInputTaxAmount,
  CostCtrActivityType,
  GrantID,
  BudgetPeriod,
  QuantityAsFloatValue,
  PubSecSplitBatchNumberID,
  USFedGovernmentUUID,
  GoodsRecepientName,
  CreationDate,
  ProfitCenter,
  ProfitabilitySegment,
  OperatingConcern,
  OrderQuantityUnit,
  DocumentCurrency
FROM R_CFinRpldPurgDocAcctAssgmt
LEFT OUTER JOIN R_CFinRpldPurchasingDocTP_2 AS _CFinRpldPurchasingDoc ON CFinRpldPurchasingDocUUID = _CFinRpldPurchasingDoc.CFinRpldPurchasingDocUUID  -- association [1..1]
LEFT OUTER JOIN E_CFinRpldPurgDocAcctAssgmt AS _Extension ON CFinRpldPurgDocAcctAssgmtUUID = _Extension.CFinRpldPurgDocAcctAssgmtUUID  -- association [1..1]
;

Learn More