I_IN_SaveInvcMgmtSystItem
Save IMS Invoice Details
I_IN_SaveInvcMgmtSystItem is a Composite CDS View (Cube) that provides data about "Save IMS Invoice Details" in SAP S/4HANA. It reads from 2 data sources (I_IN_EDCTaxAuthGSTRets2Hdr, I_IN_SaveInvcMgmtSystDetail) and exposes 27 fields with key field ElectronicDocUUID.
Data Sources (2)
| Source | Alias | Join Type |
|---|---|---|
| I_IN_EDCTaxAuthGSTRets2Hdr | _EDCTaxAuthGSTRets2Hdr | inner |
| I_IN_SaveInvcMgmtSystDetail | EDocInvcMgmtSystDetail | from |
Annotations (9)
| Name | Value | Level | Field |
|---|---|---|---|
| AccessControl.authorizationCheck | #NOT_REQUIRED | view | |
| VDM.viewType | #COMPOSITE | view | |
| EndUserText.label | Save IMS Invoice Details | view | |
| Analytics.dataCategory | #CUBE | view | |
| Analytics.internalName | #LOCAL | view | |
| Metadata.ignorePropagatedAnnotations | true | view | |
| ObjectModel.usageType.serviceQuality | #X | view | |
| ObjectModel.usageType.sizeCategory | #M | view | |
| ObjectModel.usageType.dataClass | #MIXED | view |
Fields (27)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | ElectronicDocUUID | I_IN_SaveInvcMgmtSystDetail | ElectronicDocUUID | |
| ElectronicDocCompanyCode | ||||
| EDCTaxAuthRecordUUID | I_IN_EDCTaxAuthGSTRets2Hdr | EDCTaxAuthRecordUUID | UUID | |
| IN_EDCTaxAuthTaxPayerGSTIN | I_IN_EDCTaxAuthGSTRets2Hdr | IN_EDCTaxAuthTaxPayerGSTIN | Taxpayer GSTIN | |
| IN_EDCTaxAuthBusinessPrtnGSTIN | I_IN_EDCTaxAuthGSTRets2Hdr | IN_EDCTaxAuthBusinessPrtnGSTIN | Counter Party GSTIN | |
| IN_TaxAuthRets2DocSectionCode | I_IN_EDCTaxAuthGSTRets2Hdr | IN_TaxAuthRets2DocSectionCode | GSTR2A/2B Doc Sec | |
| IN_EDCTaxAuthReportingDate | I_IN_EDCTaxAuthGSTRets2Hdr | IN_EDCTaxAuthReportingDate | Reporting Date | |
| IN_EDCTaxAuthBusinessPlace | I_IN_EDCTaxAuthGSTRets2Hdr | IN_EDCTaxAuthBusinessPlace | Business place | |
| IN_EDCDocumentNumber | I_IN_EDCTaxAuthGSTRets2Hdr | IN_EDCDocumentNumber | Purchasing Doc. | |
| IN_EDCTaxAuthDocumentDate | I_IN_EDCTaxAuthGSTRets2Hdr | IN_EDCTaxAuthDocumentDate | Document Date | |
| IN_EDCInvcMgmtSystSrceFmType | I_IN_EDCTaxAuthGSTRets2Hdr | IN_EDCInvcMgmtSystSrceFmType | ||
| IN_EDCDocumentType | I_IN_EDCTaxAuthGSTRets2Hdr | IN_EDCDocumentType | SAF-T Inv. Type | |
| IN_NoteType | I_IN_EDCTaxAuthGSTRets2Hdr | IN_NoteType | Type of Note | |
| IN_EDCTaxAuthGSTPlaceOfSupply | I_IN_EDCTaxAuthGSTRets2Hdr | IN_EDCTaxAuthGSTPlaceOfSupply | Table position | |
| IN_EDCTaxAuthDocumentAmount | I_IN_EDCTaxAuthGSTRets2Hdr | IN_EDCTaxAuthDocumentAmount | Document Amount | |
| IN_EDCTaxAuthTaxableAmount | I_IN_EDCTaxAuthGSTRets2Hdr | IN_EDCTaxAuthTaxableAmount | Taxable Amount | |
| IN_EDCTaxAuthIntegratedGSTAmt | I_IN_EDCTaxAuthGSTRets2Hdr | IN_EDCTaxAuthIntegratedGSTAmt | IGST Amount | |
| IN_EDCTaxAuthCentralGSTAmount | I_IN_EDCTaxAuthGSTRets2Hdr | IN_EDCTaxAuthCentralGSTAmount | CGST Amount | |
| IN_EDCTaxAuthStateGSTAmount | I_IN_EDCTaxAuthGSTRets2Hdr | IN_EDCTaxAuthStateGSTAmount | SGST Amount | |
| IN_EDCTaxAuthCESSAmount | I_IN_EDCTaxAuthGSTRets2Hdr | IN_EDCTaxAuthCESSAmount | Cess Amount | |
| Currency | I_IN_EDCTaxAuthGSTRets2Hdr | Currency | Valuation Crcy | |
| IN_EDCOriginalDocumentNumber | I_IN_EDCTaxAuthGSTRets2Hdr | IN_EDCOriginalDocumentNumber | Orig Doc Number | |
| IN_EDCOriginalDocumentDate | I_IN_EDCTaxAuthGSTRets2Hdr | IN_EDCOriginalDocumentDate | Original Doc Date | |
| IN_EDocInvcMgmtSystAction | I_IN_SaveInvcMgmtSystDetail | IN_EDocInvcMgmtSystAction | ||
| IN_EDocInvcMgmtSystPrevActn | I_IN_SaveInvcMgmtSystDetail | IN_EDocInvcMgmtSystPrevActn | ||
| ElectronicDocProcessStatus | I_IN_SaveInvcMgmtSystDetail | ElectronicDocProcessStatus | ||
| ElectronicDocProcessForStatus | I_IN_SaveInvcMgmtSystDetail | ElectronicDocProcessForStatus |
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_IN_SaveInvcMgmtSystItem.
-- 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.
CREATE VIEW I_IN_SaveInvcMgmtSystItem AS
SELECT
EDocInvcMgmtSystDetail.ElectronicDocUUID AS ElectronicDocUUID,
EDocInvcMgmtSystDetail._ElectronicDoc.ElectronicDocCompanyCode AS ElectronicDocCompanyCode,
_EDCTaxAuthGSTRets2Hdr.EDCTaxAuthRecordUUID AS EDCTaxAuthRecordUUID,
_EDCTaxAuthGSTRets2Hdr.IN_EDCTaxAuthTaxPayerGSTIN AS IN_EDCTaxAuthTaxPayerGSTIN,
_EDCTaxAuthGSTRets2Hdr.IN_EDCTaxAuthBusinessPrtnGSTIN AS IN_EDCTaxAuthBusinessPrtnGSTIN,
_EDCTaxAuthGSTRets2Hdr.IN_TaxAuthRets2DocSectionCode AS IN_TaxAuthRets2DocSectionCode,
_EDCTaxAuthGSTRets2Hdr.IN_EDCTaxAuthReportingDate AS IN_EDCTaxAuthReportingDate,
_EDCTaxAuthGSTRets2Hdr.IN_EDCTaxAuthBusinessPlace AS IN_EDCTaxAuthBusinessPlace,
_EDCTaxAuthGSTRets2Hdr.IN_EDCDocumentNumber AS IN_EDCDocumentNumber,
_EDCTaxAuthGSTRets2Hdr.IN_EDCTaxAuthDocumentDate AS IN_EDCTaxAuthDocumentDate,
_EDCTaxAuthGSTRets2Hdr.IN_EDCInvcMgmtSystSrceFmType AS IN_EDCInvcMgmtSystSrceFmType,
_EDCTaxAuthGSTRets2Hdr.IN_EDCDocumentType AS IN_EDCDocumentType,
_EDCTaxAuthGSTRets2Hdr.IN_NoteType AS IN_NoteType,
_EDCTaxAuthGSTRets2Hdr.IN_EDCTaxAuthGSTPlaceOfSupply AS IN_EDCTaxAuthGSTPlaceOfSupply,
_EDCTaxAuthGSTRets2Hdr.IN_EDCTaxAuthDocumentAmount AS IN_EDCTaxAuthDocumentAmount,
_EDCTaxAuthGSTRets2Hdr.IN_EDCTaxAuthTaxableAmount AS IN_EDCTaxAuthTaxableAmount,
_EDCTaxAuthGSTRets2Hdr.IN_EDCTaxAuthIntegratedGSTAmt AS IN_EDCTaxAuthIntegratedGSTAmt,
_EDCTaxAuthGSTRets2Hdr.IN_EDCTaxAuthCentralGSTAmount AS IN_EDCTaxAuthCentralGSTAmount,
_EDCTaxAuthGSTRets2Hdr.IN_EDCTaxAuthStateGSTAmount AS IN_EDCTaxAuthStateGSTAmount,
_EDCTaxAuthGSTRets2Hdr.IN_EDCTaxAuthCESSAmount AS IN_EDCTaxAuthCESSAmount,
_EDCTaxAuthGSTRets2Hdr.Currency AS Currency,
_EDCTaxAuthGSTRets2Hdr.IN_EDCOriginalDocumentNumber AS IN_EDCOriginalDocumentNumber,
_EDCTaxAuthGSTRets2Hdr.IN_EDCOriginalDocumentDate AS IN_EDCOriginalDocumentDate,
EDocInvcMgmtSystDetail.IN_EDocInvcMgmtSystAction AS IN_EDocInvcMgmtSystAction,
EDocInvcMgmtSystDetail.IN_EDocInvcMgmtSystPrevActn AS IN_EDocInvcMgmtSystPrevActn,
EDocInvcMgmtSystDetail.ElectronicDocProcessStatus AS ElectronicDocProcessStatus,
EDocInvcMgmtSystDetail.ElectronicDocProcessForStatus AS ElectronicDocProcessForStatus
FROM I_IN_SaveInvcMgmtSystDetail AS EDocInvcMgmtSystDetail
INNER JOIN I_IN_EDCTaxAuthGSTRets2Hdr AS _EDCTaxAuthGSTRets2Hdr ON /* join condition not captured in parsed metadata */
;
Learn More
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- CDS View Annotations — A Complete Guide
- What Is a CDS View in SAP S/4HANA?
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- BW Extractor to CDS View Migration Guide
- S/4HANA CDS View Deprecation: What You Need to Know
- ABAP CDS View Tutorial — From Basics to Real-World Examples
- RAP and CDS Views — Building Transactional Apps in SAP S/4HANA
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA