I_IN_SaveInvcMgmtSystItem

DDL: I_IN_SAVEINVCMGMTSYSTITEM Type: view_entity COMPOSITE

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)

SourceAliasJoin Type
I_IN_EDCTaxAuthGSTRets2Hdr _EDCTaxAuthGSTRets2Hdr inner
I_IN_SaveInvcMgmtSystDetail EDocInvcMgmtSystDetail from

Annotations (9)

NameValueLevelField
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)

KeyFieldSource TableSource FieldDescription
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 */
;