- Accounting - General (AC)
- Application Platform (AP)
- Basis Components (BC)
- Business Mobile (MOB)
- Business Network Solutions (BNS)
- Business intelligence solutions (BI)
- Collaborative Cross Applications (XAP)
- Controlling (CO)
- Cross-Application Components (CA)
- Cross-Application Components (CA)
- Customer Relationship Management (CRM)
- Customer Service (CS)
- Discrete Industries (DI)
- Enterprise Contract Management (CM)
- Enterprise Controlling (EC)
- Enterprise Performance Management (EPM)
- Enterprise Portal (EP)
- Enterprise Portal (EP)
- Enterprise information management solutions (EIM)
- Environment, Health, and Safety / Product Compliance (EHS)
- Financial Accounting (FI)
- Accounts Payable (FI-AP)
- Accounts Receivable (FI-AR)
- Additional Functions (FI-AF)
- Asset Accounting (FI-AA)
- Bank Accounting (FI-BL)
- Business Accounting (FIN-BAC)
- Business Analytics (FIN-BA)
- Central Finance (FI-CF)
- Consolidation (FI-LC)
- Contract Accounts Receivable and Payable (FI-CA)
- Convergent Contract Accounting (FI-CAC)
- Corporate Governance (FIN-CGV)
- Financial Shared Service Center (FIN-SSC)
- Financial Supply Chain Management (FIN-FSCM)
- Financials Basis (FIN-FB)
- Fiori UI for Financial Accounting (FI-FIO)
- Fiori UI for Financials (FIN-FIO)
- Funds Management (FI-FM)
- General Ledger Accounting (FI-GL)
- Generic Contract Accounts Receivable and Payable (FI-CAX)
- Lease Accounting (FI-LA)
- Localization (FI-LOC)
- ACR Activities (FI-LOC-VAT)
- Audit Reporting (FI-LOC-AUR)
- Cash Budgeting (FI-LOC-CB)
- Cash Management (FI-LOC-CM)
- Certification (FI-LOC-CER)
- Contract Accounts Receivable and Payable (FI-LOC-CA)
- Corporate Income Tax Framework (FI-LOC-CIT)
- Financials - UIs Localization (FI-LOC-UX)
- Globalization Service: Business Place (FI-LOC-BUP)
- Golden Audit Interface (FI-LOC-GAI)
- Golden Tax Interface (China) (FI-LOC-GTI)
- Localization Asset Accounting (FI-LOC-AA)
- Localization E-Payment Integration (FI-LOC-EPI)
- Localization Financials (FI-LOC-FI)
- Localization Financials (generic parts) (FI-LOC-GEN)
- Localization Financials Reporting Framework (FI-LOC-FRW)
- Localization Funds Management (FI-LOC-FM)
- Localization Logistics (FI-LOC-LO)
- Logistics Argentinia (FI-LOC-LO-AR)
- Logistics Brazil (FI-LOC-LO-BR)
- Logistics Bulgaria (FI-LOC-LO-BG)
- Logistics Croatia (FI-LOC-LO-HR)
- Logistics Greece (FI-LOC-LO-GR)
- Logistics India (FI-LOC-LO-IN)
- Logistics Israel (FI-LOC-LO-IL)
- Logistics Japan (FI-LOC-LO-JP)
- Logistics Latvia (FI-LOC-LO-LV)
- Logistics Netherlands (FI-LOC-LO-NL)
- Logistics Portugal (FI-LOC-LO-PT)
- Logistics Romania (FI-LOC-LO-RO)
- Logistics Russia (FI-LOC-LO-RU)
- Logistics Serbia (FI-LOC-LO-RS)
- Localization Public Sector (FI-LOC-PS)
- Localization Tax Service (FI-LOC-TXS)
- Localization Travel Management (FI-LOC-TV)
- Localization for Sales and Distribution (FI-LOC-SD)
- Localization for Treasury (FI-LOC-TRM)
- Localization for Utilities Industry (FI-LOC-UT)
- Online Validation Framework (FI-LOC-OVF)
- Payment Receipt (FI-LOC-PR)
- SAF-T Reporting (Generic Part) (FI-LOC-SAF)
- Statutory Reporting (FI-LOC-IS)
- Statutory Reporting Framework (FI-LOC-SRF)
- Tax Invoice Management (FI-LOC-TIM)
- VAT Pro Rata (FI-LOC-RAT)
- Predictive Accounting (FI-PRA)
- Real-Time Consolidation (FIN-RTC)
- Revenue Accounting (FI-RA)
- S4H Best Practices - Content and Content Activation (FI-CNT)
- S4HANA Financial Consolidation[Cloud] (FIN-CS)
- SAP Simple Finance data migration (FIN-MIG)
- Special Purpose Ledger (FI-SL)
- Strategic Enterprise Management (FIN-SEM)
- Tax Management Framework (FIN-TMF)
- Tax Subledger (FI-TXL)
- Travel Management (FI-TV)
- Financial Services (FS)
- Financials (FIN)
- Global Trade Services (SLL)
- Governance, Risk and Compliance (GRC)
- Incentive and Commission Management (ICM) (ICM)
- Investment Management (IM)
- Knowledge Management (KM)
- LOD Components (LOD)
- Logistics - General (LO)
- Logistics Execution (LE)
- Materials Management (MM)
- Obsolete Product: mySAP.com Workplace (WP)
- Occasional Platform User (OPU)
- Payroll (PY)
- Personnel Management (PA)
- Personnel Time Management (PT)
- Plant Maintenance (PM)
- Portfolio and Project Management (PPM)
- Product Lifecycle Management (PLM)
- Production Planning and Control (PP)
- Project System (PS)
- Public Sector Management (PSM)
- Purchasing SAP Cloud (PUR)
- Quality Management (QM)
- Real Estate Management (RE)
- SAP Business Warehouse (BW)
- SAP HANA (HAN)
- SAP NetWeaver Master Data Management (MDM)
- SAP Supplier Lifecycle Management (SLC)
- Sales and Distribution (SD)
- Service (SV)
- Supply Chain Management (SCM)
- Sustainability management (SUS)
- Training and Event Management (PE)
- Transportation Management (TM)
- Treasury (TR)
- Web Channel (WEC)
J_1IEXCDTL
Excise invoice line item details
|
#transactional
|
Component: Logistics India
- 🔑 Keys (5)
- 💰 Amounts (28)
- ∑ Quantities (7)
- 📅 Dates (4)
- ☰ Categorical (5)
- Other (45)
- 🔗 Relations (12)
| Column Name | Description | |
|---|---|---|
| MANDT FK | Client | |
| TRNTYP FK | Excise Transaction Type | |
| DOCYR | Year | |
| DOCNO FK | Internal Excise Document Number | |
| ZEILE | Item Number |
| Column Name | Description | |
|---|---|---|
| 💲 Currency (EXCUR): | ||
| EXBAS | Excise Duty Base Amount | |
| EXBED | Basic Excise Duty | |
| EXSED | Special Excise Duty | |
| EXAED | Additional Excise Duty | |
| CESS | Cess amount | |
| BEDINV | Inventorized BED | |
| AEDINV | Inventorized AED | |
| SEDINV | Inventorized SED | |
| ADDBED | Additional BED | |
| ADDSED | Additional SED | |
| ADDAED | Additional AED | |
| INDTAX | Non-deductible tax value | |
| ADDLVAL1 | Additional Value | |
| ADDLVAL2 | Additional Value | |
| NCCD | NCCD Value | |
| NCCDINV | NCCD Inventory Component | |
| ADDNCCD | Additional NCCD | |
| ECS | ECS Value | |
| ECSINV | ECS Inventory component | |
| EXADDTAX1 | Additional Tax1 value | |
| EXADDINV1 | Inventorized AT1 | |
| ADDAT1 | Additional AT1 | |
| EXADDTAX2 | Additional Tax2 value | |
| EXADDINV2 | Inventorized AT2 | |
| ADDAT2 | Additional AT2 | |
| EXADDTAX3 | Additional Tax3 value | |
| EXADDINV3 | Inventorized AT3 | |
| ADDAT3 | Additional AT3 | |
| Column Name | Description | |
|---|---|---|
| 📏 Unit of Measure (MEINS): | ||
| MENGE | Quantity mentioned in the excise invoice | |
| MENGA | Quantity of Goods Received | |
| CREDIT_QTY | Quantity on Which CENVAT Credit Is Taken | |
| MENGR | Quantity remaining in the depot | |
| SCPGN | Quantity of Scrap generated | |
| 📏 Weight Unit (GEWEI): | ||
| NTGEW | Net weight | |
| BRGEW | Gross weight | |
| Column Name | Description | |
|---|---|---|
| EXDAT | Excise Document Date | |
| CPUDT | Excise Document Entry Date | |
| CPUTM | Time of Entry | |
| AEDAT | Changed on date |
| Column Name | Description | |
|---|---|---|
| RIND1 | Reference Document Type 1 | Show values |
| RIND2 | Reference Document Type 2 | Show values |
| RIND3 | Reference document type 3 | Show values |
| STATUS | Excise Document Status | Show values |
| CAPIND | Material Type | Show values |
| Column Name | Description | Domain name | |
|---|---|---|---|
| EXNUM | Official Excise Document Number | J_1IEXCNUM | |
| EXYEAR | Excise Year | GJAHR | |
| EXGRP | Excise Group | J_1IEXCGRP | |
| LIFNR | Vendor | J_1ILIFNR | |
| SHIPFROM | Account Number of Supplier | LIFNR | |
| MAKTX | Material Description | TEXT40 | |
| CHARG | Batch Number | CHARG | |
| CHAPID | Chapter ID | CHAR12 | |
| PART2YR | Year of Register Entry | NUMC4 | |
| RG23ASER | RG23A serial no. | NUMC10 | |
| RG23CSER | RG23C serial no. | NUMC10 | |
| RGPLASER | PLA serial no. | NUMC10 | |
| PART1YR | Year of Register Entry | NUMC4 | |
| PART1SER | Register Entry Serial Number | NUMC10 | |
| RDOC1 | Reference Document 1 | CHAR10 | |
| RYEAR1 | Reference year 1 | CHAR4 | |
| RITEM1 | Reference Item 1 | NUMC6 | |
| RDOC2 | Reference Document 2 | CHAR10 | |
| RYEAR2 | Reference year 2 | CHAR4 | |
| RITEM2 | Reference Item 2 | NUMC6 | |
| RDOC3 | Reference Document 3 | CHAR40 | |
| BEDRATE | BED percentage | PRZ34 | |
| AEDRATE | Additional Excise Duty % | PRZ34 | |
| SEDRATE | Special Excise Duty % | PRZ34 | |
| CESSRATE | Cess Rate | PRZ34 | |
| MRPIND | Single-Character Flag | CHAR1 | |
| USNAM | Created By | CHAR12 | |
| AENAM | Changed by the user | CHAR12 | |
| ADDLDATA1 | Additional Data | CHAR60 | |
| ADDLDATA2 | Additional Data | CHAR60 | |
| ADDLDATA3 | Additional Data | CHAR60 | |
| ADDLDATA4 | Additional Data | CHAR60 | |
| NUM_OF_PKGS | Number of Packages | J_1ICHAR10LOW | |
| DESC_PKG | Package Description | CHAR30LOW | |
| MRK_PKG | Marks on Package | CHAR30LOW | |
| NOS_ON_PKG | Numbers on Package | CHAR30LOW | |
| LICYR | License Year | GJAHR | |
| LICNO | Internal License Number | J_1ILICNO | |
| LICZEILE | Item Number | J_1IZEILE | |
| NCCDRATE | NCCD Rate in % | PRZ34 | |
| ECSRATE | ECS rate in % | PRZ34 | |
| EXADDRATE1 | AT1 rate in % | PRZ34 | |
| EXADDRATE2 | AT2 rate in % | PRZ34 | |
| EXADDRATE3 | AT3 rate in % | PRZ34 | |
| SERTAXSERNO | Service Tax Serial Number | NUMC10 |
| Master Data Relations | Join Conditions |
|---|---|
| Foreign key for Currency key | |
| Business Area | |
Foreign key for storage location
| |
| Client | J_1IEXCDTL.MANDT == T000.MANDT |
Foreign key for Material number
| |
| Foreign key for unit of measure | |
| Base Unit of Measure | |
| Receiving plant/issuing plant | |
| Rejection Code |
|
| Plant Foreign key |
| Other Relations | to Master Data Relations ↑ | Join Conditions |
|---|---|
Excise Transaction Type
|