I_ExternalTaxHeaderDraft

DDL: I_EXTERNALTAXHEADERDRAFT Type: view_entity BASIC
31 Fields 1 Data Sources

Ext Tax Header - Draft

I_ExternalTaxHeaderDraft is a Basic CDS View that provides data about "Ext Tax Header - Draft" in SAP S/4HANA. It reads from 1 data source (ext_tax_header_d) and exposes 31 fields with key fields ExternalTaxHeaderUUID, CompanyCode, AccountingDocument, FiscalYear, DraftUUID.

Data Sources (1)

SourceAliasJoin Type
ext_tax_header_d ext_tax_header_d from

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Ext Tax Header - Draft view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
Metadata.ignorePropagatedAnnotations true view

Fields (31)

KeyFieldSource TableSource FieldDescription
KEY ExternalTaxHeaderUUID externaltaxheaderuuid
KEY CompanyCode companycode Receiver Company Code
KEY AccountingDocument accountingdocument Journal Entry
KEY FiscalYear G/L Fiscal Year
KEY DraftUUID draftuuid UUID
FiscalPeriod fiscalperiod Tax period
ReferenceDocumentType referencedocumenttype Reference Document Type
OriginalReferenceDocument originalreferencedocument Reference Key
PostingDate postingdate Posting Date for GR
DocumentDate documentdate Journal Entry Date
TaxReportingDate taxreportingdate Tax Reporting Date
TaxFulfillmentDate taxfulfillmentdate Tax Settlement Date
AccountingDocumentType accountingdocumenttype Journal Entry Type
ReverseDocument reversedocument Reversed With
ReverseDocumentFiscalYear Year
IsReversed isreversed Reversed?
IsReversal isreversal Reversal doc.
AbsoluteExchangeRate absoluteexchangerate Absolute Exchange Rate
DocumentReferenceID documentreferenceid Reference
AlternativeReferenceDocument alternativereferencedocument Alternative Reference Document
AccountingDocumentHeaderText accountingdocumentheadertext Doc.Header Text
SenderCompanyCode sendercompanycode Sender Company Code
SenderAccountingDocument senderaccountingdocument Sender Journal Entry
SenderFiscalYear Sender FiscalYr
SenderLogicalSystem senderlogicalsystem Sender Logical System
AccountingDocumentCategory accountingdocumentcategory Journal Entry Category
CreationDateTime creationdatetime Timestamp
CreatedByUser createdbyuser User Name
LoclInstanceLastChangeDateTime loclinstancelastchangedatetime Changed On
LastChangeDateTime lastchangedatetime Timestamp
LastChangedByUser lastchangedbyuser User Name

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_ExternalTaxHeaderDraft.
-- 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_ExternalTaxHeaderDraft AS
SELECT
  ExternalTaxHeaderUUID,
  CompanyCode,
  AccountingDocument,
  cast( fiscalyear as fis_gjahr_no_conv ) AS FiscalYear,
  DraftUUID,
  FiscalPeriod,
  ReferenceDocumentType,
  OriginalReferenceDocument,
  PostingDate,
  DocumentDate,
  TaxReportingDate,
  TaxFulfillmentDate,
  AccountingDocumentType,
  ReverseDocument,
  cast( reversedocumentfiscalyear as fis_stjah_no_conv ) AS ReverseDocumentFiscalYear,
  IsReversed,
  IsReversal,
  AbsoluteExchangeRate,
  DocumentReferenceID,
  AlternativeReferenceDocument,
  AccountingDocumentHeaderText,
  SenderCompanyCode,
  SenderAccountingDocument,
  cast( senderfiscalyear as fis_gjahr_sender_no_conv ) AS SenderFiscalYear,
  SenderLogicalSystem,
  AccountingDocumentCategory,
  CreationDateTime,
  CreatedByUser,
  LoclInstanceLastChangeDateTime,
  LastChangeDateTime,
  LastChangedByUser
FROM ext_tax_header_d
;

Learn More