EDCINR2BCPSMMRY
Counterparty summary table for GSTR2B from tax authority
EDCINR2BCPSMMRY is an SAP database table in S/4HANA. Counterparty summary table for GSTR2B from tax authority. It contains 15 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_IN_EDCTaxAuthRets2CtptySmmry | view_entity | from | BASIC | CP summary for GSTR2B from tax authority |
Fields (15)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | MANDT | Client | |||
| KEY | record_guid | EDC_RECORD_GUID | Record GUID | |||
| tp_gstin | EDC_IN_TAX_PAYER_GSTIN | Taxpayer GSTIN | ||||
| stmt_period_2b | EDC_IN_STMT_PERIOD_2B | 2B Statement Period | ||||
| ret_period | EDOC_IN_REP_PERIOD | Reporting Period | ||||
| cp_gstin | EDOC_IN_CTIN | Counterparty GSTIN | ||||
| doc_section | EDC_IN_DOC_SECTION_R2 | GSTR Doc Sec | ||||
| note_type | EDC_IN_NOTE_TYPE | Cr or Dr Note Type | ||||
| total_doc_count | EDC_IN_TOTAL_DOC_COUNT | Total Documents | ||||
| taxable_amount | EDC_IN_TAXABLE_AMOUNT | Taxable Amount | ||||
| cgst_amount | EDC_IN_CGST_AMOUNT | CGST Amount | ||||
| sgst_amount | EDC_IN_SGST_AMOUNT | SGST Amount | ||||
| igst_amount | EDC_IN_IGST_AMOUNT | IGST Amount | ||||
| cess_amount | EDC_IN_CESS_AMOUNT | CESS Amount | ||||
| currency_code | EDOC_IN_CURRENCY_CODE | Currency Code |
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.
-- Counterparty summary table for GSTR2B from tax authority
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE EDCINR2BCPSMMRY (
MANDT, -- Client [MANDT]
RECORD_GUID, -- Record GUID [EDC_RECORD_GUID]
TP_GSTIN, -- Taxpayer GSTIN [EDC_IN_TAX_PAYER_GSTIN]
STMT_PERIOD_2B, -- 2B Statement Period [EDC_IN_STMT_PERIOD_2B]
RET_PERIOD, -- Reporting Period [EDOC_IN_REP_PERIOD]
CP_GSTIN, -- Counterparty GSTIN [EDOC_IN_CTIN]
DOC_SECTION, -- GSTR Doc Sec [EDC_IN_DOC_SECTION_R2]
NOTE_TYPE, -- Cr or Dr Note Type [EDC_IN_NOTE_TYPE]
TOTAL_DOC_COUNT, -- Total Documents [EDC_IN_TOTAL_DOC_COUNT]
TAXABLE_AMOUNT, -- Taxable Amount [EDC_IN_TAXABLE_AMOUNT]
CGST_AMOUNT, -- CGST Amount [EDC_IN_CGST_AMOUNT]
SGST_AMOUNT, -- SGST Amount [EDC_IN_SGST_AMOUNT]
IGST_AMOUNT, -- IGST Amount [EDC_IN_IGST_AMOUNT]
CESS_AMOUNT, -- CESS Amount [EDC_IN_CESS_AMOUNT]
CURRENCY_CODE, -- Currency Code [EDOC_IN_CURRENCY_CODE]
PRIMARY KEY (MANDT, RECORD_GUID)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA