P_ARProcessFlowJournalEntryDoc

DDL: P_ARPROCESSFLOWJOURNALENTRYDOC Type: view_entity CONSUMPTION
66 Fields 1 Data Sources 3 Associations

Journal Entry for AR process flow

P_ARProcessFlowJournalEntryDoc is a Consumption CDS View that provides data about "Journal Entry for AR process flow" in SAP S/4HANA. It reads from 1 data source (I_OperationalAcctgDocItem) and exposes 66 fields with key fields CompanyCode, FiscalYear, AccountingDocument, AccountingDocumentItem. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_OperationalAcctgDocItem I_OperationalAcctgDocItem from

Associations (3)

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

Annotations (9)

NameValueLevelField
VDM.viewType #CONSUMPTION view
VDM.private true view
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Journal Entry for AR process flow view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
AccessControl.personalData.blocking #REQUIRED view
DataAging.noAgingRestriction true view

Fields (66)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode CompanyCode Receiver Company Code
KEY FiscalYear FiscalYear G/L Fiscal Year
KEY AccountingDocument AccountingDocument Journal Entry
KEY AccountingDocumentItem AccountingDocumentItem Posting View Item
FinancialAccountType FinancialAccountType Fin. Account Type
DebitCreditCode DebitCreditCode Single-Character Flag
ReferenceDocumentType ReferenceDocumentType Reference Document Type
ReferenceDocument OriginalReferenceDocument Reference Key
BillingDocument BillingDocument SD Document
PostingDate PostingDate Posting Date for GR
NetDueDate NetDueDate Net Due Date
TransactionCurrency TransactionCurrency Transaction Currency
AmountInTransactionCurrency AmountInTransactionCurrency Pt Crcy Amt
CompanyCodeCurrency CompanyCodeCurrency Local Currency
AmountInCompanyCodeCurrency AmountInCompanyCodeCurrency Local Crcy Amt
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 _JournalEntry AccountingDocCreatedByUser User which created overhead document
DocumentDate DocumentDate Journal Entry Date
FiscalPeriod FiscalPeriod Tax period
FiscalPeriodName
Customer Customer Sold-to Party
CustomerName _Customer CustomerName Name of Customer
Supplier Supplier Supplier
AccountingDocumentType AccountingDocumentType Journal Entry Type
AccountingDocumentTypeName
Ledger _JournalEntry Ledger Ledger
IsLeadingLedger
BusinessArea BusinessArea Business Area
FunctionalArea FunctionalArea Sendr Fctl Area
ProfitCenter ProfitCenter Profit Center
CostCenter CostCenter Cost Center
GLAccount GLAccount General Ledger
Segment Segment Segment number
ControllingArea ControllingArea Controlling Area
Plant Plant Valuation Area
ValuationArea ValuationArea Valuation Area
SalesOrder SalesDocument SD Document
_GLAccountInCompanyCode _GLAccountInCompanyCode
_Supplier _Supplier
_Customer _Customer
_AccountingDocumentType _AccountingDocumentType
_SalesDocument _SalesDocument
_InternalOrder _InternalOrder
_FixedAsset _FixedAsset
FixedAsset FixedAsset Sub-number
MasterFixedAsset MasterFixedAsset Fixed Asset
OrderID OrderID Order ID
ServiceDocument ServiceDocument Transaction ID
ServiceDocumentType ServiceDocumentType Transaction Type
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
_UserContactCard _UserContactCard
_CompanyCode _CompanyCode
_Plant _Plant
_SalesDoc _SalesDoc
_ServiceDocument _ServiceDocument
_ServiceDocumentType _ServiceDocumentType

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 P_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 P_ARProcessFlowJournalEntryDoc AS
SELECT
  CompanyCode,
  FiscalYear,
  AccountingDocument,
  AccountingDocumentItem,
  FinancialAccountType,
  DebitCreditCode,
  ReferenceDocumentType,
  OriginalReferenceDocument AS ReferenceDocument,
  BillingDocument,
  PostingDate,
  NetDueDate,
  TransactionCurrency,
  AmountInTransactionCurrency,
  CompanyCodeCurrency,
  AmountInCompanyCodeCurrency,
  ClearingDate,
  ClearingDocFiscalYear,
  ClearingJournalEntryFiscalYear,
  ClearingAccountingDocument,
  ClearingJournalEntry,
  _JournalEntry.AccountingDocCreatedByUser AS AccountingDocCreatedByUser,
  DocumentDate,
  FiscalPeriod,
  _FiscalPeriod._Text[1:Language = $session.system_language].FiscalPeriodName AS FiscalPeriodName,
  Customer,
  _Customer.CustomerName AS CustomerName,
  Supplier,
  AccountingDocumentType,
  _AccountingDocumentType._Text[1:Language = $session.system_language].AccountingDocumentTypeName AS AccountingDocumentTypeName,
  _JournalEntry.Ledger AS Ledger,
  _JournalEntry._Ledger.IsLeadingLedger AS IsLeadingLedger,
  BusinessArea,
  FunctionalArea,
  ProfitCenter,
  CostCenter,
  GLAccount,
  Segment,
  ControllingArea,
  Plant,
  ValuationArea,
  SalesDocument AS SalesOrder,
  FixedAsset,
  MasterFixedAsset,
  OrderID,
  ServiceDocument,
  ServiceDocumentType,
  _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
FROM I_OperationalAcctgDocItem
LEFT OUTER JOIN I_Customer AS _Customer ON Customer = _Customer.Customer  -- association [0..1]
LEFT OUTER JOIN I_UserContactCard AS _UserContactCard ON accountingdoccreatedbyuser = _UserContactCard.ContactCardID  -- association [1..1]
LEFT OUTER JOIN I_InternalOrder AS _InternalOrder ON OrderID = _InternalOrder.InternalOrder  -- association [0..1]
;

Learn More