SAP ABAP Table ROIUVL_SCTXNS1 (Settlement statement/CI transaction), sap-tables.org - The Best Online document for SAP ABAP Tables

SAP ABAP Table `ROIUVL_SCTXNS1` {Settlement statement/CI transaction}

Home

                title {label: "SAP ABAP table ROIUVL_SCTXNS1 {Settlement statement/CI transaction}", size: "20"}

# Entities

[ROIUVL_SCTXNS1] {bgcolor: "tomato"}
+PU_NO {label: "CHAR (10)"}
+PPA_RSN_CD {label: "CHAR (2)"}
+REJ_RSN_CD {label: "CHAR (3)"}
+SETT_MATNR {label: "CHAR (18)"}
+MATNR {label: "CHAR (18)"}
+MAJPD_CD {label: "CHAR (1)"}
+SETT_VNAME {label: "CHAR (6)"}
+BUKRS {label: "CHAR (4)"}
+VNAME {label: "CHAR (6)"}
+DOI_NO {label: "CHAR (5)"}
+WI_OWN_NO {label: "CHAR (10)"}
+WI_INT_TYPE_CD {label: "CHAR (2)"}
+CT_NO {label: "CHAR (10)"}
+CT_TYPE_CD {label: "CHAR (2)"}
+UNIT_VNAME {label: "CHAR (6)"}
+LAND1 {label: "CHAR (3)"}
+PRI_GEO_LOC {label: "CHAR (2)"}
+SEC_GEO_LOC {label: "CHAR (3)"}
+VL_TYPE_CD {label: "CHAR (2)"}
+TOT_GR_VL_U {label: "UNIT (3)"}
+ENERGY_U {label: "UNIT (3)"}
+DENSITY_U {label: "UNIT (3)"}
+HEAT_VAL_FCT_U {label: "UNIT (3)"}
+WLR_VL_U {label: "UNIT (3)"}
+GR_VAL_CURR {label: "CUKY (5)"}
+MKCT_CURR {label: "CUKY (5)"}
+MK_RMB_CURR {label: "CUKY (5)"}
+SVTR_CURR {label: "CUKY (5)"}
+SEVT_CURR {label: "CUKY (5)"}

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

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

[OIU_CM_CTTYP] {bgcolor: "#d0e0d0"}
*CT_TYPE_CD {label: "CHAR (2)"}

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

[OIU_CM_LXSGL] {bgcolor: "#d0e0d0"}
*MANDT {label: "CLNT (3)"}
*+LAND1 {label: "CHAR (3)"}
*+PRI_GEO_LOC {label: "CHAR (2)"}
*SEC_GEO_LOC {label: "CHAR (3)"}

[OIU_CM_MAT_PRCD] {bgcolor: "#d0e0d0"}
*+MANDT {label: "CLNT (3)"}
*+MATNR {label: "CHAR (18)"}

[OIU_CM_PDCD] {bgcolor: "#d0e0d0"}
*MAJPD_CD {label: "CHAR (1)"}
*PD_CD {label: "CHAR (2)"}

[OIU_CM_PINTTY] {bgcolor: "#d0e0d0"}
*OWN_INT_TYPE_CD {label: "CHAR (2)"}

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

[OIU_CM_REJCD] {bgcolor: "#d0e0d0"}
*REJ_RSN_CD {label: "CHAR (3)"}

[OIU_DO_DI] {bgcolor: "#d0e0d0"}
*MANDT {label: "CLNT (3)"}
*+BUKRS {label: "CHAR (4)"}
*+VNAME {label: "CHAR (6)"}
*DOI_NO {label: "CHAR (5)"}

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

[OIU_PR_VLTYP] {bgcolor: "#d0e0d0"}
*VL_TYPE_CD {label: "CHAR (2)"}

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

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

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

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

# Relationships

ROIUVL_SCTXNS1 1--* T001 {label: "ROIUVL_SCTXNS1-BUKRS = T001-BUKRS"}
ROIUVL_SCTXNS1 1--* OIUCM_CONTRACT {label: "ROIUVL_SCTXNS1-CT_NO = OIUCM_CONTRACT-VBELN"}
ROIUVL_SCTXNS1 *--* OIU_CM_CTTYP {label: "ROIUVL_SCTXNS1-CT_TYPE_CD = OIU_CM_CTTYP-CT_TYPE_CD"}
ROIUVL_SCTXNS1 1--* T006 {label: "ROIUVL_SCTXNS1-DENSITY_U = T006-MSEHI"}
ROIUVL_SCTXNS1 1--* OIU_DO_DI {label: "ROIUVL_SCTXNS1-DOI_NO = OIU_DO_DI-DOI_NO"}
ROIUVL_SCTXNS1 1--* T006 {label: "ROIUVL_SCTXNS1-ENERGY_U = T006-MSEHI"}
ROIUVL_SCTXNS1 1--* TCURC {label: "ROIUVL_SCTXNS1-GR_VAL_CURR = TCURC-WAERS"}
ROIUVL_SCTXNS1 1--* T006 {label: "ROIUVL_SCTXNS1-HEAT_VAL_FCT_U = T006-MSEHI"}
ROIUVL_SCTXNS1 1--* T005 {label: "ROIUVL_SCTXNS1-LAND1 = T005-LAND1"}
ROIUVL_SCTXNS1 *--* OIU_CM_PDCD {label: "ROIUVL_SCTXNS1-MAJPD_CD = OIU_CM_PDCD-MAJPD_CD"}
ROIUVL_SCTXNS1 1--* OIU_CM_MAT_PRCD {label: "ROIUVL_SCTXNS1-MATNR = OIU_CM_MAT_PRCD-MATNR"}
ROIUVL_SCTXNS1 1--* TCURC {label: "ROIUVL_SCTXNS1-MKCT_CURR = TCURC-WAERS"}
ROIUVL_SCTXNS1 1--* TCURC {label: "ROIUVL_SCTXNS1-MK_RMB_CURR = TCURC-WAERS"}
ROIUVL_SCTXNS1 1--* OIU_CM_PPARSN {label: "ROIUVL_SCTXNS1-PPA_RSN_CD = OIU_CM_PPARSN-PPA_RSN_CD"}
ROIUVL_SCTXNS1 1--* OIU_CM_LXPGL {label: "ROIUVL_SCTXNS1-PRI_GEO_LOC = OIU_CM_LXPGL-PRI_GEO_LOC"}
ROIUVL_SCTXNS1 1--* KNA1 {label: "ROIUVL_SCTXNS1-PU_NO = KNA1-KUNNR"}
ROIUVL_SCTXNS1 *--* OIU_CM_REJCD {label: "ROIUVL_SCTXNS1-REJ_RSN_CD = OIU_CM_REJCD-REJ_RSN_CD"}
ROIUVL_SCTXNS1 1--* OIU_CM_LXSGL {label: "ROIUVL_SCTXNS1-SEC_GEO_LOC = OIU_CM_LXSGL-SEC_GEO_LOC"}
ROIUVL_SCTXNS1 1--* OIU_CM_MAT_PRCD {label: "ROIUVL_SCTXNS1-SETT_MATNR = OIU_CM_MAT_PRCD-MATNR"}
ROIUVL_SCTXNS1 1--* OIU_DO_JV {label: "ROIUVL_SCTXNS1-SETT_VNAME = OIU_DO_JV-VNAME"}
ROIUVL_SCTXNS1 1--* TCURC {label: "ROIUVL_SCTXNS1-SEVT_CURR = TCURC-WAERS"}
ROIUVL_SCTXNS1 1--* TCURC {label: "ROIUVL_SCTXNS1-SVTR_CURR = TCURC-WAERS"}
ROIUVL_SCTXNS1 1--* T006 {label: "ROIUVL_SCTXNS1-TOT_GR_VL_U = T006-MSEHI"}
ROIUVL_SCTXNS1 1--* OIU_DO_JV {label: "ROIUVL_SCTXNS1-UNIT_VNAME = OIU_DO_JV-VNAME"}
ROIUVL_SCTXNS1 *--* OIU_PR_VLTYP {label: "ROIUVL_SCTXNS1-VL_TYPE_CD = OIU_PR_VLTYP-VL_TYPE_CD"}
ROIUVL_SCTXNS1 1--* OIU_DO_JV {label: "ROIUVL_SCTXNS1-VNAME = OIU_DO_JV-VNAME"}
ROIUVL_SCTXNS1 1--+ OIU_CM_PINTTY {label: "ROIUVL_SCTXNS1-WI_INT_TYPE_CD = OIU_CM_PINTTY-OWN_INT_TYPE_CD"}
ROIUVL_SCTXNS1 1--* KNA1 {label: "ROIUVL_SCTXNS1-WI_OWN_NO = KNA1-KUNNR"}
ROIUVL_SCTXNS1 1--* T006 {label: "ROIUVL_SCTXNS1-WLR_VL_U = T006-MSEHI"}

E-R Diagram for table ROIUVL_SCTXNS1 (Settlement statement/CI transaction)

Foreign Key tables (17)

KNA1 {General Data in Customer Master}
OIUCM_CONTRACT {PRA Contracts}
OIU_CM_CTTYP {Contract Type (TBLCS007)}
OIU_CM_LXPGL {Country and Primary Geo. Location Xref}
OIU_CM_LXSGL {Cross Reference Between Country and Secondary Geo. Locatio}
OIU_CM_MAT_PRCD {Material and Product Code (processing) Xref}
OIU_CM_PDCD {Product Codes - Tblcm003}
OIU_CM_PINTTY {Participant Interest Type (TBLRV006 & TBLRV035)}
OIU_CM_PPARSN {Prior Period Adjustments - TBLCM028}
OIU_CM_REJCD {Reject Reason Code Table - TBLRV027}
OIU_DO_DI {Base Venture/DOI Relationship}
OIU_DO_JV {PRA venture extension}
OIU_PR_VLTYP {Volume Type Table - Tblcm010}
T001 {Company Codes}
T005 {Countries}
T006 {Units of Measurement}
TCURC {Currency Codes}

SAP ABAP Table ROIUVL_SCTXNS1 {Settlement statement/CI transaction}

Foreign Key tables (17)

SAP ABAP Table `ROIUVL_SCTXNS1` {Settlement statement/CI transaction}