AddressesMD
Arquivo SQL de origem - Google Cloud Cortex Data Foundation
Google Cloud Cortex Foudantion - Cortex Reporting - (s4) - AddressesMD
Visão geral
Esta visão é uma visão de relatórios para sistemas SAP que fornece uma visão abrangente dos dados de endereço. Ele combina dados de várias tabelas para fornecer uma única fonte de verdade para informações de endereço.
Fontes de Dados
| Tabela/Visão | Descrição |
|---|---|
| ADRC | Dados do cabeçalho do endereço |
| ADRCT | Texto do endereço |
| ADR6 | Dados de comunicação para endereço |
| ADRT | Dados de comunicação para endereço |
Casos de Uso
- Pode ser usado para recuperar informações de endereço para um cliente ou parceiro de negócios específico.
- Pode ser usado para gerar etiquetas de correspondência ou outra correspondência.
- Pode ser usado para analisar dados de endereço para identificar tendências ou padrões.
Lógica da Query
A visão usa uma combinação de junções internas e junções externas esquerdas para combinar dados das tabelas ADRC, ADRCT, ADR6 e ADRT. A visão filtra os dados para incluir apenas endereços que tenham um valor date_to de '9999-12-31', o que indica que o endereço ainda é válido.
Possível relação com transações SAP
| Código da Transação | Descrição da Transação |
|---|---|
| XD01 | Criar cliente |
| XD02 | Alterar cliente |
| XD03 | Exibir cliente |
| BP | Parceiro de negócios |
Linhagem de dados
Em desenvolvimento
Campos da Tabela/Visão
| Campo | Descrição do Campo | Descrição no Dicionário SAP (Em breve) |
|---|---|---|
| Client | Client number | |
| AddressNumber_ADDRNUMBER | Address number | |
| ValidFromDATE_FROM | Valid from date | |
| VersionIdForInternationalAddresses_NATION | Version ID for international addresses | |
| ValidToDate_DATE_TO | Valid to date | |
| FormOfAddressKey_TITLE | Form of address key | |
| Name1_NAME1 | Name 1 | |
| Name2_NAME2 | Name 2 | |
| Name3_NAME3 | Name 3 | |
| Name4_NAME4 | Name 4 | |
| ConvertedNameField__withFormOfAddress___NAME_TEXT | Converted name field with form of address | |
| CoName_NAME_CO | Company name | |
| City_CITY1 | City | |
| District_CITY2 | District | |
| CityCodeForCitystreetFile_CITY_CODE | City code for city street file | |
| DistrictCodeForCityAndStreetFile_CITYP_CODE | District code for city and street file | |
| City__differentFromPostalCity___HOME_CITY | City different from postal city | |
| DifferentCityForCitystreetFile_CITYH_CODE | Different city for city street file | |
| CityFileTestStatus_CHCKSTATUS | City file test status | |
| RegionalStructureGrouping_REGIOGROUP | Regional structure grouping | |
| CityPostalCode_POST_CODE1 | City postal code | |
| PoBoxPostalCode_POST_CODE2 | PO box postal code | |
| CompanyPostalCode__forLargeCustomers___POST_CODE3 | Company postal code for large customers | |
| cityPostalCodeExtension_PCODE1_EXT | City postal code extension | |
| PoBoxPostalCodeExtension_PCODE2_EXT | PO box postal code extension | |
| PoBox_PO_BOX | PO box | |
| PoBoxAddressUndeliverableFlag_DONT_USE_P | PO box address undeliverable flag | |
| Flag_PoBoxWithoutNumber_PO_BOX_NUM | Flag: PO box without number | |
| PoBoxCity_PO_BOX_LOC | PO box city | |
| CityPoBoxCode__cityFile___CITY_CODE2 | City PO box code (city file) | |
| RegionForPoBox_PO_BOX_REG | Region for PO box | |
| PoBoxCountry_PO_BOX_CTY | PO box country | |
| TransportationZoneToOrFromWhichTheGoodsAreDelivered_TRANSPZONE | Transportation zone to or from which the goods are delivered | |
| Street_STREET | Street | |
| StreetAddressUndeliverableFlag_DONT_USE_S | Street address undeliverable flag | |
| StreetNumberForCitystreetFile_STREETCODE | Street number for city street file | |
| HouseNumber_HOUSE_NUM1 | House number | |
| HouseNumberSupplement_HOUSE_NUM2 | House number supplement | |
| Street2_STR_SUPPL1 | Street 2 | |
| Street3_STR_SUPPL2 | Street 3 | |
| Street4_STR_SUPPL3 | Street 4 | |
| Street5_LOCATION | Street 5 | |
| Building__numberOrCode___BUILDING | Building (number or code) | |
| FloorInBuilding_FLOOR | Floor in building | |
| RoomOrAppartmentNumber_ROOMNUMBER | Room or appartment number | |
| CountryKey_COUNTRY | Country key | |
| Language_LANGU | Language | |
| Region_REGION | Region | |
| AddressGroup__key_businessAddressServicesADDR_GROUP | Address group (key) (business address services) | |
| Flag_ThereAreMoreAddressGroupAssignments_FLAGGROUPS | Flag: There are more address group assignments | |
| Flag_ThisIsAPersonalAddress_PERS_ADDR | Flag: This is a personal address | |
| SearchTerm1_SORT1 | Search term 1 | |
| SearchTerm2_SORT2 | Search term 2 | |
| CommunicationMethod__key_businessAddressServicesDEFLT_COMM | Communication method (key) (business address services) | |
| FirstTelephone_TEL_NUMBER | First telephone | |
| FirstExtension_TEL_EXTENS | First extension | |
| FirstFaxNor_FAX_NUMBER | First fax nor | |
| FirstFax_FAX_EXTENS | First fax | |
| Flag_TelephoneNumber__s__Defined_FLAGCOMM2 | Flag: Telephone number(s) defined | |
| Flag_FaxNumber__s__Defined_FLAGCOMM3 | Flag: Fax number(s) defined | |
| Flag_TeletexNumber__s__Defined_FLAGCOMM4 | Flag: Teletex number(s) defined | |
| Flag_TelexNumber__s__Defined_FLAGCOMM5 | Flag: Telex number(s) defined | |
| EMailAddressX_FLAGCOMM6 | EMail address X | |
| Flag_Rml__remoteMail__Addresse__s__Defined_FLAGCOMM7 | Flag: Rml (remote mail) addresse(s) defined | |
| Flag_X400FLAGCOMM8 | Flag: X400FLAGCOMM8 | |
| Flag_RfcDestination__s__Defined_FLAGCOMM9 | Flag: Rfc destination(s) defined | |
| Flag_PrinterDefined_FLAGCOMM10 | Flag: Printer defined | |
| Flag_SsfDefined_FLAGCOMM11 | Flag: Ssf defined | |
| Flag_UriftpAddressDefined_FLAGCOMM12 | Flag: Uriftp address defined | |
| Flag_PagerAddressDefined_FLAGCOMM13 | Flag: Pager address defined | |
| Name__fieldName1__InUppercaseForSearchHelp_MC_NAME1 | Name (field name 1) in uppercase for search help | |
| CityNameInUppercaseForSearchHelp_MC_CITY1 | City name in uppercase for search help | |
| StreetNameInUppercaseForSearchHelp_MC_STREET | Street name in uppercase for search help | |
| AddressTimeZone_TIME_ZONE | Address time zone | |
| TaxJurisdiction_TAXJURCODE | Tax jurisdiction | |
| AddressRecordCreationOriginalLanguage_LANGU_CREA | Address record creation original language | |
| UuidUsedInTheAddress_ADRC_UUID | Uuid used in the address | |
| Indicator_UuidCreatedLater_UUID_BELATED | Indicator: Uuid created later | |
| CategoryOfAnAddressId_ID_CATEGORY | Category of an address ID | |
| ErrorStatusOfAddress_ADRC_ERR_STATUS | Error status of address | |
| PoBoxLobby_PO_BOX_LOBBY | PO box lobby | |
| TypeOfDeliveryService_DELI_SERV_TYPE | Type of delivery service | |
| NumberOfDeliveryService_DELI_SERV_NUMBER | Number of delivery service | |
| CountyCodeForCounty_COUNTY_CODE | County code for county | |
| County_COUNTY | County | |
| TownshipCodeForTownship_TOWNSHIP_CODE | Township code for township | |
| Township_TOWNSHIP | Township | |
| CountyNameInUpperCaseForSearchHelp_MC_COUNTY | County name in upper case for search help | |
| TownshipNameInUpperCaseForSearchHelp_MC_TOWNSHIP | Township name in upper case for search help | |
| BusinessPurposeCompletedFlag_XPCPT | Business purpose completed flag | |
| ValidFrom_DATE_FROM | Valid from | |
| VersionInternationalAddresses_NATION | Version international addresses | |
| AddressNotes_REMARK | Address notes | |
| PersonNumber_PERSNUMBER | Person number | |
| CommunicationMethod__key_businessAddressServicesCOMM_TYPE | Communication method (key) (business address services) | |
| ValidFromDate_DATE_FROM | Valid from date | |
| SequenceNumber_CONSNUMBER | Sequence number | |
| CommunicationLinkNotes_REMARK | Communication link notes | |
| Flag_ThisAddressIsTheDefaultAddress_FLGDEFAULT | Flag: This address is the default address | |
| Flag_ThisCommunicationNumberIsNotUsed_FLG_NOUSE | Flag: This communication number is not used | |
| RecipientAddressInThisCommunicationType__mailSys_HOME_FLAG | Recipient address in this communication type (mail sys) | |
| EMailAddress_SMTP_ADDR | EMail address | |
| EMailAddressSearchField_SMTP_SRCH | EMail address search field | |
| Flag_RecipientIsStandardRecipientForThisAddress_DFT_RECEIV | Flag: Recipient is standard recipient for this address | |
| Flag_ConnectedToAnSapSystem_R3_USER | Flag: Connected to an SAP system | |
| RequiredDataEncoding__eMail___ENCODE | Required data encoding (eMail) | |
| Flag_ReceiverCanReceiveTnefEncodingBySmtp_TNEF | Flag: Receiver can receive Tnef encoding by Smtp | |
| CommunicationData_ValidFrom__yyyymmddhhmmss___VALID_FROM | Communication data valid from (yyyymmddhhmmss) | |
| CommunicationData_ValidTo__yyyymmddhhmmss___VALID_TO | Communication data valid to (yyyymmddhhmmss) |