SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

Schema:
 Module:  Table: 
Column: 
Searchbeta 

icon of database logic symbol SAP  TABLESv1Made in Britain

Home | ERP 6.0  | VDCAPTR
JDETables.com - the webs number one JD Edwards Table Definition reference

ERP 6.0: Top 10 requests

TableColumnsDescription
1TJKWE15IS-M/SD: WBZ, Order Data for Inbound Processing
2RSADMINC96Customizing Table General BW
3BBP_PD_XML8Table for Persistent Class CL_XML_PPF_BBP
4/OTX/RM_TELIB24Enterprise Library Server Settings
5UMV_TR1259Obsolete:Val.Driver Tree:Assign.Web Reports to Value Drivers
6FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
7/ISDFPS/CHVW_E34External Batch Where-Used List
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9FMARCPAR4Parallelization of FMARC_BATCH
10CEKRS5Movement type parameters for automatic ERS

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5INV1265A/R Invoice - Rows
6OJDT100Journal Entry
7OPCH386A/P Invoice
8OVTG52Tax Definition
9OPOR386Purchase Order
10JDT1124Journal Entry - Rows

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2ORCT154Incoming Payment
3OINV268A/R Invoice
4OVPM154Outgoing Payments
5OIVL77Whse Journal
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction
Financial Services :: Loans Management
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0VDCAPTR1302CAPTR: Master Data of Capital TransferLoans Management
SQL:  selectupdate insert create

Use the column checkboxes to build your query. Header columns sets/unsets all columns

SELECT MANDT, BUKRS, SARCHIV, RANL, RBO, SBO_STATUS, SFGKZ, SRELSTAT, DVALUTTF, IULTDVALUTTF, ICOMTF, IREDISTF, IPREDISTF, INEUVALTF, REXCHGRA, DEXCHGRA, INSEREPCF_T, MTEMPLNO, RECAPCONTROL, DIOBCONTROL, REDISCONTROL, PREDISCONTROL, NSEREPCONTROL, COMCAPCONTROL, SCHEDREPCONTROL, UNSCHEDREPCONTR, PRATETF, IINCLDVALUT_S, PARTNR_S, UPOSCURR_S, ARECA_S, ARECAAV_S, ARECATF_S, ADIOB_S, ADIOBAV_S, ADIOBTF_S, AREDIS_S, APREDIS_S, IREPSE_S, ANSEREP_S, FTRECAOF_S, FTREDISOF_S, FTPREDISOF_S, CTDIOBOF_S, CTREPSE_S, CTCOMOF_S, MSBOTERM_S, CTREP_S, DCOEFFR_S, DBEGREP_S, PREPCHG_S, AREPCHG_S, AREPCHGBAS_S, ARECATFLC_S, MOFMETHOD_S, ISAVTERMEND_S, DEOTOLD_S, DEOT_S, APRREDIS_S, APRPREDIS_S, APRNSEREP_S, ATFVALCAOF_S, ATFSCHEDREPOF_S, ATFUNSCHREPOF_S, AVALCA_S, ASUMICSCHREP_S, ASUMICUNSCHREP_S, FTVALCAOF_S, FTSCHEDREPOF_S, FTUNSCHEDROF_S, MRANL_T, MBVTYP_T, MZLSCH_T, PARTNR_T, UPOSCURR_T, AVALUTCA_T, ADIOB_T, ADIOBAV_T, ACOLDIS_T, ARECA_T, ATFRECAIFSC_T, ATFREDISIFSC_T, ATFPREDISIFSC_T, ANSEREPCFSC_T, FTRECAIF_T, FTREPCF_T, FTREDISIF_T, FTPREDISIF_T, CTCAINC_T, CTNSETREPCF, DFIXEDFRO_T, MEXBEGEIR_T, RDISBRATE_T, MSBOTERM_T, CTREP_T, DBEGREP_T, PREPCHG_T, AREPCHG_T, AREPCHGBAS_T, ISAVTERMEND_T, IFMETHOD_T, DEOTOLD_T, DEOT_T, ATFVALCAIF_T, ATFSCHRIF_T, ATFUNSCHRIF_T, FTVALCAIF_T, FTSCHRIF_T, FTUNSCHRIF_T, MRCAPTR_REASON, MPOSTTYPE, IMANPOPROC, DCOM_T, DOFFON_T, DOFFUNT_T, DACCEPT_T, DAPPLIC_T, DAPPROV_T, DCONTRAC_T, ICONTR_CREATED_T, INEW_CONTRACT, RERF, DERF, TERF, REHER, RBEAR, DBEAR, TBEAR, RBHER, CHANGED FROM VDCAPTR
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2BUKRSCompany Codenvarchar40CHAR(N' ')No*BUKRS Allow NULL? 
3SARCHIVArchiving Category Indicatorchar10CHAR(N' ')NoSARCHIV Allow NULL? 
4RANLContract Numbernvarchar130CHAR(N' ')NoRANL Allow NULL? 
5RBOBusiness Operation Number (Loans)nvarchar150CHAR(N' ')NoRBO Allow NULL? 
6SBO_STATUSBusiness Operation Status of Capital Transferchar10CHAR(N' ')YesTB_SBOSTATUS_CAPTR Allow NULL? 
7SFGKZRelease Workflow Indicator for the Business Operationchar10CHAR(N' ')YesTB_SFGKZA Allow NULL? 
8SRELSTATInternal Release Status in the Business Operationschar10CHAR(N' ')YesTB_SRELSTAT Allow NULL? 
9DVALUTTFTransfer Key Datenvarchar80DATS(N'00000000')YesTB_TRANSFER_DATE Allow NULL? 
10IULTDVALUTTFMonth-End Indicator on Transfer Key Datechar10CHAR(N' ')YesTB_IND_ULTIMO Allow NULL? 
11ICOMTFTransfer Procedure Indicator (' ' = Rem. Cap '1' = Val.DtCp)char10CHAR(N' ')YesTB_IND_TRANSFER_PROCEDURE Allow NULL? 
12IREDISTFIndictor "Transfer Post Remaining Discount / Premium"char10CHAR(N' ')YesTB_IND_REMAINING_DISCOUNT_TF Allow NULL? 
13IPREDISTFIndicator Transfer Advance Discount / Premiumchar10CHAR(N' ')YesTB_IND_PRE_DISCOUNT_TRANSFER Allow NULL? 
14INEUVALTFTransfer Not Affecting Valuationchar10CHAR(N' ')YesTB_IND_NEUTRAL_VALIDATION_TF Allow NULL? 
15REXCHGRAExchange Ratedecimal95DEC((0))YesTB_EXCHANGE_RATE
16DEXCHGRADate of Exchange Ratenvarchar80DATS(N'00000000')YesTB_DATE_EXCHANGE_RATE Allow NULL? 
17INSEREPCF_TIndicator "Carry Forward Repayment Not Settled to Targ. Loanchar10CHAR(N' ')YesTB_IND_NOT_SETTLED_REP_TARGET Allow NULL? 
18MTEMPLNOCapital Transfer Template Keynvarchar20CHAR(N' ')YesTDCAPTR_TEMPLTB_CAPTR_TEMPLATE Allow NULL? 
19RECAPCONTROLControl Transfer Remaining Capitalnvarchar20NUMC(N'00')YesTB_REMAINING_CAPITAL_CONTROL Allow NULL? 
20DIOBCONTROLControl Disbursement Obligationnvarchar20NUMC(N'00')YesTB_DISBURSEMENT_OBL_CONTROL Allow NULL? 
21REDISCONTROLControl Remaining Discount / Premiumnvarchar20NUMC(N'00')YesTB_REMAINING_DISCOUNT_CONTROL Allow NULL? 
22PREDISCONTROLControl Advance Discount / Premiumnvarchar20NUMC(N'00')YesTB_PRE_DISCOUNT_CONTROL Allow NULL? 
23NSEREPCONTROLControl Repayment Amount Not Settlednvarchar20NUMC(N'00')YesTB_NOT_SETTLED_REP_CONTROL Allow NULL? 
24COMCAPCONTROLValue-Dated Capital Controlnvarchar20NUMC(N'00')YesTB_VALUEDATED_CAPITAL_CONTROL Allow NULL? 
25SCHEDREPCONTROLScheduled Repayment Controlnvarchar20NUMC(N'00')YesTB_SCHEDULED_REPAY_CONTROL Allow NULL? 
26UNSCHEDREPCONTRUnscheduled Repayment Controlnvarchar20NUMC(N'00')YesTB_UNSCHEDULED_REPAY_CONTROL Allow NULL? 
27PRATETFTransfer Quota Capital Transferdecimal107DEC((0))YesTB_TRANSFER_RATE
28IINCLDVALUT_SInclusive Indicator for Source Loanchar10CHAR(N' ')YesTB_IND_INCL_SOURCE Allow NULL? 
29PARTNR_SPartner Numbernvarchar100CHAR(N' ')Yes*TB_PARTNR_CAPTR Allow NULL? 
30UPOSCURR_SPosition Currency Source Loan (Currency of Postion Amounts)nvarchar50CUKY(N' ')Yes*TB_SBWHR_SOURCE Allow NULL? 
31ARECA_SRemaining Capital in Source Loandecimal132CURR((0))YesTB_REMAINING_CAPITAL_SOURCE
32ARECAAV_SAvailable Remaining Capital Source Loan on Transfer Key Datedecimal132CURR((0))YesTB_AVAIL_REMAINING_CAPITAL_S
33ARECATF_SRemaining Capital to be Transferred in the Source Loandecimal132CURR((0))YesTB_TF_REMAINING_CAPITAL_SOURCE
34ADIOB_SDisbursement Obligation of Source Loan on Transfer Key Datedecimal132CURR((0))YesTB_DISBURSEMENT_OBLIG_SOURCE
35ADIOBAV_SAvailable Disbursement Obligation Source Loandecimal132CURR((0))YesTB_AVAIL_DISBURSMENT_OBLIG_S
36ADIOBTF_SDisbursement Obligation to be Transferred Source Loandecimal132CURR((0))YesTB_TF_DISBURSEMENT_OBLIG_S
37AREDIS_SRemaining Discount / Premium in Source Loandecimal132CURR((0))YesTB_REMAINING_DISCOUNT_SOURCE
38APREDIS_SAdvance Discount / Premium Source Loandecimal132CURR((0))YesTB_PRE_DISCOUNT_SOURCE
39IREPSE_SIndicator, Repayment Settlement in Source Loanchar10CHAR(N' ')YesTB_IND_REP_SETTLEMENT_SOURCE Allow NULL? 
40ANSEREP_SRepayment Not Settled in Source Loandecimal132CURR((0))YesTB_NOT_SETTLED_REP_SOURCE
41FTRECAOF_SFlow Type Remaining Capital Outflownvarchar40CHAR(N' ')Yes*TB_FT_REMAINING_CAPITAL_OF Allow NULL? 
42FTREDISOF_SFlow Type Remaining Discount / Premium Outflownvarchar40CHAR(N' ')Yes*TB_FT_REMAINING_DISCOUNT_OF Allow NULL? 
43FTPREDISOF_SFlow Type Advance Discount / Premium Outflownvarchar40CHAR(N' ')Yes*TB_FT_PRE_DISCOUNT_OF Allow NULL? 
44CTDIOBOF_SCondition Type Disbursement Obligation Outflownvarchar40NUMC(N'0000')Yes*TB_CT_DISBURSMENT_OBLIG_OF Allow NULL? 
45CTREPSE_SCondition Type Repayment Settlementnvarchar40NUMC(N'0000')Yes*TB_CT_REPAYMENT_SETTLEMENT_OF Allow NULL? 
46CTCOMOF_SCondition Type Commitment Outflownvarchar40NUMC(N'0000')Yes*TB_CT_COMMITMENT_OF Allow NULL? 
47MSBOTERM_SRepayment Change Indicator Source Loanchar10CHAR(N' ')YesTB_SBOTERM_CAPTR_SOURCE Allow NULL? 
48CTREP_SRepayment Condition Type in Source Loannvarchar40NUMC(N'0000')Yes*TB_CT_REPAYMENT_SOURCE Allow NULL? 
49DCOEFFR_SStart of Fixed Period in Source Loannvarchar80DATS(N'00000000')YesTB_DATE_FIXED_FROM_SOURCE Allow NULL? 
50DBEGREP_SRepayment Start in Source Loannvarchar80DATS(N'00000000')YesTB_REPAYMENT_DATE_FROM_SOURCE Allow NULL? 
51PREPCHG_SRepayment Rate in Source Loan in Percentdecimal107DEC((0))YesTB_REPAYMENT_RATE_SOURCE
52AREPCHG_SSpecified Payment Installment in Source Loandecimal132CURR((0))YesTB_REPAYMENT_AMOUNT_SOURCE
53AREPCHGBAS_SBase Amount in Source Loandecimal132CURR((0))YesTB_REPAYMENT_BAS_AMOUNT_SOURCE
54ARECATFLC_SRemaining Capital in Local Currency to be Transferreddecimal132CURR((0))YesTB_REMAINING_CAP_TF_LOCAL_CURR
55MOFMETHOD_SOutflow Procedure Source Loannvarchar20NUMC(N'00')YesTB_OUTFLOW_METHOD_SOURCE Allow NULL? 
56ISAVTERMEND_SSave Term End Indicator in Source Loanchar10CHAR(N' ')YesTB_IND_SAVE_TERM_END_SOURCE Allow NULL? 
57DEOTOLD_SPrevious Term End in Source Loan (Calculated)nvarchar80DATS(N'00000000')YesTB_DATE_END_OF_TERM_OLD_SOURCE Allow NULL? 
58DEOT_SNew End of Term in Source Loan (With CT) (Calculated)nvarchar80DATS(N'00000000')YesTB_DATE_END_OF_TERM_NEW_SOURCE Allow NULL? 
59APRREDIS_SRemaining Discount in Source Loan to be Transferreddecimal132CURR((0))YesTB_REMAINING_CAP_PRORATED_S
60APRPREDIS_SAdvance Discount/ Premium to be Transferred Source Loandecimal132CURR((0))YesTB_PRE_DISCOUNT_PRORATED_S
61APRNSEREP_SProportional Repayment Not Settled in Source Loandecimal132CURR((0))YesTB_NOT_SETTLED_REP_PR_RATED_S
62ATFVALCAOF_SValue-Dated Capital to be Transferred in Sce Loan (Outflow)decimal132CURR((0))YesTB_TF_VALUEDATED_CAP_SOURCE
63ATFSCHEDREPOF_SScheduled Repayment Capital to be Transferred (Outflow)decimal132CURR((0))YesTB_TF_SCHEDULED_REPAY_CAP_S
64ATFUNSCHREPOF_SUnscheduled Repayment Capital to be Transferred (Outflow)decimal132CURR((0))YesTB_TF_UNSCHEDULED_REPAY_CAP_S
65AVALCA_SValue-Dated Capital in Source Loan (on Transfer Key Date)decimal132CURR((0))YesTB_VALUEDATED_CAPITAL_SOURCE
66ASUMICSCHREP_STotal of Incoming Payments for Scheduled Repaymentdecimal132CURR((0))YesTB_SUM_INCOMING_CAP_SCHEDR
67ASUMICUNSCHREP_STotal of Incoming Payments for Unscheduled Repaymentdecimal132CURR((0))YesTB_SUM_INCOMING_CAP_UNSCHEDR
68FTVALCAOF_SFlow Type Value-Dated Capital Outflownvarchar40CHAR(N' ')Yes*TB_FT_VALUEDATED_CAPITAL_OF Allow NULL? 
69FTSCHEDREPOF_SFlow Type Scheduled Repayment Outflownvarchar40CHAR(N' ')Yes*TB_FT_SCHEDREP_CAPITAL_OF Allow NULL? 
70FTUNSCHEDROF_SFlow Type Unscheduled Repayment Outflownvarchar40CHAR(N' ')Yes*TB_FT_UNSCHEDREP_CAPITAL_OF Allow NULL? 
71MRANL_TLoan Number Target Loannvarchar130CHAR(N' ')YesTB_RANL_TARGET Allow NULL? 
72MBVTYP_TBank Details ID in Target Loannvarchar40CHAR(N' ')YesTB_BVTYP_TARGET Allow NULL? 
73MZLSCH_TPayment Method in Target Loanchar10CHAR(N' ')Yes*TB_ZLSCH_TARGET Allow NULL? 
74PARTNR_TPartner Numbernvarchar100CHAR(N' ')Yes*TB_PARTNR_CAPTR Allow NULL? 
75UPOSCURR_TPosition Currency Target Loan (Currency of Postion Amounts)nvarchar50CUKY(N' ')Yes*TB_SBWHR_TARGET Allow NULL? 
76AVALUTCA_TValue-Dated Capital Target Loandecimal132CURR((0))YesTB_VALUT_CAPITAL_TARGET
77ADIOB_TDisbursement Obligation of Target Loandecimal132CURR((0))YesTB_DISBURSEMENT_OBLIG_TARGET
78ADIOBAV_TAvailable Disbursement Obligation Target Loandecimal132CURR((0))YesTB_AVAIL_DISBURSMENT_OBLIG_T
79ACOLDIS_TCollected Discount / Premium in Target Loandecimal132CURR((0))YesTB_COLLECTED_DISCOUNT_TARGET
80ARECA_TRemaining Capital in Target Loandecimal132CURR((0))YesTB_REMAINING_CAPITAL_TARGET
81ATFRECAIFSC_TRem. Capital Inflow To Be Transferred in Settlement Currencydecimal132CURR((0))YesTB_REMAINING_CAPITAL_IF_SC_T
82ATFREDISIFSC_TRem. Disc./Premium Inflow to be Transferred in Settl. Crcydecimal132CURR((0))YesTB_REMAINING_DISCOUNT_IF_SC_T
83ATFPREDISIFSC_TAdvance Disc./ Prem. Inflow To Transfer in Settlement Crcydecimal132CURR((0))YesTB_PRE_DISCOUNT_IF_SC_TARGET
84ANSEREPCFSC_TCarry Forward Repayment Not Settled in Settlement Currencydecimal132CURR((0))YesTB_NOT_SET_REP_CARRY_FORW_SC_T
85FTRECAIF_TFlow Type Remaining Capital Inflownvarchar40CHAR(N' ')Yes*TB_FT_REMAINING_CAPITAL_IF Allow NULL? 
86FTREPCF_TFlow Type Repayment Carry Forwardnvarchar40CHAR(N' ')Yes*TB_FT_REPAYMENT_CARRY_FORWARD Allow NULL? 
87FTREDISIF_TFlow Type Remaining Discount / Premium Inflownvarchar40CHAR(N' ')Yes*TB_FT_REMAINING_DISCOUNT_IF Allow NULL? 
88FTPREDISIF_TFlow Type Advance Discount / Premium Inflownvarchar40CHAR(N' ')Yes*TB_FT_PRE_DISCOUNT_IF Allow NULL? 
89CTCAINC_TCondition Type Capital Increasenvarchar40NUMC(N'0000')Yes*TB_CT_CAPITAL_INCREASE Allow NULL? 
90CTNSETREPCFCondition Type Carry Forward Repayment Amnt Not Settlednvarchar40NUMC(N'0000')Yes*TB_CT_NOT_SET_REP_CARRY_FORW Allow NULL? 
91DFIXEDFRO_TStart of Fixed Period in Target Loannvarchar80DATS(N'00000000')YesTB_DATE_FIXED_FROM_TARGET Allow NULL? 
92MEXBEGEIR_TExternal Initial Effective Interest Target Loandecimal107DEC((0))YesTB_EXT_ORIGINAL_EFFECTIV_IR_T
93RDISBRATE_TDisbursement Rate Target Loandecimal107DEC((0))YesTB_DISBURSEMENT_RATE_TARGET
94MSBOTERM_TRepayment Change Indicator Target Loanchar10CHAR(N' ')YesTB_SBOTERM_CAPTR_TARGET Allow NULL? 
95CTREP_TRepayment Condition Type in Target Loannvarchar40NUMC(N'0000')Yes*TB_CT_REPAYMENT_TARGET Allow NULL? 
96DBEGREP_TRepayment Start in Target Loannvarchar80DATS(N'00000000')YesTB_REPAYMENT_DATE_FROM_TARGET Allow NULL? 
97PREPCHG_TRepayment Rate in Target Loan in Percentdecimal107DEC((0))YesTB_REPAYMENT_RATE_TARGET
98AREPCHG_TSpecified Payment Installment in Target Loandecimal132CURR((0))YesTB_REPAYMENT_AMOUNT_TARGET
99AREPCHGBAS_TBase Amount in Target Loandecimal132CURR((0))YesTB_REPAYMENT_BAS_AMOUNT_TARGET
100ISAVTERMEND_TSave Term End Indicator in Target Loanchar10CHAR(N' ')YesTB_IND_SAVE_TERM_END_TARGET Allow NULL? 
101IFMETHOD_TInflow Method Target Loannvarchar20NUMC(N'00')YesTB_INFLOW_METHOD_TARGET Allow NULL? 
102DEOTOLD_TPrevious Term End in Target Loan (Calculated)nvarchar80DATS(N'00000000')YesTB_DATE_END_OF_TERM_OLD_TARGET Allow NULL? 
103DEOT_TNew Term End in Target Loan (With CT) (Calculated)nvarchar80DATS(N'00000000')YesTB_DATE_END_OF_TERM_NEW_TARGET Allow NULL? 
104ATFVALCAIF_TValue-Dated Capital to Transfer in Target Loan (Inflow)decimal132CURR((0))YesTB_TF_VALUEDATED_CAP_TARGET
105ATFSCHRIF_TScheduled Repayment Capital to be Transferred (Inflow)decimal132CURR((0))YesTB_TF_SCHEDULED_REPAY_CAP_T
106ATFUNSCHRIF_TUnscheduled Repayment Capital to be Transferred (Inflow)decimal132CURR((0))YesTB_TF_UNSCHEDULED_REPAY_CAP_T
107FTVALCAIF_TFlow Type Value-Dated Captial Inflownvarchar40CHAR(N' ')Yes*TB_FT_VALUEDATED_CAPITAL_IF Allow NULL? 
108FTSCHRIF_TFlow Type Scheduled Repayment Inflownvarchar40CHAR(N' ')Yes*TB_FT_SCHEDREP_CAPITAL_IF Allow NULL? 
109FTUNSCHRIF_TFlow Type Unscheduled Repayment Inflownvarchar40CHAR(N' ')Yes*TB_FT_UNSCHEDREP_CAPITAL_IF Allow NULL? 
110MRCAPTR_REASONReason for Capital Transfernvarchar30NUMC(N'000')YesTDCAPTR_REASONTB_CAPTR_REASON Allow NULL? 
111MPOSTTYPEPosting Control for the Capital Transfernvarchar20NUMC(N'00')YesTZB09TB_POSTTYPE_KEY Allow NULL? 
112IMANPOPROCNeed for Postprocessingnvarchar30NUMC(N'000')YesTDCAPTR_POSTPRTB_MAN_POSTPROCESSING Allow NULL? 
113DCOM_TCommitment Date of Target Loannvarchar80DATS(N'00000000')YesTB_DATE_COMMITMENT_TARGET Allow NULL? 
114DOFFON_TDate of Offer Created for Target Loannvarchar80DATS(N'00000000')YesTB_DATE_OFFER_ON_TARGET Allow NULL? 
115DOFFUNT_TEnd of Validity Period of Offer of Target Loannvarchar80DATS(N'00000000')YesTB_DATE_OFFER_UNTIL_TARGET Allow NULL? 
116DACCEPT_TAceptance Date of Offer of Target Loannvarchar80DATS(N'00000000')YesTB_DATE_ACCEPTED_ON_TARGET Allow NULL? 
117DAPPLIC_TApplication Date of Target Loannvarchar80DATS(N'00000000')YesTB_DATE_APPLICATION_ON_TARGET Allow NULL? 
118DAPPROV_TApproval Date of Target Loannvarchar80DATS(N'00000000')YesTB_DATE_APPROVAL_TARGET Allow NULL? 
119DCONTRAC_TCreation Date of Contract for Target Loannvarchar80DATS(N'00000000')YesTB_DATE_CONTRACT_ON_TARGET Allow NULL? 
120ICONTR_CREATED_TContract Created Indicator (Target Loan)char10CHAR(N' ')YesTB_IND_CONTRACT_CREATED_TARGET Allow NULL? 
121INEW_CONTRACTIndicator - Is Contract Registered for Capital Transferchar10CHAR(N' ')YesTB_NEW_CONTRACT Allow NULL? 
122RERFEntered bynvarchar120CHAR(N' ')YesRERF Allow NULL? 
123DERFFirst Entered onnvarchar80DATS(N'00000000')YesDERF Allow NULL? 
124TERFTime of Initial Entrynvarchar60TIMS(N'000000')YesTERF Allow NULL? 
125REHERSource of initial entrynvarchar100CHAR(N' ')YesREHER Allow NULL? 
126RBEAREmployee IDnvarchar120CHAR(N' ')YesRBEAR Allow NULL? 
127DBEARLast Edited onnvarchar80DATS(N'00000000')YesDBEAR Allow NULL? 
128TBEARLast Edited atnvarchar60TIMS(N'000000')YesTBEAR Allow NULL? 
129RBHEREditing Sourcenvarchar100CHAR(N' ')YesRBHER Allow NULL? 
130CHANGEDchar10(N' ')Yes Allow NULL? 
NamePrimaryUniqueTypeColumns
VDCAPTR~0YesYesCLUSTEREDMANDT, BUKRS, SARCHIV, RANL, RBO
VDCAPTR~T1NoNoNONCLUSTEREDMANDT, BUKRS, SARCHIV, MRANL_T

All references to SAP and SAP logo are trademarks of SAP AG in Germany, EU, USA and other territories.
No warranty is provided to data provided by this site. This website is not affiliated with, maintained, authorized, endorsed or sponsored by the SAP AG Company or any of its affiliates.
About :: Terms :: Privacy