I_UA_IncomingDocUnifiedReg

DDL: I_UA_INCOMINGDOCUNIFIEDREG SQL: IUAINCDOCUNIREG Type: view_entity BASIC Package: GLO_FIN_IS_VAT_UA_RETURN
12 Fields 1 Data Sources

UA VAT Unified Reg for Incoming Docs

I_UA_IncomingDocUnifiedReg is a Basic CDS View that provides data about "UA VAT Unified Reg for Incoming Docs" in SAP S/4HANA. It reads from 1 data source (j_1uf_reein_num) and exposes 12 fields with key fields CompanyCode, AccountingDocument, FiscalYear. Part of development package GLO_FIN_IS_VAT_UA_RETURN.

Data Sources (1)

SourceAliasJoin Type
j_1uf_reein_num j_1uf_reein_num from

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
EndUserText.label UA VAT Unified Reg for Incoming Docs view
Metadata.ignorePropagatedAnnotations true view
AccessControl.personalData.blocking #REQUIRED view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode bukrs Value
KEY AccountingDocument belnr SD Document
KEY FiscalYear Settlement Year
ReferenceDocumentNumber xblnr Reference
Customer lifnr Vendor no.
Supplier kunnr Stock customer
ReportedTaxNumber stcd1 Tax Number 1
UA_TaxInvoiceStatusInRegister herpn Registration Status
InvoiceReceiptDate receipt_date Receipt Date
UA_ReqNumberTaxInvoiceRegister request Request/Task
LatestRegistrationDate Registration Date
UA_TaxInvoiceDocumentType doc_type VAT Document Type

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 I_UA_IncomingDocUnifiedReg.
-- 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: IUAINCDOCUNIREG

CREATE VIEW I_UA_IncomingDocUnifiedReg AS
SELECT
  bukrs AS CompanyCode,
  belnr AS AccountingDocument,
  cast (gjahr as fis_gjahr_no_conv) AS FiscalYear,
  xblnr AS ReferenceDocumentNumber,
  lifnr AS Customer,
  kunnr AS Supplier,
  stcd1 AS ReportedTaxNumber,
  herpn AS UA_TaxInvoiceStatusInRegister,
  receipt_date AS InvoiceReceiptDate,
  request AS UA_ReqNumberTaxInvoiceRegister,
  cast (reg_date as bwbdt ) AS LatestRegistrationDate,
  doc_type AS UA_TaxInvoiceDocumentType
FROM j_1uf_reein_num
;

Learn More