I_EXCISETAXMATLDOCITEM

CDS View

MatlDocItem for Industry Excise Tax

I_EXCISETAXMATLDOCITEM is a CDS View in S/4HANA. MatlDocItem for Industry Excise Tax. It contains 56 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
A_ExciseTaxMatlDocItem view from COMPOSITE MatlDocItem for Industry Extensions

Fields (56)

KeyField CDS FieldsUsed in Views
KEY MaterialDocument MaterialDocument 1
KEY MaterialDocumentItem MaterialDocumentItem 1
KEY MaterialDocumentYear MaterialDocumentYear 1
Batch Batch 1
CompanyCode CompanyCode 1
CostCenter CostCenter 1
CreationDate CreationDate 1
CreationTime CreationTime 1
Customer Customer 1
CustomerAuthznGrp CustomerAuthznGrp 1
DebitCreditCode DebitCreditCode 1
DeliveryDocument DeliveryDocument 1
DeliveryDocumentItem DeliveryDocumentItem 1
DocumentDate DocumentDate 1
EntryUnit EntryUnit 1
GoodsMovementReasonCode GoodsMovementReasonCode 1
GoodsMovementRefDocType GoodsMovementRefDocType 1
GoodsMovementType GoodsMovementType 1
GoodsRecipientName GoodsRecipientName 1
IsAutomaticallyCreated IsAutomaticallyCreated 1
IsIssgOrRcvgStorLocAuthChkActv IsIssgOrRcvgStorLocAuthChkActv 1
IsReversalMovementType IsReversalMovementType 1
IssgOrRcvgBatch IssgOrRcvgBatch 1
IssgOrRcvgMaterial IssgOrRcvgMaterial 1
IsStorLocAuthznCheckActive IsStorLocAuthznCheckActive 1
IssuingOrReceivingPlant IssuingOrReceivingPlant 1
IssuingOrReceivingStorageLoc IssuingOrReceivingStorageLoc 1
Material Material 1
MaterialBaseUnit MaterialBaseUnit 1
OrderCategory OrderCategory 1
OrderID OrderID 1
OrderItem OrderItem 1
OrderType OrderType 1
OriginalMaterialDocumentItem OriginalMaterialDocumentItem 1
Plant Plant 1
PostingDate PostingDate 1
PurchaseOrder PurchaseOrder 1
PurchaseOrderCategory PurchaseOrderCategory 1
PurchaseOrderItem PurchaseOrderItem 1
PurchaseOrderItemCategory PurchaseOrderItemCategory 1
PurchaseOrderSubtype PurchaseOrderSubtype 1
PurchaseOrderType PurchaseOrderType 1
QuantityInBaseUnit QuantityInBaseUnit 1
QuantityInEntryUnit QuantityInEntryUnit 1
ReversedMaterialDocument ReversedMaterialDocument 1
ReversedMaterialDocumentItem ReversedMaterialDocumentItem 1
ReversedMaterialDocumentYear ReversedMaterialDocumentYear 1
SalesDocumentItemCategory SalesDocumentItemCategory 1
SalesOrder SalesOrder 1
SalesOrderItem SalesOrderItem 1
SalesOrderType SalesOrderType 1
StorageLocation StorageLocation 1
Supplier Supplier 1
SupplierAuthznGrp SupplierAuthznGrp 1
SupplyingPlant SupplyingPlant 1
SupplyingSupplier SupplyingSupplier 1

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- MatlDocItem for Industry Excise Tax
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_EXCISETAXMATLDOCITEM (
    MATERIALDOCUMENT,
    MATERIALDOCUMENTITEM,
    MATERIALDOCUMENTYEAR,
    BATCH,
    COMPANYCODE,
    COSTCENTER,
    CREATIONDATE,
    CREATIONTIME,
    CUSTOMER,
    CUSTOMERAUTHZNGRP,
    DEBITCREDITCODE,
    DELIVERYDOCUMENT,
    DELIVERYDOCUMENTITEM,
    DOCUMENTDATE,
    ENTRYUNIT,
    GOODSMOVEMENTREASONCODE,
    GOODSMOVEMENTREFDOCTYPE,
    GOODSMOVEMENTTYPE,
    GOODSRECIPIENTNAME,
    ISAUTOMATICALLYCREATED,
    ISISSGORRCVGSTORLOCAUTHCHKACTV,
    ISREVERSALMOVEMENTTYPE,
    ISSGORRCVGBATCH,
    ISSGORRCVGMATERIAL,
    ISSTORLOCAUTHZNCHECKACTIVE,
    ISSUINGORRECEIVINGPLANT,
    ISSUINGORRECEIVINGSTORAGELOC,
    MATERIAL,
    MATERIALBASEUNIT,
    ORDERCATEGORY,
    ORDERID,
    ORDERITEM,
    ORDERTYPE,
    ORIGINALMATERIALDOCUMENTITEM,
    PLANT,
    POSTINGDATE,
    PURCHASEORDER,
    PURCHASEORDERCATEGORY,
    PURCHASEORDERITEM,
    PURCHASEORDERITEMCATEGORY,
    PURCHASEORDERSUBTYPE,
    PURCHASEORDERTYPE,
    QUANTITYINBASEUNIT,
    QUANTITYINENTRYUNIT,
    REVERSEDMATERIALDOCUMENT,
    REVERSEDMATERIALDOCUMENTITEM,
    REVERSEDMATERIALDOCUMENTYEAR,
    SALESDOCUMENTITEMCATEGORY,
    SALESORDER,
    SALESORDERITEM,
    SALESORDERTYPE,
    STORAGELOCATION,
    SUPPLIER,
    SUPPLIERAUTHZNGRP,
    SUPPLYINGPLANT,
    SUPPLYINGSUPPLIER,
    PRIMARY KEY (MATERIALDOCUMENT, MATERIALDOCUMENTITEM, MATERIALDOCUMENTYEAR)
);