1. Home
  2. Resources
  3. SAP Tables
  4. NWAN - IS-H: Bad Debt Parties

SAP Table NWAN

IS-H: Bad Debt Parties

NWAN (IS-H: Bad Debt Parties) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link NWAN to other SAP tables.

NWAN table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
WANNR IS-H: Number of Bad Debt Party WAND_NR CHAR 5 0
GSCHL IS-H: Sex Indicator - Internal GSCHL CHAR 1 0
1 male
2 female
3 unknown
NNAME Last Name of Bad Debt Party NNAME_WAN CHAR 30 0
NNAMS IS-H: Standardized Last Name NNAMES_PAT CHAR 30 0
VNAME First Name of Bad Debt Party VNAME_WAN CHAR 30 0
VNAMS Standardized First Name VNAMES_PAT CHAR 30 0
GBDAT IS-H: Birthdate RI_GBDAT DATS 8 0
GBNAM IS-H: Birthname GBNAM CHAR 30 0
GBNAS IS-H: Standardized Birthname GBNAMS_PAT CHAR 30 0
NATIO IS-H: Nationality RI_NATIO T005 CHAR 3 0
LAND IS-H: Country of bad debt party's place of residence LAND_WAN T005 CHAR 3 0
PSTLZ IS-H: Postal Code of Bad Debt Party PSTLZ_WAN CHAR 10 0
ORT IS-H: City where Bad Debt Party Resides ORT01_WAN CHAR 25 0
ORT2 IS-H: District of bad debt party ORT02_WAN CHAR 25 0
STRAS IS-H: Street and house number of bad debt party STRAS_WAN CHAR 30 0
KZTXT IS-H: Comment on Bad Debt Party TEXT30_WAN CHAR 30 0
GRUND Reason why Patient Designated as Bed Debt Party GRUND_WAN CHAR 50 0
STORN IS-H: Cancellation Indicator RI_STORN CHAR 1 0
X Yes
NULL No
STUSR IS-H: Name of User who Canceled Data Record STORN_USER CHAR 12 0
STDAT Date of Cancellation STORN_DAT DATS 8 0
ERDAT IS-H: Date when Record Created RI_ERDAT DATS 8 0
ERUSR IS-H: Name of Employee who Created Record RI_ERNAM CHAR 12 0
UPDAT IS-H: Date of Last Change RI_UPDAT DATS 8 0
UPUSR IS-H: Name of Person who Last Changed Data RI_UPNAM CHAR 12 0
PATNR IS-H: Patient Number PATNR CHAR 10 0
EXTNR IS-H: External Patient Identification EXT_PATNR CHAR 20 0

NWAN foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
NWAN LAND NWAN MANDT T005 Countries MANDT
NWAN LAND NWAN LAND T005 Countries LAND1
NWAN MANDT NWAN MANDT T000 Clients MANDT
NWAN NATIO NWAN MANDT T005 Countries MANDT
NWAN NATIO NWAN NATIO T005 Countries LAND1