I_ExciseDocToday

DDL: I_EXCISEDOCTODAY SQL: ISDEXCTDY Type: view BASIC
37 Fields 1 Data Sources

ExciseDocument Created Today

I_ExciseDocToday is a Basic CDS View that provides data about "ExciseDocument Created Today" in SAP S/4HANA. It reads from 1 data source (I_ExciseDocument) and exposes 37 fields.

Data Sources (1)

SourceAliasJoin Type
I_ExciseDocument I_ExciseDocument from

Annotations (9)

NameValueLevelField
EndUserText.label ExciseDocument Created Today view
AbapCatalog.sqlViewName ISDEXCTDY view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #BASIC view

Fields (37)

KeyFieldSource TableSource FieldDescription
ExciseTransactionType I_ExciseDocument ExciseTransactionType Excise TT
ExciseDocumentYear I_ExciseDocument ExciseDocumentYear Year
InternalExciseDocNumber I_ExciseDocument InternalExciseDocNumber Number
CompanyCode I_ExciseDocument CompanyCode Receiver Company Code
Plant I_ExciseDocument Plant Valuation Area
ExciseGroup I_ExciseDocument ExciseGroup Excise Group
ExciseSeriesGroup I_ExciseDocument ExciseSeriesGroup Series Group
OfficialExciseDocNumber I_ExciseDocument OfficialExciseDocNumber Official No.
ExciseDocumentDate I_ExciseDocument ExciseDocumentDate Exc. doc. date
ExciseYear I_ExciseDocument ExciseYear Excise year
ExciseGoodsTimeOfRemoval I_ExciseDocument ExciseGoodsTimeOfRemoval Time of removal
ExciseSupplier I_ExciseDocument ExciseSupplier Vendor no.
ExciseShipFrom I_ExciseDocument ExciseShipFrom Supplier
IssuingReceivingPlant I_ExciseDocument IssuingReceivingPlant Receiving plant
Currency I_ExciseDocument Currency Valuation Crcy
BEDAmount I_ExciseDocument BEDAmount BED
SEDAmount I_ExciseDocument SEDAmount SED
AEDAmount I_ExciseDocument AEDAmount AED
CESSAmount I_ExciseDocument CESSAmount CESS
InternalReferenceDocument I_ExciseDocument InternalReferenceDocument Reference Doc
ExciseRefDoc1 I_ExciseDocument ExciseRefDoc1 Reversal Doc.
ExciseRefDocYear1 I_ExciseDocument ExciseRefDocYear1 Ref. Year1
ExciseRefDocType1 I_ExciseDocument ExciseRefDocType1 Ref doc typ 1
ExciseDocStatus I_ExciseDocument ExciseDocStatus Workflow Status
CreationDate I_ExciseDocument CreationDate Time Stamp
CreationTime I_ExciseDocument CreationTime Time of Change
CreatedByUser I_ExciseDocument CreatedByUser User Name
PostingDate I_ExciseDocument PostingDate Posting Date for GR
RuleOrSection I_ExciseDocument RuleOrSection Stk Determ.Rule
ExcisePreprintedSerialNumber I_ExciseDocument ExcisePreprintedSerialNumber Serial no.
AccountingDocumentCreationDate I_ExciseDocument AccountingDocumentCreationDate Journal Entry Date
_CompanyCode I_ExciseDocument _CompanyCode
_CompanyCodeStdVH I_ExciseDocument _CompanyCodeStdVH
_ExciseDocItem I_ExciseDocument _ExciseDocItem
_Plant I_ExciseDocument _Plant
_TextExciseGroup I_ExciseDocument _TextExciseGroup
_TextSeriesGroup I_ExciseDocument _TextSeriesGroup

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_ExciseDocToday.
-- 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: ISDEXCTDY

CREATE VIEW I_ExciseDocToday AS
SELECT
  I_ExciseDocument.ExciseTransactionType AS ExciseTransactionType,
  I_ExciseDocument.ExciseDocumentYear AS ExciseDocumentYear,
  I_ExciseDocument.InternalExciseDocNumber AS InternalExciseDocNumber,
  I_ExciseDocument.CompanyCode AS CompanyCode,
  I_ExciseDocument.Plant AS Plant,
  I_ExciseDocument.ExciseGroup AS ExciseGroup,
  I_ExciseDocument.ExciseSeriesGroup AS ExciseSeriesGroup,
  I_ExciseDocument.OfficialExciseDocNumber AS OfficialExciseDocNumber,
  I_ExciseDocument.ExciseDocumentDate AS ExciseDocumentDate,
  I_ExciseDocument.ExciseYear AS ExciseYear,
  I_ExciseDocument.ExciseGoodsTimeOfRemoval AS ExciseGoodsTimeOfRemoval,
  I_ExciseDocument.ExciseSupplier AS ExciseSupplier,
  I_ExciseDocument.ExciseShipFrom AS ExciseShipFrom,
  I_ExciseDocument.IssuingReceivingPlant AS IssuingReceivingPlant,
  I_ExciseDocument.Currency AS Currency,
  I_ExciseDocument.BEDAmount AS BEDAmount,
  I_ExciseDocument.SEDAmount AS SEDAmount,
  I_ExciseDocument.AEDAmount AS AEDAmount,
  I_ExciseDocument.CESSAmount AS CESSAmount,
  I_ExciseDocument.InternalReferenceDocument AS InternalReferenceDocument,
  I_ExciseDocument.ExciseRefDoc1 AS ExciseRefDoc1,
  I_ExciseDocument.ExciseRefDocYear1 AS ExciseRefDocYear1,
  I_ExciseDocument.ExciseRefDocType1 AS ExciseRefDocType1,
  I_ExciseDocument.ExciseDocStatus AS ExciseDocStatus,
  I_ExciseDocument.CreationDate AS CreationDate,
  I_ExciseDocument.CreationTime AS CreationTime,
  I_ExciseDocument.CreatedByUser AS CreatedByUser,
  I_ExciseDocument.PostingDate AS PostingDate,
  I_ExciseDocument.RuleOrSection AS RuleOrSection,
  I_ExciseDocument.ExcisePreprintedSerialNumber AS ExcisePreprintedSerialNumber,
  I_ExciseDocument.AccountingDocumentCreationDate AS AccountingDocumentCreationDate,
  I_ExciseDocument._CompanyCode AS _CompanyCode,
  I_ExciseDocument._CompanyCodeStdVH AS _CompanyCodeStdVH,
  I_ExciseDocument._ExciseDocItem AS _ExciseDocItem,
  I_ExciseDocument._Plant AS _Plant,
  I_ExciseDocument._TextExciseGroup AS _TextExciseGroup,
  I_ExciseDocument._TextSeriesGroup AS _TextSeriesGroup
FROM I_ExciseDocument
;

Learn More