R_ExternalTaxHeaderDraft

DDL: R_EXTERNALTAXHEADERDRAFT Type: view_entity BASIC
37 Fields 1 Data Sources

Ext Tax Header for Statry Rptng - Draft

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

Data Sources (1)

SourceAliasJoin Type
ext_tax_header_d ext_tax_header_d from

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Ext Tax Header for Statry Rptng - Draft view
VDM.viewType #BASIC view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (37)

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
DraftEntityCreationDateTime draftentitycreationdatetime Draft Created On
DraftEntityLastChangeDateTime draftentitylastchangedatetime Draft Last Changed On
DraftAdministrativeDataUUID draftadministrativedatauuid UUID
DraftEntityOperationCode draftentityoperationcode Draft - Operation Code
HasActiveEntity hasactiveentity TRUE
DraftFieldChanges draftfieldchanges Field Changes

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 R_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 R_ExternalTaxHeaderDraft AS
SELECT
  ExternalTaxHeaderUUID,
  CompanyCode,
  AccountingDocument,
  cast( fiscalyear as fis_gjahr_no_conv preserving type ) 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,
  DraftEntityCreationDateTime,
  DraftEntityLastChangeDateTime,
  DraftAdministrativeDataUUID,
  DraftEntityOperationCode,
  HasActiveEntity,
  DraftFieldChanges
FROM ext_tax_header_d
;

Learn More