P_EvtBsdRevnRecSalesOrderIss

DDL: P_EVTBSDREVNRECSALESORDERISS Type: view_entity CONSUMPTION Package: FINS_REV_REC_PECRUN
35 Fields 7 Data Sources

Event based rev. rec. sales order issue

P_EvtBsdRevnRecSalesOrderIss is a Consumption CDS View that provides data about "Event based rev. rec. sales order issue" in SAP S/4HANA. It reads from 7 data sources and exposes 35 fields with key field ApplicationLog. Part of development package FINS_REV_REC_PECRUN.

Data Sources (7)

SourceAliasJoin Type
P_EvtBsdRevRecSalesOrderAppLog AppLog from
I_CompanyCode CompanyCode inner
I_EvtBasedRevnRecgnEvalArea EvalAreaUse inner
I_SalesDocument SalesDocument inner
I_SalesDocumentItem SalesDocumentItem inner
I_ARunRequirementDocumentType SalesOrderType inner
P_Trrmonaccprin Trrmonaccprin inner

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Event based rev. rec. sales order issue view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #CONSUMPTION view
VDM.private true view

Fields (35)

KeyFieldSource TableSource FieldDescription
KEY ApplicationLog P_EvtBsdRevRecSalesOrderAppLog ApplicationLog Log Number
SalesDocument I_SalesDocumentItem SalesDocument SD Document
SalesDocumentItem I_SalesDocumentItem SalesDocumentItem Sales Document Item
Plant I_SalesDocumentItem Plant Valuation Area
SalesDocumentItemType I_SalesDocumentItem SalesDocumentItemType Item Type
ResultAnalysisInternalID I_SalesDocumentItem ResultAnalysisInternalID Results Analysis Key
ControllingObjectendasControllingObject
SalesOffice I_SalesDocument SalesOffice Sales Office
SalesGroup I_SalesDocument SalesGroup Sales Group
OrganizationDivision I_SalesDocumentItem Division Internal Division ID
DistributionChannel I_SalesDocument DistributionChannel RefDistCh-Cust/Mat.
SalesOrganization I_SalesDocument SalesOrganization Sales Organization
SalesDocumentType I_SalesDocument SalesDocumentType Sales Doc. Type
SalesDocumentTypeName I_ARunRequirementDocumentType SalesDocumentTypeName Description
Ledger I_EvtBasedRevnRecgnEvalArea Ledger Ledger
AccountingPrinciple P_Trrmonaccprin acc_principle Evaluation area EBRR
Prefix P_EvtBsdRevRecSalesOrderAppLog Prefix SerialNo.Prefix
FiscalYear P_EvtBsdRevRecSalesOrderAppLog FiscalYear G/L Fiscal Year
FiscalPeriod P_EvtBsdRevRecSalesOrderAppLog FiscalPeriod Tax period
NumberOfOpenErrorMessages P_EvtBsdRevRecSalesOrderAppLog NumberOfOpenErrorMessages
CompanyCode I_CompanyCode CompanyCode Receiver Company Code
CompanyCodeName I_CompanyCode CompanyCodeName Company Name
FiscalYearVariant I_CompanyCode FiscalYearVariant FY Variant
FiscalYearPeriod
ToFiscalYearPeriod
ProfitCenter I_SalesDocumentItem ProfitCenter Profit Center
ApplicationLogHandle P_EvtBsdRevRecSalesOrderAppLog ApplicationLogHandle Log Handle
_SalesDocument I_SalesDocumentItem _SalesDocument
_SalesOffice I_SalesDocument _SalesOffice
_SalesOrganization I_SalesDocument _SalesOrganization
_DistributionChannel I_SalesDocument _DistributionChannel
_SalesGroup I_SalesDocument _SalesGroup
_SalesDocumentType I_SalesDocument _SalesDocumentType
_Plant I_SalesDocumentItem _Plant
_Division I_SalesDocumentItem _Division

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_EvtBsdRevnRecSalesOrderIss.
-- 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_EvtBsdRevnRecSalesOrderIss AS
SELECT
  AppLog.ApplicationLog AS ApplicationLog,
  SalesDocumentItem.SalesDocument AS SalesDocument,
  SalesDocumentItem.SalesDocumentItem AS SalesDocumentItem,
  SalesDocumentItem.Plant AS Plant,
  SalesDocumentItem.SalesDocumentItemType AS SalesDocumentItemType,
  SalesDocumentItem.ResultAnalysisInternalID AS ResultAnalysisInternalID,
  case when SalesDocumentItem.ControllingObject = '' then concat('VB', concat(SalesDocumentItem.SalesDocument, SalesDocumentItem.SalesDocumentItem)) else SalesDocumentItem.ControllingObject end as ControllingObject AS ControllingObjectendasControllingObject,
  SalesDocument.SalesOffice AS SalesOffice,
  SalesDocument.SalesGroup AS SalesGroup,
  SalesDocumentItem.Division AS OrganizationDivision,
  SalesDocument.DistributionChannel AS DistributionChannel,
  SalesDocument.SalesOrganization AS SalesOrganization,
  SalesDocument.SalesDocumentType AS SalesDocumentType,
  SalesOrderType.SalesDocumentTypeName AS SalesDocumentTypeName,
  EvalAreaUse.Ledger AS Ledger,
  Trrmonaccprin.acc_principle AS AccountingPrinciple,
  AppLog.Prefix AS Prefix,
  AppLog.FiscalYear AS FiscalYear,
  AppLog.FiscalPeriod AS FiscalPeriod,
  AppLog.NumberOfOpenErrorMessages AS NumberOfOpenErrorMessages,
  CompanyCode.CompanyCode AS CompanyCode,
  CompanyCode.CompanyCodeName AS CompanyCodeName,
  CompanyCode.FiscalYearVariant AS FiscalYearVariant,
  concat(AppLog.FiscalYear, AppLog.FiscalPeriod) AS FiscalYearPeriod,
  concat(AppLog.FiscalPeriod, concat('.', AppLog.FiscalYear) ) AS ToFiscalYearPeriod,
  SalesDocumentItem.ProfitCenter AS ProfitCenter,
  AppLog.ApplicationLogHandle AS ApplicationLogHandle,
  SalesDocumentItem._SalesDocument AS _SalesDocument,
  SalesDocument._SalesOffice AS _SalesOffice,
  SalesDocument._SalesOrganization AS _SalesOrganization,
  SalesDocument._DistributionChannel AS _DistributionChannel,
  SalesDocument._SalesGroup AS _SalesGroup,
  SalesDocument._SalesDocumentType AS _SalesDocumentType,
  SalesDocumentItem._Plant AS _Plant,
  SalesDocumentItem._Division AS _Division
FROM P_EvtBsdRevRecSalesOrderAppLog AS AppLog
INNER JOIN I_SalesDocument AS SalesDocument ON /* join condition not captured in parsed metadata */
INNER JOIN I_SalesDocumentItem AS SalesDocumentItem ON /* join condition not captured in parsed metadata */
INNER JOIN I_CompanyCode AS CompanyCode ON /* join condition not captured in parsed metadata */
INNER JOIN I_EvtBasedRevnRecgnEvalArea AS EvalAreaUse ON /* join condition not captured in parsed metadata */
INNER JOIN P_Trrmonaccprin AS Trrmonaccprin ON /* join condition not captured in parsed metadata */
INNER JOIN I_ARunRequirementDocumentType AS SalesOrderType ON /* join condition not captured in parsed metadata */
;

Learn More