ADRDIF_ST SAP (Street Difference Table for Quarterly Adjustment) Table details

Dictionary Type: Table
Description: Street Difference Table for Quarterly Adjustment




ABAP Code to SELECT data from ADRDIF_ST
Related tables to ADRDIF_ST
Access table ADRDIF_ST




Table field list including key, data, relationships and ABAP select examples

ADRDIF_ST is a standard SAP Table which is used to store Street Difference Table for Quarterly Adjustment data and is available within R/3 SAP systems depending on the version and release level.

The ADRDIF_ST table consists of various fields, each holding specific information or linking keys about Street Difference Table for Quarterly Adjustment data available in SAP. These include CONSNUMBER (Unique Sequential Number for Creating Difference Data), STCODE_OLD (Previous Street Key), HSNHGH_OLD (Previous Upper House Number Range Limit), SUPHGH_OLD (Previous House Number Supplement - Upper Limit).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class: C - Customising table, maintenance only by cust
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified


SAP ADRDIF_ST table fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
CLIENTClient MANDTCLNT3Assigned to domainMANDT
CONSNUMBERUnique Sequential Number for Creating Difference Data ADDIFNMBRNUMC10NUMC10
STCODE_OLDPrevious Street Key ADDIFSTCODCHAR12Assigned to domainALPHASTRT_CODE
HSNHGH_OLDPrevious Upper House Number Range Limit ADDIFHNHGHNUMC10NUMC10
SUPHGH_OLDPrevious House Number Supplement - Upper Limit ADDIFSUPHCHAR4TEXT4
HSNLOW_OLDPrevious Lower House Number Range Limit ADDIFHNLOWNUMC10NUMC10
SUPLOW_OLDPrevious House Number Supplement - Lower Limit ADDIFSUPLCHAR4TEXT4
HSNIND_OLDPrevious House Number Flag (even/odd/all) ADDIFHNINDNUMC1HSN_IND
CTCODE_OLDPrevious City Key ADDIFCTCODCHAR12Assigned to domainALPHACITY_CODE
CTNAME_OLDPrevious City Name ADDIFCTNAMCHAR40TEXT40
STNAME_OLDPrevious Street Name ADDIFSTNAMCHAR60TEXT60
ORIGINRecord Creation Type (Difference Table) ADDIFORIGNCHAR1ADDIFORIGN
LANGULanguage Key SPRASLANG1Assigned to domainISOLASPRASSPRH_T002
CITY_CODECity Code for City/Street File CITY_CODECHAR12Assigned to domainALPHACITY_CODEORTCITYA
CITY_NAMECity AD_CITY1CHAR40TEXT40CLCITYNAME
CITY_EXTCity name extension CITY_EXTCHAR30TEXT30
STATUSProcessing Type of a Data Record in RSADRLSM02 ADR_STATUSCHAR1ADR_STATUS
STRT_CODEStreet Number for City/Street File STRT_CODECHAR12Assigned to domainALPHASTRT_CODESTNSTRTA
STREETStreet AD_STREETCHAR60TEXT60CLSTRTNAME
STREET_SHRLong abbreviation of street name (22 chars) STREET_SHRCHAR22TEXT22
STREET_S15Short abbreviation of street name (15 chars) STREET_S15CHAR15TEXT15
POST_CODEPostal Code POST_CODECHAR10Assigned to domainPOST_CODEPSCPSTC
CITYP_CODEDistrict code for city and street file CITYP_CODECHAR8Assigned to domainALPHACITYP_CODECPRTA
CITY_PARTDistrict AD_CITY2CHAR40TEXT40CITY_PART
HOUSENUM_HHouse number - upper limit (LSM Workbench interface only) AD_LSM_HNHCHAR10TEXT10
HSN_SUPP_HHouse number supplement - upper limit of an interval HSN_SUPP_HCHAR4TEXT4
HOUSENUM_LHouse number - lower limit (LSM Workbench interface only) AD_LSM_HNLCHAR10TEXT10
HSN_SUPP_LHouse number supplement - lower limit of an interval HSN_SUPP_LCHAR4TEXT4
HSN_INDHouse number ID (even/odd/all) HSN_INDNUMC1HSN_IND
COMMU_CODEMunicipality key COMMU_CODECHAR15COMMU_CODE
REGIOGROUPRegional structure grouping REGIOGROUPCHAR8Assigned to domainREGIOGROUP
TAXJURCODETax Jurisdiction AD_TXJCDCHAR15AD_TXJCDTXJ
STRTYPEABStreet type abbreviation STRTYPEABCHAR2Assigned to domainSTRTYPEAB
POSTALAREA(Not Supported) Post Delivery District AD_PSTLARCHAR15TEXT15
MC_STREETStreet name in upper case for search help AD_MC_STRTCHAR25CHAR25

Key field Non-key field



How do I retrieve data from SAP table ADRDIF_ST using ABAP code

The following ABAP code Example will allow you to do a basic selection on ADRDIF_ST to SELECT all data from the table
DATA: WA_ADRDIF_ST TYPE ADRDIF_ST.

SELECT SINGLE *
FROM ADRDIF_ST
INTO CORRESPONDING FIELDS OF WA_ADRDIF_ST
WHERE...

How to access SAP table ADRDIF_ST

Within an ECC or HANA version of SAP you can also view further information about ADRDIF_ST and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!