C_ARProcessFlowJournalEntryDoc

DDL: C_ARPROCESSFLOWJOURNALENTRYDOC Type: view_entity CONSUMPTION
43 Fields 1 Data Sources 2 Associations

Journal Entry Documents for DPF AR

C_ARProcessFlowJournalEntryDoc is a Consumption CDS View that provides data about "Journal Entry Documents for DPF AR" in SAP S/4HANA. It reads from 1 data source (P_ARProcessFlowJournalEntryDoc) and exposes 43 fields with key fields CompanyCode, FiscalYear, AccountingDocument. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
P_ARProcessFlowJournalEntryDoc P_ARProcessFlowJournalEntryDoc from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_Customer _Customer $projection.Customer = _Customer.Customer
[0..1] I_InternalOrder _InternalOrder $projection.OrderID = _InternalOrder.InternalOrder

Annotations (10)

NameValueLevelField
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Journal Entry Documents for DPF AR view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
DataAging.noAgingRestriction true view
ObjectModel.query.implementedBy ABAP:CL_AR_PROCESS_FLOW_DOC_QUERY view
Metadata.ignorePropagatedAnnotations true view

Fields (43)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode CompanyCode Receiver Company Code
KEY FiscalYear FiscalYear G/L Fiscal Year
KEY AccountingDocument AccountingDocument Journal Entry
FinancialAccountType FinancialAccountType Fin. Account Type
ReferenceDocumentType ReferenceDocumentType Reference Document Type
ReferenceDocument ReferenceDocument Reference Document
TransactionCurrency TransactionCurrency Transaction Currency
AmountInTransactionCurrency
ClearingDate ClearingDate Clearing Date
ClearingDocFiscalYear ClearingDocFiscalYear Fiscal Year of Clearing Journal Entry
ClearingJournalEntryFiscalYear ClearingJournalEntryFiscalYear Fiscal Year of Clearing Journal Entry
ClearingAccountingDocument ClearingAccountingDocument Clearing Journal Entry
ClearingJournalEntry ClearingJournalEntry Clrng doc.
AccountingDocCreatedByUser AccountingDocCreatedByUser User which created overhead document
FullName _UserContactCard FullName Name
DocumentDate DocumentDate Journal Entry Date
NetDueDate NetDueDate Net Due Date
FiscalPeriod FiscalPeriod Tax period
FiscalPeriodName FiscalPeriodName
Customer Customer Sold-to Party
CustomerName _Customer CustomerName Name of Customer
AccountingDocumentType AccountingDocumentType Journal Entry Type
AccountingDocumentTypeName AccountingDocumentTypeName
BusinessArea BusinessArea Business Area
FunctionalArea FunctionalArea Sendr Fctl Area
Segment Segment Segment number
OrderID OrderID Order ID
Ledger Ledger Ledger
AuthorizationGroup _GLAccountInCompanyCode AuthorizationGroup AuthorizGroup
SupplierFinsAuthorizationGrp _Supplier AuthorizationGroup AuthorizGroup
CustomerFinsAuthorizationGrp _Customer AuthorizationGroup AuthorizGroup
AcctgDocTypeAuthorizationGroup _AccountingDocumentType AuthorizationGroup AuthorizGroup
SalesOrderType _SalesDocument SalesOrderType Sales Order Type
OrderType _InternalOrder OrderType Order Type
AssetClass _FixedAsset AssetClass Asset Class
FixedAsset FixedAsset Sub-number
MasterFixedAsset MasterFixedAsset Fixed Asset
Plant Plant Valuation Area
ControllingArea ControllingArea Controlling Area
CostCenter CostCenter Cost Center
GLAccount GLAccount General Ledger
ProfitCenter ProfitCenter Profit Center
ValuationArea ValuationArea Valuation Area

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_ARProcessFlowJournalEntryDoc.
-- 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_ARProcessFlowJournalEntryDoc AS
SELECT
  CompanyCode,
  FiscalYear,
  AccountingDocument,
  FinancialAccountType,
  ReferenceDocumentType,
  ReferenceDocument,
  TransactionCurrency,
  sum(AmountInTransactionCurrency) AS AmountInTransactionCurrency,
  ClearingDate,
  ClearingDocFiscalYear,
  ClearingJournalEntryFiscalYear,
  ClearingAccountingDocument,
  ClearingJournalEntry,
  AccountingDocCreatedByUser,
  _UserContactCard.FullName AS FullName,
  DocumentDate,
  NetDueDate,
  FiscalPeriod,
  FiscalPeriodName,
  Customer,
  _Customer.CustomerName AS CustomerName,
  AccountingDocumentType,
  AccountingDocumentTypeName,
  BusinessArea,
  FunctionalArea,
  Segment,
  OrderID,
  Ledger,
  _GLAccountInCompanyCode.AuthorizationGroup AS AuthorizationGroup,
  _Supplier.AuthorizationGroup AS SupplierFinsAuthorizationGrp,
  _Customer.AuthorizationGroup AS CustomerFinsAuthorizationGrp,
  _AccountingDocumentType.AuthorizationGroup AS AcctgDocTypeAuthorizationGroup,
  _SalesDocument.SalesOrderType AS SalesOrderType,
  _InternalOrder.OrderType AS OrderType,
  _FixedAsset.AssetClass AS AssetClass,
  FixedAsset,
  MasterFixedAsset,
  Plant,
  ControllingArea,
  CostCenter,
  GLAccount,
  ProfitCenter,
  ValuationArea
FROM P_ARProcessFlowJournalEntryDoc
LEFT OUTER JOIN I_Customer AS _Customer ON Customer = _Customer.Customer  -- association [0..1]
LEFT OUTER JOIN I_InternalOrder AS _InternalOrder ON OrderID = _InternalOrder.InternalOrder  -- association [0..1]
;

Learn More