C_EvtBsdRevnRecSalesOrderIss

DDL: C_EVTBSDREVNRECSALESORDERISS SQL: CSDDOCISSUE Type: view CONSUMPTION
35 Fields 1 Data Sources 2 Associations

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 35 fields with key field ApplicationLog. It has 2 associations to related views.

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 (14)

NameValueLevelField
AbapCatalog.sqlViewName CSDDOCISSUE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE 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

Fields (35)

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 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
_SalesOrderIssDetail _SalesOrderIssDetail
_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.
-- SQL view name: CSDDOCISSUE
-- Parameters: P_ToFiscalYearPeriod : fis_jahrper_c_no_conv

CREATE VIEW C_EvtBsdRevnRecSalesOrderIss AS
SELECT
  ApplicationLog,
  SalesDocument,
  SalesDocumentItem,
  SalesDocumentType,
  SalesDocumentTypeName,
  CompanyCode,
  CompanyCodeName,
  NumberOfOpenErrorMessages,
  ProfitCenter,
  FiscalYear,
  cast ( FiscalPeriod as abap.int1 ) AS 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