P_GR_CADocJournalBasic

DDL: P_GR_CADOCJOURNALBASIC Type: view_entity CONSUMPTION Package: FKK_ID_GR_REP
44 Fields 2 Data Sources 3 Associations

GR Doc Journal Basic

P_GR_CADocJournalBasic is a Consumption CDS View that provides data about "GR Doc Journal Basic" in SAP S/4HANA. It reads from 2 data sources (P_GR_DocJournalBPItem, P_GR_DocJournalGLItem) and exposes 44 fields with key fields CompanyCode, CADocumentNumber, FiscalYear, PostingDate, FiscalPeriod. It has 3 associations to related views. Part of development package FKK_ID_GR_REP.

Data Sources (2)

SourceAliasJoin Type
P_GR_DocJournalBPItem P_GR_DocJournalBPItem from
P_GR_DocJournalGLItem P_GR_DocJournalGLItem union_all

Parameters (3)

NameTypeDefault
P_ToPostingDate fis_budat_to
P_GR_JournalFromDate fis_gr_docjrnl_budat_frm
P_CompanyCode fis_bukrs

Associations (3)

CardinalityTargetAliasCondition
[0..1] I_BusinessPartner _BusinessPartner $projection.BusinessPartner = _BusinessPartner.BusinessPartner
[0..1] I_CASubTransaction _CASubTransaction $projection.CAApplicationArea = _CASubTransaction.CAApplicationArea and $projection.CAMainTransaction = _CASubTransaction.CAMainTransaction and $projection.CASubTransaction = _CASubTransaction.CASubTransaction
[1..1] I_CADocumentHeader _DocHeader $projection.CADocumentNumber = _DocHeader.CADocumentNumber

Annotations (6)

NameValueLevelField
VDM.viewType #CONSUMPTION view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.private true view

Fields (44)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode CompanyCode Receiver Company Code
KEY CADocumentNumber CADocumentNumber Document Number
KEY FiscalYear FiscalYear G/L Fiscal Year
KEY PostingDate PostingDate Posting Date for GR
KEY FiscalPeriod FiscalPeriod Tax period
KEY FiscalYearVariant FiscalYearVariant FY Variant
KEY DocumentDate DocumentDate Journal Entry Date
KEY GLAccount GLAccount General Ledger
KEY CompanyCodeCurrency CompanyCodeCurrency Valuation Crcy
KEY TransactionCurrency TransactionCurrency Transaction Currency
KEY BusinessPartner BusinessPartner Issuing Authority
KEY CAMainTransaction CAMainTransaction Main Trans.
KEY CASubTransaction CASubTransaction Subtransaction
ChartOfAccounts ChartOfAccounts Node Class
CAApplicationArea CAApplicationArea ApplicationArea
CADocumentType CADocumentType Document Type
CAReferenceDocument _DocHeader CAReferenceDocument Reference
AmountInCompanyCodeCurrency AmountInCompanyCodeCurrency Local Crcy Amt
CAAmountInTransactionCurrency CAAmountInTransactionCurrency Amount
_BusinessPartner _BusinessPartner
P_ToPostingDate
P_GR_JournalFromDate
CASubTransactionkeyCompanyCode
KEY CADocumentNumber CADocumentNumber Document Number
KEY FiscalYear FiscalYear G/L Fiscal Year
KEY PostingDate PostingDate Posting Date for GR
KEY FiscalPeriod FiscalPeriod Tax period
KEY FiscalYearVariant FiscalYearVariant FY Variant
KEY DocumentDate _DocHeader DocumentDate Journal Entry Date
KEY GLAccount GLAccount General Ledger
KEY CompanyCodeCurrency _CompCode Currency Valuation Crcy
KEY TransactionCurrency TransactionCurrency Transaction Currency
KEY BusinessPartner Issuing Authority
KEY CAMainTransaction Main Trans.
KEY CASubTransaction Subtransaction
KEY DebitCreditCode DebitCreditCode Single-Character Flag
ChartOfAccounts _CompCode ChartOfAccounts Node Class
CAApplicationArea _DocHeader CAApplicationArea ApplicationArea
CADocumentType _DocHeader CADocumentType Document Type
CAReferenceDocument _DocHeader CAReferenceDocument Reference
AmountInCompanyCodeCurrency AmountInCompanyCodeCurrency Local Crcy Amt
CAAmountInTransactionCurrency CAAmountInTransactionCurrency Amount
_BusinessPartner _BusinessPartner
_CASubTransaction _CASubTransaction

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_GR_CADocJournalBasic.
-- 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.
-- Parameters: P_ToPostingDate : fis_budat_to, P_GR_JournalFromDate : fis_gr_docjrnl_budat_frm, P_CompanyCode : fis_bukrs

CREATE VIEW P_GR_CADocJournalBasic AS
SELECT
  CompanyCode,
  CADocumentNumber,
  FiscalYear,
  PostingDate,
  FiscalPeriod,
  FiscalYearVariant,
  DocumentDate,
  GLAccount,
  CompanyCodeCurrency,
  TransactionCurrency,
  BusinessPartner,
  CAMainTransaction,
  CASubTransaction,
  ChartOfAccounts,
  CAApplicationArea,
  CADocumentType,
  _DocHeader.CAReferenceDocument AS CAReferenceDocument,
  AmountInCompanyCodeCurrency,
  CAAmountInTransactionCurrency,
  P_GR_JournalFromDate: $parameters.P_GR_JournalFromDate AS P_GR_JournalFromDate,
  DebitCreditCode
FROM P_GR_DocJournalBPItem
LEFT OUTER JOIN I_BusinessPartner AS _BusinessPartner ON BusinessPartner = _BusinessPartner.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_CASubTransaction AS _CASubTransaction ON CAApplicationArea = _CASubTransaction.CAApplicationArea AND CAMainTransaction = _CASubTransaction.CAMainTransaction AND CASubTransaction = _CASubTransaction.CASubTransaction  -- association [0..1]
LEFT OUTER JOIN I_CADocumentHeader AS _DocHeader ON CADocumentNumber = _DocHeader.CADocumentNumber  -- association [1..1]
-- UNION ALL with additional select branch(es): P_GR_DocJournalGLItem
;

Learn More