R_IN_GSTRetsSlsRegDocumentTP is a Transactional CDS View that provides data about "Document header view parent root view" in SAP S/4HANA. It reads from 1 data source (I_SAPClient) and exposes 2 fields with key field ElectronicDocUUID. It has 1 association to related views.
@VDM.viewType: #TRANSACTIONAL@VDM.lifecycle.contract.type: #SAP_INTERNAL_API@AccessControl.authorizationCheck: #MANDATORY@EndUserText.label: 'Document header view parent root view'
@ObjectModel.usageType:{
serviceQuality: #X,
sizeCategory: #XL,
dataClass: #MIXED
}define root viewentity R_IN_GSTRetsSlsRegDocumentTP
asselectfrom I_SAPClient
// leftouter one to one join I_EDCElectronicDocRelation on I_IN_GSTRetsSlsRegDocument.ElectronicDocUUID = I_EDCElectronicDocRelation.ElectronicDocUUID
//
// leftouter one to one join I_EDCResult on I_EDCResult.EDCRecordUUID = I_EDCElectronicDocRelation.EDCRecordUUID
//
// leftouter one to one join I_ElectronicDocProcessTextTP on I_ElectronicDocProcessTextTP.ElectronicDocProcess = I_EDCResult.EDCResultProcess
//
// leftouter one to one join I_IN_GSTRetsSlsRegStateCode on I_IN_GSTRetsSlsRegStateCode.Region = I_IN_GSTRetsSlsRegDocument.IN_GSTPlaceOfSupply
//
// leftouter one to one join I_ElectronicDocProcStatusText on I_ElectronicDocProcStatusText.ElectronicDocProcessStatus = I_IN_GSTRetsSlsRegDocument.ElectronicDocProcessStatus
// and I_ElectronicDocProcStatusText.ElectronicDocProcess = 'INGSTR1'
//
// leftouter one to one join R_IN_EDCLastConsistencyCheckTP on I_IN_GSTRetsSlsRegDocument.CompanyCode = R_IN_EDCLastConsistencyCheckTP.EDCCompany
composition [0..*] of R_IN_GSTRetsSlsRegTaxItemTP as _TaxItemDetails
// composition [0..*] of R_SalesRegisterSummaryTP as _SalesRegSummaryTP
// composition [1] of R_IN_EDCLastConsistencyCheckTP as _ConsistencyCheck
{
keycast( 'D958DBDEC1231EDF8E8601098CA4FC41' as edoc_guid) as ElectronicDocUUID,
// cast( I_IN_GSTRetsSlsRegDocument.IN_EDocEInvcExtNmbr as gl_in_einvno ) as IN_EDocEInvcExtNmbr, // Invoice Number
// I_IN_GSTRetsSlsRegDocument.ReportingDate, // Reporting Date
// cast( I_IN_GSTRetsSlsRegDocument.ReportingDate as glo_in_invoice_date ) as IN_InvoiceDate, // Invoice Date
// cast( I_IN_GSTRetsSlsRegDocument.IN_InvoiceType as glo_in_invoice_type) as IN_InvoiceType,
// cast( I_ElectronicDocProcStatusText.ElectronicDocProcStatusText as glo_in_invoice_status ) as ElectronicDocProcStatusText, // Invoice Status
// cast( I_ElectronicDocProcessTextTP.ElectronicDocProcessText as glo_in_recon_status ) as ElectronicDocProcessText, // Reconcillation Status
// cast( I_IN_GSTRetsSlsRegStateCode.IN_GSTPlaceOfSupplyName as glo_in_placeofsupply ) as IN_GSTPlaceOfSupplyName, // Place Of Supply
// cast( I_IN_GSTRetsSlsRegDocument.IN_PrtnGSTIdentificationNmbr as glo_in_partnergstin ) as IN_PrtnGSTIdentificationNmbr,
// @Semantics.amount.currencyCode: 'CompanyCodeCurrency'
// cast( I_IN_GSTRetsSlsRegDocument.InvoiceGrossAmount as glo_in_totalamount ) as InvoiceGrossAmount, // Invoice Amount
// I_IN_GSTRetsSlsRegDocument.FiscalYear, // Fiscal year
// cast( I_IN_GSTRetsSlsRegDocument.IN_GSTIdentificationNumber as glo_in_taxpayergstin ) as IN_GSTIdentificationNumber, // TaxPayer GSTIN
// // I_IN_GSTRetsSlsRegDocument._BpPartner._TaxCategoryText.TaxTypeName, // CounterParty Name
// cast( I_IN_GSTRetsSlsRegDocument.IN_IsGSTReverseCharged as glo_in_reversecharge ) as IN_IsGSTReverseCharged, // RCM Flag
// cast( I_IN_GSTRetsSlsRegDocument.IN_DocumentSectionCode as glo_in_doc_section ) as IN_DocumentSectionCode, // Invoice Type
// cast( I_IN_GSTRetsSlsRegDocument.IN_NoteType as glo_in_notetype ) as IN_NoteType, // Note Type
// I_IN_GSTRetsSlsRegDocument.CompanyCode, // Company Code
// cast( I_IN_GSTRetsSlsRegDocument.AccountingDocument as glo_in_account_doc ) as AccountingDocument,
// I_IN_GSTRetsSlsRegDocument.BillingDocument,
// I_IN_GSTRetsSlsRegDocument.CompanyCodeCurrency,
// I_EDCElectronicDocRelation.EDCRecordUUID,
// I_EDCResult.EDCResultProcess,
// I_EDCResult.EDCSqncNmbr,
// I_EDCResult.EDCResultUUID,
// R_IN_EDCLastConsistencyCheckTP.IN_EDCCheckValue,
// I_IN_GSTRetsSlsRegDocument._IN_ElectronicDocInvoice.ElectronicDocSourceKey,
// I_IN_GSTRetsSlsRegDocument._IN_ElectronicDocInvoice.IN_ElectronicDocInvcRefNmbr, //IRN Number
// cast( I_IN_GSTRetsSlsRegDocument._IN_ElectronicDocInvoice.IN_ElectronicDocAcknDate as glo_in_einv_ack_date ) as IN_ElectronicDocAcknDate,
// cast( I_IN_GSTRetsSlsRegDocument._IN_ElectronicDocInvoice.IN_EDocEWbillStatus as glo_in_einv_ewb_status ) as IN_EDocEWbillStatus,
// cast( I_IN_GSTRetsSlsRegDocument._IN_ElectronicDocInvoice.IN_EDocEInvcEWbillNmbr as glo_in_einv_ewbno ) as IN_EDocEInvcEWbillNmbr,
// cast( I_IN_GSTRetsSlsRegDocument._IN_ElectronicDocInvoice.IN_EDocEInvcEWbillCreateDate as glo_in_einv_ewb_date ) as IN_EDocEInvcEWbillCreateDate,
// cast( I_IN_GSTRetsSlsRegDocument._IN_ElectronicDocInvoice.IN_EDocEInvcEWbillValidityDate as glo_in_einv_validto ) as IN_EDocEInvcEWbillValidityDate,
//Associations
_TaxItemDetails
// _ConsistencyCheck,
// _SalesRegSummaryTP
}