AddressesMD
Archivo SQL de origen: Google Cloud Cortex Data Foundation
Google Cloud Cortex Foudantion - Cortex Reporting - (s4) - AddressesMD
Descripción general
Esta vista es una vista de informes para sistemas SAP que proporciona una vista completa de los datos de dirección. Combina datos de varias tablas para proporcionar una única fuente de verdad para la información de dirección.
Fuentes de datos
| Tabla/vista de origen | Descripción |
|---|---|
| ADRC | Datos de cabecera de dirección |
| ADRCT | Texto de dirección |
| ADR6 | Datos de comunicación para dirección |
| ADRT | Datos de comunicación para dirección |
Casos de uso clave
- Se puede utilizar para recuperar información de dirección para un cliente o socio comercial específico.
- Se puede utilizar para generar etiquetas de correo u otra correspondencia.
- Se puede utilizar para analizar datos de dirección para identificar tendencias o patrones.
Lógica de consulta
La vista utiliza una combinación de uniones internas y uniones externas izquierdas para combinar datos de las tablas ADRC, ADRCT, ADR6 y ADRT. La vista filtra los datos para incluir solo direcciones que tengan un valor date_to de '9999-12-31', lo que indica que la dirección aún es válida.
Posible relación con SAP Transactions
| Codigo de transacción | Descripción de la transacción |
|---|---|
| XD01 | Crear cliente |
| XD02 | Cambiar cliente |
| XD03 | Mostrar cliente |
| BP | Socio comercial |
Linaje de datos
Em desarollo
Campos de tabla/vista
| Campo | Descripción del campo | Descripción del Diccionario 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) |