P_RU_ExprtConfRegItem1

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_ExprtConfRegItem1.
-- 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: PRUREGITEM1
-- Parameters: P_StatryRptgEntity : srf_reporting_entity, P_StatryRptCategory : srf_rep_cat_id, P_StatryRptRunID : srf_report_run_id

CREATE VIEW P_RU_ExprtConfRegItem1 AS
SELECT
  RegisterItems.VATReturnOperation AS VATReturnOperation,
  TaxTransfDocument.CompanyCode AS CompanyCode,
  TaxTransfDocument.TaxTransferDocument AS TaxTransferDocument,
  TaxTransfDocument.FiscalYear AS FiscalYear,
  TaxTransfDocument.TaxCode AS TaxCode,
  TaxTransfDocument.CustomsDeclaration AS CustomsDeclaration,
  TaxTransfDocument.CustomsDeclarationItem AS CustomsDeclarationItem,
  TaxTransfDocument.CustomsDeclarationSubitem AS CustomsDeclarationSubitem,
  CCDHeaderData.CustomsOffice AS CustomsOffice,
  CCDHeaderData.RU_RegistrationInvoiceDate AS RU_RegistrationInvoiceDate,
  CCDHeaderData.CustomsDeclarationExtNmbr AS CustomsDeclarationExtNmbr,
  CCDHeaderData.Customer AS Customer,
  _Customer.BPCustomerName AS BPCustomerName,
  CCDHeaderData.RU_TransportationType AS RU_TransportationType,
  CCDHeaderData.RU_TranspDocumentType AS RU_TranspDocumentType,
  CCDItemData.CommodityCode AS CommodityCode,
  CCDItemData.Material AS Material,
  _MaterialDescription.ProductDescription AS MaterialDesc,
  CCDSubItemData.Delivery AS Delivery,
  _DeliveryDocument.DeliveryDate AS DeliveryDate,
  CCDSubItemData.Quantity AS Quantity,
  CCDSubItemData.SalesUnit AS SalesUnit,
  CCDHeaderData.ExportConfirmationHeaderDate AS ExportConfirmationHeaderDate,
  CCDSubItemData.ExportConfirmationSubitemDate AS ExportConfirmationSubitemDate,
  CCDSubItemData.BillingDocument AS BillingDocument,
  TaxItem.TaxBaseAmountInCoCodeCrcy AS TaxBaseAmountInCoCodeCrcy,
  _AccountingDocument.CompanyCodeCurrency AS CompanyCodeCurrency,
  TaxItem.TaxBaseAmountInTransCrcy AS TaxBaseAmountInTransCrcy,
  _AccountingDocument.TransactionCurrency AS TransactionCurrency,
  _Customer.AuthorizationGroup AS AuthorizationGroup,
  _BusinessPartnerItem.AssignmentReference AS AssignmentReference
FROM I_RU_ExprtConfRegRptItem AS RegisterItems
LEFT OUTER JOIN I_OperationalAcctgDocItem AS _BusinessPartnerItem ON _BusinessPartnerItem.CompanyCode = TaxTransfDocument.CompanyCode AND _BusinessPartnerItem.BillingDocument = CCDSubItemData.BillingDocument AND _BusinessPartnerItem.FinancialAccountType = 'D'  -- association [1..*]
LEFT OUTER JOIN I_JournalEntry AS _AccountingDocument ON CompanyCode = _AccountingDocument.CompanyCode AND TaxTransferDocument = _AccountingDocument.AccountingDocument AND FiscalYear = _AccountingDocument.FiscalYear  -- association [1..1]
LEFT OUTER JOIN I_ProductDescription AS _MaterialDescription ON Material = _MaterialDescription.Product  -- association [1..1]
LEFT OUTER JOIN I_Customer AS _Customer ON Customer = _Customer.Customer  -- association [1..1]
LEFT OUTER JOIN I_DeliveryDocument AS _DeliveryDocument ON Delivery = _DeliveryDocument.DeliveryDocument  -- association [1..1]
;