ADDRESS
ADDRESS is an SAP database table in S/4HANA. It contains 157 fields.
Fields (157)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | AccountingDocument | AccountingDocument | 2 |
| KEY | AddressID | AddressID | 3 |
| KEY | CompanyCode | CompanyCode | 2 |
| KEY | FiscalYear | FiscalYear | 2 |
| KEY | TaxBox | TaxBox | 2 |
| KEY | TaxBoxStructureType | TaxBoxStructureType | 2 |
| KEY | TaxBoxStrucValidityStartDate | TaxBoxStrucValidityStartDate | 2 |
| KEY | TaxCode | TaxCode | 2 |
| KEY | TaxDeclnAmountType | TaxDeclnAmountType | 2 |
| KEY | TaxGroup | TaxGroup | 2 |
| KEY | TaxItem | TaxItem | 2 |
| KEY | TaxItemGroupingVersion | TaxItemGroupingVersion | 2 |
| KEY | TransactionTypeDetermination | TransactionTypeDetermination | 2 |
| _AddressObjectType | _AddressObjectType | 1 | |
| _AddressPersonName | _AddressPersonName | 1 | |
| _AddressRepresentationCode | _AddressRepresentationCode | 1 | |
| _CorrespondenceLanguage | _CorrespondenceLanguage | 1 | |
| _Country | _Country | 1 | |
| _CurrentDfltEmailAddress | _CurrentDfltEmailAddress | 1 | |
| _CurrentDfltFaxNumber | _CurrentDfltFaxNumber | 1 | |
| _CurrentDfltLandlinePhoneNmbr | _CurrentDfltLandlinePhoneNmbr | 1 | |
| _CurrentDfltMobilePhoneNumber | _CurrentDfltMobilePhoneNumber | 1 | |
| _DeliveryServiceTypeCode | _DeliveryServiceTypeCode | 1 | |
| _EmailAddress | _EmailAddress | 1 | |
| _FaxNumber | _FaxNumber | 1 | |
| _FormOfAddress | _FormOfAddress | 1 | |
| _MainWebsiteURL | _MainWebsiteURL | 1 | |
| _PhoneNumber | _PhoneNumber | 1 | |
| _POBoxAddrNonDeliverableReason | _POBoxAddrNonDeliverableReason | 1 | |
| _POBoxDeviatingCountry | _POBoxDeviatingCountry | 1 | |
| _POBoxDeviatingRegion | _POBoxDeviatingRegion | 1 | |
| _PrfrdCommMediumType | _PrfrdCommMediumType | 1 | |
| _StreetAddrNonDeliverableRsn | _StreetAddrNonDeliverableRsn | 1 | |
| _TaxTypeText | _TaxTypeText | 1 | |
| _TimeZone | _TimeZone | 1 | |
| _TransportationZone | _TransportationZone | 1 | |
| _UniformResourceIdentifier | _UniformResourceIdentifier | 1 | |
| AccountingDocumentHeaderText | AccountingDocumentHeaderText | 2 | |
| AccountingDocumentType | AccountingDocumentType | 2 | |
| AdditionalCurrency1 | AdditionalCurrency1 | 2 | |
| AdditionalCurrency2 | AdditionalCurrency2 | 2 | |
| AdditionalStreetPrefixName | AdditionalStreetPrefixName | 3 | |
| AddresseeFullName | AddresseeFullName | 1 | |
| AddresseeName1 | BusinessPartnerName1 | 1 | |
| AddresseeName2 | BusinessPartnerName2 | 1 | |
| AddressObjectType | AddressObjectType | 1 | |
| AddressPersonID | AddressPersonID | 1 | |
| AddressRepresentationCode | AddressRepresentationCode | 5 | |
| AddressSearchTerm1 | AddressSearchTerm1 | 1 | |
| AddressSearchTerm2 | AddressSearchTerm2 | 1 | |
| AddressTimeZone | AddressTimeZone | 1 | |
| AmountInAdditionalCurrency1 | AmountInAdditionalCurrency1 | 2 | |
| AmountInAdditionalCurrency2 | AmountInAdditionalCurrency2 | 2 | |
| AmountInReportingCurrency | AmountInReportingCurrency | 2 | |
| AmountInTransactionCurrency | AmountInTransactionCurrency | 2 | |
| Building | Building,house_number | 11 | |
| BusinessPartner | BusinessPartner | 2 | |
| BusinessPartnerCountry | BusinessPartnerCountry | 2 | |
| BusinessPartnerName | BusinessPartnerName | 1 | |
| BusinessPartnerUUID | BusinessPartnerUUID | 1 | |
| BusinessPlace | BusinessPlace | 2 | |
| BusinessPlaceName | BusinessPlaceName | 1 | |
| CareOfName | CareOfName | 2 | |
| city | city | 2 | |
| CityName | CityName | 11 | |
| ClearingJournalEntry | ClearingJournalEntry | 2 | |
| ClearingJournalEntryFiscalYear | ClearingJournalEntryFiscalYear | 2 | |
| CompanyCodeCountry | CompanyCodeCountry | 2 | |
| CompanyCodeCurrency | CompanyCodeCurrency | 2 | |
| CompanyPostalCode | CompanyPostalCode | 1 | |
| CorrespondenceLanguage | CorrespondenceLanguage | 1 | |
| Country | address_country,Country | 8 | |
| CountryCurrency | CountryCurrency | 2 | |
| CountryName | CountryName | 1 | |
| CustomerSupplierAddress | CustomerSupplierAddress | 2 | |
| DefaultEmailAddress | DefaultEmailAddress | 1 | |
| DeliveryServiceNumber | DeliveryServiceNumber | 1 | |
| DeliveryServiceTypeCode | DeliveryServiceTypeCode | 1 | |
| District | District | 3 | |
| DistrictName | DistrictName | 1 | |
| DocumentCurrency | DocumentCurrency | 2 | |
| DocumentDate | DocumentDate | 2 | |
| DocumentReferenceID | DocumentReferenceID | 2 | |
| FiscalPeriod | FiscalPeriod | 2 | |
| Floor | Floor | 4 | |
| FormOfAddress | FormOfAddress | 1 | |
| GLAccount | GLAccount | 2 | |
| HomeCityName | HomeCityName | 3 | |
| HouseNumber | HouseNumber | 10 | |
| HouseNumberSupplementText | HouseNumberSupplementText | 1 | |
| IsReversal | IsReversal | 2 | |
| IsReversed | IsReversed | 2 | |
| latitude | address_latitude | 2 | |
| longitude | address_longitude | 2 | |
| LowestLevelTaxJurisdiction | LowestLevelTaxJurisdiction | 2 | |
| OrganizationName1 | OrganizationName1 | 2 | |
| OrganizationName2 | OrganizationName2 | 2 | |
| OrganizationName3 | OrganizationName3 | 2 | |
| OrganizationName4 | OrganizationName4 | 2 | |
| PaymentDate | PaymentDate | 2 | |
| PaymentNote | PaymentNote | 2 | |
| PhoneNumber | PhoneNumber | 2 | |
| POBox | POBox | 1 | |
| POBoxAddrNonDeliverableReason | POBoxAddrNonDeliverableReason | 1 | |
| POBoxDeviatingCityName | POBoxDeviatingCityName | 1 | |
| POBoxDeviatingCountry | POBoxDeviatingCountry | 1 | |
| POBoxDeviatingRegion | POBoxDeviatingRegion | 1 | |
| POBoxIsWithoutNumber | POBoxIsWithoutNumber | 1 | |
| POBoxLobbyName | POBoxLobbyName | 1 | |
| POBoxPostalCode | POBoxPostalCode | 1 | |
| postal_code | postal_code | 2 | |
| PostalCode | PostalCode | 10 | |
| PostingDate | PostingDate | 2 | |
| PrfrdCommMediumType | PrfrdCommMediumType | 1 | |
| Region | Region | 5 | |
| ReportingCountry | ReportingCountry | 2 | |
| ReportingCurrency | ReportingCurrency | 2 | |
| ReportingDate | ReportingDate | 2 | |
| RoomNumber | RoomNumber | 4 | |
| SecondaryRegionName | SecondaryRegionName | 1 | |
| street | street | 2 | |
| StreetAddrNonDeliverableReason | StreetAddrNonDeliverableReason | 1 | |
| StreetName | StreetName | 9 | |
| StreetPrefixName | StreetPrefixName | 3 | |
| StreetPrefixName1 | AdditionalStreetPrefixName,StreetPrefixName,StreetPrefixName1 | 3 | |
| StreetPrefixName2 | StreetPrefixName2 | 1 | |
| StreetSuffixName | StreetSuffixName | 3 | |
| StreetSuffixName1 | StreetSuffixName,StreetSuffixName1 | 2 | |
| StreetSuffixName2 | AdditionalStreetSuffixName,StreetSuffixName2 | 2 | |
| SupplierPaytCurrencyExchRate | SupplierPaytCurrencyExchRate | 2 | |
| TaxAmount | TaxAmount | 2 | |
| TaxAmountInAdditionalCurrency1 | TaxAmountInAdditionalCurrency1 | 2 | |
| TaxAmountInAdditionalCurrency2 | TaxAmountInAdditionalCurrency2 | 2 | |
| TaxAmountInCoCodeCrcy | TaxAmountInCoCodeCrcy | 2 | |
| TaxAmountInRptgCrcy | TaxAmountInRptgCrcy | 2 | |
| TaxBaseAmountInCoCodeCrcy | TaxBaseAmountInCoCodeCrcy | 2 | |
| TaxBaseAmountInRptgCrcy | TaxBaseAmountInRptgCrcy | 2 | |
| TaxBaseAmountInTransCrcy | TaxBaseAmountInTransCrcy | 2 | |
| TaxBaseAmtInAdditionalCrcy1 | TaxBaseAmtInAdditionalCrcy1 | 2 | |
| TaxBaseAmtInAdditionalCrcy2 | TaxBaseAmtInAdditionalCrcy2 | 2 | |
| TaxBoxStructure | TaxBoxStructure | 2 | |
| TaxCalculationProcedure | TaxCalculationProcedure | 2 | |
| TaxIsNotDeductible | TaxIsNotDeductible | 2 | |
| TaxItemGroup | TaxItemGroup | 2 | |
| TaxJurisdiction | TaxJurisdiction | 3 | |
| TaxNumber1 | TaxNumber1 | 2 | |
| TaxNumber2 | TaxNumber2 | 2 | |
| TaxNumber3 | TaxNumber3 | 2 | |
| TaxPayerName | TaxPayerName | 2 | |
| TaxRate | TaxRate | 2 | |
| TaxRateValidityStartDate | TaxRateValidityStartDate | 2 | |
| TaxReportingDate | TaxReportingDate | 2 | |
| TaxType | TaxType | 2 | |
| TertiaryRegionName | TertiaryRegionName | 1 | |
| TransportZone | TransportZone | 1 | |
| ValidityEndDate | ValidityEndDate | 1 | |
| VillageName | VillageName | 1 |