P_ARProcessFlowJournalEntryDoc

DDL: P_ARPROCESSFLOWJOURNALENTRYDOC SQL: PARPROCFLOWACC Type: view CONSUMPTION

Journal Entry Document details for AR process flow

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

Data Sources (1)

SourceAliasJoin Type
I_OperationalAcctgDocItem I_OperationalAcctgDocItem from

Associations (4)

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
[0..1] I_Order _Order $projection.OrderID = _Order.OrderID

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName PARPROCFLOWACC view
VDM.viewType #CONSUMPTION view
VDM.private true view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Journal Entry Document details for AR process flow view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.personalData.blocking #REQUIRED view
DataAging.noAgingRestriction true view

Fields (61)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode CompanyCode
KEY FiscalYear FiscalYear
KEY AccountingDocument AccountingDocument
KEY AccountingDocumentItem AccountingDocumentItem
FinancialAccountType FinancialAccountType
DebitCreditCode DebitCreditCode
ReferenceDocumentType ReferenceDocumentType
ReferenceDocument OriginalReferenceDocument
BillingDocument BillingDocument
PostingDate PostingDate
NetDueDate NetDueDate
TransactionCurrency TransactionCurrency
AmountInTransactionCurrency AmountInTransactionCurrency
CompanyCodeCurrency CompanyCodeCurrency
AmountInCompanyCodeCurrency AmountInCompanyCodeCurrency
ClearingDate ClearingDate
ClearingDocFiscalYear ClearingDocFiscalYear
ClearingJournalEntryFiscalYear ClearingJournalEntryFiscalYear
ClearingAccountingDocument ClearingAccountingDocument
ClearingJournalEntry ClearingJournalEntry
AccountingDocCreatedByUser _JournalEntry AccountingDocCreatedByUser
DocumentDate DocumentDate
FiscalPeriod FiscalPeriod
FiscalPeriodName
Customer Customer
CustomerName _Customer CustomerName
Supplier Supplier
AccountingDocumentType AccountingDocumentType
AccountingDocumentTypeName
Ledger _JournalEntry Ledger
IsLeadingLedger
BusinessArea BusinessArea
FunctionalArea FunctionalArea
ProfitCenter ProfitCenter
CostCenter CostCenter
GLAccount GLAccount
Segment Segment
ControllingArea ControllingArea
Plant Plant
ValuationArea ValuationArea
SalesOrder SalesDocument
_GLAccountInCompanyCode _GLAccountInCompanyCode
_Supplier _Supplier
_Customer _Customer
_AccountingDocumentType _AccountingDocumentType
_SalesDocument _SalesDocument
_InternalOrder _InternalOrder
_FixedAsset _FixedAsset
FixedAsset FixedAsset
MasterFixedAsset MasterFixedAsset
OrderID OrderID
AuthorizationGroup _GLAccountInCompanyCode AuthorizationGroup
SupplierFinsAuthorizationGrp _Supplier AuthorizationGroup
CustomerFinsAuthorizationGrp _Customer AuthorizationGroup
AcctgDocTypeAuthorizationGroup _AccountingDocumentType AuthorizationGroup
SalesOrderType _SalesDocument SalesOrderType
OrderType _InternalOrder OrderType
AssetClass _FixedAsset AssetClass
_UserContactCard _UserContactCard
_CompanyCode _CompanyCode
_Plant _Plant
@AbapCatalog.sqlViewName: 'PARPROCFLOWACC'
@VDM.viewType: #CONSUMPTION
@VDM.private: true
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.privilegedAssociations:  [ '_UserContactCard']
@EndUserText.label: 'Journal Entry Document details for AR process flow'
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.dataClass:  #MIXED
@ObjectModel.usageType.serviceQuality: #C
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.personalData.blocking: #REQUIRED
@DataAging.noAgingRestriction: true
define view  P_ARProcessFlowJournalEntryDoc
  as
select from I_OperationalAcctgDocItem
//association [0..1] to I_UserContactCard          as _UserContactCard       on  $projection.accountingdoccreatedbyuser  = _UserContactCard.ContactCardID


  association [0..1] to I_Customer         as _Customer        on $projection.Customer                   = _Customer.Customer
  association [1..1] to I_UserContactCard  as _UserContactCard on $projection.accountingdoccreatedbyuser = _UserContactCard.ContactCardID
  
association [0..1] to I_InternalOrder      as _InternalOrder                 on  $projection.OrderID           = _InternalOrder.InternalOrder  
association [0..1] to I_Order              as _Order                         on  $projection.OrderID           = _Order.OrderID    

{
key CompanyCode,
key FiscalYear,
key AccountingDocument,
key AccountingDocumentItem,
//key LedgerGLLineItem,


    FinancialAccountType,
    DebitCreditCode,

    ReferenceDocumentType,
    OriginalReferenceDocument as ReferenceDocument,
    BillingDocument,
    PostingDate,
    NetDueDate,

    @Semantics.currencyCode:true
    TransactionCurrency,
    @Semantics.amount.currencyCode: 'TransactionCurrency'
    AmountInTransactionCurrency,

    @Semantics.currencyCode:true
    CompanyCodeCurrency,
    @Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} }
    AmountInCompanyCodeCurrency,

    ClearingDate,
    @VDM.lifecycle.status:    #DEPRECATED
    @VDM.lifecycle.successor: 'ClearingJournalEntryFiscalYear'
    ClearingDocFiscalYear,
    ClearingJournalEntryFiscalYear,
    @VDM.lifecycle.status:    #DEPRECATED
    @VDM.lifecycle.successor: 'ClearingJournalEntry'
    ClearingAccountingDocument,
    ClearingJournalEntry,

    _JournalEntry.AccountingDocCreatedByUser,

    DocumentDate,

    FiscalPeriod,
    _FiscalPeriod._Text[1:Language = $session.system_language].FiscalPeriodName,

    Customer,
    _Customer.CustomerName,
    Supplier,
    AccountingDocumentType,
    _AccountingDocumentType._Text[1:Language = $session.system_language].AccountingDocumentTypeName,

    _JournalEntry.Ledger,
    _JournalEntry._Ledger.IsLeadingLedger,
    BusinessArea,
    FunctionalArea,
    ProfitCenter,
    CostCenter,
    GLAccount,
    Segment,
    ControllingArea,
    //DistributionChannel,

    //_JournalEntry.OrganizationDivision,

    Plant,
    //_JournalEntry.SalesOrganization,

    ValuationArea,
    SalesDocument as SalesOrder,
    _GLAccountInCompanyCode,
    _Supplier,
    _Customer,
    _AccountingDocumentType,
    _SalesDocument,
    _InternalOrder,
    _FixedAsset,
    FixedAsset,
    MasterFixedAsset,
    OrderID,
               
      //Auth

    _GLAccountInCompanyCode.AuthorizationGroup,
    _Supplier.AuthorizationGroup                 as SupplierFinsAuthorizationGrp,
    _Customer.AuthorizationGroup                 as CustomerFinsAuthorizationGrp,
    _AccountingDocumentType.AuthorizationGroup   as AcctgDocTypeAuthorizationGroup,
    _SalesDocument.SalesOrderType,
    _InternalOrder.OrderType,
    _FixedAsset.AssetClass,
    
    _UserContactCard,
    _CompanyCode,
    _Plant
//    _SalesOrder


}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_ACCOUNTINGDOCUMENTTYPE",
"I_ACCOUNTINGDOCUMENTTYPETEXT",
"I_CUSTOMER",
"I_FISCALPERIODFORCOCODETEXT",
"I_FISCALYEARPERIODFORCMPNYCODE",
"I_FIXEDASSET",
"I_GLACCOUNTINCOMPANYCODE",
"I_INTERNALORDER",
"I_JOURNALENTRY",
"I_LEDGER",
"I_OPERATIONALACCTGDOCITEM",
"I_SALESORDER",
"I_SUPPLIER"
],
"ASSOCIATED":
[
"I_ACCOUNTINGDOCUMENTTYPE",
"I_COMPANYCODE",
"I_CUSTOMER",
"I_FIXEDASSET",
"I_GLACCOUNTINCOMPANYCODE",
"I_INTERNALORDER",
"I_ORDER",
"I_PLANT",
"I_SALESORDER",
"I_SUPPLIER",
"I_USERCONTACTCARD"
],
"BASE":
[
"I_OPERATIONALACCTGDOCITEM"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/