I_CN_GoldenTaxInvoiceMapping

DDL: I_CN_GOLDENTAXINVOICEMAPPING Type: view COMPOSITE
11 Fields 1 Data Sources 2 Associations

Golden Tax Invoice Mapping

I_CN_GoldenTaxInvoiceMapping is a Composite CDS View that provides data about "Golden Tax Invoice Mapping" in SAP S/4HANA. It reads from 1 data source (I_CN_GoldenTaxInvcMappingBasic) and exposes 11 fields with key field CN_GoldenTaxInvoiceMapUUID. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_CN_GoldenTaxInvcMappingBasic I_CN_GoldenTaxInvcMappingBasic from

Associations (2)

CardinalityTargetAliasCondition
[1] I_CN_GoldenTaxDocument _GTDocument $projection.CN_GoldenTaxDocument = _GTDocument.CN_GoldenTaxDocument
[1] I_CN_GoldenTaxInvoice _GTInvoice $projection.CN_TaxInvcCode = _GTInvoice.CN_TaxInvcCode and $projection.CN_TaxInvcNmbr = _GTInvoice.CN_TaxInvcNmbr

Annotations (11)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view
AbapCatalog.sqlViewName ICNGTINVCMAP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
EndUserText.label Golden Tax Invoice Mapping view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY CN_GoldenTaxInvoiceMapUUID CN_GoldenTaxInvoiceMapUUID Tax Invc. Mappg UUID
CN_GoldenTaxDocument CN_GoldenTaxDocument GT Doc No
CN_TaxInvcCode CN_TaxInvcCode VAT Invoice Code
CN_TaxInvcNmbr CN_TaxInvcNmbr VAT Invoice No.
IsDeleted IsDeleted TRUE
CreatedByUser CreatedByUser User Name
CreationDateTime CreationDateTime Timestamp
LastChangedByUser LastChangedByUser User Name
ChangedDateTime ChangedDateTime Time Stamp
_GTDocument _GTDocument
_GTInvoice _GTInvoice

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_CN_GoldenTaxInvoiceMapping.
-- 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 I_CN_GoldenTaxInvoiceMapping AS
SELECT
  CN_GoldenTaxInvoiceMapUUID,
  CN_GoldenTaxDocument,
  CN_TaxInvcCode,
  CN_TaxInvcNmbr,
  IsDeleted,
  CreatedByUser,
  CreationDateTime,
  LastChangedByUser,
  ChangedDateTime
FROM I_CN_GoldenTaxInvcMappingBasic
LEFT OUTER JOIN I_CN_GoldenTaxDocument AS _GTDocument ON CN_GoldenTaxDocument = _GTDocument.CN_GoldenTaxDocument  -- association [1]
LEFT OUTER JOIN I_CN_GoldenTaxInvoice AS _GTInvoice ON CN_TaxInvcCode = _GTInvoice.CN_TaxInvcCode AND CN_TaxInvcNmbr = _GTInvoice.CN_TaxInvcNmbr  -- association [1]
;

Learn More