I_CN_GoldenTaxDocument

DDL: I_CN_GOLDENTAXDOCUMENT Type: view COMPOSITE Package: GLO_FIN_TAX_GTI_CN
52 Fields 1 Data Sources 9 Associations

China Golden Tax Document

I_CN_GoldenTaxDocument is a Composite CDS View that provides data about "China Golden Tax Document" in SAP S/4HANA. It reads from 1 data source (I_CN_GoldenTaxDocumentBasic) and exposes 52 fields with key field CN_GoldenTaxUUID. It has 9 associations to related views. Part of development package GLO_FIN_TAX_GTI_CN.

Data Sources (1)

SourceAliasJoin Type
I_CN_GoldenTaxDocumentBasic I_CN_GoldenTaxDocumentBasic from

Associations (9)

CardinalityTargetAliasCondition
[1..*] I_CN_GoldenTaxDocumentMapping _GTDItemMapping $projection.CN_GoldenTaxDocument = _GTDItemMapping.CN_GoldenTaxDocument
[1..*] I_CN_GoldenTaxDocHeaderMapping _GTDHeaderMapping $projection.CN_GoldenTaxDocument = _GTDHeaderMapping.CN_GoldenTaxDocument
[1..*] I_CN_GoldenTaxDocumentItem _GTDItem $projection.CN_GoldenTaxUUID = _GTDItem.CN_GoldenTaxUUID
[0..*] I_CN_GoldenTaxInvoiceMapping _GTInvcMapping $projection.CN_GoldenTaxDocument = _GTInvcMapping.CN_GoldenTaxDocument and _GTInvcMapping.IsDeleted <> 'X'
[0..1] P_CN_GoldenTaxInvcMappingAgg2 _GTInvcMappingAgg $projection.CN_GoldenTaxDocument = _GTInvcMappingAgg.CN_GoldenTaxDocument and _GTInvcMappingAgg.LinesOfDoc = 1
[1] P_CN_GTDocumentMappingAgg1 _GTCombine $projection.CN_GoldenTaxDocument = _GTCombine.CN_GoldenTaxDocument
[1] P_CN_GTDocumentMappingAgg3 _GTSplite $projection.CN_GoldenTaxDocument = _GTSplite.CN_GoldenTaxDocument
[0..1] I_Currency _LocalCurrency $projection.LocalCurrency = _LocalCurrency.Currency
[0..1] I_Currency _CN_TaxInvcCrcy $projection.CN_TaxInvcCrcy = _CN_TaxInvcCrcy.Currency

Annotations (12)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED 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 ICNGTDHEAD view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
EndUserText.label China Golden Tax Document view

Fields (52)

KeyFieldSource TableSource FieldDescription
KEY CN_GoldenTaxUUID CN_GoldenTaxUUID GT Doc. Header UUID
CN_GoldenTaxDocument CN_GoldenTaxDocument GT Doc No
CN_GoldenTaxDocumentStatus CN_GoldenTaxDocumentStatus GT Doc. Status
CN_TaxInvoiceCategory CN_TaxInvoiceCategory GTS Inv. Categroy
CN_TaxInvcType CN_TaxInvcType VAT Invoice Type
CN_GoldenTaxInvoiceMedium CN_GoldenTaxInvoiceMedium Invoice Medium
CN_GoldenTaxPositiveInvcNumber CN_GoldenTaxPositiveInvcNumber VAT Invoice No.
CN_GoldenTaxPositiveInvcCode CN_GoldenTaxPositiveInvcCode VAT Invoice Code
CN_GoldenTaxSendType CN_GoldenTaxSendType Transfr Typ
CN_GoldenTaxDocumentIsCanceled CN_GoldenTaxDocumentIsCanceled Cancelled
CN_GoldenTaxIsGoodsList CN_GoldenTaxIsGoodsList GT Goods List
CN_ReferenceGoldenTaxDocument CN_ReferenceGoldenTaxDocument GT Doc No
CN_TaxInvcNetAmtInLocalCrcy CN_TaxInvcNetAmtInLocalCrcy Own Net Val
CN_TaxInvcTaxAmtInLocalCrcy CN_TaxInvcTaxAmtInLocalCrcy VAT Amount Type
CN_TaxInvcDiscNetAmtInLoclCrcy CN_TaxInvcDiscNetAmtInLoclCrcy Discount
CN_TaxInvcDiscTaxAmtInLoclCrcy CN_TaxInvcDiscTaxAmtInLoclCrcy Tax Amount
LocalCurrency LocalCurrency Local Currency
TaxRate TaxRate Tax Rate
PayerParty PayerParty Payer
PayerPartyName PayerPartyName Customer Name
CN_TaxBuyerRegnNmbr CN_TaxBuyerRegnNmbr
CN_GoldenTaxPyrPtyAddrTelText CN_GoldenTaxPyrPtyAddrTelText Customer Address
CN_GoldenTaxPyrPtyBankText CN_GoldenTaxPyrPtyBankText Customer Bank
CN_GoldenTaxPyrPtyBusinessType CN_GoldenTaxPyrPtyBusinessType Cust. Business Type
CN_GoldenTaxPayerPartyPhone CN_GoldenTaxPayerPartyPhone Cust. Telephone No.
CN_GoldenTaxPyrPtyMobilePhone CN_GoldenTaxPyrPtyMobilePhone Customer Mobile No.
CN_GoldenTaxPyrPartyProvince CN_GoldenTaxPyrPartyProvince Customer Province
CN_GoldenTaxPayerPartyEmail CN_GoldenTaxPayerPartyEmail Supplier: Email
CN_GoldenTaxNote CN_GoldenTaxNote TradeRequest Comment
CN_GoldenTaxAdditionalNote CN_GoldenTaxAdditionalNote Additional Note
CN_GoldenTaxRedNoteNumber CN_GoldenTaxRedNoteNumber Red-Ltr. Notif. No.
CN_GoldenTaxIsWithRedNoteNmbr CN_GoldenTaxIsWithRedNoteNmbr Red-Ltr Invc. Indic.
CN_GoldenTaxIssuer CN_GoldenTaxIssuer User Name
CN_GoldenTaxReviewer CN_GoldenTaxReviewer User Name
CN_GoldenTaxReceiver CN_GoldenTaxReceiver Recipient
CN_GoldenTaxSourceDocumentDate CN_GoldenTaxSourceDocumentDate Document Date
CN_GoldenTaxSentDate CN_GoldenTaxSentDate Inv Sent to GT
CN_GoldenTaxNumberOfPrinting CN_GoldenTaxNumberOfPrinting Printing Times
CN_GoldenTaxLastPrintDate CN_GoldenTaxLastPrintDate Print Date
ExchangeRate ExchangeRate Exchange rate
CN_TaxInvcNetAmtInInvcCrcy CN_TaxInvcNetAmtInInvcCrcy Amount in For. Crcy
CN_TaxInvcCrcy CN_TaxInvcCrcy Currency
CreatedByUser CreatedByUser User Name
CreationDateTime CreationDateTime Timestamp
LastChangedByUser LastChangedByUser User Name
ChangedDateTime ChangedDateTime Time Stamp
_GTDItem _GTDItem
_GTDHeaderMapping _GTDHeaderMapping
_GTDItemMapping _GTDItemMapping
_GTInvcMapping _GTInvcMapping
_LocalCurrency _LocalCurrency
_CN_TaxInvcCrcy _CN_TaxInvcCrcy

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_GoldenTaxDocument.
-- 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_GoldenTaxDocument AS
SELECT
  CN_GoldenTaxUUID,
  CN_GoldenTaxDocument,
  CN_GoldenTaxDocumentStatus,
  CN_TaxInvoiceCategory,
  CN_TaxInvcType,
  CN_GoldenTaxInvoiceMedium,
  CN_GoldenTaxPositiveInvcNumber,
  CN_GoldenTaxPositiveInvcCode,
  CN_GoldenTaxSendType,
  CN_GoldenTaxDocumentIsCanceled,
  CN_GoldenTaxIsGoodsList,
  CN_ReferenceGoldenTaxDocument,
  CN_TaxInvcNetAmtInLocalCrcy,
  CN_TaxInvcTaxAmtInLocalCrcy,
  CN_TaxInvcDiscNetAmtInLoclCrcy,
  CN_TaxInvcDiscTaxAmtInLoclCrcy,
  LocalCurrency,
  TaxRate,
  PayerParty,
  PayerPartyName,
  CN_TaxBuyerRegnNmbr,
  CN_GoldenTaxPyrPtyAddrTelText,
  CN_GoldenTaxPyrPtyBankText,
  CN_GoldenTaxPyrPtyBusinessType,
  CN_GoldenTaxPayerPartyPhone,
  CN_GoldenTaxPyrPtyMobilePhone,
  CN_GoldenTaxPyrPartyProvince,
  CN_GoldenTaxPayerPartyEmail,
  CN_GoldenTaxNote,
  CN_GoldenTaxAdditionalNote,
  CN_GoldenTaxRedNoteNumber,
  CN_GoldenTaxIsWithRedNoteNmbr,
  CN_GoldenTaxIssuer,
  CN_GoldenTaxReviewer,
  CN_GoldenTaxReceiver,
  CN_GoldenTaxSourceDocumentDate,
  CN_GoldenTaxSentDate,
  CN_GoldenTaxNumberOfPrinting,
  CN_GoldenTaxLastPrintDate,
  ExchangeRate,
  CN_TaxInvcNetAmtInInvcCrcy,
  CN_TaxInvcCrcy,
  CreatedByUser,
  CreationDateTime,
  LastChangedByUser,
  ChangedDateTime
FROM I_CN_GoldenTaxDocumentBasic
LEFT OUTER JOIN I_CN_GoldenTaxDocumentMapping AS _GTDItemMapping ON CN_GoldenTaxDocument = _GTDItemMapping.CN_GoldenTaxDocument  -- association [1..*]
LEFT OUTER JOIN I_CN_GoldenTaxDocHeaderMapping AS _GTDHeaderMapping ON CN_GoldenTaxDocument = _GTDHeaderMapping.CN_GoldenTaxDocument  -- association [1..*]
LEFT OUTER JOIN I_CN_GoldenTaxDocumentItem AS _GTDItem ON CN_GoldenTaxUUID = _GTDItem.CN_GoldenTaxUUID  -- association [1..*]
LEFT OUTER JOIN I_CN_GoldenTaxInvoiceMapping AS _GTInvcMapping ON CN_GoldenTaxDocument = _GTInvcMapping.CN_GoldenTaxDocument AND _GTInvcMapping.IsDeleted <> 'X'  -- association [0..*]
LEFT OUTER JOIN P_CN_GoldenTaxInvcMappingAgg2 AS _GTInvcMappingAgg ON CN_GoldenTaxDocument = _GTInvcMappingAgg.CN_GoldenTaxDocument AND _GTInvcMappingAgg.LinesOfDoc = 1  -- association [0..1]
LEFT OUTER JOIN P_CN_GTDocumentMappingAgg1 AS _GTCombine ON CN_GoldenTaxDocument = _GTCombine.CN_GoldenTaxDocument  -- association [1]
LEFT OUTER JOIN P_CN_GTDocumentMappingAgg3 AS _GTSplite ON CN_GoldenTaxDocument = _GTSplite.CN_GoldenTaxDocument  -- association [1]
LEFT OUTER JOIN I_Currency AS _LocalCurrency ON LocalCurrency = _LocalCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _CN_TaxInvcCrcy ON CN_TaxInvcCrcy = _CN_TaxInvcCrcy.Currency  -- association [0..1]
;

Learn More