SAP ABAP Table V_JSBW_INVOICE (Generated Table for View), sap-tables.org - The Best Online document for SAP ABAP Tables

SAP ABAP Table `V_JSBW_INVOICE` {Generated Table for View}

Home

                title {label: "SAP ABAP table V_JSBW_INVOICE {Generated Table for View}", size: "20"}

# Entities

[V_JSBW_INVOICE] {bgcolor: "tomato"}
*+MANDT {label: "CLNT (3)"}
*VBELN {label: "CHAR (10)"}
*+FKART {label: "CHAR (4)"}
*VBTYP {label: "CHAR (1)"}
*+WAERK {label: "CUKY (5)"}
*+VKORG {label: "CHAR (4)"}
*+VTWEG {label: "CHAR (2)"}
*+KALSM {label: "CHAR (6)"}
*KNUMV {label: "CHAR (10)"}
*FKDAT {label: "DATS (8)"}
*+KONDA {label: "CHAR (2)"}
*+KDGRP {label: "CHAR (2)"}
*+PLTYP {label: "CHAR (2)"}
*ZLSCH {label: "CHAR (1)"}
*+KTGRD {label: "CHAR (2)"}
*REGIO {label: "CHAR (3)"}
*COUNC {label: "CHAR (3)"}
*CITYC {label: "CHAR (4)"}
*+BUKRS {label: "CHAR (4)"}
*+KUNRG {label: "CHAR (10)"}
*+KUNAG {label: "CHAR (10)"}
*ISPSHKZGK {label: "CHAR (1)"}
*+ISPSTOGRD {label: "CHAR (3)"}
*ISPXINK {label: "CHAR (1)"}
*ISPXWBZABO {label: "CHAR (1)"}
*ISPINKVSG {label: "CHAR (10)"}
*ISPINKGP {label: "CHAR (10)"}
*ISPXVDICHT {label: "CHAR (1)"}
*XRENEWAL {label: "CHAR (1)"}
*POSNR {label: "NUMC (6)"}
*FKIMG {label: "QUAN (13)"}
*+VRKME {label: "UNIT (3)"}
*+MEINS {label: "UNIT (3)"}
*+GSBER {label: "CHAR (4)"}
*FBUDA {label: "DATS (8)"}
*NETWR {label: "CURR (15)"}
*+MATKL {label: "CHAR (9)"}
*+SPART {label: "CHAR (2)"}
*+WERKS {label: "CHAR (4)"}
*+ALAND {label: "CHAR (3)"}
*+WKREG {label: "CHAR (3)"}
*WKCOU {label: "CHAR (3)"}
*WKCTY {label: "CHAR (4)"}
*SKFBP {label: "CURR (13)"}
*+SPARA {label: "CHAR (2)"}
*SHKZG {label: "CHAR (1)"}
*ERNAM {label: "CHAR (12)"}
*ERDAT {label: "DATS (8)"}
*ERZET {label: "TIMS (6)"}
*STAFO {label: "CHAR (6)"}
*WAVWR {label: "CURR (13)"}
*+ISPAUART {label: "CHAR (4)"}
*ISPAUAGRP {label: "CHAR (1)"}
*ISPKOSTL_L {label: "CHAR (10)"}
*+ISPDRERZ {label: "CHAR (8)"}
*+ISPPVA {label: "CHAR (8)"}
*+ISPBEZ {label: "CHAR (2)"}
*+ISPLIFART {label: "CHAR (2)"}
*ISPPOSEX {label: "NUMC (6)"}
*+ISPVBELN {label: "CHAR (10)"}
*+ISPPOSNR {label: "NUMC (6)"}
*+ISPETENR {label: "NUMC (4)"}
*ISPETEEX {label: "NUMC (6)"}
*+ISPETART {label: "CHAR (2)"}
*ISPETMENGE {label: "QUAN (10)"}
*+ISPETMEINS {label: "UNIT (3)"}
*ISPETVOR {label: "CHAR (1)"}
*ISPANZET {label: "DEC (5)"}
*ISPERSDAT {label: "DATS (8)"}
*+ISPWRBAKT {label: "CHAR (8)"}
*ISPFAKVON {label: "DATS (8)"}
*ISPFAKBIS {label: "DATS (8)"}
*+ISPKONDA {label: "CHAR (2)"}
*+ISPKDGRP {label: "CHAR (2)"}
*+ISPPOART {label: "CHAR (2)"}
*ISPBRTWR_P {label: "CURR (15)"}
*ISPVERSDAT {label: "DATS (8)"}
*ISPLANDE {label: "CHAR (3)"}
*+ISPVAUSGB {label: "CHAR (10)"}
*ISPVKBURZU {label: "CHAR (4)"}
*ISPXFKRUEK {label: "CHAR (1)"}
*ISPIVWKN {label: "CHAR (8)"}
*ISPXIVW {label: "CHAR (1)"}
*XNEGOPTION {label: "CHAR (1)"}
*IVWDATUM {label: "DATS (8)"}
*CAMPAIGN {label: "RAW (16)"}
*FKPERVON {label: "DATS (8)"}
*FKPERBIS {label: "DATS (8)"}
*ISPZSKLS {label: "CHAR (1)"}
*+ISPWRBART {label: "CHAR (4)"}
*POSNR_UR {label: "NUMC (6)"}
*CYCLENR {label: "NUMC (3)"}
*FAKNRRUECK {label: "CHAR (10)"}
*XAUTO_REN {label: "CHAR (1)"}
*X_MONTAG {label: "CHAR (1)"}
*X_DIENSTAG {label: "CHAR (1)"}
*X_MITTWOCH {label: "CHAR (1)"}
*X_DONNETAG {label: "CHAR (1)"}
*X_FREITAG {label: "CHAR (1)"}
*X_SAMSTAG {label: "CHAR (1)"}
*X_SONNTAG {label: "CHAR (1)"}
*VBELN_FROM {label: "CHAR (10)"}
*POSNR_UR_FROM {label: "NUMC (6)"}
*CYCLENR_FROM {label: "NUMC (3)"}
*+PARVW {label: "CHAR (2)"}
*+KUNNR {label: "CHAR (10)"}
*ADRNR {label: "CHAR (10)"}
*+LAND1 {label: "CHAR (3)"}
*ISPADRNR {label: "CHAR (10)"}
*ISPADRVAR {label: "CHAR (1)"}

[JDTBEZTYP] {bgcolor: "#d0e0d0"}
*+MANDT {label: "CLNT (3)"}
*+DRERTR {label: "CHAR (8)"}
*+PVATRA {label: "CHAR (8)"}
*BEZTYP {label: "CHAR (2)"}

[JDTDRER] {bgcolor: "#d0e0d0"}
*+MANDT {label: "CLNT (3)"}
*DRERZ {label: "CHAR (8)"}

[JDTPVA] {bgcolor: "#d0e0d0"}
*+MANDT {label: "CLNT (3)"}
*+DRERZ {label: "CHAR (8)"}
*PVA {label: "CHAR (8)"}

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

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

[JKAP] {bgcolor: "#d0e0d0"}
*+MANDT {label: "CLNT (3)"}
*+VBELN {label: "CHAR (10)"}
*POSNR {label: "NUMC (6)"}

[JKEP] {bgcolor: "#d0e0d0"}
*+MANDT {label: "CLNT (3)"}
*+VBELN {label: "CHAR (10)"}
*+POSNR {label: "NUMC (6)"}
*ETENR {label: "NUMC (4)"}

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

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

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

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

[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)"}

[T006] {bgcolor: "#d0e0d0"}
*+MANDT {label: "CLNT (3)"}
*MSEHI {label: "UNIT (3)"}

[T023] {bgcolor: "#d0e0d0"}
*+MANDT {label: "CLNT (3)"}
*MATKL {label: "CHAR (9)"}

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

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

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

[T683] {bgcolor: "#d0e0d0"}
*+MANDT {label: "CLNT (3)"}
*KVEWE {label: "CHAR (1)"}
*KAPPL {label: "CHAR (2)"}
*KALSM {label: "CHAR (6)"}

[TCURC] {bgcolor: "#d0e0d0"}
*MANDT {label: "CLNT (3)"}
*WAERS {label: "CUKY (5)"}

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

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

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

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

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

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

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

[TJWAK] {bgcolor: "#d0e0d0"}
*+MANDT {label: "CLNT (3)"}
*WERBEAKT {label: "CHAR (8)"}

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

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

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

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

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

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

# Relationships

V_JSBW_INVOICE 1--* T005 {label: "V_JSBW_INVOICE-ALAND = T005-LAND1"}
V_JSBW_INVOICE 1--* T001 {label: "V_JSBW_INVOICE-BUKRS = T001-BUKRS"}
V_JSBW_INVOICE 1--* TJFK {label: "V_JSBW_INVOICE-FKART = TJFK-FKART"}
V_JSBW_INVOICE ?--* TGSB {label: "V_JSBW_INVOICE-GSBER = TGSB-GSBER"}
V_JSBW_INVOICE 1--* TJAK {label: "V_JSBW_INVOICE-ISPAUART = TJAK-AUART"}
V_JSBW_INVOICE *--* JDTBEZTYP {label: "V_JSBW_INVOICE-ISPBEZ = JDTBEZTYP-BEZTYP"}
V_JSBW_INVOICE *--* JDTDRER {label: "V_JSBW_INVOICE-ISPDRERZ = JDTDRER-DRERZ"}
V_JSBW_INVOICE 1--* TJEP {label: "V_JSBW_INVOICE-ISPETART = TJEP-ETART"}
V_JSBW_INVOICE 1--* JKEP {label: "V_JSBW_INVOICE-ISPETENR = JKEP-ETENR"}
V_JSBW_INVOICE *--* T006 {label: "V_JSBW_INVOICE-ISPETMEINS = T006-MSEHI"}
V_JSBW_INVOICE *--* T151 {label: "V_JSBW_INVOICE-ISPKDGRP = T151-KDGRP"}
V_JSBW_INVOICE *--* T188 {label: "V_JSBW_INVOICE-ISPKONDA = T188-KONDA"}
V_JSBW_INVOICE *--* TJV01 {label: "V_JSBW_INVOICE-ISPLIFART = TJV01-LIEFERART"}
V_JSBW_INVOICE *--* TJAP {label: "V_JSBW_INVOICE-ISPPOART = TJAP-POART"}
V_JSBW_INVOICE 1--* JKAP {label: "V_JSBW_INVOICE-ISPPOSNR = JKAP-POSNR"}
V_JSBW_INVOICE *--* JDTPVA {label: "V_JSBW_INVOICE-ISPPVA = JDTPVA-PVA"}
V_JSBW_INVOICE *--* TJF27 {label: "V_JSBW_INVOICE-ISPSTOGRD = TJF27-STOGRD"}
V_JSBW_INVOICE *--* JDTVAUSGB {label: "V_JSBW_INVOICE-ISPVAUSGB = JDTVAUSGB-VAUSGB"}
V_JSBW_INVOICE 1--* JKAK {label: "V_JSBW_INVOICE-ISPVBELN = JKAK-VBELN"}
V_JSBW_INVOICE *--* TJWAK {label: "V_JSBW_INVOICE-ISPWRBAKT = TJWAK-WERBEAKT"}
V_JSBW_INVOICE ?--* TJWAR {label: "V_JSBW_INVOICE-ISPWRBART = TJWAR-WERBEART"}
V_JSBW_INVOICE 1--* T683 {label: "V_JSBW_INVOICE-KALSM = T683-KALSM"}
V_JSBW_INVOICE ?--* T151 {label: "V_JSBW_INVOICE-KDGRP = T151-KDGRP"}
V_JSBW_INVOICE ?--* T188 {label: "V_JSBW_INVOICE-KONDA = T188-KONDA"}
V_JSBW_INVOICE ?--* TVKT {label: "V_JSBW_INVOICE-KTGRD = TVKT-KTGRD"}
V_JSBW_INVOICE 1--* KNA1 {label: "V_JSBW_INVOICE-KUNAG = KNA1-KUNNR"}
V_JSBW_INVOICE ?--* KNA1 {label: "V_JSBW_INVOICE-KUNNR = KNA1-KUNNR"}
V_JSBW_INVOICE 1--* KNA1 {label: "V_JSBW_INVOICE-KUNRG = KNA1-KUNNR"}
V_JSBW_INVOICE ?--* T005 {label: "V_JSBW_INVOICE-LAND1 = T005-LAND1"}
V_JSBW_INVOICE 1--* T000 {label: "V_JSBW_INVOICE-MANDT = T000-MANDT"}
V_JSBW_INVOICE ?--* T023 {label: "V_JSBW_INVOICE-MATKL = T023-MATKL"}
V_JSBW_INVOICE ?--* T006 {label: "V_JSBW_INVOICE-MEINS = T006-MSEHI"}
V_JSBW_INVOICE 1--* TPAR {label: "V_JSBW_INVOICE-PARVW = TPAR-PARVW"}
V_JSBW_INVOICE ?--* T189 {label: "V_JSBW_INVOICE-PLTYP = T189-PLTYP"}
V_JSBW_INVOICE ?--* TSPA {label: "V_JSBW_INVOICE-SPARA = TSPA-SPART"}
V_JSBW_INVOICE ?--* TSPA {label: "V_JSBW_INVOICE-SPART = TSPA-SPART"}
V_JSBW_INVOICE ?--* TVKO {label: "V_JSBW_INVOICE-VKORG = TVKO-VKORG"}
V_JSBW_INVOICE ?--* T006 {label: "V_JSBW_INVOICE-VRKME = T006-MSEHI"}
V_JSBW_INVOICE ?--* TVTW {label: "V_JSBW_INVOICE-VTWEG = TVTW-VTWEG"}
V_JSBW_INVOICE 1--* TCURC {label: "V_JSBW_INVOICE-WAERK = TCURC-WAERS"}
V_JSBW_INVOICE ?--* T001W {label: "V_JSBW_INVOICE-WERKS = T001W-WERKS"}
V_JSBW_INVOICE ?--* T005S {label: "V_JSBW_INVOICE-WKREG = T005S-BLAND"}

E-R Diagram for table V_JSBW_INVOICE (Generated Table for View)

Foreign Key tables (34)

JDTBEZTYP {IS-M: Mix Types (per Edition)}
JDTDRER {IS-M/SD: Publications}
JDTPVA {IS-M/SD: Editions}
JDTVAUSGB {IS-M/SD: Issues}
JKAK {Sales Order Header Data}
JKAP {Sales Order - Item Data}
JKEP {Sales Order: Schedule Line Data}
KNA1 {General Data in Customer Master}
T000 {Clients}
T001 {Company Codes}
T001W {Plants/Branches}
T005 {Countries}
T005S {Taxes: Region (Province) Key}
T006 {Units of Measurement}
T023 {Material Groups}
T151 {Customers: Customer Groups}
T188 {Conditions: Groups for Customer Classifications}
T189 {Conditions: Price List Categories}
T683 {Pricing procedures}
TCURC {Currency Codes}
TGSB {Business Areas}
TJAK {IS-M/SD: Sales Document Type}
TJAP {Sales Order: Item Types}
TJEP {Sales Order: Schedule Line Types}
TJF27 {IS-M/SD: Billing Document Reversal Reasons}
TJFK {IS-M/SD: Billing Document Types}
TJV01 {Delivery type for issue}
TJWAK {IS-M/SD: Sales Promotion}
TJWAR {IS-M/SD: Sales Source}
TPAR {Business Partner: Functions}
TSPA {Organizational Unit: Sales Divisions}
TVKO {Organizational Unit: Sales Organizations}
TVKT {Customers: Account Assignment Groups}
TVTW {Organizational Unit: Distribution Channels}