C_SalesRegisterDocumentTP

DDL: C_SALESREGISTERDOCUMENTTP Type: view_entity CONSUMPTION Package: GLO_FIN_GST_IN

Projection for Header documents

C_SalesRegisterDocumentTP is a Consumption CDS View that provides data about "Projection for Header documents" in SAP S/4HANA. It reads from 1 data source (R_IN_GSTRetsSlsRegDocumentTP) and exposes 39 fields with key fields ElectronicDocUUID, CompanyCode. It is exposed through 1 OData service (UI_MANAGE_SALES_REG). Part of development package GLO_FIN_GST_IN.

Data Sources (1)

SourceAliasJoin Type
R_IN_GSTRetsSlsRegDocumentTP R_IN_GSTRetsSlsRegDocumentTP projection

Annotations (8)

NameValueLevelField
EndUserText.label Projection for Header documents view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #CONSUMPTION view
Metadata.allowExtensions true view

OData Services (1)

ServiceBindingVersionContractRelease
UI_MANAGE_SALES_REG UI_MANAGE_SALES_RG V2 C1 NOT_RELEASED

Fields (39)

KeyFieldSource TableSource FieldDescription
KEY ElectronicDocUUID ElectronicDocUUID
KEY CompanyCode CompanyCode Receiver Company Code
BusinessPlace BusinessPlace Business place
AccountingDocument AccountingDocument Journal Entry
FiscalYear FiscalYear G/L Fiscal Year
BillingDocument BillingDocument SD Document
IN_DocumentSectionCode IN_DocumentSectionCode
IN_EDocEInvcExtNmbr IN_EDocEInvcExtNmbr
ReportingDate ReportingDate
IN_InvoiceDate IN_InvoiceDate
ElectronicDocProcStatusText ElectronicDocProcStatusText
InvoiceGrossAmount InvoiceGrossAmount Gross Invoice Amount
CompanyCodeCurrency CompanyCodeCurrency Local Currency
IN_GSTPlaceOfSupplyName IN_GSTPlaceOfSupplyName
IN_IsGSTReverseCharged IN_IsGSTReverseCharged
IN_NoteType IN_NoteType
IN_GSTTaxCodeTypeText IN_GSTTaxCodeTypeText
IN_InvoiceType IN_InvoiceType
ReportingCountry ReportingCountry
IN_GSTIdentificationNumber IN_GSTIdentificationNumber
BusinessPartnerFullName BusinessPartnerFullName Broker Name
IN_PrtnGSTIdentificationNmbr IN_PrtnGSTIdentificationNmbr
EDCRecordUUID EDCRecordUUID
EDCResultSqncNmbr EDCResultSqncNmbr
EDCResultUUID EDCResultUUID
EDCResultProcess EDCResultProcess
ElectronicDocProcessText ElectronicDocProcessText
IN_EDCCheckValue IN_EDCCheckValue
ElectronicDocSourceKey
IN_ElectronicDocInvcRefNmbr IN_ElectronicDocInvcRefNmbr
IN_ElectronicDocAcknDate IN_ElectronicDocAcknDate
IN_ElectronicInvoiceText IN_ElectronicInvoiceText
IN_EDocEInvcEWbillNmbr IN_EDocEInvcEWbillNmbr
IN_EDocEInvcEWbillCreateDate IN_EDocEInvcEWbillCreateDate
IN_EDocEInvcEWbillValidityDate IN_EDocEInvcEWbillValidityDate
IN_EDocAmendmentDte IN_EDocAmendmentDte
IN_ShippingBillDate IN_ShippingBillDate
IN_ShippingBillNumber IN_ShippingBillNumber
IN_ShippingBillPortNumber IN_ShippingBillPortNumber

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 C_SalesRegisterDocumentTP.
-- 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 C_SalesRegisterDocumentTP AS
SELECT
  ElectronicDocUUID,
  CompanyCode,
  BusinessPlace,
  AccountingDocument,
  FiscalYear,
  BillingDocument,
  IN_DocumentSectionCode,
  IN_EDocEInvcExtNmbr,
  ReportingDate,
  IN_InvoiceDate,
  ElectronicDocProcStatusText,
  InvoiceGrossAmount,
  CompanyCodeCurrency,
  IN_GSTPlaceOfSupplyName,
  IN_IsGSTReverseCharged,
  IN_NoteType,
  IN_GSTTaxCodeTypeText,
  IN_InvoiceType,
  ReportingCountry,
  IN_GSTIdentificationNumber,
  BusinessPartnerFullName,
  IN_PrtnGSTIdentificationNmbr,
  EDCRecordUUID,
  EDCResultSqncNmbr,
  EDCResultUUID,
  EDCResultProcess,
  ElectronicDocProcessText,
  IN_EDCCheckValue,
  IN_ElectronicDocInvcRefNmbr,
  IN_ElectronicDocAcknDate,
  IN_ElectronicInvoiceText,
  IN_EDocEInvcEWbillNmbr,
  IN_EDocEInvcEWbillCreateDate,
  IN_EDocEInvcEWbillValidityDate,
  IN_EDocAmendmentDte,
  IN_ShippingBillDate,
  IN_ShippingBillNumber,
  IN_ShippingBillPortNumber
FROM R_IN_GSTRetsSlsRegDocumentTP
;