SAP FINS_CFIN_S_AV_ADRC table - Customer Address details in SAP


SAP FINS_CFIN_S_AV_ADRC table summary

Object Name: FINS_CFIN_S_AV_ADRC
Dictionary Type: Structure
Description: Customer Address


Field list for FINS_CFIN_S_AV_ADRC table on an S/4 SAP system

Details
FINS_CFIN_S_AV_ADRC-CLIENT table field - Client

Description: Client
Field Name: CLIENT
Data Element: MANDT
Data Type: CLNT
length (Dec): 3(0)
Check table:
Conversion Routine:
Domain Name: MANDT
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CLIENT

FINS_CFIN_S_AV_ADRC-ADDRNUMBER table field - Address Number

Description: Address Number
Field Name: ADDRNUMBER
Data Element: AD_ADDRNUM
Data Type: CHAR
length (Dec): 10(0)
Check table:
Conversion Routine: ALPHA
Domain Name: AD_ADDRNUM
MemoryID: ADR
AppClass:
SHLP:
SHLP Field:
ConvExit: ALPHA

See all SAP tables containing field ADDRNUMBER

FINS_CFIN_S_AV_ADRC-DATE_FROM table field - Valid-from date - in current Release only 00010101 possible

Description: Valid-from date - in current Release only 00010101 possible
Field Name: DATE_FROM
Data Element: AD_DATE_FR
Data Type: DATS
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: DATUM
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DATE_FROM

FINS_CFIN_S_AV_ADRC-DATE_TO table field - Valid-to date in current Release only 99991231 possible

Description: Valid-to date in current Release only 99991231 possible
Field Name: DATE_TO
Data Element: AD_DATE_TO
Data Type: DATS
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: DATUM
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DATE_TO

FINS_CFIN_S_AV_ADRC-TITLE table field - Form-of-Address Key

Description: Form-of-Address Key
Field Name: TITLE
Data Element: AD_TITLE
Data Type: CHAR
length (Dec): 4(0)
Check table:
Conversion Routine:
Domain Name: AD_TITLE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TITLE

FINS_CFIN_S_AV_ADRC-NAME1 table field - Name 1

Description: Name 1
Field Name: NAME1
Data Element: AD_NAME1
Data Type: CHAR
length (Dec): 40(0)
Check table:
Conversion Routine:
Domain Name: TEXT40
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field NAME1

FINS_CFIN_S_AV_ADRC-NAME2 table field - Name 2

Description: Name 2
Field Name: NAME2
Data Element: AD_NAME2
Data Type: CHAR
length (Dec): 40(0)
Check table:
Conversion Routine:
Domain Name: TEXT40
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field NAME2

FINS_CFIN_S_AV_ADRC-NAME3 table field - Name 3

Description: Name 3
Field Name: NAME3
Data Element: AD_NAME3
Data Type: CHAR
length (Dec): 40(0)
Check table:
Conversion Routine:
Domain Name: TEXT40
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field NAME3

FINS_CFIN_S_AV_ADRC-NAME4 table field - Name 4

Description: Name 4
Field Name: NAME4
Data Element: AD_NAME4
Data Type: CHAR
length (Dec): 40(0)
Check table:
Conversion Routine:
Domain Name: TEXT40
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field NAME4

FINS_CFIN_S_AV_ADRC-NAME_TEXT table field - Converted name field (with form of address)

Description: Converted name field (with form of address)
Field Name: NAME_TEXT
Data Element: AD_NAMETXT
Data Type: CHAR
length (Dec): 50(0)
Check table:
Conversion Routine:
Domain Name: TEXT50
MemoryID:
AppClass: SLG
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field NAME_TEXT

FINS_CFIN_S_AV_ADRC-NAME_CO table field - c/o name

Description: c/o name
Field Name: NAME_CO
Data Element: AD_NAME_CO
Data Type: CHAR
length (Dec): 40(0)
Check table:
Conversion Routine:
Domain Name: TEXT40
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field NAME_CO

FINS_CFIN_S_AV_ADRC-CITY1 table field - City

Description: City
Field Name: CITY1
Data Element: AD_CITY1
Data Type: CHAR
length (Dec): 40(0)
Check table:
Conversion Routine:
Domain Name: TEXT40
MemoryID:
AppClass: SAP
SHLP: CLCITYNAME
SHLP Field: CITY_NAME
ConvExit:

See all SAP tables containing field CITY1

FINS_CFIN_S_AV_ADRC-CITY2 table field - District

Description: District
Field Name: CITY2
Data Element: AD_CITY2
Data Type: CHAR
length (Dec): 40(0)
Check table:
Conversion Routine:
Domain Name: TEXT40
MemoryID:
AppClass: SAP
SHLP: CITY_PART
SHLP Field: CITY_PART
ConvExit:

See all SAP tables containing field CITY2

FINS_CFIN_S_AV_ADRC-CITY_CODE table field - City code for city/street file

Description: City code for city/street file
Field Name: CITY_CODE
Data Element: AD_CITYNUM
Data Type: CHAR
length (Dec): 12(0)
Check table:
Conversion Routine: ALPHA
Domain Name: CITY_CODE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit: ALPHA

See all SAP tables containing field CITY_CODE

FINS_CFIN_S_AV_ADRC-CITYP_CODE table field - District code for City and Street file

Description: District code for City and Street file
Field Name: CITYP_CODE
Data Element: AD_CITYPNM
Data Type: CHAR
length (Dec): 8(0)
Check table:
Conversion Routine: ALPHA
Domain Name: CITYP_CODE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit: ALPHA

See all SAP tables containing field CITYP_CODE

FINS_CFIN_S_AV_ADRC-HOME_CITY table field - City (different from postal city)

Description: City (different from postal city)
Field Name: HOME_CITY
Data Element: AD_CITY3
Data Type: CHAR
length (Dec): 40(0)
Check table:
Conversion Routine:
Domain Name: TEXT40
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field HOME_CITY

FINS_CFIN_S_AV_ADRC-CITYH_CODE table field - Different city for city/street file

Description: Different city for city/street file
Field Name: CITYH_CODE
Data Element: AD_CITYHNM
Data Type: CHAR
length (Dec): 12(0)
Check table:
Conversion Routine: ALPHA
Domain Name: CITY_CODE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit: ALPHA

See all SAP tables containing field CITYH_CODE

FINS_CFIN_S_AV_ADRC-CHCKSTATUS table field - City file test status

Description: City file test status
Field Name: CHCKSTATUS
Data Element: AD_CHECKST
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: AD_CHECKST
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CHCKSTATUS

FINS_CFIN_S_AV_ADRC-REGIOGROUP table field - Regional structure grouping

Description: Regional structure grouping
Field Name: REGIOGROUP
Data Element: REGIOGROUP
Data Type: CHAR
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: REGIOGROUP
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field REGIOGROUP

FINS_CFIN_S_AV_ADRC-POST_CODE1 table field - City postal code

Description: City postal code
Field Name: POST_CODE1
Data Element: AD_PSTCD1
Data Type: CHAR
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: CHAR10
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field POST_CODE1

FINS_CFIN_S_AV_ADRC-PO_BOX table field - PO Box

Description: PO Box
Field Name: PO_BOX
Data Element: AD_POBX
Data Type: CHAR
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: CHAR10
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PO_BOX

FINS_CFIN_S_AV_ADRC-PO_BOX_NUM table field - Flag: PO Box Without Number

Description: Flag: PO Box Without Number
Field Name: PO_BOX_NUM
Data Element: AD_POBXNUM
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: XFELD
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PO_BOX_NUM

FINS_CFIN_S_AV_ADRC-PO_BOX_LOC table field - PO Box city

Description: PO Box city
Field Name: PO_BOX_LOC
Data Element: AD_POBXLOC
Data Type: CHAR
length (Dec): 40(0)
Check table:
Conversion Routine:
Domain Name: TEXT40
MemoryID:
AppClass: SAP
SHLP: CITY_NAME
SHLP Field: CITY_NAME
ConvExit:

See all SAP tables containing field PO_BOX_LOC

FINS_CFIN_S_AV_ADRC-CITY_CODE2 table field - City PO box code (City file)

Description: City PO box code (City file)
Field Name: CITY_CODE2
Data Element: AD_CIT2NUM
Data Type: CHAR
length (Dec): 12(0)
Check table:
Conversion Routine: ALPHA
Domain Name: CITY_CODE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit: ALPHA

See all SAP tables containing field CITY_CODE2

FINS_CFIN_S_AV_ADRC-PO_BOX_REG table field - Region for PO Box (Country/Region, State, Province, ...)

Description: Region for PO Box (Country/Region, State, Province, ...)
Field Name: PO_BOX_REG
Data Element: AD_POBXREG
Data Type: CHAR
length (Dec): 3(0)
Check table:
Conversion Routine:
Domain Name: REGIO
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PO_BOX_REG

FINS_CFIN_S_AV_ADRC-PO_BOX_CTY table field - PO Box of Country/Region

Description: PO Box of Country/Region
Field Name: PO_BOX_CTY
Data Element: AD_POBXCTY
Data Type: CHAR
length (Dec): 3(0)
Check table:
Conversion Routine:
Domain Name: LAND1
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PO_BOX_CTY

FINS_CFIN_S_AV_ADRC-POSTALAREA table field - (Not Supported) Post Delivery District

Description: (Not Supported) Post Delivery District
Field Name: POSTALAREA
Data Element: AD_PSTLAR
Data Type: CHAR
length (Dec): 15(0)
Check table:
Conversion Routine:
Domain Name: TEXT15
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field POSTALAREA

FINS_CFIN_S_AV_ADRC-STREET table field - Street

Description: Street
Field Name: STREET
Data Element: AD_STREET
Data Type: CHAR
length (Dec): 60(0)
Check table:
Conversion Routine:
Domain Name: TEXT60
MemoryID:
AppClass: SAP
SHLP: CLSTRTNAME
SHLP Field: STREET
ConvExit:

See all SAP tables containing field STREET

FINS_CFIN_S_AV_ADRC-STREETCODE table field - Street Number for City/Street File

Description: Street Number for City/Street File
Field Name: STREETCODE
Data Element: AD_STRNUM
Data Type: CHAR
length (Dec): 12(0)
Check table:
Conversion Routine: ALPHA
Domain Name: STRT_CODE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit: ALPHA

See all SAP tables containing field STREETCODE

FINS_CFIN_S_AV_ADRC-HOUSE_NUM1 table field - House Number

Description: House Number
Field Name: HOUSE_NUM1
Data Element: AD_HSNM1
Data Type: CHAR
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: TEXT10
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field HOUSE_NUM1

FINS_CFIN_S_AV_ADRC-STR_SUPPL1 table field - Street 2

Description: Street 2
Field Name: STR_SUPPL1
Data Element: AD_STRSPP1
Data Type: CHAR
length (Dec): 40(0)
Check table:
Conversion Routine:
Domain Name: TEXT40
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field STR_SUPPL1

FINS_CFIN_S_AV_ADRC-COUNTRY table field - Country/Region Key

Description: Country/Region Key
Field Name: COUNTRY
Data Element: LAND1
Data Type: CHAR
length (Dec): 3(0)
Check table:
Conversion Routine:
Domain Name: LAND1
MemoryID: LND
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field COUNTRY

FINS_CFIN_S_AV_ADRC-LANGU table field - Language Key

Description: Language Key
Field Name: LANGU
Data Element: SPRAS
Data Type: LANG
length (Dec): 1(0)
Check table:
Conversion Routine: ISOLA
Domain Name: SPRAS
MemoryID: SPR
AppClass: STXD
SHLP: H_T002
SHLP Field: SPRAS
ConvExit: ISOLA

See all SAP tables containing field LANGU

FINS_CFIN_S_AV_ADRC-REGION table field - Region (State, Province, County)

Description: Region (State, Province, County)
Field Name: REGION
Data Element: REGIO
Data Type: CHAR
length (Dec): 3(0)
Check table:
Conversion Routine:
Domain Name: REGIO
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field REGION

FINS_CFIN_S_AV_ADRC-COUNTY_CODE table field - County code for county

Description: County code for county
Field Name: COUNTY_CODE
Data Element: AD_CNTYNUM
Data Type: CHAR
length (Dec): 8(0)
Check table:
Conversion Routine: ALPHA
Domain Name: CNTY_CODE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit: ALPHA

See all SAP tables containing field COUNTY_CODE

FINS_CFIN_S_AV_ADRC-COUNTY table field - County

Description: County
Field Name: COUNTY
Data Element: AD_COUNTY
Data Type: CHAR
length (Dec): 40(0)
Check table:
Conversion Routine:
Domain Name: TEXT40
MemoryID:
AppClass: SAP
SHLP: CLTCNTYNAME
SHLP Field: COUNTY
ConvExit:

See all SAP tables containing field COUNTY


  



View list of all SAP tables(S4H/ECC)

Select data from SAP table