SAP ABAP Table J11SPA1 (Send Structure for TR-EDT Receiver Structure JBIUPA1), sap-tables.org - The Best Online document for SAP ABAP Tables

SAP ABAP Table `J11SPA1` {Send Structure for TR-EDT Receiver Structure JBIUPA1}

Home

                title {label: "SAP ABAP table J11SPA1 {Send Structure for TR-EDT Receiver Structure JBIUPA1}", size: "20"}

# Entities

[J11SPA1] {bgcolor: "tomato"}
+MANDT {label: "CLNT (3)"}
+PARTNR {label: "CHAR (10)"}
+KUNNR {label: "CHAR (10)"}
+AKONT {label: "CHAR (10)"}
+LAND1 {label: "CHAR (3)"}
+REGIO {label: "CHAR (3)"}
+ADR_REF_K {label: "CHAR (10)"}
+BUKRS {label: "CHAR (4)"}
+ROLE {label: "CHAR (4)"}
+ROLETYP {label: "CHAR (4)"}
+AUTHORITY {label: "CHAR (4)"}
+PROVZ {label: "CHAR (3)"}
+KNRZB {label: "CHAR (10)"}
+ZAHLS {label: "CHAR (1)"}
+REMIT {label: "CHAR (10)"}
+HBKID {label: "CHAR (5)"}
+ZGRUP {label: "CHAR (2)"}
+LOCKB {label: "CHAR (7)"}
+UZAWE {label: "CHAR (2)"}
+GROUP_ID {label: "CHAR (4)"}
+TITLE {label: "NUMC (2)"}
+TITLE_LET {label: "NUMC (2)"}
+ADR_REF {label: "CHAR (10)"}
+VIP {label: "CHAR (1)"}
+GROUP_D {label: "CHAR (4)"}
+ZUAWA {label: "CHAR (3)"}
+FDGRV {label: "CHAR (10)"}
+BLNKZ {label: "CHAR (2)"}
+KNRZE {label: "CHAR (10)"}
+NATION {label: "CHAR (3)"}
+STATE {label: "CHAR (3)"}
+MARITAL_ST {label: "CHAR (1)"}
+PROPRTY_ST {label: "NUMC (2)"}
+STAFF_GRP {label: "CHAR (4)"}
+XUBNAME {label: "CHAR (12)"}
+CALENDARID {label: "CHAR (2)"}
+LEGAL_ENTY {label: "NUMC (2)"}
+LEGAL_ORG {label: "NUMC (2)"}
+CNTRY_COMP {label: "CHAR (3)"}
+IND_SECTOR {label: "CHAR (10)"}
+BANKS {label: "CHAR (3)"}
+ADRNR {label: "CHAR (10)"}
+EMPLOYMENT {label: "NUMC (2)"}
+EMP_SECTOR {label: "CHAR (10)"}
+REL_TYP {label: "CHAR (4)"}
+PARTNR2 {label: "CHAR (10)"}
+DIF_TYP1 {label: "CHAR (4)"}
+DIF_TYP2 {label: "CHAR (4)"}
+RELAT {label: "CHAR (4)"}
+FUNCTN {label: "CHAR (4)"}
+DEPART {label: "CHAR (4)"}
+BEGRU {label: "CHAR (4)"}
+MABER {label: "CHAR (2)"}
+MAHNA {label: "CHAR (4)"}
+MANSP {label: "CHAR (1)"}
+KNRMA {label: "CHAR (10)"}
+BUSAB {label: "CHAR (2)"}
+MGRUP {label: "CHAR (2)"}
+KWG_CRE {label: "NUMC (2)"}
+SZG_AT {label: "CHAR (2)"}

[BP000] {bgcolor: "#d0e0d0"}
*+MANDT {label: "CLNT (3)"}
*PARTNR {label: "CHAR (10)"}

[KNA1] {bgcolor: "#d0e0d0"}
*+MANDT {label: "CLNT (3)"}
*KUNNR {label: "CHAR (10)"}

[SANS1] {bgcolor: "#d0e0d0"}
*+MANDT {label: "CLNT (3)"}
*ADRNR {label: "CHAR (10)"}

[SKA1] {bgcolor: "#d0e0d0"}
*+MANDT {label: "CLNT (3)"}
*+KTOPL {label: "CHAR (4)"}
*SAKNR {label: "CHAR (10)"}

[T000] {bgcolor: "#d0e0d0"}
*MANDT {label: "CLNT (3)"}

[T001] {bgcolor: "#d0e0d0"}
*+MANDT {label: "CLNT (3)"}
*BUKRS {label: "CHAR (4)"}

[T001S] {bgcolor: "#d0e0d0"}
*+MANDT {label: "CLNT (3)"}
*+BUKRS {label: "CHAR (4)"}
*BUSAB {label: "CHAR (2)"}

[T005] {bgcolor: "#d0e0d0"}
*+MANDT {label: "CLNT (3)"}
*LAND1 {label: "CHAR (3)"}

[T005S] {bgcolor: "#d0e0d0"}
*+MANDT {label: "CLNT (3)"}
*+LAND1 {label: "CHAR (3)"}
*BLAND {label: "CHAR (3)"}

[T008] {bgcolor: "#d0e0d0"}
*+MANDT {label: "CLNT (3)"}
*ZAHLS {label: "CHAR (1)"}

[T012] {bgcolor: "#d0e0d0"}
*+MANDT {label: "CLNT (3)"}
*+BUKRS {label: "CHAR (4)"}
*HBKID {label: "CHAR (5)"}

[T035] {bgcolor: "#d0e0d0"}
*+MANDT {label: "CLNT (3)"}
*GRUPP {label: "CHAR (10)"}

[T040S] {bgcolor: "#d0e0d0"}
*+MANDT {label: "CLNT (3)"}
*MANSP {label: "CHAR (1)"}

[T042F] {bgcolor: "#d0e0d0"}
*+MANDT {label: "CLNT (3)"}
*UZAWE {label: "CHAR (2)"}

[T047A] {bgcolor: "#d0e0d0"}
*+MANDT {label: "CLNT (3)"}
*MAHNA {label: "CHAR (4)"}

[T047M] {bgcolor: "#d0e0d0"}
*+MANDT {label: "CLNT (3)"}
*+BUKRS {label: "CHAR (4)"}
*MABER {label: "CHAR (2)"}

[T047R] {bgcolor: "#d0e0d0"}
*+MANDT {label: "CLNT (3)"}
*MGRUP {label: "CHAR (2)"}

[T049L] {bgcolor: "#d0e0d0"}
*+MANDT {label: "CLNT (3)"}
*+BUKRS {label: "CHAR (4)"}
*LOCKB {label: "CHAR (7)"}

[T057] {bgcolor: "#d0e0d0"}
*+MANDT {label: "CLNT (3)"}
*BLNKZ {label: "CHAR (2)"}
*BEGDA {label: "DATS (8)"}

[TB023] {bgcolor: "#d0e0d0"}
*+CLIENT {label: "CLNT (3)"}
*IND_SECTOR {label: "CHAR (10)"}

[TB027] {bgcolor: "#d0e0d0"}
*+CLIENT {label: "CLNT (3)"}
*MARST {label: "CHAR (1)"}

[TB910] {bgcolor: "#d0e0d0"}
*+CLIENT {label: "CLNT (3)"}
*ABTNR {label: "CHAR (4)"}

[TB912] {bgcolor: "#d0e0d0"}
*+CLIENT {label: "CLNT (3)"}
*PAFKT {label: "CHAR (4)"}

[TBRG] {bgcolor: "#d0e0d0"}
*MANDT {label: "CLNT (3)"}
*BROBJ {label: "CHAR (10)"}
*BRGRU {label: "CHAR (4)"}

[TD05_AT_FS] {bgcolor: "#d0e0d0"}
*MANDT {label: "CLNT (3)"}
*SZG_AT {label: "CHAR (2)"}

[TFACD] {bgcolor: "#d0e0d0"}
*IDENT {label: "CHAR (2)"}

[TP01] {bgcolor: "#d0e0d0"}
*+MANDT {label: "CLNT (3)"}
*TITLE {label: "NUMC (2)"}

[TP02] {bgcolor: "#d0e0d0"}
*+MANDT {label: "CLNT (3)"}
*TITLE_LET {label: "NUMC (2)"}

[TP04] {bgcolor: "#d0e0d0"}
*+MANDT {label: "CLNT (3)"}
*PROPRTY_ST {label: "NUMC (2)"}

[TP05] {bgcolor: "#d0e0d0"}
*+MANDT {label: "CLNT (3)"}
*STAFF_GRP {label: "CHAR (4)"}

[TP08] {bgcolor: "#d0e0d0"}
*+MANDT {label: "CLNT (3)"}
*LEGAL_ENTY {label: "NUMC (2)"}

[TP09] {bgcolor: "#d0e0d0"}
*+MANDT {label: "CLNT (3)"}
*LEGAL_ORG {label: "NUMC (2)"}

[TP11] {bgcolor: "#d0e0d0"}
*+MANDT {label: "CLNT (3)"}
*EMPLOYMENT {label: "NUMC (2)"}

[TP12] {bgcolor: "#d0e0d0"}
*+MANDT {label: "CLNT (3)"}
*KWG_CRE {label: "NUMC (2)"}

[TP13] {bgcolor: "#d0e0d0"}
*+MANDT {label: "CLNT (3)"}
*GROUP_D {label: "CHAR (4)"}

[TP14] {bgcolor: "#d0e0d0"}
*+MANDT {label: "CLNT (3)"}
*ADR_REF {label: "CHAR (10)"}

[TPZ11] {bgcolor: "#d0e0d0"}
*+MANDT {label: "CLNT (3)"}
*RELAT {label: "CHAR (4)"}

[TPZ2] {bgcolor: "#d0e0d0"}
*+MANDT {label: "CLNT (3)"}
*GROUP_ID {label: "CHAR (4)"}

[TPZ3] {bgcolor: "#d0e0d0"}
*+MANDT {label: "CLNT (3)"}
*ROLETYP {label: "CHAR (4)"}

[TPZ6] {bgcolor: "#d0e0d0"}
*+MANDT {label: "CLNT (3)"}
*ROLE {label: "CHAR (4)"}

[TPZ7] {bgcolor: "#d0e0d0"}
*+MANDT {label: "CLNT (3)"}
*REL_TYP {label: "CHAR (4)"}

[TPZ8] {bgcolor: "#d0e0d0"}
*MANDT {label: "CLNT (3)"}
*DIF_TYP {label: "CHAR (4)"}

[TVIP] {bgcolor: "#d0e0d0"}
*+MANDT {label: "CLNT (3)"}
*PAVIP {label: "CHAR (1)"}

[TZGR] {bgcolor: "#d0e0d0"}
*ZGRUP {label: "CHAR (2)"}

[TZUN] {bgcolor: "#d0e0d0"}
*ZUAWA {label: "CHAR (3)"}

[USR02] {bgcolor: "#d0e0d0"}
*MANDT {label: "CLNT (3)"}
*BNAME {label: "CHAR (12)"}

# Relationships

J11SPA1 1--* SANS1 {label: "J11SPA1-ADRNR = SANS1-ADRNR"}
J11SPA1 *--* TP14 {label: "J11SPA1-ADR_REF = TP14-ADR_REF"}
J11SPA1 *--* TP14 {label: "J11SPA1-ADR_REF_K = TP14-ADR_REF"}
J11SPA1 *--* SKA1 {label: "J11SPA1-AKONT = SKA1-SAKNR"}
J11SPA1 *--* TBRG {label: "J11SPA1-AUTHORITY = TBRG-BRGRU"}
J11SPA1 *--* T005 {label: "J11SPA1-BANKS = T005-LAND1"}
J11SPA1 1--* TBRG {label: "J11SPA1-BEGRU = TBRG-BRGRU"}
J11SPA1 *--* T057 {label: "J11SPA1-BLNKZ = T057-BLNKZ"}
J11SPA1 *--* T001 {label: "J11SPA1-BUKRS = T001-BUKRS"}
J11SPA1 *--* T001S {label: "J11SPA1-BUSAB = T001S-BUSAB"}
J11SPA1 *--* TFACD {label: "J11SPA1-CALENDARID = TFACD-IDENT"}
J11SPA1 *--* T005 {label: "J11SPA1-CNTRY_COMP = T005-LAND1"}
J11SPA1 *--* TB910 {label: "J11SPA1-DEPART = TB910-ABTNR"}
J11SPA1 *--* TPZ8 {label: "J11SPA1-DIF_TYP1 = TPZ8-DIF_TYP"}
J11SPA1 *--* TPZ8 {label: "J11SPA1-DIF_TYP2 = TPZ8-DIF_TYP"}
J11SPA1 1--* TP11 {label: "J11SPA1-EMPLOYMENT = TP11-EMPLOYMENT"}
J11SPA1 1--* TB023 {label: "J11SPA1-EMP_SECTOR = TB023-IND_SECTOR"}
J11SPA1 *--* T035 {label: "J11SPA1-FDGRV = T035-GRUPP"}
J11SPA1 *--* TB912 {label: "J11SPA1-FUNCTN = TB912-PAFKT"}
J11SPA1 1--* TP13 {label: "J11SPA1-GROUP_D = TP13-GROUP_D"}
J11SPA1 1--* TPZ2 {label: "J11SPA1-GROUP_ID = TPZ2-GROUP_ID"}
J11SPA1 *--* T012 {label: "J11SPA1-HBKID = T012-HBKID"}
J11SPA1 *--* TB023 {label: "J11SPA1-IND_SECTOR = TB023-IND_SECTOR"}
J11SPA1 *--* KNA1 {label: "J11SPA1-KNRMA = KNA1-KUNNR"}
J11SPA1 *--* KNA1 {label: "J11SPA1-KNRZB = KNA1-KUNNR"}
J11SPA1 *--* KNA1 {label: "J11SPA1-KNRZE = KNA1-KUNNR"}
J11SPA1 *--* KNA1 {label: "J11SPA1-KUNNR = KNA1-KUNNR"}
J11SPA1 *--* TP12 {label: "J11SPA1-KWG_CRE = TP12-KWG_CRE"}
J11SPA1 *--* T005 {label: "J11SPA1-LAND1 = T005-LAND1"}
J11SPA1 *--* TP08 {label: "J11SPA1-LEGAL_ENTY = TP08-LEGAL_ENTY"}
J11SPA1 *--* TP09 {label: "J11SPA1-LEGAL_ORG = TP09-LEGAL_ORG"}
J11SPA1 *--* T049L {label: "J11SPA1-LOCKB = T049L-LOCKB"}
J11SPA1 *--* T047M {label: "J11SPA1-MABER = T047M-MABER"}
J11SPA1 *--* T047A {label: "J11SPA1-MAHNA = T047A-MAHNA"}
J11SPA1 1--* T000 {label: "J11SPA1-MANDT = T000-MANDT"}
J11SPA1 *--* T040S {label: "J11SPA1-MANSP = T040S-MANSP"}
J11SPA1 1--* TB027 {label: "J11SPA1-MARITAL_ST = TB027-MARST"}
J11SPA1 *--* T047R {label: "J11SPA1-MGRUP = T047R-MGRUP"}
J11SPA1 1--* T005 {label: "J11SPA1-NATION = T005-LAND1"}
J11SPA1 *--* BP000 {label: "J11SPA1-PARTNR = BP000-PARTNR"}
J11SPA1 1--* BP000 {label: "J11SPA1-PARTNR2 = BP000-PARTNR"}
J11SPA1 1--* TP04 {label: "J11SPA1-PROPRTY_ST = TP04-PROPRTY_ST"}
J11SPA1 *--* T005S {label: "J11SPA1-PROVZ = T005S-BLAND"}
J11SPA1 *--* T005S {label: "J11SPA1-REGIO = T005S-BLAND"}
J11SPA1 *--* TPZ11 {label: "J11SPA1-RELAT = TPZ11-RELAT"}
J11SPA1 1--* TPZ7 {label: "J11SPA1-REL_TYP = TPZ7-REL_TYP"}
J11SPA1 *--* KNA1 {label: "J11SPA1-REMIT = KNA1-KUNNR"}
J11SPA1 *--* TPZ6 {label: "J11SPA1-ROLE = TPZ6-ROLE"}
J11SPA1 *--* TPZ3 {label: "J11SPA1-ROLETYP = TPZ3-ROLETYP"}
J11SPA1 1--* TP05 {label: "J11SPA1-STAFF_GRP = TP05-STAFF_GRP"}
J11SPA1 1--* T005 {label: "J11SPA1-STATE = T005-LAND1"}
J11SPA1 *--* TD05_AT_FS {label: "J11SPA1-SZG_AT = TD05_AT_FS-SZG_AT"}
J11SPA1 1--* TP01 {label: "J11SPA1-TITLE = TP01-TITLE"}
J11SPA1 1--* TP02 {label: "J11SPA1-TITLE_LET = TP02-TITLE_LET"}
J11SPA1 *--* T042F {label: "J11SPA1-UZAWE = T042F-UZAWE"}
J11SPA1 1--* TVIP {label: "J11SPA1-VIP = TVIP-PAVIP"}
J11SPA1 *--* USR02 {label: "J11SPA1-XUBNAME = USR02-BNAME"}
J11SPA1 *--* T008 {label: "J11SPA1-ZAHLS = T008-ZAHLS"}
J11SPA1 *--* TZGR {label: "J11SPA1-ZGRUP = TZGR-ZGRUP"}
J11SPA1 *--* TZUN {label: "J11SPA1-ZUAWA = TZUN-ZUAWA"}

E-R Diagram for table J11SPA1 (Send Structure for TR-EDT Receiver Structure JBIUPA1)

Foreign Key tables (46)

BP000 {Business Partner Master (General Data)}
KNA1 {General Data in Customer Master}
SANS1 {Address table}
SKA1 {G/L Account Master (Chart of Accounts)}
T000 {Clients}
T001 {Company Codes}
T001S {Accounting Clerks}
T005 {Countries}
T005S {Taxes: Region (Province) Key}
T008 {Blocking Reasons for Automatic Payment Transcations}
T012 {House Banks}
T035 {Planning groups}
T040S {Blocking reasons for dunning notices}
T042F {Payment method supplements}
T047A {Account Level Dunning Control}
T047M {Dunning areas}
T047R {Grouping rules for dunning notices}
T049L {Lockboxes at our House Banks}
T057 {Preference Indicator}
TB023 {BP industries (Obsolete ==> TB038A)}
TB027 {BP marital status}
TB910 {Contact Person Departments}
TB912 {Positions of contact persons}
TBRG {Authorization groups}
TD05_AT_FS {IS-IS: ÖNB-Target groups}
TFACD {Factory calendar definition}
TP01 {Business Partner: Form of Address}
TP02 {Business partner: Salutation}
TP04 {Business Partner: Marital Property Regime}
TP05 {Business partner: Employee group}
TP08 {Business Partner: Legal Form}
TP09 {Business Partner: Legal Entity}
TP11 {Business partner: Employment status}
TP12 {Business Partner: Credit Standing Acc. to German Banking Act}
TP13 {Business Partner: Partner Grouping (Target Group)}
TP14 {Business Partner: Address ID}
TPZ11 {BP: Business Partner - Relationship Type}
TPZ2 {Business Partner: Customizing BP Grouping}
TPZ3 {BP: Business Partner - Role Category}
TPZ6 {BP: Business Partner - Role Type}
TPZ7 {BP: Business Partner - Relationship Category}
TPZ8 {BP: Business Partner - Differentiation Category}
TVIP {Contact Person: VIP Indicator}
TZGR {Grouping rules for automatic payments}
TZUN {Rules for 'Allocation' Field Layout}
USR02 {Logon Data (Kernel-Side Use)}