ADDRESS
ADDRESS is an SAP database table in S/4HANA. It contains 114 fields.
Fields (114)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | AccountingDocument | AccountingDocument | 2 |
| KEY | AddressID | AddressID | 2 |
| KEY | AddressNumber | AddressNumber | 1 |
| KEY | CompanyCode | CompanyCode | 2 |
| KEY | FiscalYear | FiscalYear | 2 |
| KEY | ForceElementOrgID | ForceElementOrgID | 1 |
| KEY | FrcElmntOrgPlanVersion | FrcElmntOrgPlanVersion | 1 |
| KEY | FrcElmntOrgType | FrcElmntOrgType | 1 |
| KEY | NumberOfForceElementOrg | NumberOfForceElementOrg | 1 |
| 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 |
| _AccountingDocument | _AccountingDocument | 2 | |
| _ReceivablesPayablesItem | _ReceivablesPayablesItem | 2 | |
| _TaxCodeText | _TaxCodeText | 1 | |
| _TaxJurisdiction | _TaxJurisdiction | 2 | |
| _TaxTypeText | _TaxTypeText | 2 | |
| AccountingDocumentHeaderText | AccountingDocumentHeaderText | 2 | |
| AccountingDocumentType | AccountingDocumentType | 2 | |
| AdditionalCurrency1 | AdditionalCurrency1 | 2 | |
| AdditionalCurrency2 | AdditionalCurrency2 | 2 | |
| AdditionalStreetPrefixName | AdditionalStreetPrefixName | 3 | |
| AddresseeName1 | BusinessPartnerName1 | 1 | |
| AddresseeName2 | BusinessPartnerName2 | 1 | |
| AddressRepresentationCode | AddressRepresentationCode | 4 | |
| AmountInAdditionalCurrency1 | AmountInAdditionalCurrency1 | 2 | |
| AmountInAdditionalCurrency2 | AmountInAdditionalCurrency2 | 2 | |
| AmountInReportingCurrency | AmountInReportingCurrency | 2 | |
| AmountInTransactionCurrency | AmountInTransactionCurrency | 2 | |
| Building | Building,house_number | 8 | |
| BusinessPartner | BusinessPartner | 2 | |
| BusinessPartnerCountry | BusinessPartnerCountry | 2 | |
| BusinessPartnerName | BusinessPartnerName | 1 | |
| BusinessPartnerUUID | BusinessPartnerUUID | 1 | |
| BusinessPlace | BusinessPlace | 2 | |
| BusinessPlaceName | BusinessPlaceName | 1 | |
| CareOfName | CareOfName | 1 | |
| city | city | 2 | |
| CityName | CityName | 8 | |
| ClearingJournalEntry | ClearingJournalEntry | 2 | |
| ClearingJournalEntryFiscalYear | ClearingJournalEntryFiscalYear | 2 | |
| CompanyCodeCountry | CompanyCodeCountry | 2 | |
| CompanyCodeCurrency | CompanyCodeCurrency | 2 | |
| Country | address_country,Country | 6 | |
| CountryCurrency | CountryCurrency | 2 | |
| CountryName | CountryName | 1 | |
| CustomerSupplierAddress | CustomerSupplierAddress | 2 | |
| DefaultEmailAddress | DefaultEmailAddress | 1 | |
| District | District | 3 | |
| DocumentCurrency | DocumentCurrency | 2 | |
| DocumentDate | DocumentDate | 2 | |
| DocumentReferenceID | DocumentReferenceID | 2 | |
| FiscalPeriod | FiscalPeriod | 2 | |
| Floor | Floor | 3 | |
| FrcElmntOrgInfoType | FrcElmntOrgInfoType | 1 | |
| GLAccount | GLAccount | 2 | |
| HomeCityName | HomeCityName | 3 | |
| HouseNumber | HouseNumber | 6 | |
| 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 | |
| postal_code | postal_code | 2 | |
| PostalCode | PostalCode | 6 | |
| PostingDate | PostingDate | 2 | |
| Region | Region | 2 | |
| ReportingCountry | ReportingCountry | 2 | |
| ReportingCurrency | ReportingCurrency | 2 | |
| ReportingDate | ReportingDate | 2 | |
| RoomNumber | RoomNumber | 3 | |
| street | street | 2 | |
| StreetName | StreetName | 6 | |
| StreetPrefixName | StreetPrefixName | 3 | |
| StreetPrefixName1 | StreetPrefixName | 1 | |
| StreetSuffixName | StreetSuffixName | 3 | |
| 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 | 2 | |
| TaxNumber1 | TaxNumber1 | 2 | |
| TaxNumber2 | TaxNumber2 | 2 | |
| TaxNumber3 | TaxNumber3 | 2 | |
| TaxPayerName | TaxPayerName | 2 | |
| TaxRate | TaxRate | 2 | |
| TaxRateValidityStartDate | TaxRateValidityStartDate | 2 | |
| TaxReportingDate | TaxReportingDate | 2 | |
| TaxType | TaxType | 2 | |
| ValidityEndDate | ValidityEndDate | 1 |