C_EvtBsdRevnRecSrvcDocIssue

DDL: C_EVTBSDREVNRECSRVCDOCISSUE SQL: CSRVDOCISS Type: view CONSUMPTION
24 Fields 1 Data Sources 2 Associations

Manage Rev. Rec. Issues - Service Doc.

C_EvtBsdRevnRecSrvcDocIssue is a Consumption CDS View that provides data about "Manage Rev. Rec. Issues - Service Doc." in SAP S/4HANA. It reads from 1 data source (P_EvtBsdRevnRecSrvcDocIssue) and exposes 24 fields with key field ApplicationLog. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
P_EvtBsdRevnRecSrvcDocIssue P_EvtBsdRevnRecSrvcDocIssue 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 CSRVDOCISS 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 - Service Doc. 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 (24)

KeyFieldSource TableSource FieldDescription
KEY ApplicationLog ApplicationLog Log Number
ServiceDocument ServiceDocument Transaction ID
ServiceDocumentItem ServiceDocumentItem Service Document Item
ServiceDocumentType ServiceDocumentType Service Document Type
ServiceDocumentTypeName ServiceDocumentTypeName Service Document Type Description
CompanyCode CompanyCode Receiver Company Code
CompanyCodeName CompanyCodeName Company Name
NumberOfOpenErrorMessages NumberOfOpenErrorMessages Status
OrganizationDivision OrganizationDivision Division
DistributionChannel DistributionChannel Distribution Channel
SalesOrganization SalesOrganization Sales Organization
Ledger Ledger Ledger
ResultAnalysisInternalID ResultAnalysisInternalID Revenue Recognition Key
ProfitCenter ProfitCenter Profit Center
FiscalYear FiscalYear G/L Fiscal Year
FiscalPeriod Fiscal Period
ToFiscalYearPeriod ToFiscalYearPeriod Period
ApplicationLogHandle ApplicationLogHandle Log Handle
AccountingPrinciple AccountingPrinciple AP Ledger/CoCode
ControllingObject ControllingObject Object number
FiscalYearVariant FiscalYearVariant FY Variant
_ServiceDocumentIssDetail _ServiceDocumentIssDetail
_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_EvtBsdRevnRecSrvcDocIssue.
-- 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: CSRVDOCISS
-- Parameters: P_ToFiscalYearPeriod : fis_jahrper_c_no_conv

CREATE VIEW C_EvtBsdRevnRecSrvcDocIssue AS
SELECT
  ApplicationLog,
  ServiceDocument,
  ServiceDocumentItem,
  ServiceDocumentType,
  ServiceDocumentTypeName,
  CompanyCode,
  CompanyCodeName,
  NumberOfOpenErrorMessages,
  OrganizationDivision,
  DistributionChannel,
  SalesOrganization,
  Ledger,
  ResultAnalysisInternalID,
  ProfitCenter,
  FiscalYear,
  cast ( FiscalPeriod as abap.int1 ) AS FiscalPeriod,
  ToFiscalYearPeriod,
  ApplicationLogHandle,
  AccountingPrinciple,
  ControllingObject,
  FiscalYearVariant
FROM P_EvtBsdRevnRecSrvcDocIssue
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