P_JP_GRDocumentItem

DDL: P_JP_GRDOCUMENTITEM SQL: PJPGRDOCIT Type: view COMPOSITE

P_JP_GRDocumentItem is a Composite CDS View in SAP S/4HANA. It reads from 2 data sources (I_GLAccountLineItem, P_JP_GRDocumentHeader) and exposes 51 fields with key fields Supplier, SourceLedger, CompanyCode, FiscalYear, AccountingDocument. It has 3 associations to related views.

2 data source(s) 51 fields

Data Sources (2)

SourceAliasJoin Type
I_GLAccountLineItem GLAccountLineItem from
P_JP_GRDocumentHeader GRHeader inner

Associations (3)

CardinalityTargetAliasCondition
[0..1] I_Supplier _Supplier $projection.Supplier = _Supplier.Supplier
[0..1] I_PurchaseOrderItem _PurchaseOrderItem $projection.PurchasingDocument = _PurchaseOrderItem.PurchaseOrder and $projection.PurchasingDocumentItem = _PurchaseOrderItem.PurchaseOrderItem
[1..1] I_JournalEntry _JournalEntry $projection.CompanyCode = _JournalEntry.CompanyCode and $projection.FiscalYear = _JournalEntry.FiscalYear and $projection.AccountingDocument = _JournalEntry.AccountingDocument

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PJPGRDOCIT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view
VDM.private true view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view

Fields (51)

KeyFieldSource TableSource FieldDescription
KEY Supplier P_JP_GRDocumentHeader Supplier
KEY SourceLedger I_GLAccountLineItem SourceLedger
KEY CompanyCode I_GLAccountLineItem CompanyCode
KEY FiscalYear I_GLAccountLineItem FiscalYear
KEY AccountingDocument I_GLAccountLineItem AccountingDocument
KEY LedgerGLLineItem I_GLAccountLineItem LedgerGLLineItem
KEY Ledger I_GLAccountLineItem Ledger
FiscalPeriod I_GLAccountLineItem FiscalPeriod
PostingDate I_GLAccountLineItem PostingDate
DocumentDate I_GLAccountLineItem DocumentDate
ClearingDate I_GLAccountLineItem ClearingDate
AccountingDocumentHeaderText P_JP_GRDocumentHeader AccountingDocumentHeaderText
DocumentItemText I_GLAccountLineItem DocumentItemText
AccountingDocumentType I_GLAccountLineItem AccountingDocumentType
FinancialAccountType I_GLAccountLineItem FinancialAccountType
ChartOfAccounts I_GLAccountLineItem ChartOfAccounts
GLAccount I_GLAccountLineItem GLAccount
ReferenceDocument I_GLAccountLineItem ReferenceDocument
ReferenceDocumentItem I_GLAccountLineItem ReferenceDocumentItem
PurchasingDocument I_GLAccountLineItem PurchasingDocument
PurchasingDocumentItem I_GLAccountLineItem PurchasingDocumentItem
Product I_GLAccountLineItem Product
DebitCreditCode I_GLAccountLineItem DebitCreditCode
TransactionCurrency I_GLAccountLineItem TransactionCurrency
AmountInTransactionCurrency I_GLAccountLineItem AmountInTransactionCurrency
CompanyCodeCurrency I_GLAccountLineItem CompanyCodeCurrency
AmountInCompanyCodeCurrency I_GLAccountLineItem AmountInCompanyCodeCurrency
BaseUnit I_GLAccountLineItem BaseUnit
Quantity I_GLAccountLineItem Quantity
OrderPriceUnit _PurchaseOrderItem OrderPriceUnit
NetPriceQuantity _PurchaseOrderItem NetPriceQuantity
NetPriceAmount _PurchaseOrderItem NetPriceAmount
DocumentCurrency _PurchaseOrderItem DocumentCurrency
_SourceLedger I_GLAccountLineItem _SourceLedger
_CompanyCode I_GLAccountLineItem _CompanyCode
_FiscalYear I_GLAccountLineItem _FiscalYear
_JournalEntry _JournalEntry
_Ledger I_GLAccountLineItem _Ledger
_FinancialAccountType I_GLAccountLineItem _FinancialAccountType
_Supplier _Supplier
_Product I_GLAccountLineItem _Product
_PurchasingDocument I_GLAccountLineItem _PurchasingDocument
_PurchasingDocumentItem I_GLAccountLineItem _PurchasingDocumentItem
_TransactionCurrency I_GLAccountLineItem _TransactionCurrency
_CompanyCodeCurrency I_GLAccountLineItem _CompanyCodeCurrency
_BaseUnit I_GLAccountLineItem _BaseUnit
_DebitCreditCode I_GLAccountLineItem _DebitCreditCode
_GLAccountInChartOfAccounts I_GLAccountLineItem _GLAccountInChartOfAccounts
_ChartOfAccounts I_GLAccountLineItem _ChartOfAccounts
_AccountingDocumentType I_GLAccountLineItem _AccountingDocumentType
_AccountingDocumentTypeText I_GLAccountLineItem _AccountingDocumentTypeText 
@AbapCatalog.sqlViewName: 'PJPGRDOCIT'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #COMPOSITE
@VDM.private:true
@ObjectModel: { usageType.serviceQuality: #D,
                usageType.sizeCategory: #XXL,
                usageType.dataClass: #MIXED }
//@EndUserText.label: 'Goods Receipt Document Item List'

define view P_JP_GRDocumentItem
  as select from I_GLAccountLineItem   as GLAccountLineItem
    inner join   P_JP_GRDocumentHeader as GRHeader on  GLAccountLineItem.SourceLedger       = GRHeader.SourceLedger
                                                   and GLAccountLineItem.CompanyCode        = GRHeader.CompanyCode
                                                   and GLAccountLineItem.FiscalYear         = GRHeader.FiscalYear
                                                   and GLAccountLineItem.AccountingDocument = GRHeader.AccountingDocument
                                                   and GLAccountLineItem.Ledger             = GRHeader.Ledger
                                                   and GLAccountLineItem.ReferenceDocument  = GRHeader.ReferenceDocument
  association [0..1] to I_Supplier          as _Supplier          on  $projection.Supplier = _Supplier.Supplier
  association [0..1] to I_PurchaseOrderItem as _PurchaseOrderItem on  $projection.PurchasingDocument     = _PurchaseOrderItem.PurchaseOrder
                                                                  and $projection.PurchasingDocumentItem = _PurchaseOrderItem.PurchaseOrderItem
  association [1..1] to I_JournalEntry      as _JournalEntry      on  $projection.CompanyCode        = _JournalEntry.CompanyCode
                                                                  and $projection.FiscalYear         = _JournalEntry.FiscalYear
                                                                  and $projection.AccountingDocument = _JournalEntry.AccountingDocument                                                                  
                                                                  
{
  key       GRHeader.Supplier,
  key       GLAccountLineItem.SourceLedger,
  key       GLAccountLineItem.CompanyCode,
  key       GLAccountLineItem.FiscalYear,
  key       GLAccountLineItem.AccountingDocument,
  key       GLAccountLineItem.LedgerGLLineItem,
  key       GLAccountLineItem.Ledger,
            GLAccountLineItem.FiscalPeriod,
            GLAccountLineItem.PostingDate,
            GLAccountLineItem.DocumentDate,
            GLAccountLineItem.ClearingDate,
            GRHeader.AccountingDocumentHeaderText,
            GLAccountLineItem.DocumentItemText,
            GLAccountLineItem.AccountingDocumentType,
            GLAccountLineItem.FinancialAccountType,
            GLAccountLineItem.ChartOfAccounts,
            GLAccountLineItem.GLAccount,
            GLAccountLineItem.ReferenceDocument,
            GLAccountLineItem.ReferenceDocumentItem,
            GLAccountLineItem.PurchasingDocument,
            GLAccountLineItem.PurchasingDocumentItem,
            GLAccountLineItem.Product,
            GLAccountLineItem.DebitCreditCode,
            GLAccountLineItem.TransactionCurrency,
            GLAccountLineItem.AmountInTransactionCurrency,
            GLAccountLineItem.CompanyCodeCurrency,
            GLAccountLineItem.AmountInCompanyCodeCurrency,
            GLAccountLineItem.BaseUnit,
            GLAccountLineItem.Quantity,
            _PurchaseOrderItem.OrderPriceUnit,
            _PurchaseOrderItem.NetPriceQuantity,
            _PurchaseOrderItem.NetPriceAmount,
            _PurchaseOrderItem.DocumentCurrency,

            GLAccountLineItem._SourceLedger,
            GLAccountLineItem._CompanyCode,
            GLAccountLineItem._FiscalYear,
            _JournalEntry,
            GLAccountLineItem._Ledger,
            GLAccountLineItem._FinancialAccountType,
            _Supplier,
            GLAccountLineItem._Product,
            GLAccountLineItem._PurchasingDocument,
            GLAccountLineItem._PurchasingDocumentItem,
            GLAccountLineItem._TransactionCurrency,
            GLAccountLineItem._CompanyCodeCurrency,
            GLAccountLineItem._BaseUnit,
            GLAccountLineItem._DebitCreditCode,
            GLAccountLineItem._GLAccountInChartOfAccounts,
            GLAccountLineItem._ChartOfAccounts,
            GLAccountLineItem._AccountingDocumentType,
            GLAccountLineItem._AccountingDocumentTypeText
}

Learn More