PURTXITMAGGRGDBYTXCODE

39 Fields

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

Fields (39)

KeyField CDS FieldsUsed in Views
KEY AccountingDocument AccountingDocument 1
KEY CompanyCode CompanyCode 1
KEY FiscalYear FiscalYear 1
_OneTimeAccountBP _OneTimeAccountBP 1
AccountingDocumentHeaderText AccountingDocumentHeaderText 1
AccountingDocumentType AccountingDocumentType 1
AR_Branch AR_Branch 1
AR_OfficialDocumentClass AR_OfficialDocumentClass 1
AR_OfficialDocumentNumber AR_OfficialDocumentNumber 1
AR_OfficialDocumentType AR_OfficialDocumentType 1
AR_PrintCharacter AR_PrintCharacter 1
BusinessPartnerCountry BusinessPartnerCountry 1
BusinessPartnerName BusinessPartnerName 1
ClearingAccountingDocument ClearingAccountingDocument 1
ClearingDate ClearingDate 1
CompanyCodeCountry CompanyCodeCountry 1
CompanyCodeCurrency CompanyCodeCurrency 1
DocumentDate DocumentDate 1
DocumentReferenceID DocumentReferenceID 1
ExchangeRate ExchangeRate 1
ExchangeRateDate ExchangeRateDate 1
FinancialAccountType FinancialAccountType 1
FiscalPeriod FiscalPeriod 1
IsDocumentBOrCAndNotDocType33 IsDocumentBOrCAndNotDocType33 1
IsReversal IsReversal 1
IsReversed IsReversed 1
NetDueDate NetDueDate 1
NmbrOfVATRates NmbrOfVATRates 1
OriginalReferenceDocument OriginalReferenceDocument 1
PostingDate PostingDate 1
ReferenceDocumentType ReferenceDocumentType 1
ReportingCurrency ReportingCurrency 1
ReportingDate ReportingDate 1
ReversalReferenceDocument ReversalReferenceDocument 1
ReverseDocument ReverseDocument 1
Supplier Supplier 1
TaxNumber1 TaxNumber1 1
TaxNumberType TaxNumberType 1
TransactionCurrency TransactionCurrency 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 PURTXITMAGGRGDBYTXCODE (
    ACCOUNTINGDOCUMENT,
    COMPANYCODE,
    FISCALYEAR,
    _ONETIMEACCOUNTBP,
    ACCOUNTINGDOCUMENTHEADERTEXT,
    ACCOUNTINGDOCUMENTTYPE,
    AR_BRANCH,
    AR_OFFICIALDOCUMENTCLASS,
    AR_OFFICIALDOCUMENTNUMBER,
    AR_OFFICIALDOCUMENTTYPE,
    AR_PRINTCHARACTER,
    BUSINESSPARTNERCOUNTRY,
    BUSINESSPARTNERNAME,
    CLEARINGACCOUNTINGDOCUMENT,
    CLEARINGDATE,
    COMPANYCODECOUNTRY,
    COMPANYCODECURRENCY,
    DOCUMENTDATE,
    DOCUMENTREFERENCEID,
    EXCHANGERATE,
    EXCHANGERATEDATE,
    FINANCIALACCOUNTTYPE,
    FISCALPERIOD,
    ISDOCUMENTBORCANDNOTDOCTYPE33,
    ISREVERSAL,
    ISREVERSED,
    NETDUEDATE,
    NMBROFVATRATES,
    ORIGINALREFERENCEDOCUMENT,
    POSTINGDATE,
    REFERENCEDOCUMENTTYPE,
    REPORTINGCURRENCY,
    REPORTINGDATE,
    REVERSALREFERENCEDOCUMENT,
    REVERSEDOCUMENT,
    SUPPLIER,
    TAXNUMBER1,
    TAXNUMBERTYPE,
    TRANSACTIONCURRENCY,
    PRIMARY KEY (ACCOUNTINGDOCUMENT, COMPANYCODE, FISCALYEAR)
);

Learn More