I_IN_GSTRETSSLSREGDOCUMENT

CDS View
26 Fields 4 CDS Views

India GSTR Sales Register Document

I_IN_GSTRETSSLSREGDOCUMENT is a CDS View in S/4HANA. India GSTR Sales Register Document. It contains 26 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
I_IN_GSTRetSalesRegRunCube view_entity from COMPOSITE India GSTR Sales Register - Cube
I_IN_GSTRetsSalesRegisterC view_entity from COMPOSITE India GSTR Sales Register - Cube
I_IN_SalesRegisterAnalyticsC view_entity from COMPOSITE Analytics for MSR - Cube
R_IN_GSTRetsSlsRegDocumentTP view_entity from TRANSACTIONAL Document header view parent root view

Fields (26)

KeyField CDS FieldsUsed in Views
KEY CompanyCode CompanyCode 4
KEY ElectronicDocUUID ElectronicDocUUID 4
AccountingDocument AccountingDocument 3
BillingDocument BillingDocument 4
BusinessPartnerFullName BusinessPartnerFullName 1
BusinessPlace BusinessPlace 3
CompanyCodeCurrency CompanyCodeCurrency 1
Country Country 2
ElectronicDocProcessStatus ElectronicDocProcessStatus 3
ElectronicDocSourceType ElectronicDocSourceType 3
FiscalYear FiscalYear 4
IN_DifferentialPercentageRate IN_DifferentialPercentageRate 3
IN_DocumentSectionCode IN_DocumentSectionCode 1
IN_EDocEInvcEditActionFlag IN_EDocEInvcEditActionFlag 3
IN_EDocEInvcExtNmbr IN_EDocEInvcExtNmbr 2
IN_GSTIdentificationNumber IN_GSTIdentificationNumber 3
IN_GSTPartner IN_GSTPartner 1
IN_GSTPlaceOfSupply IN_GSTPlaceOfSupply 3
IN_GSTPlaceOfSupplyName IN_GSTPlaceOfSupplyName 2
IN_HasNilType IN_HasNilType 2
IN_InvoiceType IN_InvoiceType 3
IN_IsGSTReverseCharged IN_IsGSTReverseCharged 3
IN_NoteType IN_NoteType 3
IN_PrtnGSTIdentificationNmbr IN_PrtnGSTIdentificationNmbr 3
InvoiceGrossAmount InvoiceGrossAmount 3
ReportingDate ReportingDate 3

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- India GSTR Sales Register Document
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_IN_GSTRETSSLSREGDOCUMENT (
    COMPANYCODE,
    ELECTRONICDOCUUID,
    ACCOUNTINGDOCUMENT,
    BILLINGDOCUMENT,
    BUSINESSPARTNERFULLNAME,
    BUSINESSPLACE,
    COMPANYCODECURRENCY,
    COUNTRY,
    ELECTRONICDOCPROCESSSTATUS,
    ELECTRONICDOCSOURCETYPE,
    FISCALYEAR,
    IN_DIFFERENTIALPERCENTAGERATE,
    IN_DOCUMENTSECTIONCODE,
    IN_EDOCEINVCEDITACTIONFLAG,
    IN_EDOCEINVCEXTNMBR,
    IN_GSTIDENTIFICATIONNUMBER,
    IN_GSTPARTNER,
    IN_GSTPLACEOFSUPPLY,
    IN_GSTPLACEOFSUPPLYNAME,
    IN_HASNILTYPE,
    IN_INVOICETYPE,
    IN_ISGSTREVERSECHARGED,
    IN_NOTETYPE,
    IN_PRTNGSTIDENTIFICATIONNMBR,
    INVOICEGROSSAMOUNT,
    REPORTINGDATE,
    PRIMARY KEY (COMPANYCODE, ELECTRONICDOCUUID)
);

Learn More