P_HU_AUDITREPORT

CDS View
17 Fields 3 CDS Views

P_HU_AUDITREPORT is a CDS View in S/4HANA. It contains 17 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
P_HU_MM_AuditReport view from COMPOSITE
P_HU_MMInvoiceConsignment view from COMPOSITE
P_HU_SD_AuditReport view from COMPOSITE

Fields (17)

KeyField CDS FieldsUsed in Views
KEY AccountingDocument AccountingDocument,OriginalReferenceDocument 3
KEY CompanyCode CompanyCode 3
KEY TaxCode TaxCode 3
AccountingDocumentItem AccountingDocumentItem 3
AuthorizationGroup AuthorizationGroup 1
CompanyCodeCurrency CompanyCodeCurrency 3
DocumentCurrency DocumentCurrency 3
DocumentDate DocumentDate 3
FiscalYear FiscalYear 1
OriginalReferenceDocument DocumentNumber 1
PostingDate PostingDate 3
ReferenceDocument ReferenceDocument 1
ReferenceDocumentType ReferenceDocumentType 3
TaxAmountInCoCodeCrcy TaxAmountInCoCodeCrcy 1
TaxBaseAmountInCoCodeCrcy NetPriceAmount,TaxBaseAmountInCoCodeCrcy 3
TaxBaseAmountInTransCrcy NetPriceAmount 1
TaxRate TaxRate 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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_HU_AUDITREPORT (
    ACCOUNTINGDOCUMENT,
    COMPANYCODE,
    TAXCODE,
    ACCOUNTINGDOCUMENTITEM,
    AUTHORIZATIONGROUP,
    COMPANYCODECURRENCY,
    DOCUMENTCURRENCY,
    DOCUMENTDATE,
    FISCALYEAR,
    ORIGINALREFERENCEDOCUMENT,
    POSTINGDATE,
    REFERENCEDOCUMENT,
    REFERENCEDOCUMENTTYPE,
    TAXAMOUNTINCOCODECRCY,
    TAXBASEAMOUNTINCOCODECRCY,
    TAXBASEAMOUNTINTRANSCRCY,
    TAXRATE,
    PRIMARY KEY (ACCOUNTINGDOCUMENT, COMPANYCODE, TAXCODE)
);

Learn More