C_AR_StRpLastOfclDocNmbrCube

DDL: C_AR_STRPLASTOFCLDOCNMBRCUBE Type: view_entity CONSUMPTION
10 Fields 1 Data Sources

AR Last Official Document Number - Cube

C_AR_StRpLastOfclDocNmbrCube is a Consumption CDS View (Cube) that provides data about "AR Last Official Document Number - Cube" in SAP S/4HANA. It reads from 1 data source (P_AR_StRpLastOfclDocNmbrAggrgn) and exposes 10 fields with key fields CompanyCode, AR_Branch, AR_OfficialDocumentClass, AR_PrintCharacter, StatryRptgEntity.

Data Sources (1)

SourceAliasJoin Type
P_AR_StRpLastOfclDocNmbrAggrgn LastOfficialDocumentNumber from

Annotations (11)

NameValueLevelField
EndUserText.label AR Last Official Document Number - Cube view
Metadata.ignorePropagatedAnnotations true view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
VDM.viewType #CONSUMPTION view
Analytics.dataCategory #CUBE view
Analytics.internalName #LOCAL view
Metadata.allowExtensions true view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #MIXED view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode P_AR_StRpLastOfclDocNmbrAggrgn CompanyCode Receiver Company Code
KEY AR_Branch P_AR_StRpLastOfclDocNmbrAggrgn AR_Branch
KEY AR_OfficialDocumentClass P_AR_StRpLastOfclDocNmbrAggrgn AR_OfficialDocumentClass
KEY AR_PrintCharacter P_AR_StRpLastOfclDocNmbrAggrgn AR_PrintCharacter
KEY StatryRptgEntity P_AR_StRpLastOfclDocNmbrAggrgn StatryRptgEntity Reporting Entity
KEY StatryRptCategory P_AR_StRpLastOfclDocNmbrAggrgn StatryRptCategory Report ID
KEY StatryRptRunID P_AR_StRpLastOfclDocNmbrAggrgn StatryRptRunID Report Run ID
AR_OfficialDocumentNumber P_AR_StRpLastOfclDocNmbrAggrgn AR_OfficialDocumentNumber
DocumentReferenceID P_AR_StRpLastOfclDocNmbrAggrgn DocumentReferenceID Reference
AR_OfclDocClassDescription P_AR_StRpLastOfclDocNmbrAggrgn AR_OfclDocClassDescription

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_AR_StRpLastOfclDocNmbrCube.
-- 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 C_AR_StRpLastOfclDocNmbrCube AS
SELECT
  LastOfficialDocumentNumber.CompanyCode AS CompanyCode,
  LastOfficialDocumentNumber.AR_Branch AS AR_Branch,
  LastOfficialDocumentNumber.AR_OfficialDocumentClass AS AR_OfficialDocumentClass,
  LastOfficialDocumentNumber.AR_PrintCharacter AS AR_PrintCharacter,
  LastOfficialDocumentNumber.StatryRptgEntity AS StatryRptgEntity,
  LastOfficialDocumentNumber.StatryRptCategory AS StatryRptCategory,
  LastOfficialDocumentNumber.StatryRptRunID AS StatryRptRunID,
  LastOfficialDocumentNumber.AR_OfficialDocumentNumber AS AR_OfficialDocumentNumber,
  LastOfficialDocumentNumber.DocumentReferenceID AS DocumentReferenceID,
  LastOfficialDocumentNumber.AR_OfclDocClassDescription AS AR_OfclDocClassDescription
FROM P_AR_StRpLastOfclDocNmbrAggrgn AS LastOfficialDocumentNumber
;

Learn More