R_IN_GSTRetsSlsRegDocumentTP

DDL: R_IN_GSTRETSSLSREGDOCUMENTTP Type: view_entity TRANSACTIONAL

Document header view parent root view

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.

Data Sources (1)

SourceAliasJoin Type
I_SAPClient I_SAPClient from

Associations (1)

CardinalityTargetAliasCondition
[0..*] R_IN_GSTRetsSlsRegTaxItemTP _TaxItemDetails

Annotations (7)

NameValueLevelField
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Document header view parent root view view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY ElectronicDocUUID
_TaxItemDetails _TaxItemDetails
@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 view entity R_IN_GSTRetsSlsRegDocumentTP
  as select from               I_SAPClient
//    left outer one to one join  I_EDCElectronicDocRelation    on I_IN_GSTRetsSlsRegDocument.ElectronicDocUUID = I_EDCElectronicDocRelation.ElectronicDocUUID

//

//    left outer one to one join I_EDCResult                   on I_EDCResult.EDCRecordUUID = I_EDCElectronicDocRelation.EDCRecordUUID

//

//    left outer one to one join I_ElectronicDocProcessTextTP    on I_ElectronicDocProcessTextTP.ElectronicDocProcess = I_EDCResult.EDCResultProcess

//

//    left outer one to one join I_IN_GSTRetsSlsRegStateCode   on I_IN_GSTRetsSlsRegStateCode.Region = I_IN_GSTRetsSlsRegDocument.IN_GSTPlaceOfSupply

//

//    left outer one to one join I_ElectronicDocProcStatusText on  I_ElectronicDocProcStatusText.ElectronicDocProcessStatus = I_IN_GSTRetsSlsRegDocument.ElectronicDocProcessStatus

//                                                             and I_ElectronicDocProcStatusText.ElectronicDocProcess       = 'INGSTR1'

//

//    left outer 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



{
  key cast( '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

}