C_EvtBsdRevnRecSalesOrderIss

DDL: C_EVTBSDREVNRECSALESORDERISS Type: view_entity CONSUMPTION Package: FINS_REV_REC_PECRUN
34 Fields 1 Data Sources 2 Associations 1 OData Services

Manage Rev. Rec. Issues - Sales Orders

C_EvtBsdRevnRecSalesOrderIss is a Consumption CDS View that provides data about "Manage Rev. Rec. Issues - Sales Orders" in SAP S/4HANA. It reads from 1 data source (P_EvtBsdRevnRecSalesOrderIss) and exposes 34 fields with key field ApplicationLog. It has 2 associations to related views. It is exposed through 1 OData service (ASQL_F4185). Part of development package FINS_REV_REC_PECRUN.

Data Sources (1)

SourceAliasJoin Type
P_EvtBsdRevnRecSalesOrderIss P_EvtBsdRevnRecSalesOrderIss from

Parameters (1)

NameTypeDefault
P_ToFiscalYearPeriod fis_jahrper_c_no_conv

Associations (2)

CardinalityTargetAliasCondition
[0..*] I_ResultAnalysisVersionText _ResultAnalysisVersionText $projection.ResultAnalysisInternalID = _ResultAnalysisVersionText.ResultAnalysisInternalID
[0..*] I_LedgerText _LedgerText $projection.Ledger = _LedgerText.Ledger

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Manage Rev. Rec. Issues - Sales Orders view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #CONSUMPTION view
UI.headerInfo.typeName Item view
UI.headerInfo.typeNamePlural Items view
UI.textArrangement #TEXT_LAST view

OData Services (1)

ServiceBindingVersionContractRelease
ASQL_F4185 ASQL_F4185 C2 NOT_RELEASED

Fields (34)

KeyFieldSource TableSource FieldDescription
KEY ApplicationLog ApplicationLog Log Number
SalesDocument SalesDocument Sales Document
SalesDocumentItem SalesDocumentItem Sales Document Item
SalesDocumentType SalesDocumentType Sales Doc. Type
SalesDocumentTypeName SalesDocumentTypeName SalesOrder Type Description
CompanyCode CompanyCode Receiver Company Code
CompanyCodeName CompanyCodeName Company Name
NumberOfOpenErrorMessages NumberOfOpenErrorMessages Status
ProfitCenter ProfitCenter Profit Center
FiscalYear FiscalYear G/L Fiscal Year
FiscalPeriod FiscalPeriod Fiscal Period
Ledger Ledger Ledger
ResultAnalysisInternalID ResultAnalysisInternalID Revenue Recognition Key
SalesOrganization SalesOrganization Sales Organization
ToFiscalYearPeriod ToFiscalYearPeriod Period
DistributionChannel DistributionChannel Distribution Channel
OrganizationDivision OrganizationDivision Division
SalesOffice SalesOffice Sales Office
SalesGroup SalesGroup Sales Group
Plant Plant Plant
ApplicationLogHandle ApplicationLogHandle Log Handle
AccountingPrinciple AccountingPrinciple AP Ledger/CoCode
ControllingObject ControllingObject Object number
FiscalYearVariant FiscalYearVariant FY Variant
_SalesDocument _SalesDocument
_SalesDocumentType _SalesDocumentType
_SalesOrganization _SalesOrganization
_DistributionChannel _DistributionChannel
_Division _Division
_Plant _Plant
_SalesOffice _SalesOffice
_SalesGroup _SalesGroup
_ResultAnalysisVersionText _ResultAnalysisVersionText
_LedgerText _LedgerText

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 C_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.
-- Parameters: P_ToFiscalYearPeriod : fis_jahrper_c_no_conv

CREATE VIEW C_EvtBsdRevnRecSalesOrderIss AS
SELECT
  ApplicationLog,
  SalesDocument,
  SalesDocumentItem,
  SalesDocumentType,
  SalesDocumentTypeName,
  CompanyCode,
  CompanyCodeName,
  NumberOfOpenErrorMessages,
  ProfitCenter,
  FiscalYear,
  FiscalPeriod,
  Ledger,
  ResultAnalysisInternalID,
  SalesOrganization,
  ToFiscalYearPeriod,
  DistributionChannel,
  OrganizationDivision,
  SalesOffice,
  SalesGroup,
  Plant,
  ApplicationLogHandle,
  AccountingPrinciple,
  ControllingObject,
  FiscalYearVariant
FROM P_EvtBsdRevnRecSalesOrderIss
LEFT OUTER JOIN I_ResultAnalysisVersionText AS _ResultAnalysisVersionText ON ResultAnalysisInternalID = _ResultAnalysisVersionText.ResultAnalysisInternalID  -- association [0..*]
LEFT OUTER JOIN I_LedgerText AS _LedgerText ON Ledger = _LedgerText.Ledger  -- association [0..*]
;

Learn More