P_AR_CustomerSupplierEntry

DDL: P_AR_CUSTOMERSUPPLIERENTRY Type: view_entity CONSUMPTION
10 Fields 2 Data Sources

P_AR_CustomerSupplierEntry is a Consumption CDS View in SAP S/4HANA. It reads from 2 data sources (I_StRpJournalEntryHeaderLog, P_AR_JournalEntry) and exposes 10 fields with key fields CompanyCode, AccountingDocument, FiscalYear.

Data Sources (2)

SourceAliasJoin Type
I_StRpJournalEntryHeaderLog HeaderLog inner
P_AR_JournalEntry JournalEntry from

Parameters (5)

NameTypeDefault
P_StatryRptgEntity srf_reporting_entity
P_StatryRptCategory srf_rep_cat_id
P_StatryRptRunID srf_report_run_id
P_CompanyCode fis_bukrs
P_FiscalYear fis_gjahr

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #P view
ObjectModel.usageType.sizeCategory #XL view
VDM.private true view
VDM.viewType #CONSUMPTION view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode
KEY AccountingDocument P_AR_JournalEntry AccountingDocument Journal Entry
KEY FiscalYear P_AR_JournalEntry FiscalYear G/L Fiscal Year
AccountingDocumentType
AR_OfficialDocumentNumber P_AR_JournalEntry AR_OfficialDocumentNumber
ReverseDocument P_AR_JournalEntry ReverseDocument Reversed With
AR_Branch P_AR_JournalEntry AR_Branch
AR_PrintCharacter P_AR_JournalEntry AR_PrintCharacter
PostingDate P_AR_JournalEntry PostingDate Posting Date for GR
DocumentDate P_AR_JournalEntry DocumentDate Journal Entry Date

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_AR_CustomerSupplierEntry.
-- 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_StatryRptgEntity : srf_reporting_entity, P_StatryRptCategory : srf_rep_cat_id, P_StatryRptRunID : srf_report_run_id, P_CompanyCode : fis_bukrs, P_FiscalYear : fis_gjahr

CREATE VIEW P_AR_CustomerSupplierEntry AS
SELECT
  cast( JournalEntry.CompanyCode as fis_bukrs preserving type ) AS CompanyCode,
  JournalEntry.AccountingDocument AS AccountingDocument,
  JournalEntry.FiscalYear AS FiscalYear,
  cast( JournalEntry.AccountingDocumentType as fis_blart preserving type ) AS AccountingDocumentType,
  JournalEntry.AR_OfficialDocumentNumber AS AR_OfficialDocumentNumber,
  JournalEntry.ReverseDocument AS ReverseDocument,
  JournalEntry.AR_Branch AS AR_Branch,
  JournalEntry.AR_PrintCharacter AS AR_PrintCharacter,
  JournalEntry.PostingDate AS PostingDate,
  JournalEntry.DocumentDate AS DocumentDate
FROM P_AR_JournalEntry AS JournalEntry
INNER JOIN I_StRpJournalEntryHeaderLog AS HeaderLog ON /* join condition not captured in parsed metadata */
;

Learn More