I_EXCISEDUEDOCITEMBASE
ExciseItem Duelist Base
I_EXCISEDUEDOCITEMBASE is a CDS View in S/4HANA. ExciseItem Duelist Base. It contains 34 fields. 3 CDS views read from this table.
CDS Views using this table (3)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| C_ExciseDueDocItem | view | from | CONSUMPTION | ExciseItem List from Billing Document |
| P_ExciseItemDutyCalcDefn | view | from | CONSUMPTION | ExciseItem Duty Calculation with TaxDefn |
| P_ExciseItemExBaseAmt | view | from | CONSUMPTION | ExciseItem ExBase Amout Calculation |
Fields (34)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | BillingDocument | BillingDocument | 2 |
| KEY | BillingDocumentItem | BillingDocumentItem | 1 |
| _BillingDocumentCategory | _BillingDocumentCategory | 1 | |
| _ExciseSeriesGrpDtmn | _ExciseSeriesGrpDtmn | 1 | |
| _Partner | _Partner | 1 | |
| BaseUnit | BaseUnit | 1 | |
| Batch | Batch | 1 | |
| BillingDocumentCategory | BillingDocumentCategory | 1 | |
| BillingDocumentDate | BillingDocumentDate | 1 | |
| BillingDocumentType | BillingDocumentType | 1 | |
| BillingQuantity | BillingQuantity | 1 | |
| BillingQuantityUnit | BillingQuantityUnit | 1 | |
| BusinessArea | BusinessArea | 1 | |
| CompanyCode | CompanyCode | 1 | |
| CostCenter | CostCenter | 1 | |
| Currency | Currency | 1 | |
| DistributionChannel | DistributionChannel | 1 | |
| Division | Division | 1 | |
| ExciseDocStatus | ExciseDocStatus | 1 | |
| Material | Material | 2 | |
| MaterialName | MaterialName | 1 | |
| Plant | Plant | 1 | |
| PlantName | PlantName | 1 | |
| PricingDocument | PricingDocument | 1 | |
| ProfitabilitySegment | ProfitabilitySegment | 1 | |
| ProfitCenter | ProfitCenter | 1 | |
| ReferenceSDDocument | ReferenceSDDocument | 1 | |
| SalesOrganization | SalesOrganization | 1 | |
| SDPricingProcedure | SDPricingProcedure | 2 | |
| ShippingPoint | ShippingPoint | 1 | |
| SoldToParty | SoldToParty | 1 | |
| StorageLocation | StorageLocation | 1 | |
| TaxCalculationProcedure | TaxCalculationProcedure | 1 | |
| TransactionCurrency | TransactionCurrency | 1 |
@AbapCatalog.sqlViewName: 'ISDEXDUEDOCIBS'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #COMPOSITE
@ObjectModel.usageType.serviceQuality:#D
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #MIXED
@EndUserText.label: 'ExciseItem Duelist Base'
define view I_ExciseDueDocItemBase
with parameters
P_BillingDocument :vbeln
as select from I_ExciseDueDocBase
{
BillingDocument,
BillingDocumentItem,
SalesOrganization,
DistributionChannel,
Division,
BillingDocumentCategory,
SoldToParty,
BillingDocumentDate,
BillingDocumentType,
PricingDocument,
TransactionCurrency,
ExciseDocStatus,
ShippingPoint,
Material,
MaterialName,
Language,
BaseUnit,
BillingQuantity,
BillingQuantityUnit,
PricingDate,
StorageLocation,
Batch,
ProfitCenter,
ProfitabilitySegment,
BusinessArea,
CostCenter,
Plant,
PlantName,
//SalesDocumentItemCategory,
TaxCalculationProcedure,
CompanyCode,
Currency,
SDPricingProcedure,
ReferenceSDDocument,
/* Associations */
_BillingDocumentCategory,
_ExciseSeriesGrpDtmn,
_Item,
_Partner
}
where
_ExciseSeriesGrpDtmn.ExciseGroup is not null
and _ExciseSeriesGrpDtmn._TextExciseGroup.ExciseDepot = ' '
and Language = $session.system_language
and BillingDocument = :P_BillingDocument