AGGREGATEDITEM

54 Fields

AGGREGATEDITEM is an SAP database table in S/4HANA. It contains 54 fields.

Fields (54)

KeyField CDS FieldsUsed in Views
KEY AccountingDocument AccountingDocument 1
KEY AccountingDocumentItem AccountingDocumentItem 1
KEY CO_DIANReportFormat CO_DIANReportFormat 1
KEY CO_DIANReportItemType CO_DIANReportItemType 1
KEY CompanyCode CompanyCode 1
KEY FiscalYear FiscalYear 1
KEY ReportedTaxNumber ReportedTaxNumber 1
KEY StatryRptCategory StatryRptCategory 1
KEY StatryRptgEntity StatryRptgEntity 1
KEY StatryRptRunID StatryRptRunID 1
AccountingDocumentType AccountingDocumentType 1
AdditionalLastName AdditionalLastName 1
BusinessPartner BusinessPartner 1
BusinessPartnerCategory BusinessPartnerCategory 1
BusinessPartnerCountry BusinessPartnerCountry 1
BusinessPlace BusinessPlace 1
CityName CityName 1
CO_DIANBPTaxLongNumber CO_DIANBPTaxLongNumber 1
CO_DIANCountry CO_DIANCountry 1
CO_DIANTaxNumberType CO_DIANTaxNumberType 1
CO_TknWhldgCREEAmtInRptgCrcy CO_TknWhldgCREEAmtInRptgCrcy 1
CO_WhldgCREEAmtInRptgCurrency CO_WhldgCREEAmtInRptgCurrency 1
CreationUTCDateTime CreationUTCDateTime 1
Customer Customer 1
DcblGLAcctPaytsAmtInRptgCrcy DcblGLAcctPaytsAmtInRptgCrcy 1
DcblVATIncrdCostInRptgCrcy DcblVATIncrdCostInRptgCrcy 1
FirstName FirstName 1
IsNaturalPerson IsNaturalPerson 1
LastName LastName 1
MiddleName MiddleName 1
NonDcblGLAcctPaytAmtInRptgCrcy NonDcblGLAcctPaytAmtInRptgCrcy 1
NonDcblVATIncrdCostInRptgCrcy NonDcblVATIncrdCostInRptgCrcy 1
OrganizationBPName1 OrganizationBPName1 1
OrganizationBPName2 OrganizationBPName2 1
OrganizationBPName3 OrganizationBPName3 1
OrganizationBPName4 OrganizationBPName4 1
PostingDate PostingDate 1
PurchasingDocument PurchasingDocument 1
Reference1IDByBusinessPartner Reference1IDByBusinessPartner 1
Reference3IDByBusinessPartner Reference3IDByBusinessPartner 1
ReportingCurrency ReportingCurrency 1
Supplier Supplier 1
TakenWhldgTaxIncAmtInRptgCrcy TakenWhldgTaxIncAmtInRptgCrcy 1
TaxNumber1 TaxNumber1 1
TaxNumber2 TaxNumber2 1
TaxNumber3 TaxNumber3 1
TaxNumber4 TaxNumber4 1
TaxNumber5 TaxNumber5 1
TaxNumberType TaxNumberType 1
TknWhldgSimpfdVATAmtInRptgCrcy TknWhldgSimpfdVATAmtInRptgCrcy 1
VATRegistration VATRegistration 1
WhldgTaxCommonVATAmtInRptgCrcy WhldgTaxCommonVATAmtInRptgCrcy 1
WhldgTxForeignVATAmtInRptgCrcy WhldgTxForeignVATAmtInRptgCrcy 1
WhldgTxIncAmtInRptgCurrency WhldgTxIncAmtInRptgCurrency 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 AGGREGATEDITEM (
    ACCOUNTINGDOCUMENT,
    ACCOUNTINGDOCUMENTITEM,
    CO_DIANREPORTFORMAT,
    CO_DIANREPORTITEMTYPE,
    COMPANYCODE,
    FISCALYEAR,
    REPORTEDTAXNUMBER,
    STATRYRPTCATEGORY,
    STATRYRPTGENTITY,
    STATRYRPTRUNID,
    ACCOUNTINGDOCUMENTTYPE,
    ADDITIONALLASTNAME,
    BUSINESSPARTNER,
    BUSINESSPARTNERCATEGORY,
    BUSINESSPARTNERCOUNTRY,
    BUSINESSPLACE,
    CITYNAME,
    CO_DIANBPTAXLONGNUMBER,
    CO_DIANCOUNTRY,
    CO_DIANTAXNUMBERTYPE,
    CO_TKNWHLDGCREEAMTINRPTGCRCY,
    CO_WHLDGCREEAMTINRPTGCURRENCY,
    CREATIONUTCDATETIME,
    CUSTOMER,
    DCBLGLACCTPAYTSAMTINRPTGCRCY,
    DCBLVATINCRDCOSTINRPTGCRCY,
    FIRSTNAME,
    ISNATURALPERSON,
    LASTNAME,
    MIDDLENAME,
    NONDCBLGLACCTPAYTAMTINRPTGCRCY,
    NONDCBLVATINCRDCOSTINRPTGCRCY,
    ORGANIZATIONBPNAME1,
    ORGANIZATIONBPNAME2,
    ORGANIZATIONBPNAME3,
    ORGANIZATIONBPNAME4,
    POSTINGDATE,
    PURCHASINGDOCUMENT,
    REFERENCE1IDBYBUSINESSPARTNER,
    REFERENCE3IDBYBUSINESSPARTNER,
    REPORTINGCURRENCY,
    SUPPLIER,
    TAKENWHLDGTAXINCAMTINRPTGCRCY,
    TAXNUMBER1,
    TAXNUMBER2,
    TAXNUMBER3,
    TAXNUMBER4,
    TAXNUMBER5,
    TAXNUMBERTYPE,
    TKNWHLDGSIMPFDVATAMTINRPTGCRCY,
    VATREGISTRATION,
    WHLDGTAXCOMMONVATAMTINRPTGCRCY,
    WHLDGTXFOREIGNVATAMTINRPTGCRCY,
    WHLDGTXINCAMTINRPTGCURRENCY,
    PRIMARY KEY (ACCOUNTINGDOCUMENT, ACCOUNTINGDOCUMENTITEM, CO_DIANREPORTFORMAT, CO_DIANREPORTITEMTYPE, COMPANYCODE, FISCALYEAR, REPORTEDTAXNUMBER, STATRYRPTCATEGORY, STATRYRPTGENTITY, STATRYRPTRUNID)
);

Learn More