Fields (39)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| BusinessPartnerName | CorRev_BusinessPartnerName | 1 | |
| CompanyCode | CompanyCode | 2 | |
| CompanyCodeName | CorRev_CompanyCodeName | 1 | |
| CorrectionInvoice | CorrectionInvoice | 5 | |
| CorrectionInvoiceYear | CorrectionInvoiceYear | 5 | |
| CorRevChainLastRevisionDocNmbr | CorRevChainLastRevisionDocNmbr | 1 | |
| CorRevChainLastRevisionDocYear | CorRevChainLastRevisionDocYear | 1 | |
| Invoice | Invoice | 2 | |
| InvoiceYear | InvoiceYear | 2 | |
| IsLastDocumentCorRevChain | IsLastDocumentCorRevChain | 2 | |
| IsRevisionReversed | IsRevisionReversed | 2 | |
| LedgerLineSign | LedgerLineSign | 2 | |
| OriginalInvoiceRevisionDate | OriginalInvoiceRevisionDate | 3 | |
| OriginalInvoiceRevisionNumber | OriginalInvoiceRevisionNumber | 3 | |
| RevisionInvoice | RevisionInvoice | 1 | |
| RevisionInvoiceDate | RevisionInvoiceDate | 3 | |
| RevisionInvoiceYear | RevisionInvoiceYear | 1 | |
| RevisionTaxReportingDate | RevisionTaxReportingDate | 2 | |
| RU_CommissionTradeCustIsNP | CorRev_CommisTradeCustIsNP | 1 | |
| RU_CommissionTradeCustIsOrg | CorRev_CommisTradeCustIsOrg | 1 | |
| RU_CommissionTradeCustomerINN | CorRev_CommisTradeCustomerINN | 1 | |
| RU_CommissionTradeCustomerKPP | CorRev_CommisTradeCustomerKPP | 1 | |
| RU_CommissionTradeCustomerName | CorRev_CommisTradeCustomerName | 1 | |
| RU_CommissionTradeSuplrIsNP | CorRev_CommisTradeSupplIsNP | 1 | |
| RU_CommissionTradeSuplrIsOrg | CorRev_CommisTradeSupplIsOrg | 1 | |
| RU_CommissionTradeSupplierINN | CorRev_CommisTradeSupplierINN | 1 | |
| RU_CommissionTradeSupplierKPP | CorRev_CommisTradeSupplierKPP | 1 | |
| RU_CommissionTradeSupplierName | CorRev_CommisTradeSupplierName | 1 | |
| RU_CompanyCodeINN | CorRev_CompanyCodeINN | 1 | |
| RU_CompanyCodeKPP | CorRev_CompanyCodeKPP | 1 | |
| RU_PartnerOrganizationINN | CorRev_BusinessPartnerINN | 1 | |
| RU_PartnerOrganizationIsNP | CorRev_BusinessPartnerIsNP | 1 | |
| RU_PartnerOrganizationIsOrg | CorRev_BusinessPartnerIsOrg | 1 | |
| RU_PartnerOrganizationKPP | CorRev_BusinessPartnerKPP | 1 | |
| RU_SupplierINN | CorRev_SupplierINN | 1 | |
| RU_SupplierIsNP | CorRev_SupplierIsNP | 1 | |
| RU_SupplierIsOrg | CorRev_SupplierIsOrg | 1 | |
| RU_SupplierKPP | CorRev_SupplierKPP | 1 | |
| SupplierName | CorRev_SupplierName | 1 |
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.
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE VATCORREV (
BUSINESSPARTNERNAME,
COMPANYCODE,
COMPANYCODENAME,
CORRECTIONINVOICE,
CORRECTIONINVOICEYEAR,
CORREVCHAINLASTREVISIONDOCNMBR,
CORREVCHAINLASTREVISIONDOCYEAR,
INVOICE,
INVOICEYEAR,
ISLASTDOCUMENTCORREVCHAIN,
ISREVISIONREVERSED,
LEDGERLINESIGN,
ORIGINALINVOICEREVISIONDATE,
ORIGINALINVOICEREVISIONNUMBER,
REVISIONINVOICE,
REVISIONINVOICEDATE,
REVISIONINVOICEYEAR,
REVISIONTAXREPORTINGDATE,
RU_COMMISSIONTRADECUSTISNP,
RU_COMMISSIONTRADECUSTISORG,
RU_COMMISSIONTRADECUSTOMERINN,
RU_COMMISSIONTRADECUSTOMERKPP,
RU_COMMISSIONTRADECUSTOMERNAME,
RU_COMMISSIONTRADESUPLRISNP,
RU_COMMISSIONTRADESUPLRISORG,
RU_COMMISSIONTRADESUPPLIERINN,
RU_COMMISSIONTRADESUPPLIERKPP,
RU_COMMISSIONTRADESUPPLIERNAME,
RU_COMPANYCODEINN,
RU_COMPANYCODEKPP,
RU_PARTNERORGANIZATIONINN,
RU_PARTNERORGANIZATIONISNP,
RU_PARTNERORGANIZATIONISORG,
RU_PARTNERORGANIZATIONKPP,
RU_SUPPLIERINN,
RU_SUPPLIERISNP,
RU_SUPPLIERISORG,
RU_SUPPLIERKPP,
SUPPLIERNAME
);
Learn More
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- 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