VATCORREV

VATCORREV is an SAP database table in S/4HANA. It contains 39 fields.

Fields (39)

KeyField CDS FieldsUsed 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
);