P_RU_GtdFromPOMMN

DDL: P_RU_GTDFROMPOMMN SQL: PRUGTDPOMMN Type: view COMPOSITE Package: GLO_FIN_IS_VAT_RU_SPL

n

P_RU_GtdFromPOMMN is a Composite CDS View that provides data about "n" in SAP S/4HANA. It reads from 2 data sources (P_RU_GtdFromPOMM34, P_RU_GtdFromPOMM8N) and exposes 15 fields. Part of development package GLO_FIN_IS_VAT_RU_SPL.

Data Sources (2)

SourceAliasJoin Type
P_RU_GtdFromPOMM34 ImCD inner
P_RU_GtdFromPOMM8N Main from

Annotations (6)

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

Fields (15)

KeyFieldSource TableSource FieldDescription
CompanyCode P_RU_GtdFromPOMM8N CompanyCode Receiver Company Code
AccountingDocument P_RU_GtdFromPOMM8N AccountingDocument Journal Entry
FiscalYear P_RU_GtdFromPOMM8N FiscalYear G/L Fiscal Year
Plant P_RU_GtdFromPOMM34 Plant Valuation Area
PurchasingDocument P_RU_GtdFromPOMM8N PurchasingDocument Purchasing Document
PurchasingDocumentItem P_RU_GtdFromPOMM8N PurchasingDocumentItem Purchasing Doc. Item
PurchaseOrderSouce P_RU_GtdFromPOMM34 PurchaseOrderSouce
Supplier P_RU_GtdFromPOMM34 Supplier Supplier
DocumentItemText P_RU_GtdFromPOMM8N DocumentItemText Text
ImportCustomsDecln P_RU_GtdFromPOMM34 ImportCustomsDecln
ImportCustomsDeclnItem P_RU_GtdFromPOMM34 ImportCustomsDeclnItem
EntryCustomsOffice P_RU_GtdFromPOMM34 EntryCustomsOffice
CustomsDeclarationDate P_RU_GtdFromPOMM34 CustomsDeclarationDate
CustomsDeclaration P_RU_GtdFromPOMM34 CustomsDeclaration Cus. Decl. No.
ImportCustomsDeclnPrintItem P_RU_GtdFromPOMM34 ImportCustomsDeclnPrintItem

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_GtdFromPOMMN.
-- 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: PRUGTDPOMMN

CREATE VIEW P_RU_GtdFromPOMMN AS
SELECT
  Main.CompanyCode AS CompanyCode,
  Main.AccountingDocument AS AccountingDocument,
  Main.FiscalYear AS FiscalYear,
  ImCD.Plant AS Plant,
  Main.PurchasingDocument AS PurchasingDocument,
  Main.PurchasingDocumentItem AS PurchasingDocumentItem,
  ImCD.PurchaseOrderSouce AS PurchaseOrderSouce,
  ImCD.Supplier AS Supplier,
  Main.DocumentItemText AS DocumentItemText,
  ImCD.ImportCustomsDecln AS ImportCustomsDecln,
  ImCD.ImportCustomsDeclnItem AS ImportCustomsDeclnItem,
  ImCD.EntryCustomsOffice AS EntryCustomsOffice,
  ImCD.CustomsDeclarationDate AS CustomsDeclarationDate,
  ImCD.CustomsDeclaration AS CustomsDeclaration,
  ImCD.ImportCustomsDeclnPrintItem AS ImportCustomsDeclnPrintItem
FROM P_RU_GtdFromPOMM8N AS Main
INNER JOIN P_RU_GtdFromPOMM34 AS ImCD ON /* join condition not captured in parsed metadata */
;