P_RU_ExtNumByDefault2

DDL: P_RU_EXTNUMBYDEFAULT2 SQL: PRUEXTNUMBYDEF2 Type: view COMPOSITE

P_RU_ExtNumByDefault2 is a Composite CDS View in SAP S/4HANA. It reads from 3 data sources (I_AccountingDocumentType, I_CompanyCode, P_RU_ExtNumByDefault1) and exposes 6 fields.

Data Sources (3)

SourceAliasJoin Type
I_AccountingDocumentType AccDocType inner
I_CompanyCode CompCode inner
P_RU_ExtNumByDefault1 ExtNumByDefault from

Annotations (5)

NameValueLevelField
VDM.private true view
VDM.viewType #COMPOSITE view
AbapCatalog.sqlViewName PRUEXTNUMBYDEF2 view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_REQUIRED view

Fields (6)

KeyFieldSource TableSource FieldDescription
CustCompanyCode P_RU_ExtNumByDefault1 CompanyCode Receiver Company Code
CustAccountingDocumentType P_RU_ExtNumByDefault1 AccountingDocumentType Journal Entry Type
CompanyCode I_CompanyCode CompanyCode Receiver Company Code
AccountingDocumentType I_AccountingDocumentType AccountingDocumentType Journal Entry Type
ExtDocNmbrAndDteAreFilled P_RU_ExtNumByDefault1 ExtDocNmbrAndDteAreFilled
Rank P_RU_ExtNumByDefault1 Rank Sequence No.

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_RU_ExtNumByDefault2.
-- 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: PRUEXTNUMBYDEF2

CREATE VIEW P_RU_ExtNumByDefault2 AS
SELECT
  ExtNumByDefault.CompanyCode AS CustCompanyCode,
  ExtNumByDefault.AccountingDocumentType AS CustAccountingDocumentType,
  CompCode.CompanyCode AS CompanyCode,
  AccDocType.AccountingDocumentType AS AccountingDocumentType,
  ExtNumByDefault.ExtDocNmbrAndDteAreFilled AS ExtDocNmbrAndDteAreFilled,
  ExtNumByDefault.Rank AS Rank
FROM P_RU_ExtNumByDefault1 AS ExtNumByDefault
INNER JOIN I_AccountingDocumentType AS AccDocType ON /* join condition not captured in parsed metadata */
INNER JOIN I_CompanyCode AS CompCode ON /* join condition not captured in parsed metadata */
;