I_EXCISEDUEDOCHDR

CDS View

Excise Duelist with single line item

I_EXCISEDUEDOCHDR is a CDS View in S/4HANA. Excise Duelist with single line item. It contains 20 fields. 1 CDS views read from this table.

Used by 1 CDS view(s) 20 fields

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_ExciseDutyCalcDefn view from CONSUMPTION Excise Duty Calculation with TaxDefn

Fields (20)

KeyField CDS FieldsUsed in Views
KEY BillingDocument BillingDocument 2
_BillingDocumentCategory _BillingDocumentCategory 1
_Item _Item 1
BillingDocumentCategory BillingDocumentCategory 1
BillingDocumentDate BillingDocumentDate 1
BillingDocumentItem BillingDocumentItem 1
CompanyCode CompanyCode 1
Currency Currency 1
DistributionChannel DistributionChannel 1
Division Division 1
ExciseDocStatus ExciseDocStatus 1
Plant Plant 1
PlantName PlantName 1
PricingDocument PricingDocument 1
SalesOrganization SalesOrganization 1
SDPricingProcedure SDPricingProcedure 2
ShippingPoint ShippingPoint 1
SoldToParty SoldToParty 1
TaxCalculationProcedure TaxCalculationProcedure 1
TransactionCurrency TransactionCurrency 1 
@EndUserText.label: 'Excise Duelist with single line item'

@ObjectModel.representativeKey: 'BillingDocument'
@AbapCatalog.sqlViewName: 'ISDEXDUEDOCHDR'
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #COMPOSITE
@ClientHandling.algorithm: #SESSION_VARIABLE

@ObjectModel.usageType.serviceQuality:#D
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #MIXED

define view I_ExciseDueDocHdr
  as select from I_ExciseDueDocBase
    inner join   I_BillingDocFirstItem on  I_BillingDocFirstItem.BillingDocument     = I_ExciseDueDocBase.BillingDocument
                                       and I_BillingDocFirstItem.BillingDocumentItem = I_ExciseDueDocBase.BillingDocumentItem

{
  key I_ExciseDueDocBase.BillingDocument,
      I_ExciseDueDocBase.BillingDocumentItem,
      SalesOrganization,
      DistributionChannel,
      Division,
      BillingDocumentCategory,
      SoldToParty,
      BillingDocumentDate,
      I_ExciseDueDocBase.BillingDocumentType,
      PricingDocument,
      TransactionCurrency,
      ExciseDocStatus,
      ShippingPoint,
      Material,
      //MaterialName,

      BaseUnit,
      BillingQuantity,
      BillingQuantityUnit,
      PricingDate,
      StorageLocation,
      Batch,
      ProfitCenter,
      ProfitabilitySegment,
      BusinessArea,
      CostCenter,
      Plant,
      PlantName,
      //SalesDocumentItemCategory,

      TaxCalculationProcedure,
      CompanyCode,
      SDPricingProcedure,
      Currency,
      DeliveryDocument,
      ReferenceSDDocument,

      /* Associations */
      _BillingDocumentCategory,
      _ExciseSeriesGrpDtmn,
      _Item,
      _Partner
}
where
      _ExciseSeriesGrpDtmn._TextExciseGroup.ExciseGroup is not null
  and _ExciseSeriesGrpDtmn._TextExciseGroup.ExciseDepot = ' '
  and I_ExciseDueDocBase.Language                       = $session.system_language       
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BILLINGDOCFIRSTITEM",
"I_EXCISEDUEDOCBASE",
"I_EXCISEGROUP",
"I_EXCISESERIESGRPDETRMN"
],
"ASSOCIATED":
[
"I_BILLINGDOCUMENTCATEGORY",
"I_BILLINGDOCUMENTITEM",
"I_EXCISESERIESGRPDETRMN",
"I_SDDOCUMENTCOMPLETEPARTNERS"
],
"BASE":
[
"I_EXCISEDUEDOCBASE"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More