AGGREGATEDENTRIES

38 Fields

AGGREGATEDENTRIES is an SAP database table in S/4HANA. It contains 38 fields.

Fields (38)

KeyField CDS FieldsUsed in Views
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
_CompanyCode _CompanyCode 1
_CompanyCodeCountryMapping _CompanyCodeCountryMapping 1
AdditionalLastName AdditionalLastName 1
BusinessPartner BusinessPartner 1
BusinessPartnerCategory BusinessPartnerCategory 1
BusinessPartnerCountry BusinessPartnerCountry 1
BusinessPlace BusinessPlace 1
CityCode CityCode 1
CityName CityName 1
CO_DIANCountry CO_DIANCountry 1
CO_DIANTaxNumberType CO_DIANTaxNumberType 1
CompanyCodeCountry CompanyCodeCountry 1
FirstName FirstName 1
IsNaturalPerson IsNaturalPerson 1
LastName LastName 1
MiddleName MiddleName 1
OrganizationBPName1 OrganizationBPName1 1
OrganizationBPName2 OrganizationBPName2 1
OrganizationBPName3 OrganizationBPName3 1
OrganizationBPName4 OrganizationBPName4 1
Region Region 1
ReportingCurrency ReportingCurrency 1
StreetName StreetName 1
TaxNumber1 TaxNumber1 1
TaxNumber2 TaxNumber2 1
TaxNumber3 TaxNumber3 1
TaxNumber4 TaxNumber4 1
TaxNumber5 TaxNumber5 1
TaxNumberType TaxNumberType 1
VATRegistration VATRegistration 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 AGGREGATEDENTRIES (
    CO_DIANREPORTFORMAT,
    CO_DIANREPORTITEMTYPE,
    COMPANYCODE,
    FISCALYEAR,
    REPORTEDTAXNUMBER,
    STATRYRPTCATEGORY,
    STATRYRPTGENTITY,
    STATRYRPTRUNID,
    _COMPANYCODE,
    _COMPANYCODECOUNTRYMAPPING,
    ADDITIONALLASTNAME,
    BUSINESSPARTNER,
    BUSINESSPARTNERCATEGORY,
    BUSINESSPARTNERCOUNTRY,
    BUSINESSPLACE,
    CITYCODE,
    CITYNAME,
    CO_DIANCOUNTRY,
    CO_DIANTAXNUMBERTYPE,
    COMPANYCODECOUNTRY,
    FIRSTNAME,
    ISNATURALPERSON,
    LASTNAME,
    MIDDLENAME,
    ORGANIZATIONBPNAME1,
    ORGANIZATIONBPNAME2,
    ORGANIZATIONBPNAME3,
    ORGANIZATIONBPNAME4,
    REGION,
    REPORTINGCURRENCY,
    STREETNAME,
    TAXNUMBER1,
    TAXNUMBER2,
    TAXNUMBER3,
    TAXNUMBER4,
    TAXNUMBER5,
    TAXNUMBERTYPE,
    VATREGISTRATION,
    PRIMARY KEY (CO_DIANREPORTFORMAT, CO_DIANREPORTITEMTYPE, COMPANYCODE, FISCALYEAR, REPORTEDTAXNUMBER, STATRYRPTCATEGORY, STATRYRPTGENTITY, STATRYRPTRUNID)
);

Learn More